magnussolution / magnusbilling7

MagnusBilling is a fast, secure, efficient, high availability, VOIP Billing.
https://www.magnusbilling.org
GNU Lesser General Public License v3.0
182 stars 106 forks source link

Provider rates import broken after update #671

Open dimambl opened 8 months ago

dimambl commented 8 months ago

Provider rate import is broken after recent Magnus update. Getting a big red error window:

MYSQL message. CDbException Object ( [errorInfo] => Array ( [0] => 22007 [1] => 1292 [2] => Truncated incorrect DECIMAL value: ' Dialcodes' ) [message:protected] => CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DECIMAL value: ' Dialcodes' [string:Exception:private] => [code:protected] => 22007 [file:protected] => /var/www/html/mbilling/yii/framework/db/CDbCommand.php [line:protected] => 358 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/html/mbilling/protected/controllers/RateProviderController.php [line] => 179 [function] => execute [class] => CDbCommand [type] => -> ) [1] => Array ( [file] => /var/www/html/mbilling/protected/controllers/RateProviderController.php [line] => 89 [function] => importRates [class] => RateProviderController [type] => -> ) [2] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/actions/CInlineAction.php [line] => 49 [function] => actionImportFromCsv [class] => RateProviderController [type] => -> ) [3] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/CController.php [line] => 308 [function] => runWithParams [class] => CInlineAction [type] => -> ) [4] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/CController.php [line] => 286 [function] => runAction [class] => CController [type] => -> ) [5] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/CController.php [line] => 265 [function] => runActionWithFilters [class] => CController [type] => -> ) [6] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/CWebApplication.php [line] => 282 [function] => run [class] => CController [type] => -> ) [7] => Array ( [file] => /var/www/html/mbilling/yii/framework/web/CWebApplication.php [line] => 141 [function] => runController [class] => CWebApplication [type] => -> ) [8] => Array ( [file] => /var/www/html/mbilling/yii/framework/base/CApplication.php [line] => 185 [function] => processRequest [class] => CWebApplication [type] => -> ) [9] => Array ( [file] => /var/www/html/mbilling/index.php [line] => 11 [function] => run [class] => CApplication [type] => -> ) ) [previous:Exception:private] => )

I though removing strict mode in PHP might solve the problem but i did not. No rates can be added only manually one by one which makes is impossible

Please advice howe it can be fixed