Mysql upgrade

Submitted by marco@flapper on Tue, 2013-12-10 12:09 in Installation and Setup

Hi,
Mysql is getting updated on server from 5.0 to 5.1.

Are there any issues known?

And after this a upgrade to 5.5 is planned. Any issues there?

Hi Marco, Lots of users have

Submitted by support on Tue, 2013-12-10 12:13

Hi Marco,

Lots of users have applied MySQL upgrades with no problems.

Just in case however, always use the Database Tool (/admin/ menu) to export all your feed registrations / filters etc. so that your site can be restored easily if necessary - but there are no known issues.

Cheers,
David.
--
PriceTapestry.com

Thanks. Upgrade to 5.1 went

Submitted by marco@flapper on Wed, 2013-12-11 09:37

Thanks.
Upgrade to 5.1 went without any issues.

Hi, Not sure if its related

Submitted by marco@flapper on Tue, 2013-12-31 16:13

Hi,
Not sure if its related to the mysql upgrade. But installed a new pt with some custom db fields. Used search and replace on the pt files and ran setup.php.

I pressed on the link after FAIL click here to install tables but nothing happened.

So I set debug on true and then I got sql syntax error message. Any suggestions what to do?

Here's the debug information:
{code saved}

Hi, I found out that TYPE

Submitted by marco@flapper on Tue, 2013-12-31 16:29

Hi,
I found out that TYPE keyword is depreciated (since 5.0) and not supported in MySQL5.5.

So I changed the lines in setup.sql with TYPE=MyISAM; to ENGINE=MyISAM;

Best wishes for 2014!

Glad you're sorted,

Submitted by support on Tue, 2013-12-31 16:35

Glad you're sorted, Marco!

Happy New Year to you too!

Cheers,
David.
--
PriceTapestry.com