[ASTPPCOM-435] A Database Error Occurred Created: 10/Jun/18  Updated: 12/Jul/18  Resolved: 12/Jul/18

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

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


 Description   

When i would like to update a customer this error occured from ADMIN PANNEL
and could not update anything, please give me a solution

Error Number: 1054

Unknown column 'cps' in 'field list'

UPDATE accounts SET id = '3', type = '3', password = 'gaiaRg3lAZI$nTbTjVVe4Z0-hFxXrxCzQTOIug0SHow', pin = '320736', first_name = 'default', last_name = 'provider', company_name = 'ASTPP', telephone_1 = '', telephone_2 = '', email = 'yourprovider@test.com', address_1 = 'adress', address_2 = '', city = '', province = '', postal_code = '', country_id = '85', timezone_id = '49', currency_id = '59', status = '0', is_recording = '0', allow_ip_management = '1', dialed_modify = '', std_cid_translation = '', did_cid_translation = '', maxchannels = '0', cps = '', first_used = '0000-00-00 00:00:00', validfordays = '0', expiry = '2026-07-26 15:12:18', pricelist_id = '1', sweep_id = '2', invoice_day = '1', credit_limit = '0', local_call = '0', charge_per_min = '', tax_number = '' WHERE id = '3'

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

Line Number: 320



 Comments   
Comment by Samir Doshi [ 11/Jun/18 ]

Your database looks like with version 3.5. Please update it.

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