Problem in database: account_storage

[sidekoolz]

[Error - mysql_real_query] Query: SELECT value FROM account_storage WHERE account_id = 4 and key = 722524 LIMIT 1;
Message: Unknown column 'account_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT value FROM account_storage WHERE account_id = 4 and key = 722524 LIMIT 1;
Message: Unknown column 'account_id' in 'where clause'
[Error - mysql_real_query] Query: SELECT value FROM account_storage WHERE account_id = 4 and key = 145144 LIMIT 1;
Message: Unknown column 'account_id' in 'where clause'
[Error - mysql_store_result] Query: SELECT value FROM account_storage WHERE account_id = 4 and key = 145144 LIMIT 1;
Message: Unknown column 'account_id' in 'where clause'

This error appears after I open the server, what do I need to do in SQL?

Thanks!

 

[Infernum]

You need to change the query from account_id to id, nothing needs to be done in your database.

 

[sidekoolz]

How do I do that? Did not quite understand

 

[Infernum]

You have a query running (I don't know where, I'm no mindreader).
Find it in your files, it will say the nearly the exact same thing in the code as it does in the error (SELECT value from ......)
All you have to do is find that and change where it says account_id and make it id instead.

 

[sidekoolz]

It shows up there that it's on account_storage, right?

 

[Infernum]

What?

 

[sidekoolz]

FROM account_storage Does not mean anything?

 

[Infernum]

You're going to have me keep saying the same thing over and over again until you eventually get it.
You change account_id in the query you're running from your code to id.

 

[Kouki]

You can just add column "id" to your account storage...

ALTER TABLE `account_storage` ADD `id` int(11) NOT NULL DEFAULT 0

 

[Infernum]

You can just add column "id" to your account storage...

ALTER TABLE `account_storage` ADD `id` int(11) NOT NULL DEFAULT 0

Yeah sure, except that does nothing.

 

[Kouki]

Oh, my mistake..

 

[sidekoolz]

I can't fix it because I don't know which file has the wrong query.

 

[Infernum]

I can't fix it because I don't know which file has the wrong query.

Search your files for it.
Download a modern text editor such as sublime text, add your folder to project by clicking this:

Then ctrl+shift+f to search all files in project and search for:

SELECT `value` FROM `account_storage` WHERE `account_id`

 

[sidekoolz]

and i change account_id to id?

Post automatically merged: Jun 11, 2020

Search your files for it.
Download a modern text editor such as sublime text, add your folder to project by clicking this:

Then ctrl+shift+f to search all files in project and search for:

SELECT `value` FROM `account_storage` WHERE `account_id`

It worked, thank you very much and sorry, it's been 12 years since I touched otservs.