Magento

I can’t go through the installation because I allways get the same error :

Though the php_pdo extension is loaded.
What can I do ? Is it important to have this extension loaded ?

Thank you

PS : I use EasyPHP 2.0

have you tried restarting php?

just add in your php.ini

extension=php_pdo.dll
extension=php_pdo_mysql.dll

It works, but now I have this error :

Ive downloaded the php_pdo_mysql.dll and replaced the orginal one,
added the lines to php.ini

still it does not work for me!

anyobody can help?
Im trying to install on my development system locally with windows
ive installed the Zend Core 2.5 platform, which has the php_pdo_mysql.dll build in, so i just replaced the orginal file
and added the lines but it still wont work

help!

@jorries: Which package on windows do you use and what is the path of php.ini that you are editing?
For example in xampp there are at least 2 php.ini, and apache uses apache/conf/php.ini one.

I Use
Zend core 2.5 on
vista

no problems with anything
the php.ini is inside the Zend Core installation folder, ihave the correct one..
The additions for the php mysql and pdo are already there ive just added 1 extra as mentioned.

Replacing the .dll file isent working giving me the error above
Zend Core had the module builtin, and ive activated all the neccesairy modules treu the zend core admin interface

Theres only one php.ini ive searched my whole disk.. no one in windows/php.ini or inside the apache2 folder,
so thats nice.. but it still isent working.. shame i thought installing locally for faster developement, no need to upload each and every file on a change

@jorries: if you put phpinfo() in magento/index.php does it show pdo with mysql installed? could you provide a link for it?

This is my phpinfo output:

PHP Version 5.2.4

System Windows NT CREATIVE 6.0 build 6000
Build Date Oct 1 2007 20:06:04
Configure Command cscript /nologo configure.js “--enable-prefix=C:\cygwin\tmp\build.core-php-nts-5.2.4.3992\core-php-nts-5.2.4\php-5.2.4\..” “--with-openssl=C:\cygwin\tmp\build.core-php-nts-5.2.4.3992\core-php-nts-5.2.4\php-5.2.4\..” “--with-extra-includes=C:\cygwin\tmp\build.core-php-nts-5.2.4.3992\core-php-nts-5.2.4\php-5.2.4\..\usr\include” “--with-extra-libs=C:\cygwin\tmp\build.core-php-nts-5.2.4.3992\core-php-nts-5.2.4\php-5.2.4\..\usr\lib” “--disable-ipv6” “--disable-bcmath” “--disable-calendar” “--disable-ftp” “--without-gd” “--disable-odbc” “--without-sqlite” “--disable-tokenizer” “--with-libxml” “--with-iconv” “--disable-force-cgi-redirect” “--enable-fastcgi” “--enable-cli-win32” “--enable-pdo” “--disable-zts” “--disable-xmlwriter”
Server API CGI/FastCGI
Virtual Directory Support disabled
Configuration File (php.ini) Path C:\Windows
Loaded Configuration File C:\Core\etc\php.ini
PHP API 20041225
PHP Extension 20060613
Zend Extension 220060519
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support disabled
Registered PHP Streams https, ftps, php, file, data, http, ftp, compress.zlib
Registered Stream Socket Transports tcp, udp, ssl, sslv3, sslv2, tls
Registered Stream Filters convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with Zend Core v2.5.0, Copyright (c) 1998-2006, by Zend Technologies
with Zend Extension Manager v1.2.0, Copyright (c) 2003-2006, by Zend Technologies
with Zend Optimizer v3.3.1, Copyright (c) 1998-2007, by Zend Technologies
with Zend Debugger v5.2.10, Copyright (c) 1999-2007, by Zend Technologies

--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
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 no value no value
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 6143
expose_php On On
extension_dir C:\Core\lib\phpext C:\Core\lib\phpext
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:\Core\GUI\infra;.;C:\Core\ZendFramework-0.8.0 .;C:\Core\ZendFramework-0.8.0
log_errors On On
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 30 30
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv On On
register_globals Off Off
register_long_arrays Off Off
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 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order GPCS GPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off

cgi-fcgi
Directive Local Value Master Value
cgi.check_shebang_line 1 1
cgi.fix_pathinfo 1 1
cgi.nph 0 0
cgi.rfc2616_headers 0 0
fastcgi.impersonate 1 1
fastcgi.logging 1 1

com_dotnet
COM support enabled
DCOM support disabled
.Net support enabled

Directive Local Value Master Value
com.allow_dcom 0 0
com.autoregister_casesensitive 1 1
com.autoregister_typelib 0 0
com.autoregister_verbose 0 0
com.code_page no value no value
com.typelib_file no value no value

ctype
ctype functions enabled

curl
cURL support enabled
cURL Information libcurl/7.16.2 OpenSSL/0.9.8e zlib/1.2.3

date
date/time support enabled
“Olson” Timezone Database Version 2007.6
Timezone Database internal
Default timezone Etc/GMT+2

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone Etc/GMT+2 Etc/GMT+2

dom
DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.6.28
HTML Support enabled
XPath Support enabled
XPointer

nobody?

