Magento

hey guys what about a short guide for xampp?

i see i’m not the only one who has got problems to set of xampp in the right way.

could anyone give a short xampp preparing guide?

i’ve already found:

apache\bin\php.ini
uncomment: ;extension=php_mcrypt.dll

apache\conf\httpd.conf
uncomment: #LoadModule rewrite_module modules/mod_rewrite.so

I agree! want to test offline with xampplite but cant�t get it working :(

if you plan to install a local test web server on your own computer, then you should probably figure out its basic operations first (like how to turn on mod_rewrite, mcrypt etc). these requirements are already mentioned in order to run magento. xampp issues should be followed up on the xampp forums.

that being said, if there are any specific changes that one would have to perform on the web server for magento then that would be appropriate to list. otherwise, read a tutorial or faq about xampp or something..

I figured it out by myself. And hey iblastoff ...calm down

well we can help a bit here as well,

for you Phil, ensure hat you also are commenting out the extension=php_mcrypt.dll thats in php\php.ini

For xampplite

1. Do this

apache\bin\php.ini
decomment: ;extension=php_mcrypt.dll

apache\conf\httpd.conf
decomment: #LoadModule rewrite_module modules/mod_rewrite.so

2. replace the php_pdo_mysql.dll which frenchtoast posted here:

http://www.magentocommerce.com/boards/viewreply/131/

3. for secure hosting settings use the following

Protocol : http
Port : 80

all schould be fine

Uncommenting out those three got me further with xampp, but after stating all the config stuff, I press next and it gets this error (now anytime I go to http://localhost/magento, it goes to this page as well)...Note: I set the secure connection to http port 80 if that matters:

PDOException Object
(
[message:protected] => SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.  Consider using PDOStatement::fetchAll().  Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
[string:private] =>
[code:protected] => HY000
[file:protected] => C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 82
[trace:private] => Array
(
[0] => Array
(
[file] => C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 82
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[1] => Array
(
[file] => C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 113
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[2] => Array
(
[file] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 408
[function] => multi_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[3] => Array
(
[file] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.php
[line] => 39
[function] => run
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] =>
-- --------------------------------------------------------

--
-- Table structure for table `core_resource`
--

DROP TABLE IF EXISTS `core_resource`;
CREATE TABLE `core_resource` (
`code` varchar(50) NOT NULL default ‘’,
`version` varchar(50) NOT NULL default ‘’,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Resource version registry’;

)

)

[4] => Array
(
[file] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 223
[args] => Array
(
[0] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.6.0.php
)

[function] => include
)

[5] => Array
(
[file] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 121
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => install
[1] =>
[2] => 0.6.5
)

)

[6] => Array
(
[file] => C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Resource\Setup.php
[line] => 108
[function] => _installResourceDb

for that go to step 2. I posted

best regards

NOD

nod74 - 01 September 2007 09:56 AM

for that go to step 2. I posted

best regards

NOD

I did that, getting the same errors still.  I replaced the dll in the php\ext folder.  Any other ideas?

restart xampp + clear browsercache

nod74 - 01 September 2007 10:01 AM

restart xampp + clear browsercache

Still the same deal (I did restart xampp before), even used IE (was using FF previously) to ensure cache was clean.

setup the wiki using all solutions from these forums:

http://www.magentocommerce.com/wiki/Installing-on-Windows-with-XAMPP-and-WAMP/

I tested it and it works for me, if i missed anything or wrote something too much feel free to update it.
Thx
Chris Mc(kooter)