[Zeffie-Users] MySql Problem

[Bernd Schuhmacher]

Hello Listusers

I have installed the **RaQ4-OS-UPDATE-1.4.1-Built-by-Zeffie.com.pkg* 
<http://www.zeffie.com/pkgs/RaQ4-OS-UPDATE-1.4.1-Built-by-Zeffie.com.pkg>* 
some days ago. Now I have a problem with some SQL statements.
Does anybody have a hin thow to fix this?

The problem occures when using alias within a JOIN in a SELECT.

For example the following statement (as used by invision power board 
1.1.2) creates an error:

*SELECT *mod.mid as is_mod, m.id, m.name, m.mgroup, m.password, m.email, m.allow_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track, m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post, m.last_visit, m.last_activity, m.dst_in_use, m.view_prefs, g.*
*FROM *ibf_members m
*LEFT JOIN* ibf_groups g *ON *(g.g_id=m.mgroup)
*LEFT JOIN* ibf_moderators mod *ON *(mod.member_id=m.id OR mod.group_id=m.mgroup )
*WHERE *m.id='2'


mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mod ON (mod.member_id=m.id OR mod.group_id=m.mgroup )

I can't find an error within the statement and the same query runs perfect on another Raq using the mySQL PKG fom pkgmaster (3.23.54).

Any hints?


I found the PKG RaQ4-MySQL-Update-4.1.13-4.1.13-Built-by-Zeffie.com.pkg 
<ftp://www.zeffie.com/zeffie/RaQ4/RaQ4-MySQL-Update-4.1.13-4.1.13-Built-by-Zeffie.com.pkg> 
at zeffie.net. Does anybody know if this PKG ist stable and if I can put 
this on a Raq running zeffies OS Update?
* 
<http://www.zeffie.com/pkgs/RaQ4-OS-UPDATE-1.4.1-Built-by-Zeffie.com.pkg>*

-- 
nMedien, Oberhuber & Schuhmacher GbR
Donaustraße 4
66424 Homburg
Tel.: 06848/730664
FAX: 06848/72145
Email: kontakt at nmedien.de
Web: http://www.nmedien.de