MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic WebMail Pro

AfterLogic Forum : AfterLogic WebMail Pro

Topic: Contacts Problem

Author

Message

<< Prev Topic | Next Topic >>

leodosurf
Newbie
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

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

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Pro