[ASTPPCOM-156] ERROR code php Created: 15/Nov/16  Updated: 17/Nov/16  Resolved: 17/Nov/16

Status: Done
Project: ASTPP Community
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Task
Reporter: ramifourati Assignee: Unassigned
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Hi,

After installing astpp and try to create anything from trunk, rate groups, customer or provider we are getting this error after we click on save

A Database Error Occurred
Error Number: 1366

Incorrect integer value: '' for column 'includedseconds' at row 1

Insert into routes (pricelist_id,pattern,comment,status,connectcost,includedseconds,cost,init_inc,inc,trunk_id,creation_date) values('1','^33.','france','0','0','','0','','','1','2016-11-15 11:40:40') ON DUPLICATE KEY UPDATE pricelist_id = '1',pattern = '^33.',comment = 'france',status = '0',connectcost = '0',includedseconds = '',cost = '0',init_inc = '',inc = '',trunk_id = '1',creation_date = '2016-11-15 11:40:40'

Filename: /var/www/html/astpp/modules/rates/models/rates_model.php

Line Number: 355

and this error for creating a customer when we click on save

A Database Error Occurred
Error Number: 1366

Incorrect integer value: '' for column 'id' at row 1

INSERT INTO accounts (id, type, number, password, pin, first_name, last_name, company_name, telephone_1, telephone_2, email, address_1, address_2, city, province, postal_code, country_id, timezone_id, currency_id, status, is_recording, allow_ip_management, dialed_modify, maxchannels, interval, first_used, validfordays, expiry, pricelist_id, posttoexternal, sweep_id, invoice_day, balance, credit_limit, local_call, charge_per_min, notify_flag, notify_credit_limit, notify_email, reseller_id, creation) VALUES ('', '0', '4544774292', 'IuTeY62yJJUA2M9SXBAEfTv-iV7wpju5f20rmb-OBE0', '333573', 'test', '', '', '', '', 'test@test.com', '', '', '', '', '', '85', '27', '139', '0', '0', '0', '', '0', '', '0000-00-00 00:00:00', '', '2036-11-15 13:59:57', '1', '0', '2', '15', '', '0', 0, '', '0', '', '', 0, '2016-11-15 13:59:57')

Filename: /var/www/html/astpp/modules/accounts/models/accounts_model.php

Line Number: 65

Help please



 Comments   
Comment by dev-astpp [ 17/Nov/16 ]

Please change sql_mode to "NO_ENGINE_SUBSTITUTION"
It should work.

Generated at Sat Feb 10 07:14:38 CET 2024 using Jira 8.13.3#813003-sha1:22ebedbb75c99b147c66f14e031dd8a2d214753a.