Magento Installation Guide
Installation
- Please refer to Magento's system requirements to ensure you have the appropriate platform and environment set up. If you attempted to install Magento and the installation wizard suggested to use the PHP-CGI workaround, please click here.
- Download the .zip or .tar.gz file from the Magento website and decompress it.
- Upload the Magento web files to your web server via FTP (if you have SSH access and are comfortable with the command line, check out this wiki post)
- Create a MySQL database and user/password for Magento This step varies by hosting provider and is out of the scope of this document. Consult your provider's support/documentation for instructions on how to do this.
- Ensure that the file magento/var/.htaccess, the directories magento/app/etc, magento/var, and all the directories under magento/media are writable by the web server. To do so, navigate to the directory with your FTP client. Then locate the function "Change Permissions" or "Change Mode" in your FTP client and select it. Once you find the function, you must set the permissions so the web server can write to this file. There are two typical ways of representing file permissions in Linux:
- As a number (eg, 755)
- As a series of permissions categorized into user, group, and other
- Use your web browser to surf to the Magento installation wizard. If you've uploaded the Magento files to http://www.example.com/magento/, then the wizard will be located here: http://www.example.com/magento/install/.
- Once in the wizard, you can configure various system-level settings that are required for Magento to function. Most options will be intelligently guessed for you, but you're free to override any settings that don't look right. At the very least, change the database parameters in the first box “Database connection” to match those of the database you set up in Step 3.
- Success! You've completed a basic Magento install. You can now visit the administration backend and begin configuring your new online store.
- UPDATE: If you have installed Version 1.0.19700, you should follow the instructions to install the patch which fixes a known issue with the compare products feature.
- ** IMPORTANT: Catalog price rules and many other features in Magento require periodical execution of scheduled task. Please refer to this article for information on cronjob setup: http://www.magentocommerce.com/wiki/how_to_setup_a_cron_job
If your FTP client uses the first representation, set the permissions on each directory to be 777, or 0777. If your FTP client uses the second representation, set the permissions as shown in the image below. http://www.magentocommerce.com/wiki/magento_filesystem_permissions
Known Issues
Magento was developed on Linux and as such, it is most tested on this platform. Here are some known issues that may result from the use of other operating systems.
- Under Windows, image uploads do not work at this time. As a result, an administrator will not be able to upload product images.
UPDATE: Please use the Magento Install / Setup Forum to report and discuss installation issues.





