The error is the comma before AUTO_INCREMENT. Sorry for the noise.
----- Mensaje original ----- De: mailing lists <listas.cor...@yahoo.es> Para: "beginners@perl.org" <beginners@perl.org> CC: Enviado: Miércoles 9 de octubre de 2013 11:10 Asunto: DBD::SQLite::db prepare failed: table turba_shares_2013_10_08 has no column named share_name Hello, I have to do a simple backup, but I fail to see why this part (see attachment) of my script fails: $ ./test.pl INSERT INTO turba_shares_2013_10_08 (share_id, share_name, share_owner, share_flags, perm_creator, perm_default, perm_guest, attribute_name, attribute_desc, attribute_params, share_parents) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); DBD::SQLite::db prepare failed: table turba_shares_2013_10_08 has no column named share_name at ./test.pl line 49. DBD::SQLite::db prepare failed: table turba_shares_2013_10_08 has no column named share_name at ./test.pl line 49. and the "share_name" column is present in the schema, that I'm missing? Thank you -- perl5 (revision 5 version 16 subversion 3) sqlite-3.8.0.2-4.fc19.i686 perl-DBD-SQLite-1.37-4.fc19.i686 perl-DBI-1.623-2.fc19.i686 -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
