Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> SQL Error when Lottery picks a winner [SOLVED]

I have the Lottery add on installed. It was working okay until it actually went to pick a winner, so to speak.

I could purchase tickets ok, but got the following error message when I go to the Lottery link:

Error getting information from users table!

DEBUG MODE

SQL Error : 1054 Unknown column 'user_items' in 'field list'

SELECT `username`, `user_items` FROM nuke_users WHERE user_id='2'

Line : 184
File : /home/virtual/site48/fst/var/www/html/modules/Forums/lottery.php

I changed the option for the lottery to Auto-restart and everything is working.

I've always had the Auto-Restart option on but I can't get past this error when it's time to draw a winner:

General Error

Error getting information from users table!

DEBUG MODE

SQL Error : 1054 Unknown column 'user_items' in 'field list'

SELECT `username`, `user_items` FROM nuke_users WHERE user_id='17'

Line : 184
File : /home/virtual/site155/fst/var/www/html/modules/Forums/lottery.php

Anybody know how to fix this yet?
There's a few others asking the same question over at phpbbhacks but no fixes as of yet.

Register

The user_items field is added to the nuke_user table when you install the shop mod. I didn't notice the correlation, but you may have to have the shop mod installed before you run the lottery mod.

Both of these mods were made by zarath, and I would bet that could be your problem. Try adding the shop mod and see if that works.

I think the way the lottery was set up was so an individual could win items from the shop in the lottery, not just points.

Here is a portion of the sql from the shop mod install that adds this:

$sql[] = "alter table " . USERS_TABLE . " add `user_items` TEXT";

I'll give it a shot ~ thanks

That worked

I uploaded the shop files and ran the sql but didn't edit any of the files to finish up the full shop install.

I turned the Lottery back on and set the time limit to 120 seconds to see if the draw would work and YES it did.

Thanks Dauthus