Warnings with a contest gallery.

mcleve · November 8th, 2007, 07:09 PM

I am running PhotopostPro6.0 and any gallery set as contest gives the following errors. Any ideas why?

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/mcleve/sandypebble.com/gallery/showgallery.php on line 241

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/mcleve/sandypebble.com/gallery/showgallery.php on line 242

example here.

I just upgraded to 6.01 with no change.
By the way this is a vb3 integration.

Chuck S · November 8th, 2007, 07:45 PM

I dont see any error there. The error suggests the upgrade script was not ran.

mcleve · November 8th, 2007, 08:11 PM

It appears that the error only shows to users with admin rights. As for the upgrade script, this was a fresh 6.0 install then I upgraded to 6.1 just a little while ago. The post refering to the upgrade stated:

Quote:

You do not need to run the upgrade script for this update; you only need update the changed files.

Either way the error occured before and after the upgrade. Any ideas what the error is all about?

Chuck S · November 8th, 2007, 09:06 PM

If you upgraded from 5.62 yes you needed to run it. I ran it so remove upgrade.php off your server and you should be fine. You only do not run the upgrade if you upgraded from 6.0 to 6.01

Here is the correct post to quote on upgrade instructions and they are also included in the documentation portion of the download.

http://www.photopost.com/forum/showthread.php?t=133338

mcleve · November 8th, 2007, 09:51 PM

As I mentioned before I upgraded from 6.0, so that is not a problem. My issue is the errors mentioned above. This error only occurs with administrator accounts. do you have any ideas what is wrong?

Chuck S · November 8th, 2007, 09:58 PM

As I stated you should be fine now. You did not have the votes table in your comments table. That was the error those lines refer to.

Marcin · November 25th, 2007, 06:15 AM

I had a similar problem. It was caused by the fact that the column "votes" was actually not available in the 6.0 version of the script.

The 6.0 version was the first one that I ever used.

Therefore, you should really add another option to your upgrade script, upgrading the columns table.

Chuck S · November 25th, 2007, 10:55 AM

Yes downloading the current scripts and running the upgrade script would be correct action when dealing with fixing any bugs that where previously reported and fixed.

Nephalim · November 25th, 2007, 10:58 AM

do not mean to hijack but how do you make a gallery a contest? i have 6.0.1

Chuck S · November 25th, 2007, 11:05 AM

In ADMIN => Edit Categories you can set whether a category uses regular ratings or is a contest rating.