mysql errors

Blessed Mama · May 17th, 2009, 11:32 AM

When I try to click "Member Galleries"
this pops up at the top, and nothing else is shown below:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in snip/lifescrappers/gallery/showmembers.php on line 352

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in snip/lifescrappers/gallery/showmembers.php on line 382

Chuck S · May 17th, 2009, 11:47 AM

Have you recently upgraded any changes?

If you upgraded and did not run any upgrade scripts you needed to you might get that error. if your are logged in as admin you can go to global options in admin and select debug option and set to to display errors then when viewing the page it should show the full true mysql error.

Blessed Mama · May 17th, 2009, 01:59 PM

We just bought and installed our photopost last week...should we still need to upgrade??

Chuck S · May 17th, 2009, 02:25 PM

Feel free to post a url and test user login here

Blessed Mama · May 18th, 2009, 07:09 PM

I'm sorry, but I don't know what you're asking.
The gallery url is Life-Scrappers Layout Gallery - Main Index

Chuck S · May 18th, 2009, 09:22 PM

Okay try this

email us through the contact us link with your url admin login and ftp information

Chuck S · May 26th, 2009, 11:51 AM

The issue as I see it is you have installed the gallery with the same table prefix as the forum.

Your forum and photopost are both using a table prefix of phpbb_

Blessed Mama · May 28th, 2009, 07:36 AM

Um, from what we understood when setting it up, in order to have the users integrated, that's what we needed to do. How else can the forum users and gallery users be integrated?

Chuck S · May 28th, 2009, 10:20 AM

This is why you have two database areas in the photopost config when you install. Photopost suggests its tables to be pp_ but you could change that. You then are given the option to enter the forum database and setup the table prefix we need to look for the forum user info etc so integration is done.

Through all of this though your photopost and forum tables should be there own. Yours however are not. Your trying to run your photopost with the same prefix therefore you need to reinstall with the photopost tables being say pp_ and select to integrate with your forum and fill out all the proper forum info where asked.

Blessed Mama · June 3rd, 2009, 10:12 PM

OK, now the errors aren't showing up, BUT the member galleries link will not show any photos, even though there are member galleries created with photos in them.
also, we are having to log into the forum to get into the gallery - we can't log directly into the gallery.
the test url we're using is My Photo Gallery - Main Index (everything is the same as was emailed to you before, except the folder is life-scrappers instead of lifescrappers)

Chuck S · June 4th, 2009, 10:13 AM

My suggestion is to go to admin => scan database and select to rebuild the users last photo and submit

Blessed Mama · June 4th, 2009, 05:44 PM

Unfortunately, I can't even log in at the moment.

Blessed Mama · June 4th, 2009, 05:54 PM

OK got in, and it worked.

Thanks again, Chuck!

Chuck S · June 4th, 2009, 09:54 PM

Have a good evening.