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
-~----------~----~----~----~------~----~------~--~---
