Fatal Error in Reviewpost
 

I just did a complete reinstall of Photopost Classifieds in which I changed from using the Photopost database to using the vBulletin database. It appears to be working fine. Now, however, I find I get the following error when I attempt to access the Reviewpost index page which was working fine until I did the reinstall of Classifieds.
What did I do wrong and how can I correct it?

Thank you.

Did you install into reviewpost database? did you overwrite reviewpost files with classifieds. My suggestion would be to reupload reviewpost minus config files of course and see where that leaves you. at the very least reupload the forums subdirectory under reviewpost because thats where that function is found in your integration file and yours is gone.

No. In installed into the vBulletin database using a cp_prefix. The only issue was an error report that the zipdata already existed.

No.

I have re-uploaded all files except the config files and the JS directory ... even though nothing in the RP folder had been touched. Still getting the fatal error. What almost certainly has happened is the reinstall of the Classifieds which involved putting it in the vb database instead of the pp database (with a cp_ prefix) has somehow interacted with the Reviewpost tables (with an rp_ prefix) in the same vb database.

I have run check and repair routines on the vb database and nothing shows up as wrong as far as the tables are concerned.

My next step is to drop the rp_ tables and reinstall Reviewpost unless you have a better suggestion ... which means losing most or all of my work so far in getting that application setup and running.

Your error has nothing to do with a database persay. The only way you would get the error like this is one of two reasons.

The vb3.php file in your reviewpost forums subdirectory is corrupt.

or

You somehow reinstalled into reviewpost placing a bogus value in the settings table for setting 41 which should read vb3 in your rp_settings table. That way we know to look for the vb3.php file and thats where the function get_regcode exists.

why not simply rerun the install script for reviewpost overtop its current tables and see if that helps. that way you dont delete any data that already exists.

vb3.php was replaced and setting 41 looks correct. Still no Reviewpost.

That is what I did and it now is back with lots of my changes overwritten.

Taking that back. The existing categories now provide this error when clicked into:
This is getting ridiculous.

Main Index - Signs 101 Product Reviews

seems to be up and running but your error is now different.

There is no price sort in reviewpost thats your problem.

price is a classifieds sort entry

Well I did nothing more than download the latest version of ReviewPost and start from scratch with my next to last install. As I've mentioned once or twice before, there is a bit of crossover language from reviews to classifieds ... and I guess vice versa, that one runs across in dealing with the two applications side by side.

Whatever you're saying is so is not of my doing.

The sorts are exactly as I am posting in the build that I see. Feel free if your reviewpost tables are in vb database to use your vbulletin sql manager under maintenance to run the queries I posted above.

Thank you. I did not understand from your previous post what your meant or that those were queries for me to run. Running them fixed the problem.

Yeah dont know why yours included price but glad yours is fixed.

Maybe because Price Paid is part of the review criteria?

Nope not a chance. The only way your error would occur is if a classifieds sort was entered into reviewpost.

I don't propose to know how it happened. I did nothing to Reviewpost. It was installed and working. All I know is that I removed all traces of PP Classifieds, uploaded a newly configured set of files for PP Classified and installed them ... using the vb database instead of the Photopost database. Somewhere in that sequence is the how and why it happened. Neither the RP folder on my hard drive nor the RP folder on my server was ever touched. All files used were from a fresh unzip of your latest download from the members area.

well its fixed so thats good ;)