Re: [phpesp-general] database error

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

Yeah, that is exactly what I did to make it work too...


On Apr 23, 2006, at 9:45 AM, Daniel Romanchik wrote:

> Just an fyi. I decided to strip out all the DEFAULT stuff for  
> TIMESTAMP, and it seems to work just fine.  I read in the MySQL  
> manual that the default is automatically the current timestamp, so  
> taking out that part of the statement is really making it work the  
> way it was intended anyway.
>
> Dan
>
>
> On Apr 20, 2006, at 3:57 PM, Joe Auty wrote:
>
>> Not yet, so far so good...
>>
>> On Apr 20, 2006, at 2:28 PM, Daniel Romanchik wrote:
>>
>>> 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
>>>>
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> 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
>>
>