Author Topic: cannot add email account  (Read 12724 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
cannot add email account
« on: August 11, 2015, 07:07:52 AM »
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(

Offline
*
Re: cannot add email account
« Reply #1 on: August 25, 2015, 08:45:56 PM »
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(

i have the same problem.
tried but no luck. still see blank list of accounts.

did you able to fix the problem ?
any admin here to help fix this problem ?
Last change on Server: update php 5.6 and Mysql 5.6
« Last Edit: August 25, 2015, 08:50:16 PM by anuradhan »

Offline
*
Re: cannot add email account
« Reply #2 on: September 01, 2015, 04:49:00 AM »
hi guys, i almost 5 months installed cwp on vps and nothing problem, but today when i want to create an email account,i have no result in list email account. is that sql problem ?? or else ? i had never update before,
plis help ,,
thanks,  :(

i have the same problem.
tried but no luck. still see blank list of accounts.

did you able to fix the problem ?
any admin here to help fix this problem ?
Last change on Server: update php 5.6 and Mysql 5.6

dude,i still unable to add email .. i dont know how to fix it,, i tried rebuild mysql with yum update/upgrade mysql-server but no luck..
still waiting for the solutions.. is it problem from mysql database or else ???  ???

Offline
*
Re: cannot add email account
« Reply #3 on: September 02, 2015, 10:22:46 PM »
I had the same problem and solved it!

If you upgrade your MySql server to 5.6 , SQL query used in the panel will fail!
To solve this problem:
  • Open your PhpMyAdmin
  • Open postfix database
  • Go to "Structure" tab of "mailbox"  table
  • Click on "Change"  next to "name"  column (see pic below)
  • Now, Change Default value drop down to "As defined:" and leave the new input box empty
  • Save it and create your email account!



Offline
*
Re: cannot add email account
« Reply #4 on: September 04, 2015, 08:47:29 AM »
I had the same problem and solved it!

If you upgrade your MySql server to 5.6 , SQL query used in the panel will fail!
To solve this problem:
  • Open your PhpMyAdmin
  • Open postfix database
  • Go to "Structure" tab of "mailbox"  table
  • Click on "Change"  next to "name"  column (see pic below)
  • Now, Change Default value drop down to "As defined:" and leave the new input box empty
  • Save it and create your email account!




hi dude, thank you so much,, you did it..  ;D

Offline
*
Re: cannot add email account
« Reply #5 on: December 28, 2015, 09:13:08 AM »
There is another way: disable STRICT_TRANS_TABLES  on your mysql.
edit your /usr/my.cnf:

sql_mode=NO_ENGINE_SUBSTITUTION

Offline
***
Re: cannot add email account
« Reply #6 on: July 23, 2016, 04:44:59 AM »
There is another way: disable STRICT_TRANS_TABLES  on your mysql.
edit your /usr/my.cnf:

sql_mode=NO_ENGINE_SUBSTITUTION

Alright, thank you very much. You made my day easy