Continue the legacy...

[freddie]

Hey,

Trying to get a phpbb2 board running again

I have a bookie mod throwing some errors

for example

SQL Error : 1146 Table 'deb69602_keep.BOOKIE_CAT_TABLE' doesn't exist

SELECT * FROM BOOKIE_CAT_TABLE ORDER BY cat_name ASC

Line : 253
File : admin_bookies_setbet.php

the line in my admin_bookies_setbet.php file is

$cat_name=array();
$sql=" SELECT * FROM " . BOOKIE_CAT_TABLE . "
ORDER BY cat_name ASC
";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error in building existing bets', '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
$key=$row['cat_id'];
$cat_name[$key]=$row['cat_name'];
if ( $mode != 'edit' )
{
$selected=( $row['cat_id'] == $board_config['bookie_def_cat'] ) ? $row['cat_id'] . '" selected="selected' : $row['cat_id'];
$cat_box .= '<option value="' . $selected . '">' . $row['cat_name'];
}
}

I have the table in my database

What am i doing wrong ?

Thank you

[drathbun]

Does BOOKIE_CAT_TABLE have an entry in ./includes/constants.php? If not, it won't get translated to the actual table name.

[freddie]