#87 TIMESTAMP(14) depreciated, use TIMESTAMP instead

[Snala]

When running the installation script for new manual installs, errors are generated on TIMESTAMP(14). This statement is depreciated and we should be using TIMESTAMP instead.

The corrected file is attached.

mysql> show warnings\G
****** 1. row ***
Level: Warning
Code: 1287
Message: The syntax 'TIMESTAMP(14)' is deprecated and will be removed in MySQL 5
.2. Please use 'TIMESTAMP' instead*** 2. row ******
Level: Warning
Code: 1287
Message: The syntax 'TIMESTAMP(14)' is deprecated and will be removed in MySQL 5

[Snala]

Wrong file uploaded, this is the correct one.

[Anonymous]

Thank you Snala for reporting. I have included a patch in the distribution to match this change in mysql versions above 5.1.
Please let me know if you come aware of any other incompatibility (we already added the engine type support for tables as of 4.1 version).
The updated pack will be pushed for download soon (tonight).
Thank you again.
Ciprian M.

[Ciprian Murariu]

Sorry, I posted as anonymous earlier.
The pack has been pushed. Can you redownload and test the new installation for me please?
Ciprian M.

[Lady Macbeth]

I will--was actually ready for an update anyway. I've been having a few
problems with the old installation, will wipe it clean and start from
scratch with this one

Robbi Drake.

Sorry, I posted as anonymous earlier.
The pack has been pushed. Can you redownload and test the new
installation for me please?
Ciprian M.

---

[bugs:#87] http://sourceforge.net/p/phpmychat/bugs/87/
TIMESTAMP(14) depreciated, use TIMESTAMP instead

Status: open
Created: Tue Jan 22, 2013 04:44 AM UTC by Snala
Last Updated: Tue Jan 22, 2013 04:13 PM UTC
Owner: nobody

When running the installation script for new manual installs, errors
are generated on TIMESTAMP(14). This statement is depreciated and we
should be using TIMESTAMP instead.

The corrected file is attached.

mysql> show warnings\G
///*//// 1. row //*////*//
Level: Warning
Code: 1287
Message: The syntax 'TIMESTAMP(14)' is deprecated and will be removed
in MySQL 5
.2. Please use 'TIMESTAMP' instead//*////*//2. row
//*/////
Level: Warning
Code: 1287
Message: The syntax 'TIMESTAMP(14)' is deprecated and will be removed
in MySQL 5

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/phpmychat/bugs/87/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/prefs/

[Ciprian Murariu]

As php version made it to >5.4, the ftp login page (first step) might not be required - so it can be skipped.