Re: [phpesp-general] database error

[Joe A. <jo...@ne...>]

Hey Dan,

I had to do some wrestling with the included populate scripts to get  
them to work in MySQL 3.x. I'm not sure if there is a newer version  
of this script, but I basically had to yank out some of those  
offending pieces to get it to work.

If upgrading to 4.x or higher is an option, it might be easier just  
to do that...


On Apr 20, 2006, at 2:07 PM, Daniel Romanchik wrote:

> When populating the database, I get the following error:
>
> SQL query:
> CREATE TABLE realm(
> nameCHAR( 16 ) NOT NULL ,
> titleCHAR( 64 ) NOT NULL ,
> CHANGED TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
> PRIMARY KEY ( name )
> )
>
> MySQL said:
> #1064 - You have an error in your SQL syntax near '(16) NOT NULL,
> titleCHAR(64) NOT NULL,
> changed         TIMESTAMP NOT NULL DEFA' at line 2
>
>
> I tried downloading the latest two versions of mysql_populate.sql  
> from the CVS, as suggested in an earlier message, but am still  
> getting this error. The version of MySQL running on my webhost is  
> 3.23.58. I'm hoping that's not the problem. :)
>
> Thanks, Dan
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general