[opencms-dev] SQL errors revisited

[Stefan Moises]

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
> 

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