Jump to content
This Topic
The forums will be going offline for an extended maintenance period at 1400hrs GMT on 19th June 2025. The number of hours for this downtime is intentionally not advertised due to the nature of these upgrades. ×
  • 0

Database errors after updating SVN

ToiletMaster

Asked by ToiletMaster,

 Share

Question

ToiletMaster Poring

ToiletMaster

Posted
  • Group:  Members
  • Topic Count:  76
  • Topics Per Day:  0.02
  • Content Count:  276
  • Reputation:   7
  • Joined:  08/11/12
  • Last Seen:  
Posted (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?

Untitled-12_zps947935b0.png

Edited by ToiletMaster
Link to comment
Share on other sites

12 answers to this question

Recommended Posts

kyeme Poring

kyeme

Posted
  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  164
  • Reputation:   12
  • Joined:  03/08/12
  • Last Seen:  
Posted

Execute 2 SQL upgrade in sql-files/upgrade:

1. upgrade_svn17080.sql

2. upgrade_svn17086.sql

Link to comment
Share on other sites
ToiletMaster Poring

ToiletMaster

Posted
  • Group:  Members
  • Topic Count:  76
  • Topics Per Day:  0.02
  • Content Count:  276
  • Reputation:   7
  • Joined:  08/11/12
  • Last Seen:  
  • Author
Posted (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 by ToiletMaster
Link to comment
Share on other sites
kyeme Poring

kyeme

Posted
  • Group:  Members
  • Topic Count:  10
  • Topics Per Day:  0.00
  • Content Count:  164
  • Reputation:   12
  • Joined:  03/08/12
  • Last Seen:  
Posted (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 by kyeme
  • Upvote 1
Link to comment
Share on other sites
Lighta Poring

Lighta

Posted
  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  737
  • Reputation:   216
  • Joined:  11/29/11
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
ToiletMaster Poring

ToiletMaster

Posted
  • Group:  Members
  • Topic Count:  76
  • Topics Per Day:  0.02
  • Content Count:  276
  • Reputation:   7
  • Joined:  08/11/12
  • Last Seen:  
  • Author
Posted (edited)
  On 1/15/2013 at 7:44 AM, kyeme said:

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.

  On 1/15/2013 at 8:16 AM, Lighta said:

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

SQLproblem1_zpsf7fe71df.png

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 by ToiletMaster
Link to comment
Share on other sites
azze25 Poring

azze25

Posted
  • Group:  Members
  • Topic Count:  13
  • Topics Per Day:  0.00
  • Content Count:  48
  • Reputation:   0
  • Joined:  11/21/11
  • Last Seen:  
Posted (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 by azze25
Link to comment
Share on other sites
Lord Ganja Poring

Lord Ganja

Posted
  • Group:  Members
  • Topic Count:  141
  • Topics Per Day:  0.03
  • Content Count:  444
  • Reputation:   22
  • Joined:  06/18/12
  • Last Seen:  
Posted

Hello, I got errors when I updated my SVN to its latest revision.

try to look at this:

post-5465-0-44249700-1358296128_thumb.png

anyone knows how to solve this?

thanks in advance!

Link to comment
Share on other sites
Euphy Poring

Euphy

Posted
  • Group:  Members
  • Topic Count:  72
  • Topics Per Day:  0.02
  • Content Count:  2997
  • Reputation:   1133
  • Joined:  05/27/12
  • Last Seen:  
Posted

Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating.

You're probably missing:

  • Upvote 1
Link to comment
Share on other sites
Lord Ganja Poring

Lord Ganja

Posted
  • Group:  Members
  • Topic Count:  141
  • Topics Per Day:  0.03
  • Content Count:  444
  • Reputation:   22
  • Joined:  06/18/12
  • Last Seen:  
Posted (edited)
  On 1/16/2013 at 1:15 AM, Euphy said:

Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating.
You're probably missing:



Hi Euphy, thank you for that quick reply. Btw, how could I apply those upgrades? Edited by Lord Ganja
  • Upvote 1
Link to comment
Share on other sites
Vietlubu Drops

Vietlubu

Posted
  • Group:  Members
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  141
  • Reputation:   24
  • Joined:  01/19/12
  • Last Seen:  
Posted
  On 1/16/2013 at 1:19 AM, Lord Ganja said:
  On 1/16/2013 at 1:15 AM, Euphy said:

Always check trunk/sql-files/upgrades/ if you receive SQL errors from updating.

You're probably missing:

Hi Emistry, thank you for that quick reply. Btw, how could I apply those upgrades?

excute sql file on your database

Link to comment
Share on other sites
ToiletMaster Poring

ToiletMaster

Posted
  • Group:  Members
  • Topic Count:  76
  • Topics Per Day:  0.02
  • Content Count:  276
  • Reputation:   7
  • Joined:  08/11/12
  • Last Seen:  
  • Author
Posted
  On 1/15/2013 at 11:22 AM, azze25 said:

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.

  On 1/15/2013 at 7:44 AM, kyeme said:

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

Link to comment
Share on other sites
Brian Poring

Brian

Posted
  • Group:  Members
  • Topic Count:  75
  • Topics Per Day:  0.02
  • Content Count:  2223
  • Reputation:   594
  • Joined:  10/26/11
  • Last Seen:  
Posted
  On 1/15/2013 at 6:02 AM, kyeme said:

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing
×
×
  • Create New...