phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Error SQL Error : 1146 Table 'x' doesn't exist...


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
freddie
Board Member



Joined: 12 Feb 2021

Posts: 4



PostPosted: Fri Feb 12, 2021 9:44 pm 
Post subject: Error SQL Error : 1146 Table 'x' doesn't exist...

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
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 728
Location: Texas


flag
PostPosted: Fri Feb 12, 2021 11:46 pm 
Post subject: Re: Error SQL Error : 1146 Table 'x' doesn't exist...

Does BOOKIE_CAT_TABLE have an entry in ./includes/constants.php? If not, it won't get translated to the actual table name.
_________________
phpBBDoctor Blog
Back to top
freddie
Board Member



Joined: 12 Feb 2021

Posts: 4



PostPosted: Sat Feb 13, 2021 1:18 pm 
Post subject: Re: Error SQL Error : 1146 Table 'x' doesn't exist...

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


Thanks for the pointer. I used easymod but apparently it skipped a bunch of files. Everything works. Now 2145451 other mods icon_biggrin.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0232 seconds using 15 queries. (SQL 0.0019 Parse 0.0008 Other 0.0205)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo