SQL Query Executor

[dochsa]

Hi All,

I have tried to run the following with the SQL Query Executor:
<?php
$installer = $this;
$installer->startSetup();
$tblName = Mage::getSingleton('core/resource')->getTableName("social_log");
$installer->run("
CREATE TABLE $tblName (
`login_id` varchar(50) NOT NULL ,
`entity_id` int(11) NOT NULL ,
`email` varchar(255) NOT NULL ,
PRIMARY KEY (`login_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");

$installer->endSetup();


And I get the following error:
WARNING: An Error occurred, please refresh the page and try again.

www.assceneon.com/catalog

Thanks for your help,

Donovan

[lat9]

You could start here: https://www.zen-cart.com/content.php...-and-try-again

I Googled "zen cart warning an error occurred" and that link was the top hit.

[niccol]

You are trying to run that code where exactly?

Where did you find that code? It is a php script not an sql statement.

What exactly are you trying to do?

[dochsa]

Hi Nicole

I was trying to upload a mod and it had that code and said to use the SQL Executor. What I did was upload it as a file and it worked.

Thanks for your help.

Dono