Database errors after updating SVN

[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 January 15, 2013 by ToiletMaster

[kyeme]

Execute 2 SQL upgrade in sql-files/upgrade:

1. upgrade_svn17080.sql

2. upgrade_svn17086.sql

[ToiletMaster]

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

[kyeme]

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

[Lighta]

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".

[ToiletMaster]

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

[azze25]

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

[Lord Ganja]

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!

[Euphy]

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
  

[Lord Ganja]

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

[Vietlubu]

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

[ToiletMaster]

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';

[Brian]

1. upgrade_svn17080.sql

2. 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.