From: SourceForge.net <no...@so...> - 2006-03-28 12:51:04
|
Bugs item #1459344, was opened at 2006-03-27 16:51 Message generated for change (Comment added) made by svenmeyer You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1459344&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: v1.8 Status: Open Resolution: None Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: sql populate Initial Comment: #1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP, PRIMARY KEY(name) )' at line 27 Recurring errors when trying to poluate the db with mysql_populate.sql. Fix one, another one pops up - most to do with timestamp. Using phpMyAdmin 2.6.1 I think this is perhaps more related to phpMyAdmin (apologies) than phpESP, but couldn't find anything on this problem elsewhere. ---------------------------------------------------------------------- Comment By: Sven Meyer (svenmeyer) Date: 2006-03-28 14:50 Message: Logged In: YES user_id=945200 I had the same problem using phpMyAdmin to populate a MySQL 5 database. I succeded after removing the single quotes before and after all occurences of CURRENT_TIMESTAMP. ---------------------------------------------------------------------- Comment By: Matthew Gregg (greggmc) Date: 2006-03-27 17:44 Message: Logged In: YES user_id=14116 Version of php and mysql? Please post the output of test.php ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=1459344&group_id=8956 |