1RoyRubin from Los Angeles, CA|posted August 31 2007
If you have access to SSH, you can use the following commands to change permissions prior to installing (and after extracting the files)
cd magento
chmod o+w var var/.htaccess app/etc
chmod -R o+w media
2Emperor |posted August 31 2007
There is no install directory in the zip file.
How will I then be able to install the system?
Please, I need help on this.
3Moshe from Varien|posted August 31 2007
You don’t need the directory, just point your browser to http://example.com/ and it will redirect you to the right place
Also, there’s a guide available at
http://www.magentocommerce.com/knowledge-base/entry/magento-installation-guide
4Emperor |posted August 31 2007
I did just that and a NOT FOUND error page came up, saying that the url /magento/install was not found on the server.
5Magento Core from Los Angeles, CA|posted August 31 2007
Do you use apache and .htaccess is enabled?
6deluse |posted August 31 2007
I am using windows xp pro myself and extracted the magnetto under my www folder and the closest install file i see is in magento\app\code\core\Mage\Install\Model
and it will not see it that deep ? i am using Apache/2.2.4 (Win32)
PHP Version 5.2.3
MySQL client version: 5.0.37
running from Wamp 5
Maybe there is something simple i am missing or need to just put a certain folder from the magneto.zip in the root ?
Any help would be great thx
7Emperor |posted August 31 2007
Yes. I am currently changing the settings to enable .htaccess. It’s not working yet though but I think that’s the reason.
If you can give me some help concerning enabling .htaccess that would be great.
8Moshe from Los Angeles|posted August 31 2007
@deluse: you don’t need to run files, just point the browser to your site’s location after unzipping the files
9deluse |posted August 31 2007
all i get is this..
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error.
should i make a thread in forums i guess
10Moshe from Los Angeles|posted August 31 2007
Deluse: it might be you do not have mod_rewrite installed in apache
11Kyle from Scottsdale, AZ|posted August 31 2007
Have the same problem…
it redirects to /install and I get a 404 saying /dev/magento/install does not exist… i extracted from the tar
I have php 5.2 or newer
Apache 2.2.4
Rewrites are enabled
.htaccess are enabled
12deck1 |posted August 31 2007
@deluse: magento is developed under MVC paradigm, the install directory in the URL is not a physical directory under your filesystem.
13smoove |posted August 31 2007
Hey there,
while installing i get this errormessage:
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.
System:
WinXp
Apache2
Php 5.2.3 <- Pdo is enabled
mysql: 5.0.45-community-nt
any ideas?
14Allande |posted August 31 2007
I am on Wamp5, i installed mod_rewrite and php pdo_mysql and mcrypt…
but i have this message :
“http://localhost:80/magento/” is not accessible
Why :80 in url ?
15smoove |posted August 31 2007
does the folder magento/ exist in your server root?
:80 is the default http port, does your server listen on port 80? port 8080 is also common?!
16mweather |posted August 31 2007
:80 is the default port for httpd. I doubt that’s the cause of the site being inaccessible. Check your permissions. I’m not sure how to do that on Windows, though.
17smoove |posted August 31 2007
Windows does not have a filepermission system like unix/linux (Chmod)
18mweather |posted August 31 2007
It’s not like Unix, but there are file permissions. At least on Sever 2003 there are. Not sure about XP as I’ve never run apache there. I think you need to right click the file and select the security tab.
19Emperor |posted August 31 2007
I my mod_rewrite working on winxp.
I read the following article:
http://www.webmasterworld.com/forum92/2593.htm
I also had to uncomment the mod_rewrite module as well.
One thing about the article. I had to remove the .txt from the htaccess file in the apache config file that they said should be included.
20mweather |posted August 31 2007
Yep, on 2003 you right click and select security. I just confirmed it on my domain controller. Here is how to do it in XP: http://support.microsoft.com/kb/308421
Apparently you have to disable simple file sharing or join a domain to get the security tab to pop up.
21pofroad |posted August 31 2007
I do have the problem also : install directory not found ... my mod_rewrite is enabled.
22Timothy |posted August 31 2007
@smoove
Apparently that is caused by a bug in PHP and lack of support for stored procedures on Windows machines. I found a workaround here: http://bugs.php.net/bug.php?id=39858
It is just a hack and probably shouldn’t be used in a production environment. Then again this is just a beta release so maybe the good folks at Varien can come up with a better workaround.
23smoove |posted August 31 2007
@mweather: Never used Win Sever 2003, didn’t know it supports filepermissions, thx for the info.
@Timothy:
Thank you, that worked for me!
All you have to do is replace your php_pdo_mysql.dll (in php/ext/) with this one:
http://source.hackthissite.org/wsvn/HTSv4/trunk/PDO/php_pdo_mysql.dll
24Kyle from Scottsdale, AZ|posted August 31 2007
for everyone having the problem with “install directory not found” it is an .htaccess problem
you need to make sure (as i thought it was already setup) that if you are virtually hosted that you are able to use .htaccess files, as i was not… my buddy had to turn on htaccess use for my domain, now everything works, oh i also had to install mcrypt, but it’s working and i must admit, this software is amazing, not only to use but to look at, it’s so much better even in it’s beta phase than Zen, Cube, osC… amazing work from the people at Varien, congrats
25Emperor |posted August 31 2007
I also had to disable simple file sharing as well. Sorry that I left that out and give full write permissions to the directory.
26pofroad |posted August 31 2007
Kyle, how did you made sure that you are able to use .htaccess files ? Thanks for this point !
27Ahler |posted August 31 2007
Someone here where Magento works under XAMPP?
I think it was nice to test the features on local system before it goes public.
28james |posted August 31 2007
my server works with zend framework.
so i know for sure it has everything needed such as .htaccess modrewrite etc…
but how come i’m getting 404 not found error?
does magento come with the correct .htaccess file needed by zend framework’s mvc paradigm?
29zfdaily |posted August 31 2007
i found the reason why it didn’t work!
apparently, i think the zip file does not contain the .htaccess file.... where the .tar file does!!
30Scott from Northwest Ohio|posted August 31 2007
To speed up installation time:
upload the tar.gz file directly to your server and use SSH to browse to that directory and un-tar it:
cd /path/to/magento.tar.gz
tar -xzvf magento.tar.gz
Beats uploading all the files individually via FTP and helps ensure original directory structure and consistency.
31Helder |posted September 1 2007
Just after define database in the install wizard, i got this error:
Fatal error: Call to a member function children() on a non-object in C:\magento\app\code\core\Mage\Core\Model\Config.php on line 655
any idea??
thanks!
32dmitry |posted September 1 2007
For everyone having the problem with install directory not found and using XAMPP on a Mac OSX, you have to enable .htaccess support by editing httpd.conf file in /Applications/xampp/etc/httpd.conf:
Change:
AllowOverride AuthConfig
to
AllowOverride All
inside
<Directory “/Applications/xampp/xamppfiles/htdocs">
</Directory>
and restart the XAM
33Paryank Kansara |posted September 1 2007
Hi, I am trying to install Magento on Windows Server 2003 with PHP 5.2.1 and Apache Apache/2.2.4 with rewrite_mod enabled.
As it not a live web server, there is no SSL connection available. So I am giving Secure Protocol as http and port 80 during installation. I am giving correct database name, and authentication details too. I have also set the write permissions to Magento Directory. After second step of installation it throws exception like below:
exception ‘Mage_Core_Exception’ with message ‘Error in file: “C:\www\magento\app\code\core\Mage\Core\sql\core_setup\mysql4-upgrade-0.6.1-0.6.2.sql” - SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in C:\www\magento\app\Mage.php:288
Can anybody help me???
34Nic from Dallas, Texas|posted September 1 2007
Can’t seem to get pdo_mysql loaded on my server. Is there a work around? Or is this a road black i can surpass???
35Jens Holze from Germany|posted September 1 2007
Not Found
The requested URL /magento/install/ was not found on this server.
so when i looked into the magento folder, i cant locate a folder like install.
Can you help me!
Jens.
p.s. great software.
36Moshe |posted September 2 2007
hey, i really like the big thing you are doing in here, but my problem is that my server got an old PHP (4.4) and i can’t install the system after 5 very long hours of uploading. the system tells me something about trying to install with “PHP-CGI”, i’ve got no idea what that means. can someone help me with that?
37Craig Smith from Pennsylvania|posted September 2 2007
Getting this error on install and it seems Im not alone.
--------------------------------------------------------------
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
--------------------------------------------------------
I am newbie who tries to troubleshoot my way through these type of installs. Any help would REALLY be appreciated since their is not much documentation obviously.
Is this an .htaccess problem? It didnt match the earlier description and also I host with GoDaddy and I think it is on with them (I used it in an OSCommerce build).
Any other ideas? Thanks and I cant wait to test the product!
38RoyRubin from Los Angeles, CA|posted September 2 2007
Guys - If you have an install issue, I highly recommend you post in the forum. You are more likely to get help and a quicker response.
39Richard F |posted September 2 2007
I don’t get it- I have downloaded Magento, unzipped it and uploaded all files to my server, changed the permissions on the files mentione din the instructions, but I get this error message:
Not Found
The requested URL /install/ was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
I see no Install folder in the contents of the Magento Zip file.
What am I missing?
40cooee from Aachen, Germany|posted September 2 2007
Just wanted to say that on my system (Debian Etch 2.6.21-2-686, Apache/2.2.4, PHP Version 5.2.3-1+b1, MySQL 5.0.45) installation worked without any problems at all.
I just had to add this to my apache2 configuration to make the .htaccess work:
<Directory “/var/www/magento">
AllowOverride All
</Directory>
The only thing that bugged me during installation was the fact that I had to alter directory rights, then click “continue”, then I was presented some more “directory not writable"-errors, altered directory rights again, got some more errors etc. Here it would be nice to have one list of things to change rather than bits and pieces.
41austinstorm from Moscow, ID|posted September 2 2007
You just have to change everything under those directories, as well. I just switched from Filezilla to SmartFTP temporarily so that I could check a button that would alter permissions recursively.
42Tobz |posted September 2 2007
I’ve been having the same problem as everyone else.
I changed the .htaccess rewrite rules to:
RewriteEngine on
RewriteCond $1 !^(index\.php|media|skin|js|robots\.txt)
RewriteRule ^(.*)$ /magento/index.php/$1 [L]
seems to be working now
43Tobz |posted September 2 2007
But now im having the PDO errors.
anyone sorted out that problem?
44fhornain from Brussels - Belgium - E.U.|posted September 3 2007
Dear *,
Well, for those of you who have the following problem :
-> You browser is saying that the url /magento/install was NOT FOUND on the server.
You have to set the AllowOverride Option from None to All in your /etc/httpd/conf/httpd.conf
apache config file as shown below.
Rem: Do not know where is put the Apache configuration file for M$ Windows platform but the file name should be the same httpd.conf. So just do a search on you system.
#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be “All”, “None”, or any combination of the keywords:
# Options FileInfo AuthConfig Limit
#
# AllowOverride None
AllowOverride All
BTW, do not forget to restart you deamon - service for M$ Windows users -.
One thing again, I do not really know what kind of impact this option have when it is changed so I would not recommand to do that execice on production machine.
if you have any comment feel free to contact me or add a message in that forum.
BR
Fred
45Tobz |posted September 4 2007
Hi guys,
for people having install problems.
I found the default .htaccess rewrite rules were causing a server error (500), so I changed them to the same syntax that CodeIgniter uses:
RewriteEngine on
RewriteCond $1 !^(index\.php|media|skin|js|robots\.txt)
RewriteRule ^(.*)$ /magento/index.php/$1 [L]
I found this fixed the problem.
[win64x, apache 2.2.4, php5.2.3, mysql5.0.45]
Cheers,
Tobz
also there is a php_pdo_mysql.dll link floating around that fixed the pdo errors for me too.
46iPhony |posted September 5 2007
Thanks Tobz,
You suggestion helped me getting to the install screen. I used a shared hosting plan with 1and1.
However I also had to comment out the line for magic_quotes_gpc from my .htaccess file for it to work. Otherwise I was getting Internal Server Error
#php_flag magic_quotes_gpc off
I checked the server setting and this flag is ON by default. Can someone advice wether magento could work without this line?
47sid |posted September 16 2007
Tobz,
You’re my star, it’s work nice now !! i see install page, this is beautiful
)
48lukasz |posted September 20 2007
I am trying to install Magento on a Mac using MAMP pro. I followed all the steps and i still get
----------
Not Found
The requested URL /install/ was not found on this server.
----------
49Tobz |posted September 20 2007
make sure you have mod_rewrite in your apache build (im not sure if it comes compiled into osx, it probably does) and make sure your rewrite rule is the correct path to your index.php.
check your error logs should help find what file is trying to load.
50lukasz |posted September 20 2007
I am trying to install Magento on a Mac using MAMP pro. I followed all the steps and i still get
----------
Not Found
The requested URL /install/ was not found on this server.
----------
I got this this resolved. First when placing files into htdocs unzip Magento and keep /magento/ folder in your directory don’t move the files out of the folder and run your site in magento unzipped folder. I guess when i moved files outside of the folder something got screwed up.
Next upgrade MAMP Pro to a 1.7 version or higher, because it you will need Mcrypt in order to install.
This should work.
51jhloke |posted September 22 2007
I encounter “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.” error when I tried to install Magento by accessing /magento/install/, what should I do?
52jled |posted October 8 2007
I tried installing but after some battle and finally getting the install to show properly I am now getting this error during install “PHP Extension “pdo_mysql” must be loaded”
Is there any work around to this? I contacted my hosting and they said the only way they could install this module would be for me to move to a dedicated server so I am hoping there’s another way than having to add the module to the entire server. Maybe there’s something similar to the php5-cgi workaround?
53harwood |posted October 11 2007
"Not Found
The requested URL /install/ was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
“
I have installed as per the instructions above and I am getting the same error as everyone else. As I am using site5 hosting and have added the fix mentioned for handling php5, I am guessing this is something to do with the script or the webserver not understanding the /install/ request.
I installed from ssh and moved the files from the magento folder up one directory into the root webserver directory.
But as the index.php is calling the /install/ from app/Mage.php I know that the php is working.
Am I doing something stupid?
54baseev |posted October 13 2007
Iam getting the same error !!!
Can any one help me out ..
55Moshe from Los Angeles|posted October 13 2007
@harwood, @baseev: make sure you have .htaccess in /magento folder and apache is configured to allow overrides. Also, please post requests for assistance in forums, as it is much easier to truck it there. Thanks
56Moshe from Los Angeles|posted October 13 2007
err sleepy fingerz, should be “track”
57Butterstulle |posted October 15 2007
Hy!
If got a problem while running the install procedure. There is a Bug on creating the Database structure i think.
[Strict Notice: strtotime() [function.strtotime]: It is not safe to rely on the system’s timezone settings.]
There are some more troubles while running the setup:
#0 /www/htdocs/v030410/testshop/app/code/core/Mage/Core/Model/Translate.php(291): Mage::throwException(’You need init t...’)
#1 /www/htdocs/v030410/testshop/app/code/core/Mage/Core/Model/Translate.php(356): Mage_Core_Model_Translate->getData()
#2 /www/htdocs/v030410/testshop/app/code/core/Mage/Core/functions.php(47): Mage_Core_Model_Translate->translate(Array)
#3 /www/htdocs/v030410/testshop/app/code/core/Mage/Core/Model/Resource/Setup.php(242): __(’Error in file: ...’, ‘/www/htdocs/v03...’, ‘SQLSTATE[42000]...’)
#4 /www/htdocs/xxxxxx/testshop/app/code/core/Mage/Core/Model/Resource/Setup.php(121): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.3.0’)
#5 /www/htdocs/xxxxxx/testshop/app/code/core/Mage/Core/Model/Resource/Setup.php(108): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.3.0’)
#6 /www/htdocs/xxxxxx/testshop/app/code/core/Mage/Core/Model/Resource/Setup.php(82): Mage_Core_Model_Resource_Setup->applyUpdates()
#7 /www/htdocs/xxxxxx/testshop/app/code/core/Mage/Core/Model/Config.php(151): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#8 /www/htdocs/xxxxxx/testshop/app/Mage.php(326): Mage_Core_Model_Config->init(NULL)
#9 /www/htdocs/xxxxxx/testshop/app/Mage.php(349): Mage::init(NULL)
#10 /www/htdocs/v030410/testshop/index.php(27): Mage::run(’base’)
#11 {main}
What i have missed to do, or what can i do get rid of this problems?
Thank you very much.
Greets
58vampirius |posted October 18 2007
hello
y am interested of magneto installation for prove shop italian
help me
thanks
59baseev |posted October 19 2007
Hi all,
Thanks for the help !!.
I have done it on Linux with xampp installed ( u will get more info from : http://www.apachefriends.org/en/xampp-linux.html#385 )
after the xampp installation just de-compress your .tar file into the htdocs directory, and open the url http://localhost/magento
the browser will guide you through the installation steps !!! Simple
May be u need to increase the memory size in php.ini if you get some error like :
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 196606 bytes)
I think this info may help you to sort out installation problem on Linux.
Regards,
Baseev.
60ctmanic |posted November 5 2007
During install I get:
One from PHP Extensions “0,1” must be loaded
yikes, haven’t even seen it on forums anywhere!
also, I ddi have to chaneg the pdo_mysql to mysqli hack as well.
any thoughts?
61Mr Chris |posted November 6 2007
There is NO install directory in the magento-0.6.13160.zip download, thus can’t install.
I run Cubecart and OScommerce on my local machine, have all correct Apache, PHP, MySQL, database installed on my local machine ( I use a Intel Based Mac) but all i get when i try to start Magento is the 404 error .. . . . .
Not Found
The requested URL /~mysite/magento/install/ was not found on this server.
which is correct because there is NO install directory in the Magento folder.
Please help.
62Michael |posted November 7 2007
Hi Mr Chris,
You have to have mod_rewrite to get it work. Please make sure that mod_rewrite is enabled.
63Michael |posted November 7 2007
You can also check this - http://www.magentocommerce.com/boards/viewreply/6298/ - to learn how to verify that mod_rewrite is enabled.
64anada |posted November 7 2007
you kidding me and waste of my time!
Not Found
The requested URL /magento/install/ was not found on this server.
65harwood |posted November 7 2007
anada,
Magento uses mod_rewrite to create the /install/ path in the url. There is NO install folder. If you do not know what mod_rewrite is then you need to speak to the person or company that operates your server to install it.
Michael’s forum link is also useful if you want to check yourself.
(note to coders)
Perhaps for the ease of installation it would be sensible to create an install folder, which can be deleted later on. This is common practice for a lot on apps, people understand it. Or, perhaps an explanation inserted into the text above as to why an /install/ folder is not used would stop comments like anada’s.
Thanks
Paul
66SonicE from Bulgaria|posted November 8 2007
I am new to magento but i solved this issue (The requested URL /magento/install/ was not found on this server) with enablin override option in http.conf file of my apache server.
Search for
AllowOverride
Set to
AllowOverride All
I hope this helps
Cheers
67rivella |posted November 14 2007
Does someone got a solution for lighttpd (lighty)??
68FreshReg |posted November 18 2007
I would like to try it on my LOCAL WAMP5 SERVER. I tried to open it but the am not getting any INSTALL PAGE ( like i always get it in OSCOMMERCE & JOOMLA )
Is there any one who can help me with it. Thanks in advance.
69ptityop |posted November 21 2007
Hi! My host has PHP5 installed but it does not seem to be recognized by magento.. looking at the help guides on my hosting web site it is said somewhere that in order to change the php version , I need to create an .htaccess file and write SetEnv PHP_VER 5… I did add this line and now get a 404 error type..could anyone help please? many thanks..
70Michael |posted November 28 2007
Hi ptityop,
Did the http://www.magentocommerce.com/boards/viewthread/1674/ thread help you to install Magento ? Was the problem solved ?
71UKImportDirect |posted November 29 2007
Ive done everything it says here but still get this messege
Whoops, it looks like you have an invalid PHP version.
Magento supports PHP 5.2.0 or newer. Find out how to install Magento using PHP-CGI as a work-around.
Ive followed it and it doesnt work still im using Hostgator on the swamp plan
Can anyone help me the address is http://www.ukimportdirect.com
72Pixx |posted November 29 2007
Can’t get past the configuration page - it just keeps returning to that page ... no errors or warnings. All fields remain filled in except the database password field (I am using the correct db pass).
Anyone have any ideas what might be causing that?
73Mangavod |posted December 3 2007
well, every thing was fine, until that at http://www.mydomain.com/magento/install/wizard/configPost/
And my website is now down :(
Zend_Db_Statement_Mysqli_Exception Object
(
[message:protected] => Mysqli statement execute error : Incorrect arguments to mysql_stmt_execute
....
the rest of the message removed by Michael
74Michael |posted December 3 2007
Hi Mangavod,
Please take care of removing all your private info (especially passwords) when posting error text messages.
75hotdiggity |posted December 5 2007
Can’t get past the Configuration screen with these warnings:
o PHP Extension “mcrypt” must be loaded
o PHP Extension “curl” must be loaded
My info,php page indicates they are both enabled.
mycrpt 2.4.x
libcurl/7.17.1 OpenSSL/0.9.7a zlib/1.2.1.2
Running on Linux:
Apache/1.3.37
MySQL 4.1.22
PHP 5.2
76Michael |posted December 5 2007
Hi hot diggity,
Could you PM me the link to your magento installation and phpinfo.php file placed under it’s folder ?
Thank you.
77hotdiggity |posted December 6 2007
My host tells me it’s because the standard install of php 5 doesn’t contain curl or mcrpyt. It’s available for php4 which is what my info.php file was seeing on the root directory. I’ve had to enable php 5 via .htaccess within the directory Magento is installed in, so no curl or mcrypt. Bit restrictive…
78Mehul from AHMEDABAD, GUJARAT, INDIA|posted December 6 2007
How to upgrade from 0.6.137 to 0.6.140.
Do we need to follow as the fresh installation or any other way from upgradation.
thanks.
79astral |posted December 6 2007
Hi Micheal,
Its 8th night straight. I am unable to install Magento sucessfully. I always get:
Zend_Db_Adapter_Mysqli_Exception Object
(
[_chainedException:protected] =>
[message:protected] => Level2:Commands out of sync; you can’t run this command now
[string:private] =>
[code:protected] => 0
[file:protected] => /home/nilgiris/public_html/stores/lib/Varien/Db/Adapter/Mysqli.php
[line:protected] => 154
[trace:private] => Array
(
..................
store is located at https://nilgiris.net/stores/
phpinfo is located at http://www.os2india.com/phpinfo.php
Please advise.
Thank you,
Astral
80hotdiggity |posted December 6 2007
Hi Michael,
Have successfully installed php5-cgi so no problems with curl or mcrypt.
Thanks
81Michael |posted December 6 2007
Hi Mehul,
There were no major issues on upgrading Magento from 0.6.13700 to 0.6.14100 reported yet. For sure you have to backup all your data first. Read http://www.magentocommerce.com/knowledge-base/entry/how-to-upgrade-magento-to-a-newer-preview-version KB article for details.
Thank you.
82Mangavod |posted December 15 2007
Hi,
I just want to install the new 0.6.14100 version. I try over and over and i’ve got always this error, like one week ago...and no solutions ?
Any ideas ?
_______________
Zend_Db_Statement_Mysqli_Exception Object
(
[message:protected] => Mysqli statement execute error : Duplicate entry ‘general/locale’ for key 2
[string:private] =>
[code:protected] => 0
[file:protected] => /home/cybercom/public_html/magento/lib/Zend/Db/Statement/Mysqli.php
[line:protected] => 251
[trace:private] => Array
(
[0] => Array
(
[file] => /home/cybercom/public_html/magento/lib/Zend/Db/Statement.php
[line] => 279
[function] => _execute
[class] => Zend_Db_Statement_Mysqli
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/cybercom/public_html/magento/lib/Zend/Db/Adapter/Abstract.php
[line] => 396
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 373
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => update core_config_field set level=2, path=’general/locale’, frontend_label=’Locale options’ where field_id=673
)
)
[3] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 396
[function] => updateTableRow
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => core/config_field
[1] => field_id
[2] => 673
[3] => Array
(
[level] => 2
[path] => general/locale
[frontend_label] => Locale options
)
)
)
[4] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/sql/core_setup/mysql4-upgrade-0.6.1-0.6.2.php
[line] => 21
[function] => addConfigField
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => general/locale
[1] => Locale options
)
)
[5] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[args] => Array
(
[0] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/sql/core_setup/mysql4-upgrade-0.6.1-0.6.2.php
)
[function] => include
)
[6] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 145
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 0.6.1
[2] => 0.6.26
)
)
[7] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 111
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 0.6.1
[1] => 0.6.26
)
)
[8] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 94
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[9] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Config.php
[line] => 135
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[10] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Install/Model/Installer/Config.php
[line] => 75
[function] => init
[class] => Mage_Core_Model_Config
[type] => ->
[args] => Array
(
)
)
[11] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Install/Model/Installer.php
[line] => 83
[function] => install
[class] => Mage_Install_Model_Installer_Config
[type] => ->
[args] => Array
(
)
)
[12] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Install/controllers/WizardController.php
[line] => 208
[function] => installConfig
[class] => Mage_Install_Model_Installer
[type] => ->
[args] => Array
(
[0] => Array
(
[db_host] => localhost
[db_name] => magento
[db_user] => xxx
[db_pass] => xxx
[host] => http://www.xxx.com
[base_path] => /magento/
[protocol] => http
[port] => 80
[secure_host] => http://www.xxx.com
[secure_base_path] => /magento/
[secure_protocol] => http
[secure_port] => 80
)
)
)
[13] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php
[line] => 325
[function] => configPostAction
[class] => Mage_Install_WizardController
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php
[line] => 149
[function] => dispatch
[class] => Mage_Core_Controller_Varien_Action
[type] => ->
[args] => Array
(
[0] => configPost
)
)
[15] => Array
(
[file] => /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php
[line] => 166
[function] => match
[class] => Mage_Core_Controller_Varien_Router_Standard
[type] => ->
[args] => Array
(
[0] => Zend_Controller_Request_Http Object
(
[_requestUri:protected] => /magento/install/wizard/configPost/
[_baseUrl:protected] => /magento
[_basePath:protected] =>
[_pathInfo:protected] => /install/wizard/configPost/
[_params:protected] => Array
(
)
[_aliases:protected] => Array
(
)
[_dispatched:protected] => 1
[_module:protected] => install
[_moduleKey:protected] => module
[_controller:protected] => wizard
[_controllerKey:protected] => controller
[_action:protected] => configPost
[_actionKey:protected] => action
)
)
)
[16] => Array
(
[file] => /home/cybercom/public_html/magento/app/Mage.php
[line] => 382
[function] => dispatch
[class] => Mage_Core_Controller_Varien_Front
[type] => ->
[args] => Array
(
)
)
[17] => Array
(
[file] => /home/cybercom/public_html/magento/index.php
[line] => 29
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] => base
)
)
)
)
exception ‘Zend_Controller_Response_Exception’ with message ‘Cannot send headers; headers already sent in
/home/cybercom/public_html/magento/app/code/core/Mage/Core/Model/Resource/Setup.php, line 253’ in
/home/cybercom/public_html/magento/lib/Zend/Controller/Response/Abstract.php:265
Stack trace:
#0 /home/cybercom/public_html/magento/lib/Zend/Controller/Response/Abstract.php(131): Zend_Controller_Response_Abstract->canSendHeaders(true)
#1 /home/cybercom/public_html/magento/app/code/core/Mage/Install/controllers/WizardController.php(216): Zend_Controller_Response_Abstract-
>setRedirect(’http://www.cybe...’)
#2 /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(325): Mage_Install_WizardController->configPostAction()
#3 /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(149): Mage_Core_Controller_Varien_Action-
>dispatch(’configPost’)
#4 /home/cybercom/public_html/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(166): Mage_Core_Controller_Varien_Router_Standard->match
(Object(Zend_Controller_Request_Http))
#5 /home/cybercom/public_html/magento/app/Mage.php(382): Mage_Core_Controller_Varien_Front->dispatch()
#6 /home/cybercom/public_html/magento/index.php(29): Mage::run(’base’)
#7 {main}
83TexanJim from Nottingham, UK|posted December 16 2007
Just thought I’d note my experiences installing Magento on OS X server 10.4.9, (for local testing).
I updated the default PHP 4 module to PHP 5 by using Marc Liyanage’s package found here:
http://www.entropy.ch/software/macosx/php/
I then had the 404 error that seems to be a common issue, although none of the edits above resolved it. My specific solution was to edit the httpd.conf file at /private/etc/httpd/httpd.conf and duplicate the following section:
<Directory “/">
Options FollowSymLinks
AllowOverride All
</Directory>
and create a new block like so:
<Directory “/Library/WebServer/Documents/magento">
Options FollowSymLinks
AllowOverride All
</Directory>
The installation wizard then worked as planned.
The only other thing to note was that during installation, the database address needed to be 127.0.0.1 and not localhost, as this raised and error. (I had also made this edit suggested by Marc: http://www.entropy.ch/phpbb2/viewtopic.php?p=9499#9499)
I hope that this is of help to someone.
84magneto |posted December 17 2007
Hello,
I’m confused of which magento version should I download ?
Full version or not full ? What’s the different between those two ?
thanks
85YoavKutner |posted December 17 2007
@magento-The full version contains sample products. The code base is the same in both the light and full versions.
Thanks yoav
86Michael |posted December 17 2007
Hello,
The only difference is that full package contains sample data (products, categories, product images, customer reviews and ratings, product tags, etc).
87magneto |posted December 17 2007
wow, it tooks over 40MB only for sample data?
88Tarun Agarwal from Jodhpur- India|posted December 20 2007
hii, i have older version of php i.e. 4.4.0 ...can i still use it some other way. ??
89Michael |posted December 20 2007
Hi Tarun,
Yes, you can. Check the Installing Magento on a PHP4 server Knowledge Base for details - http://www.magentocommerce.com/knowledge-base/entry/installing-magento-on-a-php4-server/
Thank you.
90Tarun Agarwal from Jodhpur- India|posted December 20 2007
Hello Michael,
Thanks for guiding me.
Best Regards,
Tarun
91Synchro |posted December 21 2007
For those getting file not found errors, an alternative to the rather loose “AllowOverride All” is to simply set the RewriteBase in the .htaccess.
The .htaccess is expecting your install to be the top level of your domain, not in a sub-folder. So if you have installed it in http://www.example.com/magento/, the .htaccess should contain:
RewriteBase /magento/
Without this, magento will be looking in /var/www/www.example.com/install/ instead of /var/www/www.example.com/magento/install/
92Mangavod |posted December 23 2007
Hi,
I’ve got this error :
Mysqli statement execute error : Incorrect arguments to mysql_stmt_execute
Any ideas ?
93Mangavod |posted December 23 2007
Here is the solution about the mysql error :
just download and install the new config.xml from http://www.magentocommerce.com/boards/viewthread/1903
94sunmedia |posted December 26 2007
Hello
I am currently install magento on my site, but the browser show this error:
Warning: include_once(Mage/Core/functions.php) [function.include-once]: failed to open stream: No such file or directory in /home/sunmedia/public_html/testnewsite/magento/app/Mage.php on line 40
Warning: include_once() [function.include]: Failed opening ‘Mage/Core/functions.php’ for inclusion (include_path=’.:/usr/lib/php:/usr/local/lib/php:/home/sunmedia/public_html/testnewsite/magento/lib:/home/sunmedia/public_html/testnewsite/magento/app/code/core:/home/sunmedia/public_html/testnewsite/magento/app/code/local:/home/sunmedia/public_html/testnewsite/magento/app/code/community’) in /home/sunmedia/public_html/testnewsite/magento/app/Mage.php on line 40
Fatal error: Call to undefined function checkmagicquotes() in /home/sunmedia/public_html/testnewsite/magento/app/Mage.php on line 48
I hope that this is of help to someone.
95hassanqureshi from Karachi-Pakistan|posted December 31 2007
Friends, i am facing this error after login in admin section
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 393216 bytes) in C:\wamp\www\magento\lib\Zend\Date.php on line 1072
and following error in front end mode:
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 24576 bytes) in C:\wamp\www\magento\app\code\core\Mage\Eav\Model\Entity\Abstract.php on line 580
Please help me to resolve it
I am using windows XP sp2- Wamp5 Version 1.7.2
96Moshe from Los Angeles|posted December 31 2007
@hassanqureshi: http://www.magentocommerce.com/boards/viewreply/9136/
let’s try to keep support questions to the forums
97hassanqureshi from Karachi-Pakistan|posted December 31 2007
Ok Boss.
98FH |posted January 3 2008
Hi @all,
may be a stupid question....I have copied the magento files to shop.haass.net and made the rights as described in the installation guide. The php5 cgi is in a directory cgi-bin.
the .htaccess is as follows:
<IfModule mod_php5.c>
php_flag magic_quotes_gpc off
php_flag short_open_tag on
</IfModule>
Action php5-cgi /cgi-bin/php5-cgi
AddHandler /cgi-bin/php5-cgi .php
DirectoryIndex index.php
RewriteEngine on
RewriteBase /
RewriteCond %{REQUEST_URI} !^/media/
RewriteCond %{REQUEST_URI} !^/skin/
RewriteCond %{REQUEST_URI} !^/js/
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-l
RewriteRule .* index.php
I always get this output when I address shop.haass.net:
<?php
/**
* Magento
*
* NOTICE OF LICENSE
*
* This source file is subject to the Open Software License (OSL 3.0)
* that is bundled with this package in the file LICENSE.txt.
* It is also available through the world-wide-web at this URL:
* http://opensource.org/licenses/osl-3.0.php
* If you did not receive a copy of the license and are unable to
* obtain it through the world-wide-web, please send an email
* to so we can send you a copy immediately.
*
* @category Mage
* @package Mage
* @copyright Copyright (c) 2004-2007 Irubin Consulting Inc. DBA Varien (http://www.varien.com)
* @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0)
*/
if (version_compare(phpversion(), ‘5.2.0’, ‘<’)===true) {
echo ‘<div style="font:12px/1.35em arial, helvetica, sans-serif;"><div style="margin:0 0 25px 0; border-bottom:1px solid #ccc;"><h3 style="margin:0; font-size:1.7em; font-weight:normal; text-transform:none; text-align:left; color:#2f2f2f;">Whoops, it looks like you have an invalid PHP version.</h3></div>Magento supports PHP 5.2.0 or newer. Find out how to install</a> Magento using PHP-CGI as a work-around.</div>’;
exit;
}
require_once ‘app/Mage.php’;
umask(0);
Mage::run(’base’);
Whats the failure I make? Thandks so much for help!!!!
FH
99kosh |posted January 5 2008
Hi All
I can’t help wondering why no one is asking what seems to me to be the obvious question ....
Why (??????) oh why is the installer written like this in the first place ? I mean - it’s obvious what’s going to happen, and most of the above posts just prove the point.
Is there some reason for the ‘virtual’ installer that I have missed, or is it a case of ‘why make something easy if there’s a hard way’. Sorry to sound so glib, but that’s how it seems to me - complicated and difficult for the sake of it.
I have installed more scripts than I can remember and never encountered this before - mod rewrite is something people might want to play with when chasing seo, or for other more developed reasons, but it is just a basket of trouble to bring it into play during an install process.
Seriously - I honestly think that magento will never be more than an interesting curiosity so long as this silly installer persists - one for the ‘techies’, but not for the average joe.
I await the release of 1.0 with much anticipation, but if the installer is not sorted out by then it will be a waste of time as far as I am concerned, and I think that would be a sad day because magneto shows so much promise. Come on guys - scrap the little SOB and give us a proper ‘physical’ installer like every other script does
Cheers
Kosh
100Mangavod |posted January 5 2008
the new installer doesn’t work.
I made the directories writable and click the beta button… and the installation failed :
Settings preferred state to: beta
config-set succeeded
Downloading and installing Magento, please wait…
Attempting to discover channel “pear"…
unknown channel “pear” in “pear/PEAR-stable”
invalid package name/package file “pear/PEAR-stable”
Cannot initialize ‘pear/PEAR-stable’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
....done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Mage_Pear_Helpers”
invalid package name/package file “connect.magentocommerce.com/core/Mage_Pear_Helpers”
Cannot initialize ‘connect.magentocommerce.com/core/Mage_Pear_Helpers’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Lib_ZF”
invalid package name/package file “connect.magentocommerce.com/core/Lib_ZF”
Cannot initialize ‘connect.magentocommerce.com/core/Lib_ZF’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Lib_Varien”
invalid package name/package file “connect.magentocommerce.com/core/Lib_Varien”
Cannot initialize ‘connect.magentocommerce.com/core/Lib_Varien’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Mage_All”
invalid package name/package file “connect.magentocommerce.com/core/Mage_All”
Cannot initialize ‘connect.magentocommerce.com/core/Mage_All’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Frontend_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Frontend_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Frontend_Default’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Adminhtml_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Adminhtml_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Adminhtml_Default’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Install_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Install_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Install_Default’, invalid or missing package file
Array
(
[data] => Array
(
[0] => Array
(
[0] => Package “pear/PEAR-stable” is not valid
)
[1] => Array
(
[0] => Package “connect.magentocommerce.com/core/Mage_Pear_Helpers” is not valid
)
[2] => Array
(
[0] => Package “connect.magentocommerce.com/core/Lib_ZF” is not valid
)
[3] => Array
(
[0] => Package “connect.magentocommerce.com/core/Lib_Varien” is not valid
)
[4] => Array
(
[0] => Package “connect.magentocommerce.com/core/Mage_All” is not valid
)
[5] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Frontend_Default” is not valid
)
[6] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Adminhtml_Default” is not valid
)
[7] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Install_Default” is not valid
)
)
[headline] => Install Errors
)
PEAR ERROR: install failed
Well, any help.
the last version 14.100 worked perfectly..
101Ram |posted January 6 2008
Hi ,
I am getting the following errors while installing Magento. TIA for your help
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:\wamp\www\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 108
[trace:private] => Array
(
[0] => Array
(
[file] => C:\wamp\www\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 108
.....
exception ‘Mage_Core_Exception’ with message ‘Error in file: “C:\wamp\www\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.7.0.php” - 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.’ in C:\wamp\www\app\Mage.php:363
Stack trace:
#0 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(254): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(133): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.7.0’)
#2 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(120): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.7.0’)
#3 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(94): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 C:\wamp\www\app\code\core\Mage\Core\Model\Config.php(156): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 C:\wamp\www\app\code\core\Mage\Core\Model\App.php(135): Mage_Core_Model_Config->init(NULL)
#6 C:\wamp\www\app\Mage.php(390): Mage_Core_Model_App->init(’base’, NULL)
#7 C:\wamp\www\app\Mage.php(410): Mage::app(’base’, NULL)
#8 C:\wamp\www\index.php(29): Mage::run(’base’)
#9 {main}
102Ram |posted January 6 2008
I am having this problem while installing magento. Any help is greatly appreciated
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:\wamp\www\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 108
[trace:private] => Array
(
[0] => Array
(
[file] => C:\wamp\www\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 108
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
....... More like these .......
exception ‘Mage_Core_Exception’ with message ‘Error in file: “C:\wamp\www\app\code\core\Mage\Core\sql\core_setup\mysql4-install-0.7.0.php” - 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.’ in C:\wamp\www\app\Mage.php:363
Stack trace:
#0 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(254): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(133): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.7.0’)
#2 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(120): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.7.0’)
#3 C:\wamp\www\app\code\core\Mage\Core\Model\Resource\Setup.php(94): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 C:\wamp\www\app\code\core\Mage\Core\Model\Config.php(156): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 C:\wamp\www\app\code\core\Mage\Core\Model\App.php(135): Mage_Core_Model_Config->init(NULL)
#6 C:\wamp\www\app\Mage.php(390): Mage_Core_Model_App->init(’base’, NULL)
#7 C:\wamp\www\app\Mage.php(410): Mage::app(’base’, NULL)
#8 C:\wamp\www\index.php(29): Mage::run(’base’)
#9 {main}
103Moshe from Los Angeles|posted January 6 2008
For windows installations, try this file:
http://www.nolimitclubbing.com/lib_php/php_pdo_mysql.dll
And please keep the support requests and error pastes out of the blog comments - it was not built for long comments and conversations. Forums are much better suited place for that.
Thank you.
104Moshe from Los Angeles|posted January 6 2008
@Mangavod: looks like permissions for me, try the full package, not installer, and click “Continue with SVN installation”
By the way, please do not post long error paste in blog comments, it was not built for that.
Keep them for the forums.
105Seurot from Ohio|posted January 7 2008
@Mangavod : I had this same problem. Does anybody know what might be going on here?
106developerx |posted January 8 2008
you need to use the version of pear in the magento sub-directory
also after you issue
./pear install mage-core/Mage_All
the permission on pear change, removing execute rights, so you need to issue
chmod o+x pear
107Duro |posted January 8 2008
I’m getting that same error
108Moshe from Los Angeles|posted January 9 2008
@Mangavod: it still looks to me like a permissions problem in lib/pear/php folder.
Please keep the error pastes OUT of the comments to articles, the forums are better place for follow up.
Also, you can download the full package and not use PEAR if it doesn’t work for you.
109fromTheRiviera from Nice France|posted January 9 2008
Tried to install the ALPHA or BETA version from scratch but got the following error on the last file:
Starting to download Mage_All-0.7.0.tgz (1,890,552 bytes)
Fatal error: Maximum execution time of 240 seconds exceeded in
htdocs\magento\lib\pear\php\PEAR\Downloader.php on line 1716
110griffin12000 |posted January 11 2008
i have installed everything properly.. I have set the right permissions.. I also have php5.2.. when i try to install it says I don’t have the right php version.. I have already checked with my server.. it is 1and1.com the specs say 5.2
thanx for your help!
patrick
111dwkitchen |posted January 13 2008
I have a similar problem as above. I am new and this is my first install, don’t want to be put off magento at the first step
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/usr/local/etc/pear.conf) is not within the allowed path(s): (/home/penznpri:/usr/lib/php:/usr/local/lib/php:/tmp) in /home/penznpri/public_html/lib/pear/php/PEAR/Config.php on line 595[0] in file_exists("/usr/local/etc/pear.conf") in /home/penznpri/public_html/lib/pear/php/PEAR/Config.php on line 595[1] in PEAR_Config->PEAR_Config("/home/penznpri/public_html/lib/pear/pear.ini", “”, , 1) in /home/penznpri/public_html/lib/pear/php/PEAR/Config.php on line 645[2] in PEAR_Config->singleton("/home/penznpri/public_html/lib/pear/pear.ini") in /home/penznpri/public_html/lib/Varien/Pear.php on line 78[3] in Varien_Pear->getConfig() in /home/penznpri/public_html/lib/Varien/Pear.php on line 47[4] in Varien_Pear->__construct() in /home/penznpri/public_html/lib/Varien/Pear.php on line 53[5] in Varien_Pear->getInstance() in /home/penznpri/public_html/app/code/core/Mage/Install/controllers/WizardController.php on line 221[6] in Mage_Install_WizardController->installAction() in /home/penznpri/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php on line 332[7] in Mage_Core_Controller_Varien_Action->dispatch("install") in /home/penznpri/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php on line 149[8] in Mage_Core_Controller_Varien_Router_Standard->match(Mage_Core_Controller_Request_Http) in /home/penznpri/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php on line 166[9] in Mage_Core_Controller_Varien_Front->dispatch() in /home/penznpri/public_html/app/Mage.php on line 411[10] in Mage::run("base") in /home/penznpri/public_html/index.php on line 29
Setting preferred state to: beta
config-set succeeded
Downloading and installing Magento, please wait…
Attempting to discover channel “pear"…
unknown channel “pear” in “pear/PEAR-stable”
invalid package name/package file “pear/PEAR-stable”
Cannot initialize ‘pear/PEAR-stable’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
....done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Mage_Pear_Helpers”
invalid package name/package file “connect.magentocommerce.com/core/Mage_Pear_Helpers”
Cannot initialize ‘connect.magentocommerce.com/core/Mage_Pear_Helpers’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Lib_ZF”
invalid package name/package file “connect.magentocommerce.com/core/Lib_ZF”
Cannot initialize ‘connect.magentocommerce.com/core/Lib_ZF’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Lib_Varien”
invalid package name/package file “connect.magentocommerce.com/core/Lib_Varien”
Cannot initialize ‘connect.magentocommerce.com/core/Lib_Varien’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Mage_All”
invalid package name/package file “connect.magentocommerce.com/core/Mage_All”
Cannot initialize ‘connect.magentocommerce.com/core/Mage_All’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Frontend_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Frontend_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Frontend_Default’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Adminhtml_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Adminhtml_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Adminhtml_Default’, invalid or missing package file
Attempting to discover channel “connect.magentocommerce.com/core"…
downloading channel.xml ...
Starting to download channel.xml (687 bytes)
...done: 687 bytes
Auto-discovered channel “connect.magentocommerce.com/core”, alias “connect.magentocommerce.com/core”, adding to registry
unknown channel “connect.magentocommerce.com/core” in “connect.magentocommerce.com/core/Interface_Install_Default”
invalid package name/package file “connect.magentocommerce.com/core/Interface_Install_Default”
Cannot initialize ‘connect.magentocommerce.com/core/Interface_Install_Default’, invalid or missing package file
Array
(
[data] => Array
(
[0] => Array
(
[0] => Package “pear/PEAR-stable” is not valid
)
[1] => Array
(
[0] => Package “connect.magentocommerce.com/core/Mage_Pear_Helpers” is not valid
)
[2] => Array
(
[0] => Package “connect.magentocommerce.com/core/Lib_ZF” is not valid
)
[3] => Array
(
[0] => Package “connect.magentocommerce.com/core/Lib_Varien” is not valid
)
[4] => Array
(
[0] => Package “connect.magentocommerce.com/core/Mage_All” is not valid
)
[5] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Frontend_Default” is not valid
)
[6] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Adminhtml_Default” is not valid
)
[7] => Array
(
[0] => Package “connect.magentocommerce.com/core/Interface_Install_Default” is not valid
)
)
[headline] => Install Errors
)
PEAR ERROR: install failed
112kgrach |posted January 13 2008
Dear Kosh, if you think this installer is hard you need to get a new job please for everyone’s sake.
Last Sunday I decided to give this software a try as my current storefront sucks to say it bluntly. Plus my hosting service is charging me a fortune plus nickel and dime me to death for really poor service. I haven’t had a working SSL for the last year.
We have both Fiber and Cable at my office so why not trying to hosting myself.
Yes this is a bit insane as I have no real Linux knowledge and absolutely none when it comes to Apache MySQL PHP. But undaunted I proceeded to gather some spare computer parts up Sunday night and assemble a computer.
Sunday
Alas could not get computer to work system powers up and down as soon as power is applied I suspect bad power supply.
Spend rest of Sunday researching different Linux installs.
Ubuntu has a server version the claims to have a quick and easy LAMP install. I am sold.
Monday Evening
Home from work with another used PSU. System powers up and seems to work fine
The CDRW I put in the system seems to have some problems reading the CD.
Grab another spare CDRW this one works. Reinstalled Ubuntu from scratch with
LAMP. System powers up and I am presented with a text login and a note to read about man sudo because there is no such thing as root on my system.
Server system loads without GUI great I have no idea how to navigate a Linux from Shell.
Spend rest of evening learning how to navigate shell.
Learned Ifconfig command I now have server IP number .
I login from my windows machine and great I have working server.
Tuesday Evening
Home from bookstore got two books mastering Linux 1889 pages ouch seven years old according to copyright. Plus it only deals with RED Hat Linux.
Second book PHP MySQL Apache a more manageable 599 pages whoot.
Better yet copyrighted 2006.
Learned system rights and how to use nano to edit config files.
Beat my head trying to move the default web directory.
Learned the hard way about system rights or what ever its called.
So that’s why it wouldn’t display my HTML pages CHMOD and group rights fixed that
Wednesday took the evening off to spend time with the GF.
Thursday Evening
Installed SSL server and vsftpd spent rest of evening struggling with the FTP configuration.
Friday Evening
Spent trying to figure out what the hell a MTA was and how to set one up plus I did research online on which one was better I chose EXIM4 as my MTA.
Saturday afternoon
Marathon session SSL server setup and now I can’t get non HTTPS pages to display.
Erased hard drive and resetup LAMP. This time making backups of original config files plus write protecting them. Finally figured out that it requires two apache2 defines one for port 80 and one for port 443 plus how to get certificates and make self signing one. Godaddy seems to have the cheapest cert at $25 versus 150 or 400 dollars for thaws and verisign what a rip.
Made self signing for testing purposes and downloaded Magento BZ2 version.
FTP’d to server and now had fun trying to figure out how to untar something TAR XZF didn’t work where Tar xvvf worked huh!
Installed curl and mcrypt I thought !!!
Magento stopped on install ohh I needed PHP-curl and PHP-Mcrypt didn’t know there was a difference.
Magento installer stopped again on database section. Now I had to learn about how to create a database named magento in MySQL. Figured that out now try installer again finished. Checked storefront up and running.
Now some sleep.
Sunday afternoon
Back in front of the computer trying to figure out how to configure store. Really my only complaint on the installation process and instructions how bout a simple line at the end of the installations instructions like “To now configure store, type http://www.example.com/magento/admin to get to store backend “
To the Magento team nice job on that really easy Installer. It was really handy and made life easy for a total noob to setup a storefront. Also don’t worry the Apache Rewrite module as it was easy to setup and this is coming from a complete apache novice.
113RoyRubin from Los Angeles, CA|posted January 14 2008
For further comments and discussion, please use the Magento Install Forum
http://www.magentocommerce.com/boards/viewforum/9/
Thanks!