Fatal Error in Reviewpost

allcompu · November 9th, 2009, 01:03 AM

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.

Quote:

Fatal error: Call to undefined function get_regcode() in /home/signs101/public_html/reviewpost/pp-inc.php on line 2926

What did I do wrong and how can I correct it?

Thank you.

Chuck S · November 9th, 2009, 05:33 AM

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.

allcompu · November 9th, 2009, 10:21 AM

Quote:

Originally Posted by Chuck S

Did you install into reviewpost database?

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

Quote:

Originally Posted by Chuck S

did you overwrite reviewpost files with classifieds.

No.

Quote:

Originally Posted by Chuck S

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.

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.

Chuck S · November 9th, 2009, 10:38 AM

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.

Code:

Content visible to verified customers only.

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.

Chuck S · November 9th, 2009, 10:40 AM

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.

allcompu · November 9th, 2009, 11:31 AM

Quote:

Originally Posted by Chuck S

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.

Code:

Content visible to verified customers only.

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.

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

Quote:

Originally Posted by Chuck S

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.

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

allcompu · November 9th, 2009, 11:37 AM

Taking that back. The existing categories now provide this error when clicked into:

Quote:

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews,extra1,extra2,extra3,extra4,extra5,extra6,disporder,zipcode FROM rp_products WHERE approved=1 AND cat=3 ORDER BY disporder,price ASC

Result: Unknown column 'price' in 'order clause'

Database handle: Resource id #49

This is getting ridiculous.

Chuck S · November 9th, 2009, 12:40 PM

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.

Code:

Content visible to verified customers only.

price is a classifieds sort entry

allcompu · November 9th, 2009, 12:59 PM

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.

Chuck S · November 9th, 2009, 04:01 PM

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.

allcompu · November 9th, 2009, 04:41 PM

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.

Chuck S · November 9th, 2009, 04:56 PM

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

allcompu · November 9th, 2009, 05:02 PM

Quote:

Originally Posted by Chuck S

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

Maybe because Price Paid is part of the review criteria?

Chuck S · November 9th, 2009, 06:19 PM

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

allcompu · November 9th, 2009, 07:06 PM

Quote:

Originally Posted by Chuck S

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.

Chuck S · November 9th, 2009, 07:14 PM

well its fixed so thats good