[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 16:05
Message generated for change (Tracker Item Submitted) made by Item Submitter
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: Open
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.


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

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