TIMESTAMP-incompatibility in mySQL 4.1

Get help with installation and running phpwcms here. Please do not post bug reports or feature requests here.
Post Reply
Earl of Mar
Posts: 20
Joined: Sun 26. Sep 2004, 09:41
Location: Hamburg

TIMESTAMP-incompatibility in mySQL 4.1

Post by Earl of Mar »

I recently received a notice from my web space provider according to installation of new version of mySQL (current 4.0.22, new 4.1.17). There is an incompatibility regarding TIMESTAMP:

-------------------------------------
Incompatible change: TIMESTAMP is now returned as a string in
'YYYY-MM-DD HH:MM:SS' format (from 4.0.12 the --new option can be
used to make a 4.0 server behave as 4.1 in this respect). See section
11.3.1.2 TIMESTAMP Properties as of MySQL 4.1. If you want to have the
value returned as a number (as MySQL 4.0 does) you should add +0 to
TIMESTAMP columns when you retrieve them:
SELECT ts_col + 0 FROM tbl_name;
-------------------------------------

Should any changes be made inside the sorcecode of phpwcms?

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

Post by Earl of Mar »

hi there,

is anyone using phpwcms with mysql 4.1.17?
Post Reply