[opencms-dev] SQL errors revisited

Dirk Bajohr db at isolution.de
Thu Jun 24 12:03:01 CEST 2004


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




More information about the opencms-dev mailing list