@jorries: your phpinfo is cut at DOM extension so there’s no way to know if you have pdo_mysql installed. could you find only PDO section and paste it here ?

Sorry Moshe,
completely missed that out, my fault

here is the section:
PDO
PDO support enabled
PDO drivers mysql, pgsql

pdo_mysql
PDO Driver for MySQL, client library version 5.0.18

pdo_pgsql
PDO Driver for PostgreSQL enabled
PostgreSQL(libpq) Version 8.2.3
Module version 1.0.2
Revision $Id: pdo_pgsql.c,v 1.7.2.11.2.1 2007/01/01 09:36:05 sebastian Exp $

Perhaps the upgraded installer works im going to try it now

i skipped the pdo_mysql eror during installation by changing config.xml and install.xml now it shows error

please give hand on solving this problem ASAP

Invalid bind-variable position ‘:customer_email’
Trace:
#0 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Statement.php(108): Zend_Db_Statement->_parseParameters(’SELECT `custome...’)
#1 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Mysqli.php(330): Zend_Db_Statement->__construct(Object(Varien_Db_Adapter_Mysqli), ‘SELECT `custome...’)
#2 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Abstract.php(405): Zend_Db_Adapter_Mysqli->prepare(’SELECT `custome...’)
#3 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Abstract.php(711): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Customer/Model/Entity/Customer.php(132): Zend_Db_Adapter_Abstract->fetchOne(Object(Varien_Db_Select), Array)
#5 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Customer/Model/Customer.php(80): Mage_Customer_Model_Entity_Customer->loadByEmail(Object(Mage_Customer_Model_Customer), ‘fdddddddddddddd’)
#6 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Customer/Model/Customer.php(69): Mage_Customer_Model_Customer->loadByEmail(’fdddddddddddddd’)
#7 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Customer/Model/Session.php(109): Mage_Customer_Model_Customer->authenticate(’fdddddddddddddd’, ‘ddfssssssssssss’)
#8 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Customer/controllers/AccountController.php(103): Mage_Customer_Model_Session->login(’fdddddddddddddd’, ‘ddfssssssssssss’)
#9 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Customer_AccountController->loginPostAction()
#10 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch(’loginPost’)
#11 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#12 /home/procabgr/public_html/uhlmannshopup/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#13 /home/procabgr/public_html/uhlmannshopup/index.php(40): Mage::run()
#14 {main}

while logging frontend..

and while logging at admin section

Invalid bind-variable position ‘:username’
Trace:
#0 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Statement.php(108): Zend_Db_Statement->_parseParameters(’SELECT `admin_u...’)
#1 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Mysqli.php(330): Zend_Db_Statement->__construct(Object(Varien_Db_Adapter_Mysqli), ‘SELECT `admin_u...’)
#2 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Abstract.php(405): Zend_Db_Adapter_Mysqli->prepare(’SELECT `admin_u...’)
#3 /home/procabgr/public_html/uhlmannshopup/lib/Zend/Db/Adapter/Abstract.php(636): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/Mysql4/User.php(62): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select), Array)
#5 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/User.php(195): Mage_Admin_Model_Mysql4_User->loadByUsername(’dfssad’)
#6 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/User.php(158): Mage_Admin_Model_User->loadByUsername(’dfssad’)
#7 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/User.php(180): Mage_Admin_Model_User->authenticate(’dfssad’, ‘ddddddddddddddd...’)
#8 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/Session.php(42): Mage_Admin_Model_User->login(’dfssad’, ‘ddddddddddddddd...’)
#9 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Admin/Model/Observer.php(43): Mage_Admin_Model_Session->login(’dfssad’, ‘ddddddddddddddd...’, Object(Mage_Core_Controller_Request_Http))
#10 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Model/App.php(1032): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer))
#11 /home/procabgr/public_html/uhlmannshopup/app/Mage.php(278): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#12 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Action.php(377): Mage::dispatchEvent(’controller_acti...’, Array)
#13 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Adminhtml/Controller/Action.php(116): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Action.php(335): Mage_Adminhtml_Controller_Action->preDispatch()
#15 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(148): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#16 /home/procabgr/public_html/uhlmannshopup/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#17 /home/procabgr/public_html/uhlmannshopup/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#18 /home/procabgr/public_html/uhlmannshopup/index.php(40): Mage::run()
#19 {main}

I have the same problem roshangmail, I change the pdo_mysql on config.xml and install.xml for mysqli and now show me that error!!

you resolve roshangmail??? I cant log in, same error!!!!! :( please let me know if you resolve, thanks a lot.

It seems that you can’t install Magento with FastCGI, turn to CGI, install, then you can turn to FastCGI again if you like, it seems to work fine after installation.

I am using a shared server and cannot access my php.ini I was told…

“After checking with our administrator, he says he cannot activate the ‘pdo_mysql’ extension in the php.ini file because it may break other clients applications. Therefore, see if you can find out how this can be done through .htaccess”

is this possible here is my phpinfo
http://brentsfiles.com/phpinfo.php
Magento Check:
http://brentsfiles.com/store/magento/magento-check.php

Please help i really want to use your software.

~Brent