I've submitted to my directory using FireFox and Opera as a Guest and as Admin. Both browsers give me know errors and both submissions showed up in "validate items" list.
However, when I use the web browser Opera for doing submissions, I get this error after pressing the submit button:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/orbitalz/public_html/directory/classes/database.php on line 69
And the submission doesn't showup in my "validate items" list.
Sofar, Opera is the only browser that seems to cause this.
Orbitalz wrote: Load time so far: 0.23 seconds. Performing query: SELECT parentids FROM wsnlinks_categories WHERE id= ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/orbitalz/public_html/directory/classes/database.php on line 69
It appears the category id of the link is somehow unknown. Also the case for the link insertion -- so you should notice that your link isn't showing up in any category.
Try opening suggest.php and replacing
$thecat = new category('id', $_POST['catid']);
with
$catid = $_POST['catid']; $thecat = new category('id', $_POST['catid']);
before submission, I had 206 links in my directory. After submitting using Opera, My directory reports I have 207 links yet the link doesn't showup in my "validate list" nor in the directory its self.
before submission, I had 206 links in my directory. After submitting using Opera, My directory reports I have 207 links yet the link doesn't showup in my "validate list" nor in the directory its self.
It's the fact that as noted before it's being submitted to no category. Do you have the category selector on submission pages on or off?
Rik wrote: Why are the messages in this topic not word wrapping?
Do you have any other scripts installed that might be setting a cookie named catid, that you might have visited in opera but not in the other browsers? What else might you have done differently in opera?
Didn't do anything differently in opera. I've only changed the colors and layout. Plus I reverted back to the default suggestlink.tpl to see if it was a template error, but that didn't work either.
I get the error in opera on your site as well, and not in firefox. It really doesn't make any sense, as cookies couldn't be different when I've never been to the site in either browser before (and, as noted, on my own 3.14 installs Opera doesn't complain).
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Mysql_fetch_row
Experienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
Hey, This is a tad unusual.
I've submitted to my directory using FireFox and Opera as a Guest and as Admin. Both browsers give me know errors and both submissions showed up in "validate items" list.
However, when I use the web browser Opera for doing submissions, I get this error after pressing the submit button:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/orbitalz/public_html/directory/classes/database.php on line 69
And the submission doesn't showup in my "validate items" list.
Sofar, Opera is the only browser that seems to cause this.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Opera works fine for me. Must be a cookie. Post the debug info.
Experienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
yes
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Load time so far: 0.23 seconds.
Performing query: SELECT parentids FROM wsnlinks_categories WHERE id= ;
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/orbitalz/public_html/directory/classes/database.php on line 69
It appears the category id of the link is somehow unknown. Also the case for the link insertion -- so you should notice that your link isn't showing up in any category.
Try opening suggest.php and replacing
$thecat = new category('id', $_POST['catid']);withExperienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
Nope, didn't fix it. I still get the same mysql error in Opera
Any other suggesstions?
Experienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
this is odd aswell,
before submission, I had 206 links in my directory. After submitting using Opera, My directory reports I have 207 links yet the link doesn't showup in my "validate list" nor in the directory its self.
Forum Regular
Usergroup: Customer
Joined: Sep 22, 2004
Location: Wake Forest, NC
Total Topics: 23
Total Comments: 161
Why are the messages in this topic not word wrapping?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
this is odd aswell,
before submission, I had 206 links in my directory. After submitting using Opera, My directory reports I have 207 links yet the link doesn't showup in my "validate list" nor in the directory its self.
It's the fact that as noted before it's being submitted to no category. Do you have the category selector on submission pages on or off?
Why are the messages in this topic not word wrapping?
Because I had the value set too high.
Experienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
I have it turned on.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Do you have any other scripts installed that might be setting a cookie named catid, that you might have visited in opera but not in the other browsers? What else might you have done differently in opera?
Experienced
Usergroup: Customer
Joined: Dec 19, 2004
Total Topics: 15
Total Comments: 54
Didn't do anything differently in opera. I've only changed the colors and layout. Plus I reverted back to the default suggestlink.tpl to see if it was a template error, but that didn't work either.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Well, the URL you PMed me just gives me a 404 in Opera or any other browser.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
I get the error in opera on your site as well, and not in firefox. It really doesn't make any sense, as cookies couldn't be different when I've never been to the site in either browser before (and, as noted, on my own 3.14 installs Opera doesn't complain).