PhotoPost Community - MySQL Error Report

PhotoPost Community (http://www.photopost.com/forum/)

- ReviewPost BETA (http://www.photopost.com/forum/reviewpost-beta/)

- - MySQL Error Report (http://www.photopost.com/forum/reviewpost-beta/142277-mysql-error-report.html)

Micky

March 7th, 2010 04:44 AM

MySQL Error Report

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

Quote:

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

March 7th, 2010 05:51 AM

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

Code:

Content visible to verified customers only.

Micky

March 7th, 2010 05:06 PM

Hi Chuck,

the next Error Report

Quote:

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

March 7th, 2010 06:51 PM

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

Code:

Content visible to verified customers only.

Micky

March 7th, 2010 07:40 PM

Okay, Thanks. ;)

Chuck S

March 7th, 2010 07:57 PM

enjoy whats left of the weekend. ;)

All times are GMT -5. The time now is 03:05 PM.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97