[opencms-dev] SQL errors revisited

[Cyrill Brunschwiler]

Hi Stefan

Why don't you use an actual version of mysql 4.x?????
I never ran into problems running opencms on SuSE.
Maybe you should upgrade your SuSE 7.x system anyway.

regards,
Cyrill

.....................................................................
From: "Stefan Moises" <beffy at gmx.de>
Date: Thursday 24 June 2004 12:56

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