1146 - Table 'SQL_DB.TABLE_PAGES' doesn't

[The Stig]

Any clue as to were i have gone wrong please?

 

is it due to me missing a SQL update or patch?

 

I can see that the table is not in the SQL DB but i din't know what the config of the table would be ie what coragorys should be in the table???

 

1146 - Table 'DB_DB.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.sort_order > 0 order by p.sort_order, s.pages_title

[OceanRanch]

Looks like a contribution (possibly "extra Pages") was not fully installed. The php/sql code is looking for a define in the database_tables.php for TABLE_PAGES and can't find it so it uses the table name TABLE_PAGES which of course is not in the database.

 

Check with who installed the contribution and re-check that ALL the files were properly updated and that any SQL table changes via a .sql file were applied.

 

HTH

Tom