PHP advice needed

iMax

Hi,

I have a PHGP script which I need to get installed/set up. I've been looking at it & Can't see why it's not working. Is there anyone who'd be able to assist ?

We'll need more info. Whats the script? Whats the problem?

iMax

Hi,

I need someone who's familiar/experienced with Magento "themes"

A Magento theme should be mainly XML, CSS and phtml files. How does this relate to a PHP script to be installed?

iMax

The index file I have is .php As are a lot of other files. I'm a little out of my depth on it.

See files in image

Webmonkey

What exactly are you trying to do. That list of files looks more than just a theme.

iMax

Trying to set up an online store

Webmonkey

Yeah that's quite obvious. The exactly bit meant what "exactly" speciifics are you trying to do with these PHP files.

iMax

Sorry, my bad. I'm trying to set up an online store which should be contained within these files, (front/end artwork, engine etc), however, I can't figure out how to "install" it.

Webmonkey

When you upload this, and call the install script from browser do you get to an install stage? or have you attempted this?

iMax

Sorry for the delay respponding. I get the following when I call the install.php:


There has been an error processing your request
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Trace:
#0 /usr/local/pem/vhosts/136223/webspace/httpdocs/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /usr/local/pem/vhosts/136223/webspace/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(251): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /usr/local/pem/vhosts/136223/webspace/httpdocs/lib/Zend/Db/Adapter/Abstract.php(448): Varien_Db_Adapter_Pdo_Mysql->_connect()
#3 /usr/local/pem/vhosts/136223/webspace/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#4 /usr/local/pem/vhosts/136223/webspace/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#5 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Resource/Type/Db/Pdo/Mysql.php(45): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#6 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Resource.php(93): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Object(Mage_Core_Model_Config_Element))
#7 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(297): Mage_Core_Model_Resource->getConnection('core_read')
#8 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(312): Mage_Core_Model_Mysql4_Abstract->_getConnection('read')
#9 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Mysql4/Cache.php(41): Mage_Core_Model_Mysql4_Abstract->_getReadAdapter()
#10 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Cache.php(424): Mage_Core_Model_Mysql4_Cache->getAllOptions()
#11 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Cache.php(459): Mage_Core_Model_Cache->_initOptions()
#12 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/App.php(1100): Mage_Core_Model_Cache->canUse('config')
#13 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Config.php(404): Mage_Core_Model_App->useCache('config')
#14 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/Config.php(286): Mage_Core_Model_Config->_canUseCacheForInit()
#15 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/App.php(359): Mage_Core_Model_Config->loadModulesCache()
#16 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/code/core/Mage/Core/Model/App.php(295): Mage_Core_Model_App->_initModules()
#17 /usr/local/pem/vhosts/136223/webspace/httpdocs/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#18 /usr/local/pem/vhosts/136223/webspace/httpdocs/index.php(78): Mage::run('', 'store')
#19 {main}

Webmonkey

Have you set up MySQL and configured a user/pass and database? Looks like the database settings wern't set.

iMax

I've uploaded the sql file, I'm suspecting that's not the same as "Set Up" ??

Liam Byrne

iMax wrote: »

I've uploaded the sql file, I'm suspecting that's not the same as "Set Up" ??

You'd be right.

I think Microsoft's SQL allows you to read an SQL file as if it were a database, but MySQL is a completely different setup altogether.

Your host should have an SQL control panel, and you should be able to export from your local version of MySQL and import using that, or else export to a CSV or equivalent file and then import using that.

iMax

Thanks. Will try that.

iMax

OK, Have setup a mysql database through blacknight's control panel & am still getting the same error page when I run install again. Any ideas ?

fasty

You might have to edit a config file to match the DB details of the MySQL database you set up. Maybe check the readme for the filename? I dunno what it is myself.