#87 TIMESTAMP(14) depreciated, use TIMESTAMP instead

1.94
closed
None
1
2013-05-17
2013-01-22
Snala
No

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

1 Attachments

Related

Bugs: #87

Discussion

  • Snala

    Snala - 2013-01-22

    Wrong file uploaded, this is the correct one.

     
  • Anonymous - 2013-01-22

    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.

     
    Last edit: Ciprian Murariu 2013-05-17
  • Ciprian Murariu

    Ciprian Murariu - 2013-01-22

    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

    Lady Macbeth - 2013-01-22

    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/

     

    Related

    Bugs: #87

  • Ciprian Murariu

    Ciprian Murariu - 2013-01-22

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

     
  • Ciprian Murariu

    Ciprian Murariu - 2013-05-17
    • status: open --> closed
     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks