Jump to content

Recommended Posts

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

Share this post


Link to post
Share on other sites

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


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 >

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

That's in In the ADMIN SIDE ON THE SERVER (not your local copy)?

:unsure:


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 >

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

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

×