MySQL Error on fresh install

azarl · February 21st, 2009, 05:13 AM

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.

Chuck S · February 21st, 2009, 08:32 AM

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.

azarl · February 21st, 2009, 09:25 AM

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

azarl · February 21st, 2009, 09:35 AM

Reset debug back to 0 in table cp_settings I'm back to the original error - at least I can get in again

Chuck S · February 21st, 2009, 09:29 PM

If your logged in as admin the true error should be displayed.

what is this site?

That line looks like it may be this

Code:

Content visible to verified customers only.

Your sure things where installed or was this an upgrade?

azarl · February 22nd, 2009, 05:20 AM

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

azarl · February 22nd, 2009, 06:37 AM

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.

Chuck S · February 22nd, 2009, 10:20 AM

Yep bet you have mysql 5 set in STRICT MODE. Let me know if you have any other issues.

azarl · February 23rd, 2009, 03:46 AM

Thanks, I set it to "no_auto_create" now

Chuck S · February 23rd, 2009, 06:45 AM

No problem as long as you got it working.