Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: jameswilson on August 02, 2012, 07:55:14 PM

Title: DBD sqlite error
Post by: jameswilson on August 02, 2012, 07:55:14 PM

Quote

Software error:

DBD::SQLite::db prepare failed: not an error at /opt/sark/perl/modules/sark/SarkSubs.pm line 917.

Upgraded asterisk 14 to 18 and now have this?

Any ideas please

Title: Re: DBD sqlite error
Post by: SARK devs on August 04, 2012, 04:06:55 PM

I have not seen an error like this as a result of an upgrade of asterisk.  The error does not have anything to do with asterisk directly so I would suspect that something else may have changed on your system.   The error message you received is an unusual one. It is often associated with mixed or incorrect versions of sqlite.  Did you by any chance build sqlite with your new asterisk install?  How did you install the new asterisk version?  which version of sark/sail do you have?   

You can get an output (in the error-log) of the actual sql command which you are running by uncommenting line 914 in the same SarkSubs module and running your code again.

Kind Regards

S
 

Title: Re: DBD sqlite error
Post by: compsos on August 25, 2012, 01:06:19 AM

James
Check the version of perl-DBD-SQLite installed as there is an update in smecontribs that breaks Sail. Remove and reinstall the version from the Sail site.
http://sailpbx.com/sail/sail-3.2/perl-DBD-SQLite-1.14-1.el5.rf.i386.rpm (http://sailpbx.com/sail/sail-3.2/perl-DBD-SQLite-1.14-1.el5.rf.i386.rpm)