ERROR 1005 (HY000) at line 147: Can't create table '.\hitandlove\members_services.frm' (errno: 121)

Posted on 2007-07-30
Last Modified: 2010-05-18
I think I have a problem with my Primary Key:

ERROR 1005 (HY000) at line 147: Can't create table '.\hitandlove\members_services.frm' (errno: 121)

CREATE TABLE `members_services` (
  `member_id` int(10) unsigned NOT NULL default '0',
  `service_id` int(10) unsigned NOT NULL default '0',
  `quantity` int(5) unsigned NOT NULL default '0',
  `price` int(5) unsigned NOT NULL default '0',
  `paid_date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`member_id`,`service_id`),
  KEY `FK_MEMBER_ID` (`member_id`),
  CONSTRAINT `FK_MEMBER_ID` FOREIGN KEY (`member_id`) REFERENCES `members` (`id_member`),
  KEY `FK_SERVICE_ID` (`service_id`),
  CONSTRAINT `FK_SERVICE_ID` FOREIGN KEY (`service_id`) REFERENCES `services` (`id_service`)

Question by:matthew016
    1 Comment
    LVL 17

    Accepted Solution


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Tracking a Database Lock - SQL 2014 10 28
    SQL Query 18 64
    SQL for monthly balance change 15 51
    Php Sql Query 7 19
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now