Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 10:23 pm
Hosted Voice Broadcast


All times are UTC




Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: I can not create ratecards
PostPosted: Tue Mar 03, 2015 10:27 am 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Hello forgive my English, I'm from Spain and I use an online translator.

I have a problem for several months, I can not create ratecards, created one when I get the following message

Your new ratecard Average User inserted.

Looking at the logs I see this mistake

[Tue Mar 03 11:17:04 2015] [error] [client XX.XX.XX.XX] PHP Notice: Undefined variable: cssname in /var/www/html/a2billing/common/lib/Misc.php online 324, referer: http://myurl.com/Public/A2B_entity_tari ... &section=6

I a2billing 2.0.12 php version 5.3.3 mysql version 5.5.36

I hope you can help me. A greeting.


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 12:02 am 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Hi I upgraded to version 2.1.0 a2billing and still have the same problem.

Any ideas?


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 12:19 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
I don't think the PHP Notice is causing any issues.

What is the exact error you get when trying to create a rate card?


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 7:39 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Hello

Your new Ratecard hasn't been inserted.


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 9:23 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Hello I contribute new data

I created a new database data without data, and in this way if I can create the ratecard.

Now if I restore the copy of a2billing then I can not create ratecard.

I have checked that no corrupt table is entirely correct.

Any ideas?


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 11:41 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Are you sure you restored data from the same version of A2Billing? If not you should run the update scripts to update the database schema from the previous format.


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Wed Mar 04, 2015 11:44 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
If insurance

When I upgrade from version 2.0.16 a2billing to 2.1.0 I made upgrade scripts.


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 8:40 am 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Did you do the update scripts after restoring the data?


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 1:13 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Yes


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 1:16 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
Unfortunately then I'm not sure. I think it means the SQL that is running to insert the rate card is failing.

The way to find out what SQL commands are running (so you can try them and see why they are failing) is like this - https://sysadminman.net/blog/2015/a2bil ... oting-6476


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 3:17 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
Hi thanks for the tip, do not know much about sql but it seems that any error that you think you do not see?



SELECT config_key as cfgkey, config_value as cfgvalue, config_group_title as cfggname, config_valuetype as cfgtype FROM cc_config

INSERT INTO cc_system_log (iduser, loglevel, action, description, tablename, pagename, ipaddress, data) VALUES('2','1','Page Visit','User Visited the Page','','A2B_entity_tariffplan.php','X.X.X.X','')

SELECT count(*) FROM cc_notification LEFT JOIN cc_notification_admin ON id = id_notification AND id_admin =2 WHERE viewed != 1 OR viewed IS NULL

INSERT INTO cc_tariffplan (tariffname, startingdate, expirationdate, id_trunk, dnidprefix, calleridprefix) values ('Direct', '2015-03-05 16:04:28', '2025-03-05 16:04:28', '3', 'all', 'all')

INSERT INTO cc_system_log (iduser, loglevel, action, description, tablename, pagename, ipaddress, data) VALUES('2','2','NEW RATECARD CREATED','User added a new record in database','cc_tariffplan','A2B_entity_tariffplan.php','X.X.X.X','tariffname = Direct| startingdate = 2015-03-05 16:04:28| expirationdate = 2025-03-05 16:04:28| id_trunk = 3| dnidprefix = all| calleridprefix = all')


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 4:13 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
I can't remember if you see SQL errors in the profiler? Maybe not.

If not you want to connect to MySQL and try running the INSERT INTO cc_tariffplan command manually.

You could try the others too, but I'm guessing it's that one that's failing ...


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 5:56 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
I compared the structure of the table cc_tariffplan new database (which I insert ratecards) and the database where I restored the data (and I can not insert ratecards)

In mysql console there is a column called key in the table cc_tariffplan have different values

Bad data base

--------------------+------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| iduser | int(11) | NO | UNI | 0 | |

Good database

+--------------------+------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------------+------------+------+-----+---------------------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| iduser | int(11) | NO | MUL | 0 | |


I send you this information if you can help.


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 6:13 pm 
Offline

Joined: Fri Sep 20, 2013 5:02 pm
Posts: 35
From the mysql console if I can insert data into the table using INSERT INTO.

Then I go into a2billing and I can modify the ratecard, but from a2billing can not create the ratecard :?

Let the solution seems to be close :D


Top
 Profile  
 
 Post subject: Re: I can not create ratecards
PostPosted: Thu Mar 05, 2015 7:38 pm 
Offline

Joined: Mon Mar 02, 2009 8:56 pm
Posts: 271
If the MySQL command works from the console then it's probably not that causing the issue.

Could you check that the php session folder (/var/lib/php/session on CentOS) is owned by the same use as that running Apache (ps -ef | grep httpd)

Other wise I'm not sure why it's failing.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 16 posts ]  Go to page 1, 2  Next
Auto Dialer Software


All times are UTC


Who is online

Users browsing this forum: No registered users and 16 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group