MySQL 5.5.25 and Update (not compatible with TIMESTAMP(x))

Please post all install related problems here. Visit this forum first for troubleshooting.
Post Reply
Earl of Mar
Posts: 20
Joined: Sun 26. Sep 2004, 09:41
Location: Hamburg

MySQL 5.5.25 and Update (not compatible with TIMESTAMP(x))

Post by Earl of Mar » Thu 16. Aug 2012, 17:01

Hello,

I´m trying to upgrade from 1.1 to 1.5, getting errors during execution of 27-08-2004 to 1.2.7-DEV.sql script:
"ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL,
`group_trash` int(1) NOT NULL default '0',
`group_active` int' at line 6 -> CREATE TABLE `phpwcms_usergroup` ..."

The same if I am pasting the SQL code directly to PHPmyAdmin:
"#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL, `group_trash` int(1) NOT NULL default '0', `group_active` i' at line 6..."

What I found is that "timestamp(14)" is causing the errors (i.e.`group_timestamp` timestamp(14) NOT NULL,). It runs fine without the "(14)": i.e.`group_timestamp` timestamp NOT NULL). Does MySQL 5.5 not support timestamp(x)?

I´m upgrading to phpwcms 1.5 because the old version will not run with PHP 5.3...

Please help!

Markus

Earl of Mar
Posts: 20
Joined: Sun 26. Sep 2004, 09:41
Location: Hamburg

Re: MySQL 5.5.25 and Update (not compatible with TIMESTAMP(x

Post by Earl of Mar » Thu 16. Aug 2012, 20:32

OK, this TIMESTAMP(14) seems to be used only in update 07 (27-08-2004...) which I edited.

User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Re: MySQL 5.5.25 and Update (not compatible with TIMESTAMP(x

Post by flip-flop » Fri 17. Aug 2012, 07:25

Hi,

yes, timestamp(N) is incompatible with MySql 5.5 ->
http://dev.mysql.com/doc/refman/5.5/en/ ... eries.html
Incompatible change: In very old versions of MySQL (prior to 4.1), the TIMESTAMP data type supported a display width, which was silently ignored beginning with MySQL 4.1. This is deprecated in MySQL 5.1, and removed altogether in MySQL 5.5. These changes in behavior can lead to two problem scenarios when trying to use TIMESTAMP(N) columns with a MySQL 5.5 or later server:
Serch for timestamp on this page.

Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )

User avatar
Oliver Georgi
Site Admin
Posts: 9456
Joined: Fri 3. Oct 2003, 22:22
Location: Dessau
Contact:

Re: MySQL 5.5.25 and Update (not compatible with TIMESTAMP(x

Post by Oliver Georgi » Sun 19. Aug 2012, 01:07

solved, next time use issues…
Oliver Georgi | phpwcms Developer | GitHub | LinkedIn | Kleintierpraxis am Georgengarten

Post Reply