PDA

View Full Version : SQL Errors on Units page

bizarroStormy
11/04/2010, 17:46
Is something up with the 'Units' database? I no longer have the Haves, Wants, Needs options either in the left frame or in the unit-specific descriptions.

And when I attempt to do a search based on my 'Haves' I'm getting the same errors in both Firefox and Safari.

Here are the SQL errors I'm seeing:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/vhosts/realmworx.com/subdomains/heroclix/httpdocs/forum/units/units_advanced_search_results.php on line 537

and

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/realmworx.com/subdomains/heroclix/httpdocs/forum/units/units_advanced_search_results.php on line 545

Same error but different line references.

--
BizarroStormy
Tarnish
11/04/2010, 17:47
I'm having no problem with it in Minefield (64 bit Firefox)

Tarnish
Drunky
11/04/2010, 21:11
Did you check the "Remember me" box when logging in ?
(it has to be checked for the Have/Want/Keep features to work correctly)
HydraBob
11/04/2010, 21:14
I've been having the same problem. I'll hit remember me, and hope
bizarroStormy
11/04/2010, 21:21
Did you check the "Remember me" box when logging in ?
(it has to be checked for the Have/Want/Keep features to work correctly)

Wow...that fixed it. Strange behavior.

Thanks, Drunky. :)

--
BizarroStormy
HydraBob
11/04/2010, 21:30
Wow...that fixed it. Strange behavior.

Thanks, Drunky. :)

--
BizarroStormy

it fixed it indeed
VanisherPunisher
11/05/2010, 05:38
The following is pure speculation:

I think it must be something to do with cookies. If you don't click the 'Remember me'-box no cookies will be generated. It's the cookie that would tell the search who you are, but since no cookies are generated the search can't know who's inventory it should be searching or showing in the unit-specific descriptions.

What I don't understand is why the Units-section can't check who you are based on the session variables instead of the cookie. I've never really looked at any forum-code, so I don't know if there's something there that just makes it impossible.