Issue information

Issue ID
#7822
Status
Working as Intended
Severity
None
Started
Viollently Happy
Nov 15, 2013 12:34
Last Post
Haru
Nov 30, 2013 21:18
Confirmation
Yes (2)
No (1)

Viollently Happy - Nov 15, 2013 12:34

Error[color=rgb(0,0,0)][font=sans-serif][size=3]
[b]SQL query:[/b][/size][/font][/color][color=rgb(0,0,0)][font=sans-serif][size=3]
[font=Verdan, Arial, Tahoma][size=4]CALL alter_if_not_exists[color=#FF00FF]([/color][/size][/font][/size][/font][/color]
[color=rgb(0,0,0)][font=sans-serif][size=3][indent=1][color=rgb(0,128,0)]'item_db2'[/color][color=#FF00FF],[/color] [color=rgb(0,128,0)]'matk'[/color][color=#FF00FF],[/color] [color=rgb(0,128,0)]'ADD COLUMN'[/color][color=#FF00FF],[/color] [color=rgb(0,128,0)]'smallint(5) unsigned DEFAULT NULL AFTER atk'[/color][/size][/font][/color][/indent]
[color=#FF00FF][font=sans-serif][size=3])[/size][/font][/color][color=rgb(0,0,0)][font=sans-serif][size=3]$$[/size][/font][/color]
[color=rgb(0,0,0)][font=sans-serif][size=3]
[b]MySQL said: [/b][url="https://192.69.201.227/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Ferror-messages-server.html&token=33cda9af5bb9da316ca5d984935a264b"][img]https://192.69.201.227/phpmyadmin/themes/dot.gif[/img][/url][/size][/font][/color]
#1436 - Thread stack overrun: 5472 bytes used of a 131072 byte stack, and 128000 bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

themon - Nov 15, 2013 13:05

Script line: 105 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

INSERT INTO `sql_updates` (`timestamp`) VALUES (1384473995);

LuLu - Nov 15, 2013 13:12

yes, I have this too. I can't upgrade my sql. give's me the error on linux.

Haru - Nov 15, 2013 14:57

Works for me on MySQL 5.6 and MySQL 5.1. As the error message says, it depends on your server's settings.

You have two options:

- Change the thread_stack setting to a higher value in your my.cnf (MySQL configuration), and then restart MySQL. (consult your OS and/or MySQL manual)

or

- Run the manual upgrade instead. You can find it in sql-files/upgrades/2013-11-15--00-06.sql, in a comment near the top of the file. I'll also paste it here for convenience sake:[code=auto:0] -- Note: If you're running a MySQL version earlier than 5.0 (or if this scripts fails for you for any reason) -- you'll need to run the following queries manually: -- [ Pre-Renewal only ] ALTER TABLE item_db2 ADD COLUMN `matk` smallint(5) unsigned DEFAULT NULL AFTER atk; ALTER TABLE item_db2 CHANGE COLUMN `equip_level` `equip_level_min` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 ADD COLUMN `equip_level_max` smallint(5) unsigned DEFAULT NULL AFTER equip_level_min; -- [ Both Pre-Renewal and Renewal ] ALTER TABLE item_db2 MODIFY COLUMN `price_buy` mediumint(10) DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `price_sell` mediumint(10) DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `weight` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `atk` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `matk` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `defence` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `range` tinyint(2) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `slots` tinyint(2) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_jobs` int(12) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_upper` tinyint(8) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_genders` tinyint(2) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_locations` smallint(4) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `weapon_level` tinyint(2) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_level_min` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `equip_level_max` smallint(5) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `refineable` tinyint(1) unsigned DEFAULT NULL; ALTER TABLE item_db2 MODIFY COLUMN `view` smallint(3) unsigned DEFAULT NULL; INSERT INTO `sql_updates` (`timestamp`) VALUES (1384473995); -- [ End ] [/code]

LuLu - Nov 16, 2013 4:38

what I did was removed the old itemdb's and added the updated itemdb.sql.is that safe? still gives errors on PHPMyAdmin.

Haru - Nov 30, 2013 21:18

Yes, that is safe (and actually the correct way to go).

Not sure about the phpmyadmin errors, but it often errors out when the files are too big for it to handle due to some technical limitations. You might need to split them in multiple files, if you want to use phpmyadmin. Or simply import from command line mysql.