MySQL Error on fresh install
I've just done a fresh install PP Classifieds (version 3.05) on a new machine after having hardware problems. It is integrated with VB 3.7
Testing it out I posted an advert and got this error message:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\websites\hangout\ppc\pp-inc.php on line 3346
Tables seemed ok but a did a MySQL repair tables anyway. Still the same problem.
Thanks for your help.
Turn on debug setting to display errors in global options in admin and then try the action and tell us the error when logged in as admin.
It gets worse
I did that and got:
We're sorry, but the system experienced an unrecoverable error. Please try again later
Now can't get into anything
Reset debug back to 0 in table cp_settings I'm back to the original error - at least I can get in again
If your logged in as admin the true error should be displayed.
what is this site?
That line looks like it may be this
Logged in as admin.
This is on a local machine, clean install of both VB and PPClassifieds. When I get it working I'll take down the live machine and replace with this one.
If I comment out from 3346
while ( list( $rating, $votes ) = mysql_fetch_row($totalv) )
if ( $rating == 1 ) $overall -= $votes;
elseif ( $rating == 3 ) $overall += $votes;
The error goes
Sorted it! (I think)
I output the variables $totalv and the query string, $query from the line above, to a text file. Line 3343 of pp_inc.php was trying to query a non-existent table - cp_feedback hadn't been created by the install process.
I tried to create it manually using the CREATE TABLE string from install.php and it produced a MySQL error - can't have a default value for the BLOB/TEXT field 'comments'. I've removed the default from it, run again and created the table. It appears OK now.
Yep bet you have mysql 5 set in STRICT MODE. Let me know if you have any other issues.
Thanks, I set it to "no_auto_create" now
No problem as long as you got it working.
|All times are GMT -5. The time now is 08:05 PM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0