[Richard Prossor]

Hi Ritesh

thanks for your reply identifying the bugs. I look forward to receiving advice of the new version because I do like your software 🙂

Regards

Richard

[Richard Prossor]

Hi Ritesh

the MySQL version is 4.1.4-gamma-max-log

As detailed in the first post, I am importing from MS Access. After the import, because the primary key and other indexes and relationships are not transferred, I need to set these up again manually – that is what I am trying to do when I get the errors I reported

I am assuming the 1091 error is a sql error rather than related to your software but do not understand what it is trying to tell me

This is the table after I have added the information I require using mysql-front

Regards

Richard

/*Column Information For – transact_mysql.activity*/

---

Field Type Collation Null Key Default Extra Privileges Comment

---

---

---

---

---

---

---

---

---

activity_id int(10) NULL PRI (NULL) auto_increment select,insert,update,references

activity varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references

activity_description blob NULL YES (NULL) select,insert,update,references

employee_issue char(1) latin1_swedish_ci select,insert,update,references

activity_type_id int(10) NULL MUL 0 select,insert,update,references

/*Index Information For – transact_mysql.activity*/

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment

---

---

---

---

---

---

---

---

---

---

---

---

activity 0 PRIMARY 1 activity_id A 8 (NULL) (NULL) BTREE

activity 1 NewIndex 1 activity_type_id A 8 (NULL) (NULL) BTREE

/*DDL Information For – transact_mysql.activity*/

---

Table Create Table

---

---

activity CREATE TABLE `activity` (

`activity_id` int(10) NOT NULL auto_increment,

`activity` varchar(50) default NULL,

`activity_description` blob,

`employee_issue` char(1) NOT NULL default '',

`activity_type_id` int(10) NOT NULL default '0',

PRIMARY KEY (`activity_id`),

KEY `NewIndex` (`activity_type_id`),

CONSTRAINT `activity_ibfk_1` FOREIGN KEY (`activity_type_id`) REFERENCES `activity_type` (`activity_type_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

[Richard Prossor]

I have just found that I don't have these problems using MySQL-Front……..I think you may have lost a customer (but at least I paid for the product)

😎

Regards

Richard

[Author]

Posts