RP error and question(FIXED)

[mixylplik3]

SELECT c.id,c.catname,c.template,n.userid
FROM rp_categories c
LEFT JOIN rp_notify n ON (n.userid=0 AND n.product=c.id AND n.type=1)
WHERE c.id=archive

The query returned with an errorcode of:

Unknown column 'archive' in 'where clause'

This is the latest random error I got. I upgraded from 2.8.2 to 3 a few days ago. I have gone back to run earlier upgrades, and in fact have redone my upgrade (from 2.8.2 to 3) and didn't get any errors during that process.

I'm also wondering if it's possible to blow away everything EXCEPT the reviews themselves. By that I mean install a fresh copy of RP and import the reviews.

[Arnie]

Well the reviews are linked and refer to a userbase. You can't really cut down the database as all it stores is userdata that you need, reviews, config, and the categories.

Where did this error crop up, which page? It could be that a query in your code has a typo in it. At a quick guess 'archive' should be a string or similar.

[mixylplik3]

I got that message in a debug email. I don't know what page it came from.

[Chuck S]

Well the code is in showcat.php and maybe a playing bot

Content visible to verified customers only.

You can change to this as it wont harm anything

Content visible to verified customers only.

[mixylplik3]

Thanks. I have been trying to duplicate the error without success. I didn't even think of it possibly being a bot. Thanks.