Re: [phpesp-general] database error

[Daniel R. <da...@da...>]

Thanks for the info, Joe. Unfortunately, upgrading is not an option  
as my website is on a shared server. After you got it working, did  
you have any other problems?

Thanks, Dan

On Apr 20, 2006, at 2:11 PM, Joe Auty wrote:

> 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
>