FrankJ Posted January 29, 2011 Report Share Posted January 29, 2011 I tried to load Drupal 7 on my Uniform Server 5.7.1 and get this message below. I apologize, but I have very little experience with the workings of a server. Should I go and download the PDO support files from MySQL? How hard is it to install? Will that mess up Uniform Server? I also found something on PHP.net that stated I just had to alter php.ini. I am not sure exactly which ones to enable. I have the Uniform Server running on a flash drive. My computer is running WindowsXP SP3 with 2Gb of ram, if that has anything to do with it. (and do I need to keep coming back here to keep seeing if anyone answers or is there an email notification? if needed knarfhill@embarqmail.com) -----------------Drupal messageDatabase support DisabledYour web server does not appear to support any common PDO database extensions. Check with your hosting provider to see if they support PDO (PHP Data Objects) and offer any databases that Drupal supports Drupal supports. Quote Link to comment Share on other sites More sharing options...
Ric Posted January 29, 2011 Report Share Posted January 29, 2011 Drupal state the following: For Apache, you will need to make sure php_pdo.dll and php_pdo_mysql.dll exist in the php/ext directory, un-comment or add the appropriate lines in php.ini, and restart the web server. Note: The php_pdo.dll is pre-compiled into PHP 5.3.5 hence will not appear in the extensions folder. Extension php_pdo_mysql.dll exists in the extensions folder however it needs to be enabled in php.ini configuration file. To enable perform the following: Edit file:UniServer\usr\local\php\php.iniLocate this line:;extension=php_pdo_mysql.dllUn-comment the line (remove ; ) as shown below:extension=php_pdo_mysql.dll Enable InnoDBOtherwise you will receive this error:Syntax error or access violation: 1286 Unknown storage engine 'InnoDB' Edit file:UniServer\usr\local\mysql\my.iniLocate this line:skip-innodbComment line (add #) as shown below:#skip-innodb Finally: During installation use a real e-mail address otherwise install will fail. Tested on: Nano 5.7.1 Drupal 7.0 All the bestRic Quote Link to comment Share on other sites More sharing options...
FrankJ Posted January 29, 2011 Author Report Share Posted January 29, 2011 Perfect! Thanks so much for the information and instructions - very simple and thorough. 10,000 thank yous. Quote Link to comment Share on other sites More sharing options...
Ollie222 Posted March 9, 2011 Report Share Posted March 9, 2011 Just for the record the same process has worked for me using Uniserver 5.5. Keep up the good work Ric, Uniserver really is becoming a very useful collection of tools. Quote Link to comment Share on other sites More sharing options...
10basetom Posted March 13, 2011 Report Share Posted March 13, 2011 Does this mean Drupal 7 *requires* InnoDB? I can see this being a problem for many people because most cheap hosts only support MyISAM. Quote Link to comment Share on other sites More sharing options...
FrankJ Posted March 13, 2011 Author Report Share Posted March 13, 2011 "Note: Drupal supports MyISAM and InnoDB table types. NDB tables (MySQL Cluster) are not supported." From http://drupal.org/requirements. Drupal 5.x, 6.x, 7.x requirements page. And my uniformserver was not set up this way, thus the original question. I did as outlined above and D7 loaded just fine. Quote Link to comment Share on other sites More sharing options...
10basetom Posted March 13, 2011 Report Share Posted March 13, 2011 "Note: Drupal supports MyISAM and InnoDB table types. NDB tables (MySQL Cluster) are not supported." From http://drupal.org/requirements. Drupal 5.x, 6.x, 7.x requirements page. And my uniformserver was not set up this way, thus the original question. I did as outlined above and D7 loaded just fine. Yup, I just installed Drupal 7 a minute ago and can confirm that nothing broke after ALTERing all the tables to ENGINE=MyISAM. Quote Link to comment Share on other sites More sharing options...
Amonsa Posted April 6, 2011 Report Share Posted April 6, 2011 Thanks a lot for the help,it works for me Quote Link to comment Share on other sites More sharing options...
makantruzz Posted September 16, 2011 Report Share Posted September 16, 2011 how to check that pdo_mysql is activated ?? and how to test that my PHP is connected to pdo mysql ? Quote Link to comment Share on other sites More sharing options...
rleroy Posted September 23, 2011 Report Share Posted September 23, 2011 Does this mean Drupal 7 *requires* InnoDB? I can see this being a problem for many people because most cheap hosts only support MyISAM. I actually did not know that some web hosting provider do not support Drupal 7. I think I will contact the customer support of my web hosting provider and will check if they also support Drupal 7 but I think this should not be a problem. Quote Link to comment Share on other sites More sharing options...
FrankJ Posted October 4, 2011 Author Report Share Posted October 4, 2011 I just did this with Uniform Server 7.1.11 Orion and Drupal D7 following Ric's information at the top of this thread. All works just fine. Quote Link to comment Share on other sites More sharing options...
robie Posted October 19, 2011 Report Share Posted October 19, 2011 Hi Ric,I was having the same problem and followed your instructions but unfortunately still get this error message:Error Database support DisabledYour web server does not appear to support any common PDO database extensions. Check with your hosting provider to see if they support PDO (PHP Data Objects) and offer any databases that Drupal supports. Any ideas what I can try next please? I'm using version Orion 7.1.12 on windows 7 CheersRob Drupal state the following: For Apache, you will need to make sure php_pdo.dll and php_pdo_mysql.dll exist in the php/ext directory, un-comment or add the appropriate lines in php.ini, and restart the web server. Note: The php_pdo.dll is pre-compiled into PHP 5.3.5 hence will not appear in the extensions folder. Extension php_pdo_mysql.dll exists in the extensions folder however it needs to be enabled in php.ini configuration file. To enable perform the following: Edit file:UniServer\usr\local\php\php.iniLocate this line:;extension=php_pdo_mysql.dllUn-comment the line (remove ; ) as shown below:extension=php_pdo_mysql.dll Enable InnoDBOtherwise you will receive this error:Syntax error or access violation: 1286 Unknown storage engine 'InnoDB' Edit file:UniServer\usr\local\mysql\my.iniLocate this line:skip-innodbComment line (add #) as shown below:#skip-innodb Finally: During installation use a real e-mail address otherwise install will fail. Tested on: Nano 5.7.1 Drupal 7.0 All the bestRic Quote Link to comment Share on other sites More sharing options...
vaalf Posted January 22, 2012 Report Share Posted January 22, 2012 Hi Ric,I was having the same problem and followed your instructions but unfortunately still get this error message:Error Database support DisabledYour web server does not appear to support any common PDO database extensions. Check with your hosting provider to see if they support PDO (PHP Data Objects) and offer any databases that Drupal supports. Any ideas what I can try next please? I'm using version Orion 7.1.12 on windows 7 CheersRobHi, I had the very same issue with Orion 7.1.4 on Win 7. But I could manage to resolve the issue by manually restarting the Orion server. Maybe it is the trick for you as well! Thanks,Vaalf Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.