Author |
|
leodosurf Newbie
Joined: 01 December 2009 Location: Brazil
Online Status: Offline Posts: 1
|
Posted: 01 December 2009 at 7:26am | IP Logged
|
|
|
I have problems with contact list, it´s all time blank, and I have already add 11 contacts and nothing happen, at the bottom of page I see 11 contacts but the list is blank anyway.
My boss has import from Outlook, 1680 contacts, all of them are on MYSQL perfectly, but on the Webmail Contact´s List not appear.
In the logs I enconter a MYSQL error:
[13:40:42.491] MySQL Query: SELECT id_addr AS id, fullname AS name,
CASE primary_email
WHEN 0 THEN h_email
WHEN 1 THEN b_email
WHEN 2 THEN other_email
END AS email, 0 AS is_group, use_frequency AS frequency, use_friendly_nm AS usefriendlyname
FROM webmail_awm_addr_book
WHERE id_user = 1
UNION
SELECT id_group AS id, group_nm AS name, '' AS email, 1 AS is_group, use_frequency AS frequency, 1 AS usefriendlyname
FROM webmail_awm_addr_groups
WHERE id_user = 1
ORDER BY is_group ASC, name ASC
LIMIT 0, 20
[13:40:42.492] ErrorDesc [1064]: You have an error in your SQL syntax near 'UNION
What should I do ?
Att,
Leonardo Prado
|
Back to Top |
|
|
Igor AfterLogic Support
Joined: 24 June 2008 Location: United States
Online Status: Offline Posts: 6092
|
Posted: 01 December 2009 at 12:25pm | IP Logged
|
|
|
What version of MySQL you're using?
--
Regards,
Igor, AfterLogic Support
|
Back to Top |
|
|