Error code : in threads7.php

Micky · March 18th, 2008, 01:51 AM

Hi,

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxxxxxxxxx/gallery/forums/threads7.php on line 141

I use ubbt7.3b4 and pp6.01. If I use threads7.php from version pp6.0 it is fine!

Chuck S · March 18th, 2008, 09:42 AM

Michael Michael Michael I am gonna have to get him on this one. I wrote this integration file and I see whats wrong he lower cased the fields and you cant do that in threads7. Try making sure your profiledata query is this

Code:

Content visible to verified customers only.

Micky · March 18th, 2008, 11:20 AM

Yes, now it well works! Thanks

Chuck S · March 18th, 2008, 11:33 AM

glad to help

Micky · March 18th, 2008, 11:37 AM

Yes! :d

Chuck S · March 18th, 2008, 12:20 PM

anything else let me know

Micky · March 18th, 2008, 12:47 PM

Oh yes, here I have found just one more mistake...

An error was encountered during execution of the query:

SELECT p.id,p.title,p.userid,p.cat,p.approved,p.storecat,p.bigimage FROM ubbt7_pp_photos p LEFT JOIN ubbt7_pp_categories c ON p.cat=c.id WHERE p.userid= AND c.password='' ORDER BY p.date DESC LIMIT 5

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.password='' ORDER BY p.date DESC LIMIT 5' at line 1

Micky · March 18th, 2008, 01:14 PM

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxxxxxxxx/gallery/member.php on line 574

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxxxxxxxx/gallery/member.php on line 541

Chuck S · March 18th, 2008, 01:17 PM

Line 325 of members.php try making the query this. I have no idea why your uid variable is empty though

Code:

Content visible to verified customers only.

Micky · March 18th, 2008, 01:44 PM

No, the error remains.

Chuck S · March 18th, 2008, 04:00 PM

There are two different errors. You mean you still have two different errors you need to post a url then thanks.

I am posting based on the query you posted

Micky · March 18th, 2008, 04:27 PM

You have a PM

Micky · March 18th, 2008, 07:44 PM

I have it, user name in the table pp_users lacked.

Chuck S · March 19th, 2008, 08:39 AM

what do you mean by lacked? Did you forget to run an upgrade.

Micky · March 19th, 2008, 10:09 AM

Yes installed, not upgrade. I had mistake in the previous version.

I wanted to have a clean version.

Chuck S · March 19th, 2008, 10:50 AM

Okay thats good.

Micky · September 11th, 2008, 04:16 PM

The same error in 6.2b2

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /xxxxxxxxxx/gallery/forums/threads7.php on line 153

Chuck S · September 11th, 2008, 07:04 PM

LOL gonna have to staple it to Michael's head to stop lower casing the field names just redo as noted above

Micky · September 22nd, 2008, 08:25 AM

In version 6.2rc1 it is not changed!

Chuck S · September 22nd, 2008, 06:40 PM

Not a problem resending email to developer thanks.