Error #1005 on MySQL Query: Can’t Create Table

Asked By Duncan Shaw 0 points N/A Posted on - 10/15/2011

Dear Expert,

Has anybody here, been using Magento, ecommerce application using PHP. I was trying to install a sample database using phpMyAdmin. But some errors occur, that I could not continue with the Installation. Is there something wrong with my Database (MySQL) or the Magento. I captured the error that occurred.

Error:

#1005 – Can't create table 'magento.api_user' (err no: 150)

• Status: Open
• Question Views: 1742
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Garry Bross 20 points N/A #121667

Error #1005 on MySQL Query: Can’t Create Table

 

Did you create a database before? It is not a small thing to know, it is so sensitive and you have to adjust your requirement of field parameters correctly. I recommend you to read eBooks and also articles to gather your knowledge about it. Because it is huge “PHP and Database”.

 

I can’t give you the solution directly and it is not clear what your problem is. I will give you some links to some sites and eBooks on database and PHP. This is a good site about “Database creation”. Follow them, you will find what went wrong on your own. Here is an eBook : Mastering PHP/MyAdmin.

About Garry Bross

Questions
0

Answers
196

Best Answers
128

• Vote Up 0 Vote Down

• Posted on - 10/16/2011
• Question Category: MS SQL Server