Probably we all had the problem where we increased the traffic limit for a plan sometime after having hundreds of users using the plan. If you do not increase the traffic limit for each user  then your users will pay usage fees even if their usage is between the old preset value and the new preset value.

So we must increase the  limits for all the users using our plans to match the plan limits set. But only if the user's preset limit is lower than the current plan limit. If a user set their limit very high, so they wont pay extra usage fees, we shouldnt lower their limits!

Below is the SQL command which will accomplish this task for the main plans, if you want to do it for one of your resellers, please change the reseller_id=1 to suit to the reseller ID in question.

update traffics set tt_size=float8(plan_value.value) from parent_child,accounts,plan_value where parent_child.child_type=121 and parent_child.account_id=accounts.id and traffics.id=parent_child.child_id and plan_value.plan_id=accounts.plan_id and plan_value.name='_FREE_UNITS_' and plan_value.type_id=121 and float8(traffics.tt_size)<float8(plan_value.value) and accounts.reseller_id=1;

After issuing the command above in your SQL server, you must restart your CP process!