|--> LHTek, le 11/10/2013 20:56, a dit : > When I add a domain I've noticed that the VQADMIN "View Domain" screen is > blank. Every other aspect of VQADMIN works as does QMAIL. After searching for > an answer I found that the cur_user column in the vpopmail/dir_control table > needed to be reset. Of the domains that showed a blank screen in VQADMIN, The > content of that particular field is something like "21441236575" - a very > strange number. Upon resetting it to 0 everything works again. > > Although this is more of a encumbrance than real issue, I'm curious what > might be causing this. Has anyone else seen this occur? I would think that > cur_users should be the actual count of the number of users. I suppose I > could write an SQL script to look up each domains user count and update with > real numbers. I'm hoping this isn't an indication of a larger issue that I'm > not aware of.
I'll try to explain, but french native, sorry 1st QMT build vpopmail with disable-users-big-dir 2nd when disable-users-big-dir is on the function which increase cur_users in dir_control is not called but the function which decrease yes 3rd vqadmin or its cgi was built with 32bits binary integer instead of signed integer which maximum value is 999999999 mod_domain will throw an error when cur_users is > to this value this error is not catched therefore view_domain is empty 4th the decrease function simply do a -- to cur_users without controlling its value as increase function wasnot called, this value is 0 but 0 -1 makes an overflow and it is system maximum value which is returned 4294967295 for a 32bits os 1844674407370955161 for a 64bits os 5th cur_users field is a signed integer therefore mysql reduces these huge values to its maximum or 2147483647 if you have less than 80000/160000 users the less effort solution is to change cur_users type from signed integer to signed/unsigned medium integer their maximum values |8388607/|||16777215| won't exceed cgi or vqadmin maximum value that's all folks xaf | --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
