| Message Text |
I upgraded to 5.1.12 yesterday, and had all almost all of my links wiped out almost ALL THE LINKS (about 95% of them) in the database when I was just deleting ONE link - an error message came up (below). Today I was in the process of replenishing my database (by hand) and must have had close to 100 links back in when WHOOSH - away they went again. I now have a clean database for the second time in two days. This is after approximately 10 years of using the software and accumulating links, I might add. Nothing else was affected (category information, email logs, templates, etc. are all fine). I sent the error message in to the WSN support system, but here it is - maybe someone can spot what went wrong here? Hope it doesn't happen to anyone else.
Script: WSN Links Category: Customer account: (MY EMAIL) Version: WSN Links 5.1.12 URL: http://www.MYDOMAIN.com/guide PHP
Version: 5.2.9 Server Test: http://www.MYDOMAIN.com/guide/servertest.php Error occurred at www.MYDOMAIN.com/guide/edit...&filled=1&delete=1&id=2694 on 2009-11-19 18:22:59. Error text: Error #2: 'mysql_fetch_row(): supplied argument is not a valid MySQL result resource' in /home/MYACCOUNT/public_html/guide/databases/mysql.php on line 81. 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.05 seconds. Query 1: SHOW TABLE STATUS LIKE 'wsnlinks_categories' Load time so far: 0.05 seconds. Query 2: SET CHARACTER SET 'utf8' Load time so far: 0.05 seconds. Query 3: SET character_set_server = 'utf8' Query 4: SELECT [huge field list omitted] FROM wsnlinks_modlog WHERE type='member' AND nature='banned' AND memberid= Step 1 of backtrace: File: /home/MYACCOUNT/public_html/guide/databases/mysql.php Line: 81 Function: mysql_fetch_row Arguments: Step 2 of backtrace: File: /home/MYACCOUNT/public_html/guide/classes/database.php Line: 148 Function: row Arguments: Class: db Step 3 of backtrace: File: /home/MYACCOUNT/public_html/guide/classes/database.php Line: 175 Function: row Arguments: Class: database Step 4 of backtrace: File: /home/MYACCOUNT/public_html/guide/classes/database.php Line: 316 Function: rowitem Arguments: Class: database Step 5 of backtrace: File: /home/MYACCOUNT/public_html/guide/classes/modlog.php Line: 106 Function: selectcount Arguments: modlogtable type='member' AND nature='banned' AND memberid= Class: database Step 6 of backtrace: File: /home/MYACCOUNT/public_html/guide/classes/onelink.php Line: 511 Function: add Arguments: Class: modlog Step 7 of backtrace: File: /home/MYACCOUNT/public_html/guide/includes/editlink.php Line: 50 Function: deletethis Arguments: 1 Class: onelink Step 8 of backtrace: File: /home/MYACCOUNT/public_html/guide/edit.php Line: 153 Function: require_once Arguments: /home/MYACCOUNT/public_html/guide/includes/editlink.php |
