Had a site with 4.0.33 on that has been sitting around so decided to practice and upgraded it to 4.1.0 beta6 All went well and looks good that I've looked at so far, except that I am now getting the following error on the display links page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kritters/public_html/databases/mysql.php on line 26
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kritters/public_html/databases/mysql.php on line 29
Comments on Error on display links after upgrade
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Hi Paul
Had a site with 4.0.33 on that has been sitting around so decided to practice and upgraded it to 4.1.0 beta6 All went well and looks good that I've looked at so far, except that I am now getting the following error on the display links page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kritters/public_html/databases/mysql.php on line 26
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kritters/public_html/databases/mysql.php on line 29
debug is attached
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The problem is that the "similar categories" switch is turned on, but there's no fulltext index in the categories table. should fix it. The upgrade is supposed to be doing that, I don't see why it's not working.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Thanks Paul - that did the trick
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
The upgrade is supposed to be doing that, I don't see why it's not working.
Don't know if this is helpful to you. Just upgraded another site. Uploaded all files then ran upgrade.php which produced...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/homeandg/public_html/databases/mysql.php on line 26
I still ran the upgrade and the program looked ok and appeared to complete ok, I added the ALTER TABLE as above and it seems to be fine.
Attached is the debug I ran whilst upgrading
Attached Files:
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
It's trying to find the fields of tables that haven't been added yet. Not a problem, once the upgrade is run the tables add so it works.