bug report: issues with installation and update procedure from vhcs

[umaxx]

(12-30-2008 08:04 AM)umaxx Wrote:  5. client/mail_accounts.php is still not working - resulting in a "query was empty" message

solved by searching the forum...
http://www.isp-control.net/forum/showthr...972&page=2

this seems to be a bug in RC7 (setup or update script).

setting "collation" off all "mail_users" columns to utf8_unicode_ci via pma solves this problem...
pma query:

Code:

ALTER TABLE `mail_users` CHANGE `mail_acc` `mail_acc` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_pass` `mail_pass` VARCHAR( 150 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_forward` `mail_forward` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `mail_type` `mail_type` VARCHAR( 30 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `status` `status` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL