#226 Adapting to MySQL 5

closed
Bruderer
None
9
2011-08-11
2011-01-03
M. Günter
No

The world is changing. Oracle now owns MySQL, and you cannot download MySQL Server version 4 anymore, not even from the archives at the MySQL website. MySQL Server 4 is listed as a requirement for your application. I have tried ReqHeap with MySQL Server 5, but version 5 has changes that break ReqHeap's SQL insert commands. Here is the bad news, starting from MySQL Server version 5, previous functionality that would insert "sane" default values for a field no longer exists. An example of this behaviour can be seen when using edit_project.php to add a new project, the field p_template in the insert statement is given a value of "" (an empty string), which MySQL Server 4 would substitute the value 0 for, because the field is an integer type. A work around would be to edit each php file and code some validation to check that variables used in SQL insert or update statements have been initialized to sane values, and set those variables to sane values. I think Req Heap is great program, but needs a little tweaking to get with the times.

Discussion

  • M. Günter
    M. Günter
    2011-04-28

    • priority: 5 --> 9
     
  • Slav Peev
    Slav Peev
    2011-07-14

    fixed - integers and date formats sane values are now handled correctly.

    Zip release 1.1 will be available soon. Until then, please use the latest
    files from the tracker. Before updating, please, make sure to create a copy
    of install/params.php and admin/inc/conn.php to have your current
    parameters (as both files are changed). Migration DB script is available -
    install/modifyDBfrom1.0to1.1.php if you need to keep an old DB.

     
  • Slav Peev
    Slav Peev
    2011-07-14

    • assigned_to: slavpeev --> bruderer
     
  • Bruderer
    Bruderer
    2011-08-11

    • status: open --> closed