Hello. I recently upgraded MySQL from 3.23.58 to 4.1.18. After upgrading, qmailadmin does not show the list of users in any domain on the server, but says: No users left to view, please return to the previous page
The following error appears in apache logs:
vmysql: sql error[5]: 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 '00000' at line 1
MySQL log shows:
6673 Connect [EMAIL PROTECTED] on vpopmail
6673 Query select pw_name, pw_passwd, pw_uid, pw_gid,
pw_gecos, pw_dir, pw_shell from domain00000
I did search in google, it shows that some people were having the same
problem. I found this link
(http://forum.qmailrocks.org/archive/index.php/t-1004.html), but it does not
work in my case. By the way, vqadmin shows the correct number of users in the
domain. I have tried to create new domain - same thing.
Vpopmail version: 5.4.13
Qmailadmin version: 1.2.9
MySQL version: 4.1.18
Does anyone have a solution for this problem? Thank you in advance and have a
nice weekend.
pgphOFLTVjqgD.pgp
Description: PGP signature
