MySQL query OK in localhost, error on ISP serve.

contiw · Joined: 25 Mar 2008 Posts: 3

The following query run flawlessly in localhost but produces error on ISP server:
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 'distinct sf_threads.views) as views, ((count(distinct sf_messages.' at line 6

The actual behaviour here:
http://eduforums.us or
http://wconti.com/schoolsforums/index.cfm

I am using the exact same database both in local and server.
Running MySQL 5 in localhost and supposedly versions 4 and 5 sopported by the ISP server.

Thanks for helping

------------

SELECT
conferences.id,
conferences.name,
count(distinct forums.id)-1 as schools,
count(distinct threads.id) as topics,
count(distinct messages.id) as msgs,
sum(distinct threads.views) as views,
((count(distinct messages.id) *2) +sum(distinct threads.views) ) as activity,
0 as hBarLength
FROM ((conferences
left JOIN forums ON conferences.id = forums.conferenceidfk)
left JOIN threads ONforums.id = threads.forumidfk and threads.author <> 'admin')
left JOIN messages ON threads.id = messages.threadidfk and messages.author <> 'admin'
GROUP BY conferences.id

lostboy · Joined: 02 May 2004 Posts: 5572 Location: toronto, canada

try running the query thru phpmyadmin or some other gui to see what the error is
_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google