Re^3: Querying an existing sqlite DB on a remote machine

Well..Now i copied the DB to my local machine.modified the code as follows

$db_handler = DBI->connect("dbi:SQLite:dbname=$dbfile","","") or die "
+Unable to connect: $DBI::errstr\n";
$a_query = "SELECT * FROM $tablename where user_name=\"Psibond\"";
$res = $db_handler->prepare($a_query);

$res->execute();
$row = $res->fetch;
[download]

I am geeting the followin erros now:
DBD::SQLite::db prepare failed: no such module: calmfts2 at DB-Querying.pl line 22.
Can't call method "execute" on an undefined value at DB-Querying.pl line 24.
Is there anything wrong.I guess the sqlite module supports prepare n execute methods. I also will be glad if u can tell me how to fetch out data
Thanks,
Psibond

Comment on Re^3: Querying an existing sqlite DB on a remote machine Download Code

Replies are listed 'Best First'.
Re^4: Querying an existing sqlite DB on a remote machine by Corion (Patriarch) on Jan 28, 2010 at 08:54 UTC
This likely means that on the other machine, SQLite is compiled with an SQLite-specific plugin, `calmfts2`, which sounds to me like it is a Full Text Search implementation. And this plugin does not seem to exist on your local machine. Ask your system administrator about the differences between the two machines and also how to bring the two machines closer in sync.	[reply] [d/l]