[T2DMan]

What is the version of mysql that you are using?

I am using mysql 4.0.25-standard and I am not having issues.
I have also used it on 3.23.58 and it works?
This was in fact the place that I tweaked the code to get it to work on the 3.23.58 version. I had two joins in the code, and had to reduce it to one for that version.

Originally Posted by Disi

Hi T2D,

got the following Problem:

mysql_error
select count(`vb_thread`.threadid) FROM `vb_thread`,`vb_forum` left join `vb_forumpermission` on `vb_thread`.`forumid` = `vb_forumpermission`.`forumid` and `vb_forumpermission`.`usergroupid` = 1 where `vb_thread`.`visible`=1 and vb_thread.`forumid`= vb_forum.`forumid` and (mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(mod(forumpermissions,262144),131072),65536),32768),16384),8192),4096),2048),1024),512),256),128),64),32),16),8),4) = 3 or forumpermissions=0 or forumpermissions is null) and `vb_forum`.`password`='' and (`options` /2 <> ceiling(`options` /2)) and `vb_thread`.`forumid`='3'