MySQL Problem

General Interworx Control Panel Info General Inquries
1

Hello,

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?

Thanks.

2

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?

Many Thanks.

3

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

http://updates.interworx.info/iworx/SRPMS/

If not, take a look around on the web at the various RPM reoisitories.

4

Tim,

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+ ?

Cheers.

5

Hello,

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.

Thank You :slight_smile:

6

EverythingWeb,

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.

Thanks,

Chris