Windows Unknown column 'item' in field list (1054)

[Mesmeroo]

Hello Guys

I ran into this problem in my console.
I get this error when the lottery takes place.

Unknown column 'item' in field list <1054>

I know it has something to do with a SQL querty, but i cant seem to find the querty to execute in DB.

 

[Ninja]

Do you have any SQL table for the lottery system?

 

[Mesmeroo]

Yes i have the table for lottery, i used this

CREATE TABLE `lottery` (
   `id` int(11) NOT NULL auto_increment,
   `name` varchar(255) NOT NULL,
   `item` varchar(255) NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

and this

INSERT INTO `lottery`(`id`, `name`, `item`) VALUES (NULL , 'Nobody', 'nothing');

while your looking at it, can you take a look at my other problem aswell?
http://otland.net/f16/problems-loading-login-lua-183250/

 

[Ninja]

I'm not experiencing any troubles with the lottery system, I assume we are using the same. (http://otland.net/f82/lottery-system-v2-45937/)

db.executeQuery("INSERT INTO `lottery` (`name`, `item`) VALUES ('".. getCreatureName(winner) .."', '".. getItemNameById(random_item) .."');")

 

[Mesmeroo]

Thanks, thats the one indeed.
I'll check when I'm back at home and ill update the post.

Did you take a look at my other issue? The one mentioned one post above you.

 

[Ninja]

Thanks, thats the one indeed.
I'll check when I'm back at home and ill update the post.

Did you take a look at my other issue? The one mentioned one post above you.

Yes, you can take a look here. No errors appeared when I loaded the script.

 

[Mesmeroo]

Thanks in advance.
I'll check when I'm at home.