ToiletMaster Posted January 15, 2013 Group: Members Topic Count: 76 Topics Per Day: 0.02 Content Count: 276 Reputation: 7 Joined: 08/11/12 Last Seen: January 26, 2018 Share Posted January 15, 2013 (edited) Hi there guys, i'm getting this error at the moment. I've updated from Svn 17054. I've already applied the SQL Updates. What am i missing here? Edited January 15, 2013 by ToiletMaster Quote Link to comment Share on other sites More sharing options...
kyeme Posted January 15, 2013 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 164 Reputation: 12 Joined: 03/08/12 Last Seen: Sunday at 10:22 PM Share Posted January 15, 2013 Execute 2 SQL upgrade in sql-files/upgrade: 1. upgrade_svn17080.sql 2. upgrade_svn17086.sql Quote Link to comment Share on other sites More sharing options...
ToiletMaster Posted January 15, 2013 Group: Members Topic Count: 76 Topics Per Day: 0.02 Content Count: 276 Reputation: 7 Joined: 08/11/12 Last Seen: January 26, 2018 Author Share Posted January 15, 2013 (edited) doesn't work. i've already did that. Just to recall, highlighting my database, then open the 2 sql scripts and execute it right? I've done it already however the error remains when i throw an item out or picking an item up. Edited January 15, 2013 by ToiletMaster Quote Link to comment Share on other sites More sharing options...
kyeme Posted January 15, 2013 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 164 Reputation: 12 Joined: 03/08/12 Last Seen: Sunday at 10:22 PM Share Posted January 15, 2013 (edited) Are you sure youv successfully executed the files? If your are using My SQL Browser Default Schema: Log Execute this 1st ALTER TABLE `picklog` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0' AFTER `card3`; and Then: ALTER TABLE `picklog` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; Edited January 15, 2013 by kyeme 1 Quote Link to comment Share on other sites More sharing options...
Lighta Posted January 15, 2013 Group: Members Topic Count: 16 Topics Per Day: 0.00 Content Count: 737 Reputation: 216 Joined: 11/29/11 Last Seen: December 20, 2020 Share Posted January 15, 2013 show us the result picklog table. Seem like the second query kyeme quote wasn't apply. As state "He didn't found unique_id colum in table picklog". Quote Link to comment Share on other sites More sharing options...
ToiletMaster Posted January 15, 2013 Group: Members Topic Count: 76 Topics Per Day: 0.02 Content Count: 276 Reputation: 7 Joined: 08/11/12 Last Seen: January 26, 2018 Author Share Posted January 15, 2013 (edited) Are you sure youv successfully executed the files? If your are using My SQL Browser Default Schema: Log Execute this 1st ALTER TABLE `picklog` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0' AFTER `card3`; and Then: ALTER TABLE `picklog` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; Thanks this works! Compared to the sql files that i used, manually inserting this into the schema works. show us the result picklog table. Seem like the second query kyeme quote wasn't apply. As state "He didn't found unique_id colum in table picklog". Already fixed thanks to kyeme, there was an error that came out on MYSQL 5.2 Workbench when i execute the upgrades from the SQL-Files Will put images of what it looks like let me reproduce the error first. On my log schema, SQL upgrade 17080 Time Action Message Duration / Fetch 1 1 16:32:05 CREATE TABLE IF NOT EXISTS `interreg` ( `varname` varchar(11) NOT NULL, `value` varchar(20) NOT NULL, PRIMARY KEY (`varname`) ) ENGINE=InnoDB 0 row(s) affected, 1 warning(s): 1050 Table 'interreg' already exists 0.000 sec 3 2 16:32:05 INSERT INTO `interreg` (`varname`, `value`) VALUES ('nsiuid', '0') 1 row(s) affected 0.047 sec 0 3 16:32:05 ALTER TABLE `auction` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0' Error Code: 1146. Table 'logs.auction' doesn't exist 0.000 sec SQL Upgrade for 17086 hope it helps (brb will post an image, looks like copying the things din't look the way it wanted to lol Cant reproduce the original error that i had. It was ended with an X on the execution part for both 17080 and 17086. However the 17080 is stated above there. that was the exact error i had if i'm not mistaken. Lemme know if i can help in anyway in providing any other information thanks! Edited January 15, 2013 by ToiletMaster Quote Link to comment Share on other sites More sharing options...
azze25 Posted January 15, 2013 Group: Members Topic Count: 13 Topics Per Day: 0.00 Content Count: 48 Reputation: 0 Joined: 11/21/11 Last Seen: January 30, 2013 Share Posted January 15, 2013 (edited) same problem too... these are the error when executing upgrade_svn17080.sql Script line: 9 Table 'log2.auction' doesn't exist Script line: 10 Table 'log2.cart_inventory' doesn't exist Script line: 11 Table 'log2.guild_storage' doesn't exist Script line: 12 Table 'log2.inventory' doesn't exist Script line: 13 Table 'log2.mail' doesn't exist Script line: 14 Table 'log2.storage' doesn't exist these are the error when executing upgrade_svn17086.sql Script line: 6 Table 'log2.guild_storage' doesn't exist Script line: 7 Table 'log2.inventory' doesn't exist Script line: 8 Table 'log2.mail' doesn't exist Script line: 9 Table 'log2.storage' doesn't exist How can we solve this? please help us Edited January 15, 2013 by azze25 Quote Link to comment Share on other sites More sharing options...
Lord Ganja Posted January 16, 2013 Group: Members Topic Count: 141 Topics Per Day: 0.03 Content Count: 444 Reputation: 22 Joined: 06/18/12 Last Seen: August 11, 2018 Share Posted January 16, 2013 Hello, I got errors when I updated my SVN to its latest revision. try to look at this: anyone knows how to solve this? thanks in advance! Quote Link to comment Share on other sites More sharing options...
Euphy Posted January 16, 2013 Group: Members Topic Count: 72 Topics Per Day: 0.02 Content Count: 2997 Reputation: 1130 Joined: 05/27/12 Last Seen: June 1, 2017 Share Posted January 16, 2013 Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating. You're probably missing: trunk/sql-files/upgrades/upgrade_svn17080.sql trunk/sql-files/upgrades/upgrade_svn17086.sql 1 Quote Link to comment Share on other sites More sharing options...
Lord Ganja Posted January 16, 2013 Group: Members Topic Count: 141 Topics Per Day: 0.03 Content Count: 444 Reputation: 22 Joined: 06/18/12 Last Seen: August 11, 2018 Share Posted January 16, 2013 (edited) Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating.You're probably missing: trunk/sql-files/upgrades/upgrade_svn17080.sql trunk/sql-files/upgrades/upgrade_svn17086.sql Hi Euphy, thank you for that quick reply. Btw, how could I apply those upgrades? Edited April 3, 2013 by Lord Ganja 1 Quote Link to comment Share on other sites More sharing options...
Vietlubu Posted January 16, 2013 Group: Members Topic Count: 36 Topics Per Day: 0.01 Content Count: 141 Reputation: 24 Joined: 01/19/12 Last Seen: Sunday at 12:08 AM Share Posted January 16, 2013 Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating. You're probably missing: trunk/sql-files/upgrades/upgrade_svn17080.sql trunk/sql-files/upgrades/upgrade_svn17086.sql Hi Emistry, thank you for that quick reply. Btw, how could I apply those upgrades? excute sql file on your database Quote Link to comment Share on other sites More sharing options...
ToiletMaster Posted January 16, 2013 Group: Members Topic Count: 76 Topics Per Day: 0.02 Content Count: 276 Reputation: 7 Joined: 08/11/12 Last Seen: January 26, 2018 Author Share Posted January 16, 2013 same problem too... these are the error when executing upgrade_svn17080.sql Script line: 9 Table 'log2.auction' doesn't exist Script line: 10 Table 'log2.cart_inventory' doesn't exist Script line: 11 Table 'log2.guild_storage' doesn't exist Script line: 12 Table 'log2.inventory' doesn't exist Script line: 13 Table 'log2.mail' doesn't exist Script line: 14 Table 'log2.storage' doesn't exist these are the error when executing upgrade_svn17086.sql Script line: 6Table 'log2.guild_storage' doesn't exist Script line: 7 Table 'log2.inventory' doesn't exist Script line: 8 Table 'log2.mail' doesn't exist Script line: 9 Table 'log2.storage' doesn't exist How can we solve this? please help us Hi i've solved my problem. do it manually using kyeme's method. Are you sure youv successfully executed the files? If your are using My SQL Browser Default Schema: Log Execute this 1st ALTER TABLE `picklog` ADD `nsiuid` BIGINT NOT NULL DEFAULT '0' AFTER `card3`; and Then: ALTER TABLE `picklog` CHANGE `nsiuid` `unique_id` BIGINT( 20 ) NOT NULL DEFAULT '0'; Quote Link to comment Share on other sites More sharing options...
Brian Posted January 17, 2013 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted January 17, 2013 1. upgrade_svn17080.sql2. upgrade_svn17086.sql It's because both of those files contain SQL queries for 2 databases, "ragnarok" and "logs". If you have all your tables in 1 database, you can execute the SQL Upgrade files as-is. If you have 2 separate databases (ragnarok & logs), then make sure you execute queries for picklog on the "logs" database. Quote Link to comment Share on other sites More sharing options...
Question
ToiletMaster
Hi there guys, i'm getting this error at the moment.
I've updated from Svn 17054. I've already applied the SQL Updates.
What am i missing here?
Edited by ToiletMasterLink to comment
Share on other sites
12 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.