mysql_fetch_row()

[Barticus89]

When I click on "My Photos", I get this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2621

And the main window says "You do not have permission to view this category."

I think I've set the permissions in the admin control panel correctly, but maybe I'm missing something.

Thanks.
-Bart

[Chuck S]

Link to your site?

Thats a weird error line to have.

[Barticus89]

Hi Chuck,
I appreciate your help. My site is a private forum for a fraternity, and they're really weird about outsiders looking at the forums.... Can I give you a temporary guest login?
Thanks for your help.
-Bart

[Chuck S]

You can

[Barticus89]

Chuck,

When I try to create an album from my user account, it does not get created, and I get this error:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 4250

When I try to create categories in the Admin Control Panel, I get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/adm-cats.php on line 241
And it says, "Unable to find categoy: 508"

However, if I look at the directory structure on the server, the 508 directory is there, along with a bunch of others (apparently created as I've tried to set up new categories.)

Any ideas about what might be wrong? I've checked my permissions, and /data and all the subdirectories are set to 755.

Thanks,
-Bart

[Barticus89]

Also, I'm getting errors when I even just click on a category under the Main heading.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/showgallery.php on line 122
And the display area says, "You do not have permission to view this category"

I also get these errors when I upload photos during the bulkupload process, when the redirect page comes up that says the upload was successful. These error messages are at the top of the screen before it takes me to the category where they were uploaded (where it says I don't have permission to view this category).

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/phibeta2/public_html/photos/pp-inc.php on line 2692

[Chuck S]

Hello still no info from you so without knowing more on the exact situation hard to say. In your global options set display errors as the default in debug option.

Did you upgrade and not run an upgrade script? we need to see the real error to comment so turn on the debug and post the real error

[Chuck S]

Check to see your categories table is not using phpmyadmin

[Barticus89]

Ok, I turned debug "on". When I simply try to view a category under the Main heading, this error appears:

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

Script:

Query: SELECT c.id,c.catname,c.thumbs,c.cattype,c.parent,c.theme,c.thumbtype, c.sortorder,c.frames,c.intro,c.introtitle,c.introcopy,c.ratingtype,c.takevotes,c.ismember,n.userid FROM pp_categories c LEFT JOIN pp_notify n ON (n.userid='1' AND n.photo=c.id AND n.type=1) WHERE c.id=505

Result: Unknown column 'c.thumbtype' in 'field list'

Database handle: Resource id #22

[Barticus89]

Originally Posted by Chuck S

Check to see your categories table is not using phpmyadmin

Please explain how to do that, Chuck. I have no idea what that means.
Thank you.
-Bart

[Chuck S]

In your control panel of your site you should see a phpmyadmin link

You can in there view your database and check the table names and select repair or use the sql box and type this

REPAIR TABLE pp_categories

Again without more info on what you did to your site like upgrading or what not I am stabbing in the dark

[Barticus89]

Done. Repair status: OK.

This is a re-install. A long time ago, I had an older version of Photopost on the server, but it was using it's own database and installed in a different directory (/gallery), and I couldn't get it to work well so I took it off. This time around, I chose to use one common database for vBulletin and Photopost, installed it in a different directory (/photos). Do you think there may be some lingering settings, tables, code, etc that's messing with the new installation?

These are colocated servers running Linux 2.6.16.17-grsec on an i686 with Apache 1.3.36 (Unix), PHP 4.4.2 and mySQL 4.1.21-standard.

Hope that helps. Thanks.
-Bart

[Chuck S]

Looks to me like you have old database tables. if this is a total reinstall probaly best to drop the photopost tables and reinstall otherwise you need to run the applicable upgrade scripts from your last version forward if your using an older database structure

[Barticus89]

The upgrade script took care of the problems. Thanks Chuck.
-Bart

[mukoh]

I am getting the same type errors.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mukohbox55/domywife.com/forums/photopost.php on line 373 Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/mukohbox55/domywife.com/forums/photopost.php on line 332

What can I do? Chuck the site is domywife.com (NOT SAFE FOR WORK)

[Chuck S]

Using your sites control panel use phpmyadmin and type this sql when viewing the photopost database

REPAIR TABLE pp_iponline