Jump to content

Database error on install (ps_meta_lang)


Recommended Posts

Hi-

I'm having a problem installing Prestashop on a MediaTemple (gs) server. Started out trying to copy the database from my development build, but I got the following error when copying the database to the GridServer:

Error while inserting data in the database:
'CREATE TABLE `ps_meta_lang` ( `id_meta` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `title` varchar(128) default NULL, `description` varchar(255) default NULL, `keywords` varchar(255) default NULL, `url_rewrite` varchar(254) NOT NULL, PRIMARY KEY (`id_meta`,`id_lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8'
Can\'t create table \'db126733_zengyro.ps_meta_lang\' (errno: -1)(Error: : 1005)

So I tried a new installation of Prestashop on the GridServer. Same error on step #3 after verifying my database connection. It installs all the tables up until that point but stops at ps_meta_lang. I suspect it may have something to do with the composite primary key, but I'm not totally sure.

I'm kind of stumped. It's running fine on my local machine as well as another MediaTemple staging server, though the staging server is a DV instead of a GS. Any ideas?

Thanks,
Adam

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...