Warning: mysql_fetch_row(): supplied argument is not a valid

mikem

Joined: 2002-08-22
Posts: 19
Posted: Fri, 2002-08-23 17:25

I get this error when accessing my Gallery. The error didn't start showing up until just a while ago. I had gone through configuring the gallery and uploading a few files and never once saw this error until now. It is at the top of my test site when you enter Gallery.

http://www.fastacs.com/test/

Quote:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/f/fastacs/htdocs/test/modules/gallery/classes/database/mysql/Database.php on line 35

I have searched this site thouroughly(at least I think I have) and I cannot find ANYTHING relative to this subject. Anyone have any ideas?

mikem
 
TheWatcher
TheWatcher's picture

Joined: 2002-08-21
Posts: 120
Posted: Fri, 2002-08-23 17:36
Quote:
I get this error when accessing my Gallery. The error didn't start showing up until just a while ago. I had gone through configuring the gallery and uploading a few files and never once saw this error until now. It is at the top of my test site when you enter Gallery.

http://www.fastacs.com/test/

>>
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /www/f/fastacs/htdocs/test/modules/gallery/classes/database/mysql/Database.php on line 35
<<

I have searched this site thouroughly(at least I think I have) and I cannot find ANYTHING relative to this subject. Anyone have any ideas?

mikem

I've visited your site and everything seems to be working find...

btw, nice site.
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2002-08-23 17:41

I checked it out also and didn't see the error. Does it only occur if you're logged in to the site?
 
mikem

Joined: 2002-08-22
Posts: 19
Posted: Fri, 2002-08-23 17:41

Ok I think I am going crazy!! Just as a goof, I re-uploaded the Database.php file that came with the Gallery and I am not getting that error anymore. Can I have a ice cream now? Oh the humanity!! :eek:

mikem
 
mikem

Joined: 2002-08-22
Posts: 19
Posted: Fri, 2002-08-23 17:56
Quote:
I checked it out also and didn't see the error. Does it only occur if you're logged in to the site?

AH-HA, I just duplicated by logging out of my site, however, whenn I log back in, the error persists. Then, if I uplaod the Database.php file again, no error, until I log out again...BAH...Definately related to logging in and out.

mikem
 
mikem

Joined: 2002-08-22
Posts: 19
Posted: Fri, 2002-08-23 18:02
Quote:
btw, nice site.

Sorry I missed your compliment. Thank you.

mikem
 
TheWatcher
TheWatcher's picture

Joined: 2002-08-21
Posts: 120
Posted: Fri, 2002-08-23 18:23
Quote:
>>I checked it out also and didn't see the error. Does it only occur if you're logged in to the site?<<

AH-HA, I just duplicated by logging out of my site, however, whenn I log back in, the error persists. Then, if I uplaod the Database.php file again, no error, until I log out again...BAH...Definately related to logging in and out.

mikem

log in and out issue.... this is interesting .. i will try to replicate your issue to one of my test server later tonight.

I'll keep you posted.
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Sat, 2002-08-24 03:33

Mikem -- you're running Gallery in phpBB2, right? That means that you applied the phpBB2 integration patch and so you're running a non-standard patch. *And*, the problem is happening in the user authentication code which was undoubtedly part of the patch. This means that we can't help you -- you need to talk to the guy who wrote the patch. I suggest you post a question in the "Gallery in Other Applications" forum and see if WebSnail has an answer for you.

-Bharat
 
TheWatcher
TheWatcher's picture

Joined: 2002-08-21
Posts: 120
Posted: Sat, 2002-08-24 04:21
Quote:
Mikem -- you're running Gallery in phpBB2, right? That means that you applied the phpBB2 integration patch and so you're running a non-standard patch. *And*, the problem is happening in the user authentication code which was undoubtedly part of the patch. This means that we can't help you -- you need to talk to the guy who wrote the patch. I suggest you post a question in the "Gallery in Other Applications" forum and see if WebSnail has an answer for you.

-Bharat

thanks bharat, you make my life easier ... I haven't encounter the error. I suppose to test this on my server... ignore it then.
 
mikem

Joined: 2002-08-22
Posts: 19
Posted: Wed, 2002-09-04 21:55

Ok UPDATE> I never figured out the SQL error message I was getting. I do know that it was due to some changes in the nuke_users table in version 6.0 of PHP-Nuke. I tried the Gallery on version 5.5 and 5.6 of PHP-Nuke as a Module and it works PERFECTLY!!!

Thanks to everyone.
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Thu, 2002-09-05 04:42

Doh. I haven't kept up with PHP-Nuke .. guess I'll have to see if somebody can track this down and figure out what's changed.

-Bharat
 
LOrdSteiN

Joined: 2002-11-19
Posts: 2
Posted: Sat, 2002-12-21 13:04

i am running php-nuke 6 and gallery 1.3.1
this error occurs when a normal phpnuke user tries to access the gallery section...
but phpnuke administrator does not get this error...
any advise that can possibly eliminate this error in my phpnuke Gallery section would be gladly appreciated...
thank you very much :smile:

http://lordhouse.tk
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Fri, 2002-12-27 20:48

This is fixed in Gallery v1.3.3, available via CVS.
 
LOrdSteiN

Joined: 2002-11-19
Posts: 2
Posted: Sat, 2002-12-28 08:22

thanks a lot man :smile:
Gallery rocks!!
 
mark2005

Joined: 2003-01-16
Posts: 9
Posted: Wed, 2003-02-05 16:36

Not really fixed yet! I got the error as well when I moved the gallery (1.3.3) from root directory where it used to be and put it inside the html/modules directory so I can run it inside the PHPNuke 6.5-B6.
I ran the configuration after the moving, but I am still getting Databse.php error on line 35.
Any idea please on how to fix this one..
Thank you
Mark
 
alindeman
alindeman's picture

Joined: 2002-10-06
Posts: 8194
Posted: Wed, 2003-02-05 21:51

You might want to post this in the Nuke forum -- there are more knowledgeable people there.
 
Virgil

Joined: 2003-02-04
Posts: 3
Posted: Thu, 2003-02-06 02:47

I get the same error but only when using NS7 it works perfect in IE.
 
alindeman
alindeman's picture

Joined: 2002-10-06
Posts: 8194
Posted: Thu, 2003-02-06 02:51

Weird...this error shouldn't be browser-dependent.
 
chatserv

Joined: 2003-02-06
Posts: 1
Posted: Thu, 2003-02-06 18:51

These problems are more evident on PHP-Nuke 6.5, i use gallery on a nuke 6.0 site which has the bbtonuke port, i noticed a phpBB patch was mentioned, oddly enough i didn't know one existed so naturally i haven't applied it and my gallery seems to be working ok, as for nuke 6.5, six fields in the users table have changed:
uid is now user_id
uname is now username
email is now user_email
url is now user_website
user_intrest is now user_interests
and pass is now user_password

If i could be given some tips as to what files could need modifying i could put out a zip with the adapted files for users of nuke 6.5 beta 7, i've been looking at the code but so far could only find references to the users table in the gallery/classes/nuke5 folder, any comments?