Wow - one of the most comprehensive set of steps I've seen for a while! Regarding your problem - try using this syntax in databases.yml for the dsn:
sqlite:///c:/full/windows/path/to/file.db -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Norman G. Hoffman Sent: 10 May 2009 05:17 To: [email protected] Subject: [symfony-users] Propel:insert-sql for sqlite fails with "[wrapped: could not find driver]" error. Hi, I'm trying to learn symfony, and I'm having a problem with propel:insert-sql for the sqlite database in the sf_sandbox application. It is failing with a "[wrapped: could not find driver]" error. Here's what I get: This command will remove all data in your database. Are you sure you want to proceed? (y/N) y >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "insert-sql" phing task Execution of target "insert-sql" failed for the following reason: C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\ lib\vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] [phing] C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\ lib\vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] Some problems occurred when executing the task: build-propel.xml:275:1: [wrapped: could not find driver] If the exception message is not clear enough, read the output of the task for more information >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml When I switch to MySQL, propel:insert-sql works fine. I'm running on Windows XP Pro, Service Pack 3. Below is a detailed log of my attempt to get this working. Thanks in advance for your help! Sincerely, Norm Hoffman [email protected] As a guideline for installation, I used the instructions at http://trac.symfony-project.org/wiki/WindowsXPDevelopmentEnvironment and http://www.symfony-project.org/tutorial/1_2/my-first-project. Initially, I performed all the recommended updates, and got the problem. Then I ran through it again, installing the bare minimum to see if I still got the problem (I did). Following is the log if that minimal installation. 1. Removed previous installations of symfony, apache, mysql, php, perl. Cleaned up files, registry entries, environment variables, Windows services, etc. Left earlier installation of Subversion and TortoiseSVN intact. 2. Downloaded and ran xampp-win32-1.7.1-installer.exe from http://www.apachefriends.org/en/xampp-windows.html. Documentation says this will install (For Windows 2000, 2003, XP, VISTA): Apache HTTPD 2.2.11, MySQL 5.1.33, PHP 5.2.9, Openssl 0.9.8i, phpMyAdmin 3.1.3.1, XAMPP Control Panel 2.5, XAMPP CLI Bundle 1.3, Webalizer 2.01-10, Mercury Mail Transport System v4.62, FileZilla FTP Server 0.9.31, SQLite 2.8.15, ADODB 5.06a, Zend Optimizer 3.3.0, eAccelerator 0.9.5.3, XAMPP Security, and Ming. Installed XAMPP into the default directory c:\xampp. Installed Apache, MySQL and FIleZilla as Windows services. Got these popup windows at the end: "Installation Complete. Setup was completed successfully." "Service installation finished! Hint: Used also the XAMPP Control Panel to manage services." "Congratulations! The installation was successful! Start the XAMPP Control Panel now?" Clicked Yes. 3. Displayed XAMPP status in the XAMPP Control Panel: XAMPP Control Panel shows Apache, MySQL and FileZilla running. 4. Displayed XAMPP status in http://localhost/xampp/: Navigated to http://localhost/, specified English as the desired language. "Welcome to XAMPP for Windows Version 1.7.1 !" Clicked Status. XAMPP Status shows the following as ACTIVATED: MySQL database, PHP, HTTPS (SSL), Common Gateway Interface (CGI), Server Side Includes (SSI), SMTP Service, FTP Service. 5. Added to PATH: C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin;C:\xampp\apache\bin;. Then rebooted. 6. Showed pear configuration: C:\>pear config-show CONFIGURATION (CHANNEL PEAR.PHP.NET): ===================================== Auto-discover new Channels auto_discover <not set> Default Channel default_channel pear.php.net HTTP Proxy Server Address http_proxy <not set> PEAR server [DEPRECATED] master_server pear.php.net Default Channel Mirror preferred_mirror pear.php.net Remote Configuration File remote_config <not set> PEAR executables directory bin_dir C:\xampp\php PEAR documentation directory doc_dir C:\xampp\php\pear\docs PHP extension directory ext_dir C:\xampp\php\ext\ PEAR directory php_dir C:\xampp\php\pear PEAR Installer cache directory cache_dir C:\xampp\tmp PEAR configuration file cfg_dir C:\xampp\php\cfg directory PEAR data directory data_dir C:\xampp\php\pear\data PEAR Installer download download_dir C:\DOCUME~1\norm\LOCALS~1\Temp\pear\download directory PHP CLI/CGI binary php_bin C:\xampp\php\.\php.exe php.ini location php_ini <not set> PEAR Installer temp directory temp_dir C:\DOCUME~1\norm\LOCALS~1\Temp\pear\temp PEAR test directory test_dir C:\xampp\php\pear\tests PEAR www files directory www_dir C:\xampp\php\www Cache TimeToLive cache_ttl 3600 Preferred Package State preferred_state stable Unix file mask umask 0 Debug Log Level verbose 1 PEAR password (for password <not set> maintainers) Signature Handling Program sig_bin c:\gnupg\gpg.exe Signature Key Directory sig_keydir C:\xampp\php\pearkeys Signature Key Id sig_keyid <not set> Package Signature Type sig_type gpg PEAR username (for username <not set> maintainers) User Configuration File Filename C:\WINDOWS\pear.ini System Configuration File Filename C:\WINDOWS\pearsys.ini 7. Added the 'symfony' channel: C:\> pear channel-discover pear.symfony-project.com Adding Channel "pear.symfony-project.com" succeeded Discovery of channel "pear.symfony-project.com" succeeded 8. Viewed the libraries available in the 'symfony' channel: C:\> pear remote-list -c symfony CHANNEL SYMFONY AVAILABLE PACKAGES: =================================== PACKAGE VERSION pake 1.1.4 symfony 1.2.7 9. Installed the latest stable version of symfony and all its dependencies: C:\> pear install symfony/symfony downloading symfony-1.2.7.tgz ... Starting to download symfony-1.2.7.tgz (2,695,475 bytes) ........done: 2,695,475 bytes install ok: channel://pear.symfony-project.com/symfony-1.2.7 10. Changed c:\xampp\php\php.ini to support symfony: Set magic_quotes_gpc = Off. register_globals was already Off. short_open_tag was already On. 11. Installed symfony sandbox: Downloaded http://www.symfony-project.org/get/sf_sandbox_1_2.zip. Installed into C:\MyDocs\Projects\Symfony\sf_sandbox. C:\MyDocs\Projects\Symfony\sf_sandbox>symfony -V symfony version 1.2.7 (C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony) 12. Configured apache server to access sf_sandbox; Added definitions to C:\xampp\apache\conf\httpd.conf: ### BEGIN NEW FOR SYMFONY # Use name-based virtual hosting. NameVirtualHost *:80 #original xampp location <VirtualHost *:80> ServerName localhost DocumentRoot "C:\xampp\htdocs" </VirtualHost> <VirtualHost *:80> ServerName mysandbox DocumentRoot "C:\MyDocs\Projects\Symfony\sf_sandbox\web" DirectoryIndex index.php Alias /sf "C:\xampp\php\PEAR\data\symfony\web\sf" <Directory "C:\xampp\php\PEAR\data\symfony\web\sf"> AllowOverride All Allow from All </Directory> <Directory "C:\MyDocs\Projects\Symfony\sf_sandbox\web"> AllowOverride All Allow from All </Directory> </VirtualHost> ### END NEW FOR SYMFONY 13. Updated C:\WINDOWS\system32\drivers\etc\hosts: 127.0.0.1 mysandbox 14. Stopped and restarted the apache server Windows service. 15. Confirmed that the default apache website is still working: Navigated to http://localhost and got the Welcome page. Clicked Status and got the XAMPP Status page. 16. Tested the sf_sandbox project: Navigated to http://mysandbox and got the congratulations page: "Symfony Project Created. Congratulations! You have successfully created your symfony project." 17. Confirmed that sqlite is working: C:\> sqlite -version 2.8.17 C:\> sqlite test.db "create table t1 (t1key INTEGER PRIMARY KEY,data TEXT);" C:\> sqlite test.db "insert into t1 (data) values ('This is sample data');" C:\> sqlite test.db "insert into t1 (data) values ('More sample data');" C:\> sqlite test.db "insert into t1 (data) values ('And a little more');" C:\> sqlite test.db "select * from t1;" 1|This is sample data 2|More sample data 3|And a little more 18. Confirmed that php and the sf_sandbox project include support for sqlite: C:\MyDocs\Projects\Symfony\sf_sandbox> php -m [PHP Modules] bcmath calendar com_dotnet ctype date dom exif filter ftp gd gettext hash iconv imap json libxml mbstring mcrypt mime_magic ming mssql mysql mysqli odbc paradox pcre pdf PDO pdo_mssql pdo_mysql pgsql ps Reflection session SimpleXML soap sockets SPL SQLite standard tokenizer wddx xml xmlreader xmlrpc xmlwriter xsl Zend Optimizer zip zlib [Zend Modules] Zend Extension Manager Zend Optimizer php -i excerpt: phpinfo() PHP Version => 5.2.9 System => Windows NT LAPTOP6 5.1 build 2600 Build Date => Feb 25 2009 15:51:41 Configure Command => cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" Server API => Command Line Interface Virtual Directory Support => enabled Configuration File (php.ini) Path => C:\WINDOWS Loaded Configuration File => C:\xampp\php\php.ini Scan this dir for additional .ini files => (none) additional .ini files parsed => (none) PHP API => 20041225 PHP Extension => 20060613 Zend Extension => 220060519 Debug Build => no Thread Safety => enabled Zend Memory Manager => enabled IPv6 Support => enabled Registered PHP Streams => php, file, data, http, ftp, compress.zlib, zip Registered Stream Socket Transports => tcp, udp Registered Stream Filters => convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.* ... PDO PDO support => enabled PDO drivers => mssql, mysql, sqlite2 ... session Session Support => enabled Registered save handlers => files user sqlite ... SQLite SQLite support => enabled PECL Module version => 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.12 2008/12/31 11:17:44 sebastian Exp $ SQLite Library => 2.8.17 SQLite Encoding => iso8859 Directive => Local Value => Master Value sqlite.assoc_case => 0 => 0 ... Environment Variable => Value ALLUSERSPROFILE => C:\Documents and Settings\All Users APPDATA => C:\Documents and Settings\norm\Application Data APR_ICONV_PATH => C:\Program Files\Subversion\iconv CommonProgramFiles => C:\Program Files\Common Files COMPUTERNAME => LAPTOP6 ComSpec => C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK => NO GETMODEL => Satellite A105 HOMEDRIVE => C: HOMEPATH => \Documents and Settings\norm JRE_HOME => C:\Program Files\Java\jre6 LOGONSERVER => \\LAPTOP6 NUMBER_OF_PROCESSORS => 2 OS => Windows_NT Path => C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin;ðî PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW PHP_PEAR_BIN_DIR => C:\xampp\php PHP_PEAR_INSTALL_DIR => C:\xampp\php\pear PHP_PEAR_PHP_BIN => C:\xampp\php\.\php.exe PMTPMTPMT => @include_path@ PROCESSOR_ARCHITECTURE => x86 PROCESSOR_IDENTIFIER => x86 Family 6 Model 15 Stepping 6, GenuineIntel PROCESSOR_LEVEL => 6 PROCESSOR_REVISION => 0f06 ProgramFiles => C:\Program Files PROMPT => $P$G RUBYOPT => -rubygems SESSIONNAME => Console SVN_EDITOR => C:\Program Files\TextPad 4\TextPad.exe SystemDrive => C: SystemRoot => C:\WINDOWS TEMP => C:\DOCUME~1\norm\LOCALS~1\Temp TMP => C:\DOCUME~1\norm\LOCALS~1\Temp TMPTMPTMPTMPT => @includ USERDOMAIN => LAPTOP6 USERNAME => norm USERPROFILE => C:\Documents and Settings\norm VERNUM => PSAA8U-14N02KR VS90COMNTOOLS => c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\ windir => C:\WINDOWS PHP Variables Variable => Value _SERVER["ALLUSERSPROFILE"] => C:\Documents and Settings\All Users _SERVER["APPDATA"] => C:\Documents and Settings\norm\Application Data _SERVER["APR_ICONV_PATH"] => C:\Program Files\Subversion\iconv _SERVER["CommonProgramFiles"] => C:\Program Files\Common Files _SERVER["COMPUTERNAME"] => LAPTOP6 _SERVER["ComSpec"] => C:\WINDOWS\system32\cmd.exe _SERVER["FP_NO_HOST_CHECK"] => NO _SERVER["GETMODEL"] => Satellite A105 _SERVER["HOMEDRIVE"] => C: _SERVER["HOMEPATH"] => \Documents and Settings\norm _SERVER["JRE_HOME"] => C:\Program Files\Java\jre6 _SERVER["LOGONSERVER"] => \\LAPTOP6 _SERVER["NUMBER_OF_PROCESSORS"] => 2 _SERVER["OS"] => Windows_NT _SERVER["Path"] => C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin;ðî _SERVER["PATHEXT"] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW _SERVER["PHP_PEAR_BIN_DIR"] => C:\xampp\php _SERVER["PHP_PEAR_INSTALL_DIR"] => C:\xampp\php\pear _SERVER["PHP_PEAR_PHP_BIN"] => C:\xampp\php\.\php.exe _SERVER["PMTPMTPMT"] => @include_path@ _SERVER["PROCESSOR_ARCHITECTURE"] => x86 _SERVER["PROCESSOR_IDENTIFIER"] => x86 Family 6 Model 15 Stepping 6, GenuineIntel _SERVER["PROCESSOR_LEVEL"] => 6 _SERVER["PROCESSOR_REVISION"] => 0f06 _SERVER["ProgramFiles"] => C:\Program Files _SERVER["PROMPT"] => $P$G _SERVER["RUBYOPT"] => -rubygems _SERVER["SESSIONNAME"] => Console _SERVER["SVN_EDITOR"] => C:\Program Files\TextPad 4\TextPad.exe _SERVER["SystemDrive"] => C: _SERVER["SystemRoot"] => C:\WINDOWS _SERVER["TEMP"] => C:\DOCUME~1\norm\LOCALS~1\Temp _SERVER["TMP"] => C:\DOCUME~1\norm\LOCALS~1\Temp _SERVER["TMPTMPTMPTMPT"] => @includ _SERVER["USERDOMAIN"] => LAPTOP6 _SERVER["USERNAME"] => norm _SERVER["USERPROFILE"] => C:\Documents and Settings\norm _SERVER["VERNUM"] => PSAA8U-14N02KR _SERVER["VS90COMNTOOLS"] => c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\ _SERVER["windir"] => C:\WINDOWS _SERVER["PHP_SELF"] => _SERVER["SCRIPT_NAME"] => _SERVER["SCRIPT_FILENAME"] => _SERVER["PATH_TRANSLATED"] => _SERVER["DOCUMENT_ROOT"] => _SERVER["REQUEST_TIME"] => 1241899958 _SERVER["argv"] => Array ( ) _SERVER["argc"] => 0 _ENV["ALLUSERSPROFILE"] => C:\Documents and Settings\All Users _ENV["APPDATA"] => C:\Documents and Settings\norm\Application Data _ENV["APR_ICONV_PATH"] => C:\Program Files\Subversion\iconv _ENV["CommonProgramFiles"] => C:\Program Files\Common Files _ENV["COMPUTERNAME"] => LAPTOP6 _ENV["ComSpec"] => C:\WINDOWS\system32\cmd.exe _ENV["FP_NO_HOST_CHECK"] => NO _ENV["GETMODEL"] => Satellite A105 _ENV["HOMEDRIVE"] => C: _ENV["HOMEPATH"] => \Documents and Settings\norm _ENV["JRE_HOME"] => C:\Program Files\Java\jre6 _ENV["LOGONSERVER"] => \\LAPTOP6 _ENV["NUMBER_OF_PROCESSORS"] => 2 _ENV["OS"] => Windows_NT _ENV["Path"] => C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin;ðî _ENV["PATHEXT"] => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW _ENV["PHP_PEAR_BIN_DIR"] => C:\xampp\php _ENV["PHP_PEAR_INSTALL_DIR"] => C:\xampp\php\pear _ENV["PHP_PEAR_PHP_BIN"] => C:\xampp\php\.\php.exe _ENV["PMTPMTPMT"] => @include_path@ _ENV["PROCESSOR_ARCHITECTURE"] => x86 _ENV["PROCESSOR_IDENTIFIER"] => x86 Family 6 Model 15 Stepping 6, GenuineIntel _ENV["PROCESSOR_LEVEL"] => 6 _ENV["PROCESSOR_REVISION"] => 0f06 _ENV["ProgramFiles"] => C:\Program Files _ENV["PROMPT"] => $P$G _ENV["RUBYOPT"] => -rubygems _ENV["SESSIONNAME"] => Console _ENV["SVN_EDITOR"] => C:\Program Files\TextPad 4\TextPad.exe _ENV["SystemDrive"] => C: _ENV["SystemRoot"] => C:\WINDOWS _ENV["TEMP"] => C:\DOCUME~1\norm\LOCALS~1\Temp _ENV["TMP"] => C:\DOCUME~1\norm\LOCALS~1\Temp _ENV["TMPTMPTMPTMPT"] => @includ _ENV["USERDOMAIN"] => LAPTOP6 _ENV["USERNAME"] => norm _ENV["USERPROFILE"] => C:\Documents and Settings\norm _ENV["VERNUM"] => PSAA8U-14N02KR _ENV["VS90COMNTOOLS"] => c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\ _ENV["windir"] => C:\WINDOWS ... Created C:\MyDocs\Projects\Symfony\sf_sandbox\web\phpinfo.php to contain "<?php phpinfo(); ?>". Displayed results by navigating to http://mysandbox/phpinfo.php in browser: PHP Version 5.2.9 System Windows NT LAPTOP6 5.1 build 2600 Build Date Feb 25 2009 15:51:41 Configure Command cscript /nologo configure.js "--enable-snapshot-build" "--enable-debug-pack" "--with-snapshot-template=d:\php-sdk\snap_5_2\vc6\x86\template" "--with-php-build=d:\php-sdk\snap_5_2\vc6\x86\php_build" "--with-pdo-oci=D:\php-sdk\oracle\instantclient10\sdk,shared" "--with-oci8=D:\php-sdk\oracle\instantclient10\sdk,shared" Server API Apache 2.0 Handler Virtual Directory Support enabled Configuration File (php.ini) Path C:\WINDOWS Loaded Configuration File C:\xampp\php\php.ini Scan this dir for additional .ini files (none) additional .ini files parsed (none) PHP API 20041225 PHP Extension 20060613 Zend Extension 220060519 Debug Build no Thread Safety enabled Zend Memory Manager enabled IPv6 Support enabled Registered PHP Streams php, file, data, http, ftp, compress.zlib, zip Registered Stream Socket Transports tcp, udp Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.* ... Configuration PHP Core Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen On On allow_url_include Off Off always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file no value no value auto_globals_jit On On auto_prepend_file no value no value browscap C:\xampp\php\browscap\browscap.ini C:\xampp\php\browscap\browscap.ini default_charset no value no value default_mimetype text/html text/html define_syslog_variables Off Off disable_classes no value no value disable_functions no value no value display_errors On On display_startup_errors Off Off doc_root no value no value docref_ext no value no value docref_root no value no value enable_dl On On error_append_string no value no value error_log no value no value error_prepend_string no value no value error_reporting 6135 6135 expose_php On On extension_dir C:\xampp\php\ext\ C:\xampp\php\ext\ file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .;C:\xampp\php\pear\ .;C:\xampp\php\pear\ log_errors Off Off log_errors_max_len 1024 1024 magic_quotes_gpc Off Off magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.force_extra_parameters no value no value max_execution_time 60 60 max_input_nesting_level 64 64 max_input_time 60 60 memory_limit 32M 32M open_basedir no value no value output_buffering no value no value output_handler no value no value post_max_size 64M 64M precision 12 12 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays On On report_memleaks On On report_zend_debug On On safe_mode Off Off safe_mode_exec_dir no value no value safe_mode_gid Off Off safe_mode_include_dir no value no value sendmail_from no value no value sendmail_path no value no value serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func no value no value upload_max_filesize 64M 64M upload_tmp_dir C:\xampp\tmp C:\xampp\tmp user_dir no value no value variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.ze1_compatibility_mode Off Off ... Apache Environment Variable Value AuthDigestEnableQueryStringHack On UNIQUE_ID SgYA6goKCgoAAA-4KlIAAAD2 HTTP_ACCEPT image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */* HTTP_ACCEPT_LANGUAGE en-us HTTP_UA_CPU x86 HTTP_ACCEPT_ENCODING gzip, deflate HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727; InfoPath.2; Media Center PC 2.8; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; eMusic DLM/4; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0) HTTP_HOST mysandbox HTTP_CONNECTION Keep-Alive PATH C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin SystemRoot C:\WINDOWS COMSPEC C:\WINDOWS\system32\cmd.exe PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW WINDIR C:\WINDOWS SERVER_SIGNATURE <address>Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9 Server at mysandbox Port 80</address> SERVER_SOFTWARE Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9 SERVER_NAME mysandbox SERVER_ADDR 127.0.0.1 SERVER_PORT 80 REMOTE_ADDR 127.0.0.1 DOCUMENT_ROOT C:/MyDocs/Projects/Symfony/sf_sandbox/web SERVER_ADMIN ad...@localhost SCRIPT_FILENAME C:/MyDocs/Projects/Symfony/sf_sandbox/web/phpinfo.php REMOTE_PORT 2709 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD GET QUERY_STRING no value REQUEST_URI /phpinfo.php SCRIPT_NAME /phpinfo.php ... PDO PDO support enabled PDO drivers mssql, mysql, sqlite2 ... session Session Support enabled Registered save handlers files user sqlite Registered serializer handlers php php_binary wddx ... SQLite SQLite support enabled PECL Module version 2.0-dev $Id: sqlite.c,v 1.166.2.13.2.12 2008/12/31 11:17:44 sebastian Exp $ SQLite Library 2.8.17 SQLite Encoding iso8859 ... Environment Variable Value ALLUSERSPROFILE C:\Documents and Settings\All Users APR_ICONV_PATH C:\Program Files\Subversion\iconv CommonProgramFiles C:\Program Files\Common Files COMPUTERNAME LAPTOP6 ComSpec C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK NO JRE_HOME C:\Program Files\Java\jre6 NUMBER_OF_PROCESSORS 2 OS Windows_NT Path C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW PROCESSOR_ARCHITECTURE x86 PROCESSOR_IDENTIFIER x86 Family 6 Model 15 Stepping 6, GenuineIntel PROCESSOR_LEVEL 6 PROCESSOR_REVISION 0f06 ProgramFiles C:\Program Files RUBYOPT -rubygems SVN_EDITOR C:\Program Files\TextPad 4\TextPad.exe SystemDrive C: SystemRoot C:\WINDOWS TEMP C:\WINDOWS\TEMP TMP C:\WINDOWS\TEMP USERPROFILE C:\Documents and Settings\LocalService VS90COMNTOOLS c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\ windir C:\WINDOWS AP_PARENT_PID 3036 PHP Variables Variable Value _SERVER["AuthDigestEnableQueryStringHack"] On _SERVER["UNIQUE_ID"] SgYA6goKCgoAAA-4KlIAAAD2 _SERVER["HTTP_ACCEPT"] image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */* _SERVER["HTTP_ACCEPT_LANGUAGE"] en-us _SERVER["HTTP_UA_CPU"] x86 _SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate _SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; .NET CLR 1.0.3705; .NET CLR 1.1.4322; Media Center PC 4.0; .NET CLR 2.0.50727; InfoPath.2; Media Center PC 2.8; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; eMusic DLM/4; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0) _SERVER["HTTP_HOST"] mysandbox _SERVER["HTTP_CONNECTION"] Keep-Alive _SERVER["PATH"] C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin _SERVER["SystemRoot"] C:\WINDOWS _SERVER["COMSPEC"] C:\WINDOWS\system32\cmd.exe _SERVER["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW _SERVER["WINDIR"] C:\WINDOWS _SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9 Server at mysandbox Port 80</address> _SERVER["SERVER_SOFTWARE"] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i PHP/5.2.9 _SERVER["SERVER_NAME"] mysandbox _SERVER["SERVER_ADDR"] 127.0.0.1 _SERVER["SERVER_PORT"] 80 _SERVER["REMOTE_ADDR"] 127.0.0.1 _SERVER["DOCUMENT_ROOT"] C:/MyDocs/Projects/Symfony/sf_sandbox/web _SERVER["SERVER_ADMIN"] ad...@localhost _SERVER["SCRIPT_FILENAME"] C:/MyDocs/Projects/Symfony/sf_sandbox/web/phpinfo.php _SERVER["REMOTE_PORT"] 2709 _SERVER["GATEWAY_INTERFACE"] CGI/1.1 _SERVER["SERVER_PROTOCOL"] HTTP/1.1 _SERVER["REQUEST_METHOD"] GET _SERVER["QUERY_STRING"] no value _SERVER["REQUEST_URI"] /phpinfo.php _SERVER["SCRIPT_NAME"] /phpinfo.php _SERVER["PHP_SELF"] /phpinfo.php _SERVER["REQUEST_TIME"] 1241907434 _SERVER["argv"] Array ( ) _SERVER["argc"] 0 _ENV["ALLUSERSPROFILE"] C:\Documents and Settings\All Users _ENV["APR_ICONV_PATH"] C:\Program Files\Subversion\iconv _ENV["CommonProgramFiles"] C:\Program Files\Common Files _ENV["COMPUTERNAME"] LAPTOP6 _ENV["ComSpec"] C:\WINDOWS\system32\cmd.exe _ENV["FP_NO_HOST_CHECK"] NO _ENV["JRE_HOME"] C:\Program Files\Java\jre6 _ENV["NUMBER_OF_PROCESSORS"] 2 _ENV["OS"] Windows_NT _ENV["Path"] C:\Program Files\Java\jdk1.6.0_13\bin;C:\Program Files\Java\jre6\bin;C:\Program Files\Java\jre6\bin\client;C:\xampp\php;C:\xampp\mysql\bin;C:\xampp\perl\bin ;C:\xampp\apache\bin;C:\Program Files\WinOne;C:\ruby\bin;C:\oracle\product\10.1.2\db_devsuite\bin;C:\oracle\ product\10.1.2\db_devsuite\jdk\jre\bin\classic;C:\oracle\product\10.1.2\db_d evsuite\jdk\jre\bin;C:\oracle\product\10.1.2\db_devsuite\jdk\jre\bin\client; C:\oracle\product\10.1.2\db_devsuite\jlib;C:\oracle\product\10.1.2\db_devsui te\jre\1.4.2\bin\client;C:\oracle\product\10.1.2\db_devsuite\jre\1.4.2\bin;C :\oracle\product\11.1.0\db_laptop6\bin;C:\MyDocs\utl;C:\Program Files\Windows Resource Kits\Tools\;C:\Program Files\Support Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Subversion\bin _ENV["PATHEXT"] .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.RB;.RBW _ENV["PROCESSOR_ARCHITECTURE"] x86 _ENV["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 15 Stepping 6, GenuineIntel _ENV["PROCESSOR_LEVEL"] 6 _ENV["PROCESSOR_REVISION"] 0f06 _ENV["ProgramFiles"] C:\Program Files _ENV["RUBYOPT"] -rubygems _ENV["SVN_EDITOR"] C:\Program Files\TextPad 4\TextPad.exe _ENV["SystemDrive"] C: _ENV["SystemRoot"] C:\WINDOWS _ENV["TEMP"] C:\WINDOWS\TEMP _ENV["TMP"] C:\WINDOWS\TEMP _ENV["USERPROFILE"] C:\Documents and Settings\LocalService _ENV["VS90COMNTOOLS"] c:\Program Files\Microsoft Visual Studio 9.0\Common7\Tools\ _ENV["windir"] C:\WINDOWS _ENV["AP_PARENT_PID"] 3036 19. Confirmed that sf_sandbox is configured for sqlite: C:\MyDocs\Projects\Symfony\sf_sandbox\config\propel.ini excerpt: propel.database = sqlite propel.database.driver = sqlite propel.database.url = sqlite:%SF_DATA_DIR%/sandbox.db propel.database.creole.url = ${propel.database.url} propel.database.user = root propel.database.password = C:\MyDocs\Projects\Symfony\sf_sandbox\config\databases.yml dev: propel: param: classname: DebugPDO test: propel: param: classname: DebugPDO all: propel: class: sfPropelDatabase param: classname: PropelPDO dsn: 'sqlite:%SF_DATA_DIR%/sandbox.db' username: root password: null encoding: utf8 persistent: true pooling: true 20. Created a data model in C:\MyDocs\Projects\Symfony\sf_sandbox\config\schema.yml: propel: blog_post: id: ~ title: { type: varchar(255), required: true } excerpt: { type: longvarchar } body: { type: longvarchar } created_at: ~ blog_comment: id: ~ blog_post_id: ~ author: { type: varchar(255) } email: { type: varchar(255) } body: { type: longvarchar } created_at: ~ 21. Built the data model: C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-model >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "om" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml >> autoload reloading autoloading 22. Built the SQL statements that will be used to create the database schema: C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-sql >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "sql" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml C:\MyDocs\Projects\Symfony\sf_sandbox\data\sql\lib.model.schema.sql was created with the following contents: ---------------------------------------------------------------------------- - -- blog_post ---------------------------------------------------------------------------- - DROP TABLE [blog_post]; CREATE TABLE [blog_post] ( [id] INTEGER NOT NULL PRIMARY KEY, [title] VARCHAR(255) NOT NULL, [excerpt] MEDIUMTEXT, [body] MEDIUMTEXT, [created_at] TIMESTAMP ); ---------------------------------------------------------------------------- - -- blog_comment ---------------------------------------------------------------------------- - DROP TABLE [blog_comment]; CREATE TABLE [blog_comment] ( [id] INTEGER NOT NULL PRIMARY KEY, [blog_post_id] INTEGER, [author] VARCHAR(255), [email] VARCHAR(255), [body] MEDIUMTEXT, [created_at] TIMESTAMP ); -- SQLite does not support foreign keys; this is just for reference -- FOREIGN KEY ([blog_post_id]) REFERENCES blog_post ([id]) 23. Tried to build the database schema based on the created SQL file: C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:insert-sql This command will remove all data in your database. Are you sure you want to proceed? (y/N) y >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "insert-sql" phing task Execution of target "insert-sql" failed for the following reason: C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\ lib\vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] [phing] C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\ lib\vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] Some problems occurred when executing the task: build-propel.xml:275:1: [wrapped: could not find driver] If the exception message is not clear enough, read the output of the task for more information >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml C:\MyDocs\Projects\Symfony\sf_sandbox> Sqlite fails with "[wrapped: could not find driver]" error. Tried MySQL instead: 1. Confirmed that MySQL is available and create a mysandbox database: C:\MyDocs\Projects\Symfony\sf_sandbox>mysql --version mysql Ver 14.14 Distrib 5.1.33, for Win32 (ia32) C:\MyDocs\Projects\Symfony\sf_sandbox>mysql -uroot mysql> create database mysandbox; Query OK, 1 row affected (0.08 sec) mysql> exit 2. Changed sf_sandbox to use MySQL: C:\MyDocs\Projects\Symfony\sf_sandbox>symfony configure:database "mysql:dbname=mysandbox;host=localhost" root Here is an excerpt of the updated propel.ini file: propel.database = mysql propel.database.driver = mysql propel.database.url = mysql:dbname=mysandbox;host=localhost propel.database.creole.url = ${propel.database.url} propel.database.user = root propel.database.password = Here is the updated databases.yml file: dev: propel: param: classname: DebugPDO test: propel: param: classname: DebugPDO all: propel: class: sfPropelDatabase param: classname: PropelPDO dsn: 'mysql:dbname=mysandbox;host=localhost' username: root password: null encoding: utf8 persistent: true pooling: true 3. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-model >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "om" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml >> autoload reloading autoloading 4. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-sql >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "sql" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml C:\MyDocs\Projects\Symfony\sf_sandbox\data\sql\lib.model.schema.sql was created with the following contents: # This is a fix for InnoDB in MySQL >= 4.1.x # It "suspends judgement" for fkey relationships until are tables are set. SET FOREIGN_KEY_CHECKS = 0; #--------------------------------------------------------------------------- -- #-- blog_post #--------------------------------------------------------------------------- -- DROP TABLE IF EXISTS `blog_post`; CREATE TABLE `blog_post` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `title` VARCHAR(255) NOT NULL, `excerpt` TEXT, `body` TEXT, `created_at` DATETIME, PRIMARY KEY (`id`) )Type=InnoDB; #--------------------------------------------------------------------------- -- #-- blog_comment #--------------------------------------------------------------------------- -- DROP TABLE IF EXISTS `blog_comment`; CREATE TABLE `blog_comment` ( `id` INTEGER NOT NULL AUTO_INCREMENT, `blog_post_id` INTEGER, `author` VARCHAR(255), `email` VARCHAR(255), `body` TEXT, `created_at` DATETIME, PRIMARY KEY (`id`), INDEX `blog_comment_FI_1` (`blog_post_id`), CONSTRAINT `blog_comment_FK_1` FOREIGN KEY (`blog_post_id`) REFERENCES `blog_post` (`id`) )Type=InnoDB; # This restores the fkey checks, after having unset them earlier SET FOREIGN_KEY_CHECKS = 1; 5. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:insert-sql This command will remove all data in your database. Are you sure you want to proceed? (y/N) y >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "insert-sql" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml 6. Made sure the insert-sql worked: C:\MyDocs\Projects\Symfony\sf_sandbox>mysql -hlocalhost -uroot mysandbox Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.1.33-community MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show tables; +---------------------------+ | Tables_in_symfony_project | +---------------------------+ | blog_comment | | blog_post | +---------------------------+ 2 rows in set (0.00 sec) mysql> describe blog_comment; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | blog_post_id | int(11) | YES | MUL | NULL | | | author | varchar(255) | YES | | NULL | | | email | varchar(255) | YES | | NULL | | | body | text | YES | | NULL | | | created_at | datetime | YES | | NULL | | +--------------+--------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) mysql> describe blog_post; +------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | title | varchar(255) | NO | | NULL | | | excerpt | text | YES | | NULL | | | body | text | YES | | NULL | | | created_at | datetime | YES | | NULL | | +------------+--------------+------+-----+---------+----------------+ 5 rows in set (0.01 sec) exit MySQL worked. Tried sqlite again: 1. Changed sf_sandbox to use sqlite: C:\MyDocs\Projects\Symfony\sf_sandbox>symfony configure:database "sqlite:C:\MyDocs\Projects\Symfony\sf_sandbox\data\sandbox.db" Here is an excerpt of the updated propel.ini file: propel.database = sqlite propel.database.driver = sqlite propel.database.url = sqlite:C:\MyDocs\Projects\Symfony\sf_sandbox\data\sandbox.db propel.database.creole.url = ${propel.database.url} propel.database.user = root propel.database.password = Here is the updated databases.yml file: dev: propel: param: classname: DebugPDO test: propel: param: classname: DebugPDO all: propel: class: sfPropelDatabase param: classname: PropelPDO dsn: 'sqlite:C:\MyDocs\Projects\Symfony\sf_sandbox\data\sandbox.db' username: root password: null encoding: utf8 persistent: true pooling: true 2. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-model >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "om" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml >> autoload reloading autoloading 3. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:build-sql >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "sql" phing task >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml >> file- C:/MyDocs/Projects/Symfony/sf_s...enerated-schema-transformed.xml C:\MyDocs\Projects\Symfony\sf_sandbox\data\sql\lib.model.schema.sql was created with the following contents: ---------------------------------------------------------------------------- - -- blog_post ---------------------------------------------------------------------------- - DROP TABLE [blog_post]; CREATE TABLE [blog_post] ( [id] INTEGER NOT NULL PRIMARY KEY, [title] VARCHAR(255) NOT NULL, [excerpt] MEDIUMTEXT, [body] MEDIUMTEXT, [created_at] TIMESTAMP ); ---------------------------------------------------------------------------- - -- blog_comment ---------------------------------------------------------------------------- - DROP TABLE [blog_comment]; CREATE TABLE [blog_comment] ( [id] INTEGER NOT NULL PRIMARY KEY, [blog_post_id] INTEGER, [author] VARCHAR(255), [email] VARCHAR(255), [body] MEDIUMTEXT, [created_at] TIMESTAMP ); -- SQLite does not support foreign keys; this is just for reference -- FOREIGN KEY ([blog_post_id]) REFERENCES blog_post ([id]) 4. Ran C:\MyDocs\Projects\Symfony\sf_sandbox>symfony propel:insert-sql This command will remove all data in your database. Are you sure you want to proceed? (y/N) y >> schema converting "C:/MyDocs/Projects/...ndbox/config/schema.yml" to XML >> schema putting C:/MyDocs/Projects/Symf...box/config/generated-schema.xml >> propel Running "insert-sql" phing task Execution of target "insert-sql" failed for the following reason: C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\lib \vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] [phing] C:\MyDocs\Projects\Symfony\sf_sandbox\lib\symfony\plugins\sfPropelPlugin\lib \vendor\propel-generator\build-propel.xml:275:1: [wrapped: could not find driver] Some problems occurred when executing the task: build-propel.xml:275:1: [wrapped: could not find driver] If the exception message is not clear enough, read the output of the task for more information >> file- C:/MyDocs/Projects/Symfony/sf_s...box/config/generated-schema.xml Propel:insert-sql for sqlite still fails with "[wrapped: could not find driver]" error. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
