[opencms-dev] SQL errors revisited

[Alexander Kandzior]

This is OpenCms 5.3.x. (i.e. 6 pre Alpha) We never tested 5.3.x with mySQL
3.x, only 4.0.x. 

Ist probably not working because of SQL limitation of mySQL 3. 
You will need to upgrade to mySQL 4.0.x for OpenCms 6.

Best Regards,
Alex.

Alexander Kandzior
Alkacon Software - The OpenCms Experts
http://www.alkacon.com



> -----Original Message-----
> From: opencms-dev-admin at opencms.org 
> [mailto:opencms-dev-admin at opencms.org] On Behalf Of Stefan Moises
> Sent: Thursday, June 24, 2004 12:56 PM
> To: Dirk Bajohr
> Cc: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] SQL errors revisited
> 
> 
> Hm, this statement seems to cause the error:
> 
> DELETE 
> CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_FILES
> .* FROM 
> CMS_BACKUP_STRUCTURE,CMS_BACKUP_RESOURCES,CMS_BACKUP_FILES 
> WHERE 
> CMS_BACKUP_STRUCTURE.STRUCTURE_ID='7812994a-c5ca-11d8-be92-cd4
> 6e5448a96' AND CMS_BACKUP_STRUCTURE.TAG_ID=14 AND 
> CMS_BACKUP_STRUCTURE.RESOURCE_ID=CMS_BACKUP_RESOURCES.RESOURCE
> _ID AND 
> CMS_BACKUP_STRUCTURE.BACKUP_ID=CMS_BACKUP_RESOURCES.BACKUP_ID 
> AND CMS_BACKUP_RESOURCES.FILE_ID=CMS_BACKUP_FILES.FILE_ID AND 
> CMS_BACKUP_RESOURCES.BACKUP_ID=CMS_BACKUP_FILES.BACKUP_ID
> 
> I've also set lower_case_table_names=1 now, didnt help...
> 
> I've tried with two different MySQL versions on Linux:
> 3.23.55 and 3.23.37...
> 
> But yeah, the workspace works and some of the modules import fine...
> 
> where can I find that statement in the setup code?
> 
> any more ideas?
> thanks :)
> 
> Stefan
> 
> 
> > It's running fine for me, SuSE 7.2, MySQL 3.23.58
> > (lower_case_table_names=1).
> > In earlier versions of MySQL there may be some bugs, e.g. 3.23.41 
> > didn't work
> > on my machine.
> > 
> > But if your workplace is working the problem must be something else.
> > 
> > Cheers,
> > Dirk
> > 
> > Am 24.06.2004 um 11:44 schrieb Stefan Moises:
> > 
> > > Hi list,
> > >
> > > I'm still trying to figure out why the installation/import of some
> > > modules
> > > fail with an SQL error on Linux with MySQL 3.2x - here is 
> the error 
> > > again:
> > >
> > > 4462:	Root cause was: java.sql.BatchUpdateException: 
> Syntax error or 
> > > access
> > > violation,  message from server: "You have an error in your SQL 
> > > syntax
> > > near
> > > 
> 'CMS_BACKUP_STRUCTURE.*,CMS_BACKUP_RESOURCES.*,CMS_BACKUP_FILES.* FROM
> > > CMS_BACKUP' at line 1"
> > >
> > > The weird thing is, I cant even find that statement in 
> the "opencms"
> > > folder,
> > > any idea where it comes from or what may be wrong with 
> it? May it be an
> > > Uppercase/Lowercase issue on Linux?
> > > Does anybody have OpenCMS running on Linux with MySQL 3.2x 
> > > successfully?
> > >
> > > thanks for any hints!
> > > regards,
> > > Stefan
> > >
> > > --
> > > --------------------------
> > > ---------- beffy ----------
> > > --------------------------
> > > eMail: beffy at beffy.de
> > > web: http://www.beffy.de
> > > --------------------------
> > >
> > > +++ Jetzt WLAN-Router für alle DSL-Einsteiger und Wechsler +++
> > > GMX DSL-Powertarife zudem 3 Monate gratis* http://www.gmx.net/dsl
> > >
> > > _______________________________________________
> > > This mail is send to you from the opencms-dev mailing 
> list To change 
> > > your list options, or to unsubscribe from the list, please visit
> > > http://mail.opencms.org/mailman/listinfo/opencms-dev
> > >
> > >
> > -- 
> > Dirk Bajohr
> > iSOLUTION - Individuelle Software fuer moderne Kommunikation
> > 
> > Hauptstr. 50
> > 53757 Sankt Augustin
> > 
> > T +49 2241 921567-0
> > F +49 2241 921567-89
> > http://www.isolution.de
> > 
> 
> -- 
> --------------------------
> ---------- beffy ----------
> --------------------------
> eMail: beffy at beffy.de
> web: http://www.beffy.de
> --------------------------
> 
> "Sie haben neue Mails!" - Die GMX Toolbar informiert Sie beim Surfen!
> Jetzt aktivieren unter http://www.gmx.net/info
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, 
> please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
> 
> 
>