Client running on our Interworx box is having a problem with MySQL which is thought to be related to the MySQL version being 3.23.58.
He is attemptingto run one of the three SQL statements below:
[SIZE=2]ALTER TABLE table CONVERT TO CHARACTER SET latin1
ALTER TABLE [/SIZE][SIZE=2]table [/SIZE][SIZE=2] DEFAULT CHARSET=latin1
ALTER TABLE `[/SIZE][SIZE=2]table [/SIZE][SIZE=2]` DEFAULT CHARSET = 'latin1''
And returning an error such as:
[/SIZE] #1064 - You have an error in your SQL syntax near ‘DEFAULT CHARSET = ‘latin1’’ at line 1
Could it be to do with the Version of MySQL, if so what is supported on a Fedora 3 box? Or is it something else?
Okay, Socheat has confirmed by Ticket that the MySQL version is to blame, with it being 3.23. Does anyone who is based on Fedora 3, have a correct method of upgrading the MySQL to version , without affection Interworx at all?
Upgrading MySQL won’t effect InterWorx at all as runs on it’s own instance of MySQL.
You need to either recompile it from source, or find RPM’s for Fedor Core 3
You will probably also need to recompile php against the new version of MySQL
If MySQK 4.0.23 is sufficient, whe have source RPM’s available here
If not, take a look around on the web at the various RPM reoisitories.
Thanks for the post. Unfortuantely I need 4.1.2+, I will have to do a manual upgrade, by the sounds of things.
Anyone been in the same boat with manually upgrading MySQL from 3.23 to 4.1.2+ ?
Does anyone have any experience of upgrading MySQL from 3.23 to something in the 4.1.x tree, as we have an urgency to ahve it updated (clients pushing for extra functionality) and we are struggling to find a ‘comprehensive’ way of upgrading…
If anyone can offer support on this, it would be most appreciated.
It should be as easy as rebuilding MySQL 4.1.x for your distro, installing it (as an RPM or from make install) and then running the few scripts provided to update the permissions tables from 3.x to 4.x. We can do this for you if you’d like to have us do it for our normal hourly rate or you can give it a shot yourself and post questions/status to the boards here. If you’d like us to do it for you just open a ticket and provide all the relavent info.