Customer Can't Search Rate ver 4.0.1

[acpanda]

Hi,

In customer portal, rate menu, enter a country code for the search form and after hit search button, there is nothing happens except waiting icon.

Also went to check the demo: http://latest.astppbilling.org/user/user_rates_list/

Same thing happens.

Any idea how to fix that\? 

ACP 

[acpanda]

paste here for the demo account password:

http://latest.astppbilling.org/user/user_rates_list/

Username: 9115444435
Password: customer@123

[acpanda]

So I digged deeper. 

when search eg. Code: 79, and inspect the console in Chrome, I saw this URL highlighted in red at the Newtwork Section of Chrome Console :

http://latest.astppbilling.org/user/user_rates_list_json?page=1&rp=10&sortname=id&sortorder=desc&query=&qtype=

paste it and run from browser, it gave this error:

A Database Error Occurred

Error Number: 1054

Unknown column 'pattern' in 'where clause'

SELECT pricelist_id FROM (`accounts`) WHERE `pattern` LIKE '^79%' AND `id` = '4'

Filename: /opt/ASTPP/web_interface/astpp/models/db_model.php

Line Number: 77

It seems to be a bug ? The pattern field is formed as part of the query string which is not the field of accounts table.