[phpesp-dev] [ phpesp-Bugs-1459344 ] sql populate

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

Bugs item #1459344, was opened at 2006-03-27 09:51
Message generated for change (Comment added) made by greggmc
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: Matthew Gregg (greggmc)
Date: 2006-03-28 20:51

Message:
Logged In: YES 
user_id=14116

What versin of phpESP are you using?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2006-03-28 09:41

Message:
Logged In: NO 

I'm installing it locally before uploading (not installing)
to server (which will be 5 - is phpESP 5-friendly? :)

PHP Information 
Version: 4.2.2 
OS: WINNT 
SAPI: apache2filter 
register_globals: No 
magic_quotes_gpc: Yes 
magic_quotes_runtime: No 
safe_mode: No 
open_basedir: 
 
PHP Extensions 
dBase: No 
GD: No 
GNU Gettext: No 
LDAP: No 
MySQL: Yes 
PHP Extension Dir (compiled): c:\php4 
PHP Extension Dir (run time): C:\FoxServ\php\extensions 
 
phpESP Settings 
Expected ESP_BASE: C:\FoxServ\www\adcritic\phpESP/ 
Expected base_url: localhost/adcritic/phpESP/ 
Loading phpESP.ini.php ...

Knew it was related to CURRENT_TIMESTAMP, but did not try 
removing the single quotes.  


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

Comment By: Sven Meyer (svenmeyer)
Date: 2006-03-28 07: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 10: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