Error in magento script file

Question

I have used this file for an extension of mine to add a new table but it doesn't run and gives error. Here is the code for my script.

$installer = $this;

$installer->startSetup();

$installer->run("

-- DROP TABLE IF EXISTS ` magebuzz_testimonial_store`;
CREATE TABLE ` magebuzz_testimonial_store` (
  `testimonial_id` INT(10) UNSIGNED NOT NULL,
    `store_id` VARCHAR(11) NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Testimonials Store Table';

");

$installer->endSetup();

Can anyone please tell me where am i going wrong with this? Thanks.

Maybe it would be helpful if you could post the error as well... — fmrng
– fmrng, Commented Jul 9, 2013 at 10:29
It just says Error in file: You have a syntax error in your file on line number 4 near ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Testimonials Store Table'' But there is just comment on line number 4 and code starts after that. — jdhaar
– jdhaar, Commented Jul 9, 2013 at 10:35

Marius · Accepted Answer · 2013-07-09 12:42:33Z

1

it's because of the comma after the store_id field: It should look like this:

$installer->run("

-- DROP TABLE IF EXISTS `{$installer->getTable('magebuzz_testimonial_store')}`;
CREATE TABLE `{$installer->getTable('magebuzz_testimonial_store')}` (
  `testimonial_id` INT(10) UNSIGNED NOT NULL,
    `store_id` VARCHAR(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Testimonials Store Table';

");

I also added a $installer->getTable() statement around the table name. This is in case you have table a prefix.

edited Jul 9, 2013 at 12:42

answered Jul 9, 2013 at 11:23

Marius

199k55 gold badges431 silver badges837 bronze badges

Thanks. It is working. Just a bit of edit. The curly brace that started near $installer needs to be ended at the end of the same line.

jdhaar
– jdhaar

2013-07-09 12:35:34 +00:00
Commented Jul 9, 2013 at 12:35
Right. My bad. sorry. I edited the answer.

Marius
– Marius

2013-07-09 12:37:11 +00:00
Commented Jul 9, 2013 at 12:37

Add a comment |

Sander Mangel · Accepted Answer · 2013-07-09 11:30:53Z

0

When running into issues with a MySQL installer script it's always smart to just run the query in PHPMyAdmin for example to see if it returns any errors.

Optionally use PHPMyAdmin or MySQL workbench to create tables and use the export functionality to get the required Query. This way you are sure your query is correct.

answered Jul 9, 2013 at 11:30

Sander Mangel

37.6k5 gold badges81 silver badges149 bronze badges

Add a comment |

Stack Exchange Network

Error in magento script file

2 Answers 2

Your Answer

Hot Network Questions

Error in magento script file

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions