[Zeffie-Users] MySql Problem

[Bernd Schuhmacher]

Hi
The Problem is solved ;-)
There was no problem with the MySQL update. The Problem was the code 
used by this old version of Invision Power Board.
Within the second "LEFT JOIN" mod was used as an alias, but mod became a 
function in MySQL 4 ...

Bernd Schuhmacher schrieb:
> 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