Welcome Visitor, Please Login or Register Now Saturday, April 20, 2024 01:53 PM 
Forums Index > Mewsoft > Minor Updates and bug fixes > Boardawy Update for MySQL 5.x
New Topic   New Reply
Search for:
Author Message
mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-20-24 01:53 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Boardawy Update for MySQL 5.x Edit Delete Reply with quote Quote
First Post Posted on: 05-03-10 07:08 AM last post first post

MySQl server 5.x used the reserved word "Reads" which we used in some tables columns in the forum software so it will generate errors on servers that have the MySQL server new version 5.x. We released the Boardawy updated for this.  New installations will have no problem, only if you are going to update on your current forum installation, you need to do the following.

Go to your admin.cgi for the forum, click on Database & SQL manager, click on SQL Commander, in the text box enter this line exactly:

ALTER TABLE Forum_Forums CHANGE Reads Readx INT

Then click the button "Run Statement"

Now clear the textbox and enter this new line

ALTER TABLE Forum_Groups CHANGE Reads Readx INT

Now clear the textbox and enter this new line

ALTER TABLE Forum_Users_Info CHANGE Reads Readx INT

Then upgrade all the cgi file /forum/*cgi, *.pm, do not update any files under /data directory or you lose all your settings.


Mewsoft Support
www.mewsoft.com

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print