Jump to content
Sign in to follow this  
inknowv8

TABLE_PAGES doesn't exist issue

Recommended Posts

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
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

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
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
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
www . theufolibrary . com/catalog/

 

have you made changes to the configure files?

Edited by Jan Zonjee

Regards

 

Mark A Reynolds

Share this post


Link to post
Share on other sites
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
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
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

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

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
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
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
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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×