Guest Posted April 25, 2013 Share Posted April 25, 2013 I have read every post and Googled but I found no solution so hoping someone can answer. I have the addon - Extra Pages-Info box installed on localhost that works fine but can not get it working online. tried all I know. I get this database error every time: Extra Infos Page Manager 1146 - Table 'db407532263.TABLE_PAGES' doesn't exist select count(*) as total from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where s.language_id='1' Of course the tables are in the database. Please, please help. Tom Quote Link to comment Share on other sites More sharing options...
germ Posted April 25, 2013 Share Posted April 25, 2013 When you get UPPER_CASE_EERORS like that it usually means you have missed a "define" in a PHP file. Check you /admin/includes/database_tables.php and be sure it includes definitions for TABLE_PAGES and TABLE_PAGES_DESCRIPTION Quote If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2013 Share Posted April 25, 2013 Thanks for the reply. Seems I am OK there. I double checked. Here is the defines from the database_tables.php: define('TABLE_WHOS_ONLINE', 'whos_online'); define('TABLE_ZONES', 'zones'); define('TABLE_PAGES', 'pages'); define('TABLE_PAGES_DESCRIPTION', 'pages_description'); ?> Have any more ideas? Tom Quote Link to comment Share on other sites More sharing options...
germ Posted April 25, 2013 Share Posted April 25, 2013 That's in In the ADMIN SIDE ON THE SERVER (not your local copy)? :unsure: Quote If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2013 Share Posted April 25, 2013 Yes it is? and same on localhost. using same database_tables.php file.... All works fine on localhost using Wamp. The problem is in live site. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 25, 2013 Share Posted April 25, 2013 I'll re-state first post. All works fine offline (Localhost). The error appears in admin online when I try working with the extra pages. Quote Link to comment Share on other sites More sharing options...
jedimarv Posted March 7, 2014 Share Posted March 7, 2014 I have a question.it's about the add-on extra info pages.I'm trying to add more pages than the max of 10 pages.Where can I adjust this in the script. I have added 30 pages in the <option> And have added it in this section also if ($action == 'insert') { if($page_type == "1" || $page_type == "2" || $page_type == "3" || $page_type == "4" || $page_type == "5" || $page_type == "6" || $page_type == "7" || $page_type == "8" || $page_type == "9" || $page_type == "10" || $page_type == "11" || $page_type == "12" || $page_type == "13" || $page_type == "14" || $page_type == "15" || $page_type == "16" || $page_type == "17" || $page_type == "18" || $page_type == "19" || $page_type == "20" || $page_type == "21" || $page_type == "22" || $page_type == "23" || $page_type == "24" || $page_type == "25" || $page_type == "26" || $page_type == "27" || $page_type == "28" || $page_type == "29" || $page_type == "30") { $selectquery=tep_db_query("select count(*) as count from ". TABLE_PAGES ." where page_type=\"$page_type\""); $exists = tep_db_fetch_array($selectquery); if($exists['count'] >= 1) { $updateall=tep_db_query("update ". TABLE_PAGES ." set page_type=\"30\" where page_type=\"$page_type\""); } } } if ($action == 'update') { if($page_type == "1" || $page_type == "2" || $page_type == "3" || $page_type == "4" || $page_type == "5" || $page_type == "6" || $page_type == "7" || $page_type == "8" || $page_type == "9" || $page_type == "10" || $page_type == "11" || $page_type == "12" || $page_type == "13" || $page_type == "14" || $page_type == "15" || $page_type == "16" || $page_type == "17" || $page_type == "18" || $page_type == "19" || $page_type == "20" || $page_type == "21" || $page_type == "22" || $page_type == "23" || $page_type == "24" || $page_type == "25" || $page_type == "26" || $page_type == "27" || $page_type == "28" || $page_type == "29" || $page_type == "30") { $selectquery=tep_db_query("select count(*) as count from ". TABLE_PAGES ." where page_type=\"$page_type\" and pages_id != \"(int)$pages_id\""); $exists = tep_db_fetch_array($selectquery); if($exists['count'] >= 1) { $updateall=tep_db_query("update ". TABLE_PAGES ." set page_type=\"30\" where page_type=\"$page_type\""); } } } But still is shows in the database in page_type the number 1. It goes up to 9 and no further Is there anyone who can help me with this problem Where in the script can I adjust this Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.