Error on display links after upgrade: WSN Support

Error on display links after upgrade

babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 313
Total Posts: 1036

Posted 08/01/07 - 10:53 PM:	#1
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: debug.txt (10 KB, 24 downloads)

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 08/02/07 - 06:22 AM:	#2
The problem is that the "similar categories" switch is turned on, but there's no fulltext index in the categories table. ALTER TABLE wsnlinks_categories ADD FULLTEXT `nameindex` (`name`); should fix it. The upgrade is supposed to be doing that, I don't see why it's not working.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 313
Total Posts: 1036

Posted 08/02/07 - 08:39 PM:	#3
Thanks Paul - that did the trick

babrees
Expert

Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 313
Total Posts: 1036

Posted 08/05/07 - 08:52 PM:	#4
Paul wrote: 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: upgrade-debug.txt (66 KB, 24 downloads)

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 08/07/07 - 09:08 AM:	#5
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.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

You don't have permission to post.