https://www.webmastersite.net/forums en-us 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 https://www.webmastersite.net/forums/threads/all-links-wiped-out-after-upgrade-8911.html Thu, 19 Nov 2009 19:51:05 GMT https://www.webmastersite.net/forums/thread/8911/ 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]]> https://www.webmastersite.net/forums/threads/all-links-wiped-out-after-upgrade-8911.html https://www.webmastersite.net/forums/threads/nofollow-tag-8429.html Wed, 24 Sep 2008 03:44:00 GMT https://www.webmastersite.net/forums/thread/8429/ https://www.webmastersite.net/forums/threads/nofollow-tag-8429.html https://www.webmastersite.net/forums/threads/validation-and-sitemap-questions-8416.html Sat, 20 Sep 2008 21:23:54 GMT https://www.webmastersite.net/forums/thread/8416/ https://www.webmastersite.net/forums/threads/validation-and-sitemap-questions-8416.html https://www.webmastersite.net/forums/threads/tag-cloud-8289.html Fri, 08 Aug 2008 21:58:19 GMT https://www.webmastersite.net/forums/thread/8289/ https://www.webmastersite.net/forums/threads/tag-cloud-8289.html https://www.webmastersite.net/forums/threads/upgrade-problems-7405.html Tue, 12 Jun 2007 22:48:03 GMT https://www.webmastersite.net/forums/thread/7405/ www.webmastersite.net/forum...Upgrade_problems-7372.html). Since then, the directory seemed to be working fine... except that the sites still register as running version 4.0.25 even after running the 4.0.28 upgrade, as I'd noted previously. Today I decided to go ahead and upgrade once again to 4.0.31. I uploaded all files except the templates and integration directories to one of the 3 WSNlinks sites I have, and ran upgrade.php. The script ran without any error messages, but when I logged in to my directory and afterwards and started working with it, wanting to delete some entries, I got blank pages after pressing the delete button. Turning debug on still gives me a blank page after pressing "delete" and when I returned to the admin panel or directory, the entries that I tried to delete still appeared. I had to go into the phpmyadmin and manually delete the entries. Once there I looked more closely at the database itself I realized that many of the tables that should be there were missing. The tables the database contain are only these: wsnlinks_calendar wsnlinks_categories wsnlinks_comments wsnlinks_email wsnlinks_invites wsnlinks_links wsnlinks_markup wsnlinks_membergroups wsnlinks_members wsnlinks_pm wsnlinks_ratings wsnlinks_searches wsnlinks_sessions wsnlinks_settings wsnlinks_switches wsnlinks_trader The databases of other sites (which were upgraded to 4.0.25 or 4.0.28 but on which I haven't run the 4.0.31 upgrade) contain the above tables plus attachments, crons, helpcategory, helpitem, im and modlog. I ran the upgrade script several times. It always goes through everything fine, saying that the upgrade was successful and with no errors. Yet the database is incomplete and it seems it was like that before I did this last upgrade, since my database backup, which I did just before the upgrade, is also the same way. I suspect that the database wasn't properly upgraded on one of the two prior upgrades done recently. What do you recommend I do to correct this? Would there be a way of constructing a blank database per version 4.0.31 and importing my current settings, categories and links into it (I don't use the member system, comments, etc.). Right now my site is visible and the information looks correct to the public, but the back end isn't working and I'm afraid of losing all my link data.]]> https://www.webmastersite.net/forums/threads/upgrade-problems-7405.html