inknowv8 0 Posted March 6, 2008 Here is the issue I am running into. The host is using PHP 5.02. Thank you in advance for your help. 1146 - Table 'theufo41.TABLE_PAGES' doesn't exist select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 Ok fixed that topic Share this post Link to post Share on other sites
crash3903 1 Posted March 6, 2008 Ok fixed that topic What was it - didn't run a sql file or didn't add the table define in the tables file? Regards Mark A Reynolds Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 I installed this contribution and now I can not see any any of my boxes and I can't login to the admin. Please help I really need to get this up by tomorrow. Thank you in advance. Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 What was it - didn't run a sql file or didn't add the table define in the tables file? I did not define one of the tables. But now the tables are all not showing up and I can't get into my admin. hmmmmm Share this post Link to post Share on other sites
crash3903 1 Posted March 6, 2008 I did not define one of the tables. But now the tables are all not showing up and I can't get into my admin. hmmmmm url? Regards Mark A Reynolds Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 (edited) url? www . theufolibrary . com/catalog/ Edited July 23, 2008 by Jan Zonjee Share this post Link to post Share on other sites
crash3903 1 Posted March 6, 2008 (edited) www . theufolibrary . com/catalog/ have you made changes to the configure files? Edited July 23, 2008 by Jan Zonjee Regards Mark A Reynolds Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 have you made changes to the configure files? I haven't touched the configure file Share this post Link to post Share on other sites
crash3903 1 Posted March 6, 2008 I haven't touched the configure file to be able to properly diagnose your problem I would need some access - If you want to PM me some access details then I would be happy to help Regards Mark A Reynolds Share this post Link to post Share on other sites
inknowv8 0 Posted March 6, 2008 to be able to properly diagnose your problem I would need some access - If you want to PM me some access details then I would be happy to help PM? Ping? I can send you the login and password. How would you like me to send ti to you? Share this post Link to post Share on other sites
HanZ 0 Posted March 16, 2008 PM? Ping? I can send you the login and password. How would you like me to send ti to you? Is there an answer? have the same problem Grtz HanZ ----------- Life is simple, only people make it complicated... Louis Couperus, Dutch writer (1863-1923) Share this post Link to post Share on other sites
janice171 0 Posted March 20, 2008 yep i too have this problem...anyone found any answers. This problem has arisen from a clean install of 2.2rc2: 1146 - Table 'username_shop.TABLE_PAGES' doesn't exist select p.pages_id, p.sort_order, p.status, s.pages_title, s.pages_html_text from TABLE_PAGES p LEFT JOIN TABLE_PAGES_DESCRIPTION s on p.pages_id = s.pages_id where p.status = 1 and s.language_id = '1' and p.page_type = 1 [TEP STOP] thanks for any help Share this post Link to post Share on other sites
RAH 0 Posted July 21, 2008 Has anyone found a solution to this? 1146 - Table 'strapcod_osc1.TABLE_PAGES' doesn't exist select pd.pages_title, pd.pages_body, p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order from TABLE_PAGES p, TABLE_PAGES_DESCRIPTION pd where p.pages_name = 'home' and p.pages_id = pd.pages_id and pd.language_id = '1' [TEP STOP] Share this post Link to post Share on other sites
Jan Zonjee 57 Posted July 22, 2008 Has anyone found a solution to this? 1146 - Table 'strapcod_osc1.TABLE_PAGES' doesn't exist select pd.pages_title, pd.pages_body, p.pages_id, p.pages_name, p.pages_image, p.pages_status, p.sort_order from TABLE_PAGES p, TABLE_PAGES_DESCRIPTION pd where p.pages_name = 'home' and p.pages_id = pd.pages_id and pd.language_id = '1' [TEP STOP] It would help if you added the defines for those tables to the (correct - catalog or admin) includes/database_tables.php (as will surely be mentioned in the install instructions). Share this post Link to post Share on other sites
RAH 0 Posted July 22, 2008 It would help if you added the defines for those tables to the (correct - catalog or admin) includes/database_tables.php (as will surely be mentioned in the install instructions). How do I do this? Share this post Link to post Share on other sites
Jan Zonjee 57 Posted July 22, 2008 How do I do this? Downloading that file and using a text editor to add those defines. If you take a look at the file you'll get the idea. It wouldn't hurt to read the instructions of that contribution again. I'm almost sure it is mentioned somewhere. I can almost predict it will look like this: define('TABLE_PAGES', 'pages'); define('TABLE_PAGES_DESCRIPTION', 'pages_description'); Share this post Link to post Share on other sites
RAH 0 Posted July 23, 2008 Great that issue is now fixed however now I'm getting this: Warning: require(includes/boxes/boxad.php) [function.require]: failed to open stream: No such file or directory in /home/strapcod/public_html/store/includes/column_left.php on line 30 Warning: require(includes/boxes/boxad.php) [function.require]: failed to open stream: No such file or directory in /home/strapcod/public_html/store/includes/column_left.php on line 30 Fatal error: require() [function.require]: Failed opening required 'includes/boxes/boxad.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/strapcod/public_html/store/includes/column_left.php on line 30 Where do I get boxad.php from? It's not in the contribution. Share this post Link to post Share on other sites
PStueck 0 Posted November 24, 2009 I also do not have the boxad.php file and am getting the same errors. Any one have it? Share this post Link to post Share on other sites