Re: DATAOBJECT_FORMBUILDER_FRONTEND with SQLITE

On 11/3/06, Marco Sottana <marco.sottana@q-web.it> wrote:

my error: #!/usr/bin/php -q DB_DataObject_Generator: 0: CREATING FOR c:/AppServ/www/SQLITE/databases/prova.sqlite DB_DataObject_Generator: CONNECT: NEW CONNECTION DB_DataObject_Generator: CONNECT: sqlite:///c:/AppServ/www/SQLITE/databases/prova.sqlite 0191ee0e352f79440a265e6f7debb14e DB_DataObject_Generator: CONNECT: a:1:{s:32:"0191ee0e352f79440a265e6f7debb14e";O:8:"DB_Error":8:{s:20:"error_message_prefix";s:0:"";s:4:"mode";i:1;s:5:"level";i:1024;s:4:"code";i:-25;s:7:"message";s:29:"DB Error: extension not found";s:8:"userinfo";s:90:" [DB Error: extension not found] ** sqlite:///c:/AppServ/www/SQLITE/databases/prova.sqlite";s:9:"backtrace";a:10:{i:0;a:7:{s:4:"file";s:19:"C:\php5\PEAR\DB.php";s:4:"line";i:888;s:8:"function";s:10:"PEAR_Error";s:5:"class";s:10:"PEAR_Error";s:6:"object";r:2;s:4:"type";s:2:"->";s:4:"args";a:5:{i:0;s:29:"DB Error: extension not found";i:1;i:-25;i:2;i:1;i:3;i:1024;i:4;s:32:" [DB Error: extension not found]";}}i:1;a:7:{s:4:"file";s:21:"C:\php5\PEAR\PEAR.php";s:4:"line";i:557;s:8:"function";s:8:"DB_Error";s:5:"class";s:8:"DB_Error";s:6:"object";r:2;s:4:"type";s:2:"->";s:4:"args";a:4:{i:0;i:-25;i:1;i:1;i:2;i:1024;i:3;s:32:" [DB Error: extension not found]";}}i:2;a:7:{s:4:"file";s:26:"C:\php5\PEAR\DB\common.php";s:4:"line";i:1849;s:8:"function";s:10:"raiseError";s:5:"class";s:4:"PEAR";s:6:"object";O:9:"DB_sqlite":7:{s:8:"dbsyntax";s:6:"sqlite";s:3:"dsn";a:0:{}s:8:"features";a:7:{s:5:"limit";s:5:"alter";s:8:"new_link";b:0;s:7:"numrows";b:1;s:8:"pconnect";b:1;s:7:"prepare";b:0;s:3:"ssl";b:0;s:12:"transactions";b:0;}s:9:"fetchmode";i:1;s:22:"fetchmode_object_class";s:8:"stdClass";s:7:"options";a:8:{s:16:"result_buffering";i:500;s:10:"persistent";b:0;s:3:"ssl";b:0;s:5:"debug";i:0;s:14:"seqname_format";s:6:"%s_seq";s:8:"autofree";b:0;s:11:"portability";i:0;s:8:"optimize";s:11:"performance";}s:13:"was_connected";b:0;}s:4:"type";s:2:"->";s:4:"args";a:7:{i:0;N;i:1;i:-25;i:2;N;i:3;N;i:4;s:32:" [DB Error: extension not found]";i:5;s:8:"DB_Error";i:6;b:1;}}i:3;a:7:{s:4:"file";s:26:"C:\php5\PEAR\DB\sqlite.php";s:4:"line";i:199;s:8:"function";s:10:"raiseError";s:5:"class";s:9:"DB_common";s:6:"object";r:40;s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;i:-25;}}i:4;a:7:{s:4:"file";s:19:"C:\php5\PEAR\DB.php";s:4:"line";i:556;s:8:"function";s:7:"connect";s:5:"class";s:9:"DB_sqlite";s:6:"object";r:40;s:4:"type";s:2:"->";s:4:"args";a:2:{i:0;a:9:{s:7:"phptype";s:6:"sqlite";s:8:"dbsyntax";s:6:"sqlite";s:8:"username";b:0;s:8:"password";b:0;s:8:"protocol";s:3:"tcp";s:8:"hostspec";s:0:"";s:4:"port";b:0;s:6:"socket";b:0;s:8:"database";s:44:"c:/AppServ/www/SQLITE/databases/prova.sqlite";}i:1;b:0;}}i:5;a:7:{s:4:"file";s:30:"C:\php5\PEAR\DB\DataObject.php";s:4:"line";i:2205;s:8:"function";s:7:"connect";s:5:"class";s:2:"DB";s:6:"object";O:23:"DB_DataObject_Generator":19:{s:6:"tables";N;s:12:"_definitions";N;s:5:"table";N;s:10:"_newConfig";N;s:8:"_extends";s:13:"DB_DataObject";s:12:"_extendsFile";s:17:"DB/DataObject.php";s:10:"_className";N;s:22:"_DB_DataObject_version";s:5:"1.8.4";s:7:"__table";s:0:"";s:1:"N";i:0;s:13:"_database_dsn";s:54:"sqlite:///c:/AppServ/www/SQLITE/databases/prova.sqlite";s:17:"_database_dsn_md5";s:32:"0191ee0e352f79440a265e6f7debb14e";s:9:"_database";s:12:"prova.sqlite";s:6:"_query";a:7:{s:9:"condition";s:0:"";s:8:"group_by";s:0:"";s:8:"order_by";s:0:"";s:6:"having";s:0:"";s:11:"limit_start";s:0:"";s:11:"limit_count";s:0:"";s:11:"data_select";s:1:"*";}s:12:"_DB_resultid";N;s:13:"_resultFields";b:0;s:12:"_link_loaded";b:0;s:5:"_join";s:0:"";s:10:"_lastError";b:0;}s:4:"type";s:2:"->";s:4:"args";a:1:{i:0;s:54:"sqlite:///c:/AppServ/www/SQLITE/databases/prova.sqlite";}}i:6;a:7:{s:4:"file";s:40:"C:\php5\PEAR\DB\DataObject\Generator.php";s:4:"line";i:173;s:8:"function";s:8:"_connect";s:5:"class";s:13:"DB_DataObject";s:6:"object";r:105;s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:7;a:7:{s:4:"file";s:40:"C:\php5\PEAR\DB\DataObject\Generator.php";s:4:"line";i:142;s:8:"function";s:16:"_createTableList";s:5:"class";s:23:"DB_DataObject_Generator";s:6:"object";r:105;s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:8;a:7:{s:4:"file";s:43:"C:\php5\PEAR\DB\DataObject\createTables.php";s:4:"line";i:58;s:8:"function";s:5:"start";s:5:"class";s:23:"DB_DataObject_Generator";s:6:"object";O:23:"DB_DataObject_Generator":19:{s:6:"tables";N;s:12:"_definitions";N;s:5:"table";N;s:10:"_newConfig";N;s:8:"_extends";s:13:"DB_DataObject";s:12:"_extendsFile";s:17:"DB/DataObject.php";s:10:"_className";N;s:22:"_DB_DataObject_version";s:5:"1.8.4";s:7:"__table";s:0:"";s:1:"N";i:0;s:13:"_database_dsn";s:0:"";s:17:"_database_dsn_md5";s:0:"";s:9:"_database";s:0:"";s:6:"_query";a:7:{s:9:"condition";s:0:"";s:8:"group_by";s:0:"";s:8:"order_by";s:0:"";s:6:"having";s:0:"";s:11:"limit_start";s:0:"";s:11:"limit_count";s:0:"";s:11:"data_select";s:1:"*";}s:12:"_DB_resultid";N;s:13:"_resultFields";b:0;s:12:"_link_loaded";b:0;s:5:"_join";s:0:"";s:10:"_lastError";b:0;}s:4:"type";s:2:"->";s:4:"args";a:0:{}}i:9;a:4:{s:4:"file";s:44:"C:\AppServ\www\SQLITE\FRONT\createTables.php";s:4:"line";i:14;s:4:"args";a:1:{i:0;s:43:"C:\php5\PEAR\DB\DataObject\createTables.php";}s:8:"function";s:12:"require_once";}}s:8:"callback";N;}} DB_DataObject_Generator: CONNECT FAILED: [db_error: message="DB Error: extension not found" code=-25 mode=return level=notice prefix="" info=" [DB Error: extension not found] ** sqlite:///c:/AppServ/www/SQLITE/databases/prova.sqlite"] DB_DataObject_Generator: ERROR: Connect failed, turn on debugging to 5 see why DB_DataObject Error: Connect failed, turn on debugging to 5 see why

First off, this is a DB_DataObject Generator error, not a FormBuilder_Frontend error. Second, this is actually a DB error. DB Error: extension not found Looks like you don't have sqlite built into PHP perhaps?

----- Original Message ----- From: "Justin Patrin" <papercrane@gmail.com> To: "Marco Sottana" <marco.sottana@q-web.it> Cc: <pear-general@lists.php.net> Sent: Thursday, November 02, 2006 9:35 PM Subject: Re: [PEAR] DATAOBJECT_FORMBUILDER_FRONTEND with SQLITE On 11/2/06, Marco Sottana <marco.sottana@q-web.it> wrote:

i would like to use dataobject_formbuilder_frontend with sqlite... but it doesn't work .. anyone can help me ?

What isn't working? -- Justin Patrin -- PEAR General Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

-- Justin Patrin