[phpesp-dev] [ phpesp-Bugs-890830 ] MySQL > 4 complains about /scripts/db/mysql_popuplate.sql

[SourceForge.net <no...@so...>]

Bugs item #890830, was opened at 2004-02-04 19:05
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=890830&group_id=8956

Category: SQL
Group: v1.6.1
>Status: Closed
Resolution: None
Priority: 5
Submitted By: Kevin Hawkins (jedihawk)
Assigned to: Nobody/Anonymous (nobody)
>Summary: MySQL > 4 complains about /scripts/db/mysql_popuplate.sql

Initial Comment:
When using MySQL 4.0.17, I get this error with install
script /scripts/db/mysql_popuplate.sql:

ERROR 1067: Invalid default value for 'changed'

I've commented-out the original offending line and
removed the DEFAULT '' part of the field/table
creation.  This new script works.
Attached is the new script.


----------------------------------------------------------------------

Comment By: Matthew Gregg (greggmc)
Date: 2004-02-21 16:23

Message:
Logged In: YES 
user_id=14116

Fixed in CVS.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=890830&group_id=8956