Codezwiz >> Forums >> Codezwiz BBtoNuke Mods Help >> Ne help with a Lottery Mod SQL Error

Ok hello all,

I am having a problem with the lottery mod. I have uploaded all the files and did all the edits. I uploaded the sql file. I am running nuke 7.6.0.31 and forums 2.0.17..

Error is

An Error Occurred

DEBUG MODE

SQL Error : 1146 Table 'XXXXXXXXXX.lottery' doesn't exist

SELECT * FROM lottery WHERE id > 0

Line : 119
File : admin_lottery.php

Hey there. Here's a little briefing on SQL select statements:

SELECT = go get me....
* = everything...
FROM = from this table:

So that being said, your code:

An Error Occurred

DEBUG MODE

SQL Error : 1146 Table 'XXXXXXXXXX.lottery' doesn't exist

SELECT * FROM lottery WHERE id > 0

Line : 119
File : admin_lottery.php

yeah in my database it shows nuke_lottery. but that is not what it comes up when it comes with in the error. So if that is the case then where is it wrong in the files.

I would look for something like

SELECT * FROM lottery WHERE id > 0

Ok i found it but what do I edit for it to find the right table.

Here is the code.

$sql = "SELECT *
   FROM " . LOTTERY_TABLE . "
   WHERE id > 0";
if ( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}

Perhaps there is a language file in there that can be edited? Do you have a language file with that mod?

just lang_admin and lang_main

Doesn't seem that it is going to work. Thanks for the help.

Well, without knowing too much about that module, the easy answer is to change:

" . LOTTERY_TABLE . "

Yeah. I think i am just going to remove it. Doesn't seem to want to work. thanks for the help. Note I did try that and got a page can't be defined. So not sure but thanks for the help.

Well I looked at the module and perhaps you missed this part on the install:

#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
define('LOTTERY_TABLE', $prefix.'_lottery');
define('LOTTERY_HISTORY_TABLE', $prefix.'_lottery_history');

#