I just found this when I tried to access my site. Is this WSN or rather server/database related?
Error occurred at http://link-lounge.com/thelinks/index.php on 2010-01-06 22:54:59. Error text: Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/linkloun/public_html/thelinks/databases/mysqli.php on line 73. Last SQL error: 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 '' at line 1
Debug info:
Load time so far: 0.04 seconds.
Query 1: SHOW TABLE STATUS LIKE 'wsnlinksclone1_categories' Load time so far: 0.04 seconds.
Query 2: SET CHARACTER SET 'utf8' Load time so far: 0.04 seconds.
Query 3: SET character_set_server = 'utf8' Query 4: SELECT [huge field list omitted] FROM wsnlinksclone1_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0, Load time so far: 0.25 seconds.
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 '' at line 1
Interesting, hosting support said I had to contact you, because it was solely a script error. Which I know isn't true, because the Wordpress installation was affected, too, and some database tables were crashed. Long story short, I guess they found the error and fixed it, everything seems to be back to normal.
The problem there was that the number of emails to send per queue (on the email preferences page) had somehow been set to a blank value -- and the "no category types" error being there also suggests that other values in the settings table had gone blank, perhaps even all of them. I can't imagine how a hosting problem could change database table values... some sort of botched mysql upgrade maybe.
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on No page, just an error message
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
I just found this when I tried to access my site. Is this WSN or rather server/database related?
Error occurred at http://link-lounge.com/thelinks/index.php on 2010-01-06 22:54:59. Error text: Error #2: 'mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given' in /home/linkloun/public_html/thelinks/databases/mysqli.php on line 73.
Last SQL error: 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 '' at line 1
Debug info:
Load time so far: 0.04 seconds.
Query 1: SHOW TABLE STATUS LIKE 'wsnlinksclone1_categories'
Load time so far: 0.04 seconds.
Query 2: SET CHARACTER SET 'utf8'
Load time so far: 0.04 seconds.
Query 3: SET character_set_server = 'utf8'
Query 4: SELECT [huge field list omitted] FROM wsnlinksclone1_email WHERE timesent=0 AND inprogress=0 ORDER BY id ASC LIMIT 0,
Load time so far: 0.25 seconds.
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 '' at line 1
Step 1 of backtrace:
File: /home/linkloun/public_html/thelinks/databases/mysqli.php
Line: 73
Function: mysqli_num_rows
Arguments:
Step 2 of backtrace:
File: /home/linkloun/public_html/thelinks/classes/database.php
Line: 159
Function: numrows
Arguments:
Class: db
Step 3 of backtrace:
File: /home/linkloun/public_html/thelinks/includes/commonfuncs.php
Line: 1000
Function: numrows
Arguments:
Class: database
Step 4 of backtrace:
File: /home/linkloun/public_html/thelinks/start.php
Line: 150
Function: sendqueuemail
Arguments:
Step 5 of backtrace:
File: /home/linkloun/public_html/thelinks/index.php
Line: 2
Function: require
Arguments: /home/linkloun/public_html/thelinks/start.php
Oh, and it also says:
"Somehow you have no category types."
Forum Regular
Usergroup: Customer
Joined: May 11, 2003
Total Topics: 64
Total Comments: 199
Interesting, hosting support said I had to contact you, because it was solely a script error. Which I know isn't true, because the Wordpress installation was affected, too, and some database tables were crashed. Long story short, I guess they found the error and fixed it, everything seems to be back to normal.
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The problem there was that the number of emails to send per queue (on the email preferences page) had somehow been set to a blank value -- and the "no category types" error being there also suggests that other values in the settings table had gone blank, perhaps even all of them. I can't imagine how a hosting problem could change database table values... some sort of botched mysql upgrade maybe.