[phpesp-dev] [ phpesp-Bugs-1457232 ] MySQL Error on mysql_poulate

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

Bugs item #1457232, was opened at 2006-03-23 15:12
Message generated for change (Comment added) made by greggmc
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1457232&group_id=8956

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL
Group: None
>Status: Closed
>Resolution: Wont Fix
Priority: 5
Submitted By: Matthew Galvin (videohead)
Assigned to: Nobody/Anonymous (nobody)
Summary: MySQL Error on mysql_poulate

Initial Comment:
The MySQL Server returned this Error:
MySQL Error Nr.1064-You have an error in your SQL 
syntax.  Check the manual that corresponds to your 
MySQL server version for the right syntax to use 
near 'CURRENT_TIMESTAMP,
	PRIMARY KEY(name)
)' at line 4

Windows 2003 Server
IIS 6
PHP ISAPI 4.4.2
mySQL 3.23.49
phpESP 1.8.1

Is this a character encoding issue?


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

>Comment By: Matthew Gregg (greggmc)
Date: 2006-03-23 15:54

Message:
Logged In: YES 
user_id=14116

It's probably a compatibility issue with the SQL that the
populate script supports.    We no longer support 3.23
mySQL.  Try upgrading to a more recent, 4.1 or 5.x and try
again.

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

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