MySQL Error Report

[Micky]

Hi, Chuck,
I receive this mistake message of the last update.

SELECT catname FROM categories WHERE id='10'

The query returned with an errorcode of:

Table 'xxxxx-porsche.categories' doesn't exist

my rp_db_prefix must have 'xxxxx-porsche.porsche_rp_categories'

[Chuck S]

Thats because in the get_catname function in pp-inc.php this query has pp_db_prefix and it should read rp_db_prefix

Content visible to verified customers only.

[Micky]

Hi Chuck,

the next Error Report

SELECT o.*,p.title AS title,p.cat AS cat FROM porsche_rp_iponline o LEFT JOIN porsche_rp_photos p ON (p.id=o.item) ORDER BY o.uid DESC,o.date DESC LIMIT 0,50

The query returned with an errorcode of:

Table 'xxxxx-porsche.porsche_rp_photos' doesn't exist

[Chuck S]

That was previously posted in online.php the query should read this

Content visible to verified customers only.

[Micky]

Okay, Thanks.

[Chuck S]

enjoy whats left of the weekend.