WebmasterSite.net

No page, just an error message

Version: 5.1.18
URL:

PrintPrint


No page, just an error message
Jenny
Forum Regular
Avatar

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Posts: 199
quote post #1
Posted 01/06/10 - 2:56 PM:

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."
Jenny
Forum Regular
Avatar

Usergroup: Customer
Joined: May 11, 2003

Total Topics: 64
Total Posts: 199
quote post #2
Posted 01/06/10 - 5:22 PM:

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.
Paul
developer
Avatar

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

Total Topics: 65
Total Posts: 7614
quote post #3
Posted 01/07/10 - 8:32 PM:

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.

Edited by Paul on 01/07/10 - 8:34 PM
 
Search thread for
Download thread as


Sorry, you don't have permission to post. Log in, or register if you haven't yet.