Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> lottery mod error help

SQL Error : 1146 Table 'totalonlineplay_com_-_phpnuke.LOTTERY_TABLE' doesn't exist

SELECT * FROM LOTTERY_TABLE WHERE id > 0

Line : 119
File : /home/virtual/site44/fst/var/www/html/one/phpnuke/modules/Forums/admin/admin_lottery.php

Possibly a short between the chair and keyboard....

I am lost

Register

many times i have to configure my mods for my site because i have it in a couple of sub-directories...as i see you do. Open up that file and look thru to see if you have something like "/html/admin/file/" if you do change it to w/e it is up to /admin/...

i think that might be what it is

First of all thanks Wolf..... Could you Dumb it down for me a bit.AKA which file ?

Register

Then again, since it is an SQL error, you have not set up the SQL for the Lottery right, or the configuration is wrong...is there like a config.php or anything to configure pertaining to the database?

Let me see if I can help.

SQL Error : 1146 Table 'totalonlineplay_com_-_phpnuke.LOTTERY_TABLE' doesn't exist

SELECT * FROM LOTTERY_TABLE WHERE id > 0

Line : 119
File : /home/virtual/site44/fst/var/www/html/one/phpnuke/modules/Forums/admin/admin_lottery.php

What that error is telling you is that in Line 119 of admin_lottery.php, you are trying to pull all the data from the LOTTERY_TABLE in your database, but it can't find a table by that name in your database. So the first step is to check to see if the table does indeed exist in your database. If it isn't then you either didn't run the sql that installs the table, or for some reason it didn't install when you ran the sql.

If the table does exist in your database, then you need to start checking config files to make sure your paths are correct.

Totally user error, I forgot to define 2 tables....Its fixed now
thanks guys