Webmastersite.net
Register Log In

Editing 'Load Management' gives error

Comments on Editing 'Load Management' gives error

DerekOntario
Member

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 6
Total Comments: 13
Posted Feb 19, 2007 - 6:28 PM:

I did 3 fresh installs re-copying files and then running setup.php, I was able to repeat this error.

After fresh install of 4.017 I go into wsnlinks admin panel and edit a few settings; every seems okay.

I then go into admin > settings > system configuration > load management > edit values for 'reject spiders when load above' & 'reject guests when load above'

After submitting changes I get this error:

www.vacationlinkexchange.co...ks/admin/index.php&debug=1

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0201/d30/s24/b02a42c7/www/vacationlinkexchange.com/links/databases/mysql.php on line 22

I took a screen shot:
http://www.vacationlinkexchange.com/error-1.gif

_____
Derek
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Feb 20, 2007 - 5:26 AM:

Can't reproduce. I set the values to 4 and 5, no problem. Tried on a new install as well. What are you setting them to?
DerekOntario
Member

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 6
Total Comments: 13
Posted Feb 20, 2007 - 9:11 AM:

Without reading the help section I thought the value was a percent figure.

'reject spiders when load above' = 75
'reject guests when load above' = 95

So I did a re-install and setup.php, and made the settings:

'reject spiders when load above' = 4
'reject guests when load above' = 5

I got the same error.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0201/d30/s24/b02a42c7/www/vacationlinkexchange.com/links/databases/mysql.php on line 22

http://www.vacationlinkexchange.com/error-2.gif
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Feb 21, 2007 - 7:40 AM:

All those template variables sitting about looks like there's something wrong with your settings table perhaps.

I got the same error.
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0201/d30/s24/b02a42c7/www/vacationlinkexchan ge.com/links/databases/mysql.php on line 22


Every mysql error looks exactly like that, so it means nothing without the debug info.

If I pause www.vacationlinkexchange.co...ks/admin/index.php?debug=1 quickly enough before it redirects me to the login prompt, it says:
Load time so far: 3.17 seconds.

Query: SELECT `name`,`content` FROM wsnlinks_settings WHERE id>0 ORDER BY id ASC

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0201/d30/s24/b02a42c7/www/vacationlinkexchange.com/links/databases/mysql.php on line 22

SQL error while fetching row:Lost connection to MySQL server during query

Load time so far: 3.17 seconds.

Lost connection to MySQL server during query


"Lost connection to MySQL server during query" indicates some sort of server problem.
DerekOntario
Member

Usergroup: Customer
Joined: Oct 10, 2003

Total Topics: 6
Total Comments: 13
Posted Feb 21, 2007 - 9:50 PM:

Thanks for the help Paul.

"Lost connection to MySQL server during query" indicates some sort of server problem.


I forwarded that info to my webhost and haven't had any problems since.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.