[opencms-dev] setup wizard - datetime values missing single quotes

[Brian Eagan]

I successfully installed 6.0.3 on the following platform recently:


mysql  Ver 14.7 Distrib 4.1.14, for pc-linux-gnu (i686)

(from tomcat manager)
Server Information
Tomcat Version     JVM Version     JVM Vendor     OS Name     OS Version
OS Architecture
Apache Tomcat/5.0.28     1.4.2_10-b03     Sun Microsystems Inc.     Linux
2.4.21-37.EL     i386



On 2/8/06 2:09 PM, "Preece, Kaz" <kpreece at dodo.com.au> wrote:

> Yes, I get this error as well. I posted the error to this list last week and
> received no reply. The issue is either too well known for anyone to respond
> or not known at all!
> 
> I believe it is a bug in the latest install wizard that only affects people
> installing from scratch with MySQL. That is why I can find nothing on this
> error anywhere on any site on the Internet.
> 
> Someone please respond to this post.
> 
> ----- Original Message -----
> From: "Keith Stevens" <keith at acsinc.net>
> To: <opencms-dev at opencms.org>
> Sent: Saturday, January 07, 2006 4:24 AM
> Subject: [opencms-dev] setup wizard - datetime values missing single quotes
> 
> 
>> I can't get it installed because of this error in the setup wizard
>> showing datetime values missing single quotes:
>> 
>> 20:    Caused by: org.opencms.db.CmsDbSqlException: An SQL error
>> occurred when executing the following query:
>> com.mysql.jdbc.PreparedStatement at 46497b8: UPDATE CMS_TASK SET
>> 
> NAME='Online',STATE=2,TASKTYPEREF=1,ROOT=0,PARENT=0,INITIATORUSERREF='c300ba
> 5c-01e8-3727-b305-5dcc9ccae1ee',ROLEREF='5f81f1a1-1f7d-3af6-b188-3bac3da5458
> 0',AGENTUSERREF='c300ba5c-01e8-3727-b305-5dcc9ccae1ee',ORIGINALUSERREF='c300
> ba5c-01e8-3727-b305-5dcc9ccae1ee',STARTTIME=2006-01-06
>> 11:57:20,WAKEUPTIME=2006-01-06 11:57:20,TIMEOUT=2006-01-06
>> 
> 11:57:20,ENDTIME=null,PERCENTAGE=0,PERMISSION='30308',PRIORITYREF=2,ESCALATI
> ONTYPEREF=0,HTMLLINK='../taskforms/adhoc.asp',MILESTONEREF=0,AUTOFINISH=1
>> WHERE ID=1.
>> 
>> any suggestions?
>> Thanks,
>> -Keith
>> 
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev