| Author |
|
spacemail
Newbie
Joined: 22 May 2011
Location: Nigeria
Online Status: Offline
Posts: 4
|
| Posted: 22 May 2011 at 6:02am | IP Logged
|
|
|
Hi,
Can anybody help me out here? I install Webmail lite, but i cannot create user, whenever i try creating user for webmail, it shows me the below error.
Syntax error (missing operator) in query expression 'awm_accounts.id_user = awm_settings.id_user INNER JOIN a_users ON awm_accounts.id_user = a_users.id_user'.
Can someone help me please!
Thank you
Obum Madu
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 22 May 2011 at 12:46pm | IP Logged
|
|
|
Does this occur when you use MS Access? If yes, can you use MS SQL or MySQL instead, and see if the issue still persists?
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
spacemail
Newbie
Joined: 22 May 2011
Location: Nigeria
Online Status: Offline
Posts: 4
|
| Posted: 23 May 2011 at 1:45am | IP Logged
|
|
|
Yes,
I'm using MS Access.
I have tried installing MS SQL, but i'm having problems with it. Though it's my first time installing Database myself.
I search online for guide on how to use it, but no positive result. How much will it cost to install?
Thank you
Ogbodo ThankGod
|
| Back to Top |
|
| |
spacemail
Newbie
Joined: 22 May 2011
Location: Nigeria
Online Status: Offline
Posts: 4
|
| Posted: 23 May 2011 at 7:53am | IP Logged
|
|
|
I'm still having problems creating user on MS Access.
Can't anything be done in the MS Access file?
Or can any expert help with the installation?
Thank you
Obum Madu
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 24 May 2011 at 8:29am | IP Logged
|
|
|
There's a known issue with managing users when MS Access is used. To sort it out, modify the following code in WEBMAIL\App_Code\CommandCreator.cs file:
Code:
| string commandText = string.Format(@"SELECT COUNT(*) FROM {0} INNER JOIN {1} ON {0}.id_user = {1}.id_user INNER JOIN {2} ON {0}.id_user = {2}.id_user {3}", |
|
|
It should be modified as follows:
Code:
| string commandText = string.Format(@"SELECT COUNT(*) FROM ({0} INNER JOIN {1} ON {0}.id_user = {1}.id_user) INNER JOIN {2} ON {0}.id_user = {2}.id_user {3}", |
|
|
To make sure the code gets recompiled, run compile.bat file found in main folder of WebMail.
Still, it is recommended to use MySQL instead. To use it with ASP.NET version of AfterLogic WebMail (Lite or Pro), you'll need ODBC Connector installed.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
spacemail
Newbie
Joined: 22 May 2011
Location: Nigeria
Online Status: Offline
Posts: 4
|
| Posted: 25 May 2011 at 4:14am | IP Logged
|
|
|
Hi,
I replaced the code in the WEBMAIL\App_Code\CommandCreator.cs file and the database connected successfully, but i still can't create user accounts.
I get the error:
Failed to create new user account. Internal Server Error. Please, contact your system administrator in order to report the problem.
Please, it is becoming difficult for me to handle, i'll please be needing expert hand.
Please, what will it cost to have a professional from Afterlogic install it for me?
I'll provide my VPS details, and the professional will handle installation, configuration and everything for me. Please, i'm asking this as a favour.
If my favour will be granted please get in-touch via my email: ogb*********on@yahoo.com
Hope to hearing soonest.
Thank you
Obum Madu
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 25 May 2011 at 5:32am | IP Logged
|
|
|
I have replied to your request via email, and have removed email address from your message for privacy reasons.
--
Regards,
Igor, AfterLogic Support
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: ERROR CREATING NEW USER
Privacy policy |
Refund policy