|
Posted by lark on October 31, 2006, 9:24 am
Please log in for more thread options also, i'd look at the table being referenced: order_form_printers and
make sure it's pk is set correctly.
davie wrote:
> Have you created table EC_SAVED_ORDER_LINE_ITEMS ???
> laredotornado@zipmail.com wrote:
>> Hello,
>>
>> My hosting company has MySQL 5 and so do I on my local Fedora Core 5
>> Linux machine. However, when I import a dump file from their
>> enviornment into mine, I get this error
>>
>> ERROR 1064 (42000) at line 21428: You have an error in your SQL syntax;
>> check the manual that corresponds to your MySQL server version for the
>> right syntax to use near 'TABLE `EC_SAVED_ORDER_LINE_ITEMS`
>> ADD CONSTRAINT `FK1_SAVED_ORDER_LINE_ITEMS` ' at line 3
>>
>> This is the line (and those around it) from my file. It is complaining
>> about the first line. What is the problem?
>>
>> ALTER TABLE `EC_SAVED_ORDER_LINE_ITEMS`
>> ADD CONSTRAINT `FK1_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY
>> (`ORDER_FORM_PRINTER_ID`) REFERENCES `ORDER_FORM_PRINTERS`
>> (`ORDER_FORM_PRINTER_ID`) ON DELETE CASCADE,
>> ALTER TABLE `EC_SAVED_ORDER_LINE_ITEMS`
>> ADD CONSTRAINT `FK1_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY
>> (`ORDER_FORM_PRINTER_ID`) REFERENCES `ORDER_FORM_PRINTERS`
>> (`ORDER_FORM_PRINTER_ID`) ON DELETE CASCADE, ADD CONSTRAINT
>> `FK2_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY (`PRODUCT_ID`) REFERENCES
>> `PROD_PRODUCTS` (`PRODUCT_ID`) ON DELETE CASCADE,
>> ALTER TABLE `EC_SAVED_ORDER_LINE_ITEMS`
>> ADD CONSTRAINT `FK1_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY
>> (`ORDER_FORM_PRINTER_ID`) REFERENCES `ORDER_FORM_PRINTERS`
>> (`ORDER_FORM_PRINTER_ID`) ON DELETE CASCADE, ADD CONSTRAINT
>> `FK2_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY (`PRODUCT_ID`) REFERENCES
>> `PROD_PRODUCTS` (`PRODUCT_ID`) ON DELETE CASCADE, ADD CONSTRAINT
>> `FK3_SAVED_ORDER_LINE_ITEMS` FOREIGN KEY (`TRANSACTION_ID`) REFERENCES
>> `EC_SAVED_ORDERS` (`TRANSACTION_ID`) ON DELETE CASCADE;
>>
>> Thanks, - Dave
>
| 
XML Sitemap