Table 'reviewpost.notify' doesn't exist(FIXED)

[Tom1234]

Getting the following error with RP 3.0. Which upgrade should have created table reviewpost.notify?


An error was encountered during execution of the query:

SELECT c.catname,c.thumbs,c.cattype,c.parent,n.userid
FROM rp_categories c
LEFT JOIN notify n ON (n.userid=0 AND n.product=c.id AND n.type=1)
WHERE c.id=35

The query returned with an errorcode of:

Table 'reviewpost.notify' doesn't exist

[ncg]

you should run all the upgrades. just pick the first one and let it run through them all. you probably dont have some fields that the database needs. i had problems like this and omegatron suggested to run previous upgrade scripts to make sure all fields had been created.

[Chuck S]

Okay found it FIRST OFFICIAL BUG

FROM {$Globals['rp_db_prefix']}categories c
LEFT JOIN {$Globals['rp_db_prefix']}notify n ON (n.userid={$User['userid']} AND n.product=c.id AND n.type=1)
WHERE c.id=$cat";

[Tom1234]

which file should we make this change in?

[Chuck S]

index.php

[Tom1234]

New error:

An error was encountered during execution of the query:

SELECT c.catname,c.thumbs,c.cattype,c.parent,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=1

The query returned with an errorcode of:

Unknown column 'c.cattype' in 'field list'

[Chuck S]

I will let you know when the build is updated remove c.cattype from the query and remove , $cattype from the list results