[ASTPPCOM-221] Cant import new rates version 3.5 Created: 07/Sep/17  Updated: 01/Apr/21  Resolved: 01/Apr/21

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

Type: New Feature
Reporter: genlangtechnologies Assignee: Samir Doshi
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

Error Number: 1054

Unknown column 'old_cost' in 'field list'

INSERT INTO routes (pattern, comment, connectcost, includedseconds, cost, init_inc, inc, precedence, last_modified_date, pricelist_id, trunk_id, reseller_id, creation_date) VALUES ('^27106150.','CELL C - GEOGRAPHIC','0','0','0.290928','1','1','','2017-09-07 17:35:28','6','0','0','2017-09-07 17:35:28'),('^27128820.','CELL C - GEOGRAPHIC','0','0','0.290928','1','1','','2017-09-07 17:35:28','6','0','0','2017-09-07 .. """""" cut out the bulk of the import """"".........*','CELL C - MOBILE','0','0','0.3819','1','1','','2017-09-07 17:35:28','6','0','0','2017-09-07 17:35:28') ON DUPLICATE KEY UPDATE old_cost = IF(VALUES(cost) != cost,cost,old_cost), effective_date = IF(VALUES(cost) > cost,'',(IF(VALUES(cost) < cost,'',effective_date))), comment=VALUES(comment), connectcost=VALUES(connectcost), includedseconds=VALUES(includedseconds), cost=VALUES(cost), init_inc=VALUES(init_inc), inc=VALUES(inc), last_modified_date=VALUES(last_modified_date), status=IF(VALUES(cost) = '-1','1','0')

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

Line Number: 375

 Comments   
Comment by exgard [ 11/Sep/17 ]

Hi.
this is a issue, because,in the database, doesn't exist the column "old_cost".
i fix, this issue, adding the colum old_cost in the database routes.
how:
1) i search the password of user root for mysql.
vim /var/lib/astpp/astpp-config.conf
2) execute the command: mysql -u root -p, after write the password of mysql root user
3) execute the command: use astpp;
4) execute: show tables;
5) execute: alter table routes add old_cost varchar (255);
6) try again.

Best Regard.

Comment by Samir Doshi [ 11/Sep/17 ]

We have resolved that issue in github source code last week. You can run
update script to update your server source to latest one.

<https://mailtrack.io/> Sent with Mailtrack
<https://mailtrack.io/install?source=signature&lang=en&referral=samir.doshi@inextrix.com&idSignature=22>

Best Regards

Samir Doshi
iNextrix Technologies Pvt. Ltd.
http://www.inextrix.com

Disclaimer:
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorized to receive it. If you
are not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking action in reliance of the contents of this
information is strictly prohibited and may be unlawful. Please notify the
sender immediately and destroy all copies of this message and any
attachments contained in it.

On Mon, Sep 11, 2017 at 5:28 AM, Exgard <notifications@github.com> wrote:

> Hi.
> this is a issue, because,in the database, doesn't exist the column
> "old_cost".
> i fix, this issue, adding the colum old_cost in the database routes.
> how:
>
> 1. i search the password of user root for mysql.
> vim /var/lib/astpp/astpp-config.conf
> 2. execute the command: mysql -u root -p, after write the password of
> mysql root user
> 3. execute the command: use astpp;
> 4. execute: show tables;
> 5. execute: alter table routes add old_cost varchar (255);
> 6. try again.
>
> Best Regard.
>
> —
> You are receiving this because you commented.
> Reply to this email directly, view it on GitHub
> <https://github.com/iNextrix/ASTPP/issues/221#issuecomment-328383633>, or mute
> the thread
> <https://github.com/notifications/unsubscribe-auth/AA6gcTKbJolz7MJmhoO2vZAgb3y3vsvOks5shHe-gaJpZM4PQJ50>
> .
>

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