[Sqlstate[Hy093] Error When Adding Company]

I am getting this error when I try to create another company in Blesta. 

SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 

Printing Stack Trace:
#0 /u01/web_sky806/accounts.percepticon.com/public_html/lib/model.php(124): PDOStatement->execute(Array)
#1 /u01/web_sky806/accounts.percepticon.com/public_html/components/record/record.php(669): Model->query('SELECT `id`, `n...', Array)
#2 /u01/web_sky806/accounts.percepticon.com/public_html/app/models/companies.php(284): Record->fetch()
#3 /u01/web_sky806/accounts.percepticon.com/public_html/app/controllers/admin_system_companies.php(78): Companies->get('3')
#4 /u01/web_sky806/accounts.percepticon.com/public_html/lib/dispatcher.php(111): AdminSystemCompanies->add()
#5 /u01/web_sky806/accounts.percepticon.com/public_html/index.php(21): Dispatcher::dispatch('/admin/settings...')
#6 {main}

Any ideas as to what might be causing it?

[How To List All Pricing_Id's]

Actually I want to get a list of all pricing options. That way I can differentiate between monthly and yearly price options for a package. Am I correct in assuming that each price option in a package has a unique pricing_id?

[How To List All Pricing_Id's]

I am attempting to provision services based on the data posted to a URL when a service is added, suspended, canceled, etc. The data posted when a service is added is adequate, but unfortunately very little information is posted when a service is suspended or canceled. The JSON below is returned when a service is added. When a service is suspended, only the package options are returned (domain_prefix, maximum_contacts, provisioning_id). It would be nice if the client_id and other information was returned when a service is suspended or canceled.

{  
   "domain_prefix":"mobile",
   "maximum_contacts":"100000",
   "provisioning_id":"123456",
   "_other":{  
      "status":"active",
      "meta":{  
         "domain_prefix":"mobile"
      },
      "notify_order":"true",
      "use_module":"true",
      "pricing_id":"32",
      "qty":"1",
      "current_qty":"1",
      "client_id":"1"
   }
}

So I am trying to create a list of all the pricing_id's in order to build a table to provision the services based on what the customer ordered. Does anyone have a simple way of creating a master list of pricing_id's?

 

Any help is appreciated.

[[Module] Opensrs - Beta 1.0.8 Relesed :)]

Hi PauloV,

 

I succesfully installed your module and it works well! I would like to move over several existing domains into Blesta (100+) and was wondering if you had any suggestions. Is there an easy way to import existing domains at OpenSRS into Blesta?

 

Thanks

--

dmonaldo