Magento error with pdo_mysql

Sunday, December 27th, 2009

Magento is a great Free / Open source eCommerce script, is much more prettier and yet complex than Prestashop or osCommerce or Virtuemart. Take sometimes to upload it to hosting server, but if your hosting provider have Automatic script installer like Installatron or Softacolous, you can install it in a breeze. So Installation of Magento is no longer problem.

But after a succesful installation, I even get this error saying that I dont have pdo_mysql installed on the server.

pdo_mysql extension is not installed
Trace:
#0 /home/store/public_html/lib/Zend/Db/Adapter/Abstract.php(441):
Varien_Db_Adapter_Pdo_Mysql->_connect()
#1 /home/store/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230):
Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#2 /home/store/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(281):
Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#3 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Type/Db/Pdo/Mysql.php(45):
Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#4 /home/store/public_html/app/code/core/Mage/Core/Model/
Resource.php(87): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql-
>getConnection(Object(Mage_Core_Model_Config_Element))
#5 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Setup.php(62): Mage_Core_Model_Resource->getConnection('core_setup')
#6 /home/store/public_html/app/code/core/Mage/Core/Model/Resource/
Setup.php(120): Mage_Core_Model_Resource_Setup->__construct('core_setup')
#7 /home/store/public_html/app/code/core/Mage/Core/Model/Config.php(263):
Mage_Core_Model_Resource_Setup::applyAllUpdates()
#8 /home/store/public_html/app/code/core/Mage/Core/Model/App.php(263):
Mage_Core_Model_Config->init(Array)
#9 /home/store/public_html/app/Mage.php(434):
Mage_Core_Model_App->init('', 'store', Array)
#10 /home/store/public_html/app/Mage.php(455):
Mage::app('', 'store', Array)
#11 /home/store/public_html/index.php(65): Mage::run()
#12 {main}

I don’t get it, when I check with function

<?php
phpinfo();
?>

pdo and pdo_mysql is there.

'--enable-pdo=shared'
'--with-pdo-mysql=shared'

So, it’s time for searching and lurking into Google and Magento forum/docs
(more…)

SocialTwist Tell-a-Friend

Fantastico Problem

Wednesday, August 19th, 2009

First, Joomla is not listed on Fantastico, tried to update Fantastico
WHM >> Plugins >> Fantastico De Luxe WHM Admin >> Update/Get files
Failed!! Below Error showed up when opening Fantastico from cPanel

The server was not able to find the document (./frontend/x3/fantastico/index.php) you requested. Please check the url and try again. You might also want to report this error to your web hosting provider.

Access WHM >> Plugins >> Fantastico De Luxe WHM Admin again, this time it asked to re-install. Done that. But I still get the same error.
(more…)

SocialTwist Tell-a-Friend

SQL Error: Table ‘mysql.proc’ doesn’t exist

Thursday, June 18th, 2009

Today I upgraded my HeidiSQL into version 4, but when I am running it on the MySQL server 5.0 I got error

"SQL Error: Table 'mysql.proc' doesn't exist"

After googling around, found that this error caused HeidiSQL requires table Mysql.proc which is not exist. Table Mysql.proc is used to store procedure. But wait, I am using MySQL 5.0.x which already support Procedures and Views!! so How come this error show up??

After some tought, the are several reason why this error came up although you are using MySQL 5.

  1. You are upgrading from MySQL 4.x
  2. Your MySQL 5.x installation didn’t smooth

And in my case, it was reason no. 1, as I am remember I was once upgrade mysql server a year ago. So how to fix it? (more…)

SocialTwist Tell-a-Friend

Skip Replication Error

Monday, February 9th, 2009

This is happen long time ago when Mysql Replication stop due to duplicate error, Kumay has the log. But I don’t want to do a manual labor. So to skip a duplicate error on A MySQL Replication Server (SLAVE) automatically. Added this line on /etc/my.cnf

Note: Make sure you know what cause a duplicate error and does it really not important so that you can skip inserting that query.
(more…)

SocialTwist Tell-a-Friend

You have reached a limit on your ability to send money although already Verified

Sunday, February 1st, 2009

So you need to buy something, and the seller accept payment via PayPal. Or you dont want to expose your Credit Card details to that seller, then you create PayPal account. You have a real (not a virtual) Credit Card and has succesfully link and confirm it and make your PayPal account Verified.

But then when you about to pay the invoice Paypal gave you error

“You have reached a limit on your ability to send money. Please link and confirm a debit or credit card to lift this limit”

No need to link and confirm another credit card, here what happen:
(more…)

SocialTwist Tell-a-Friend