Input error database
-
Hi all,
When I'm edit in maintenance the agreement information and want to save, I get a error:
Unknown column 'isys_cats_maintenance_list__customer_number' in 'field list'Does this mean that the update to the last version and patch where wrong or is it a bug?
Mels
-
Seems that this field is missing in the database. How did you use the patch? Was there a database update?
-
I did a update the i-doit update screen, this wa at home.
In the office i did the same update and inported the database at home. The export was done with mysqldump/I check tomorro the db in the office for the missing field, this evening i install a clean version at home, so I can compare them.
I let you know.Mels
-
no bug, I had imported a old database file in the new database.
problem solved
thanks
Mels -
-
Still one little question:
Why is one mandator database MYISAM and the other INODB?Mels
-
Which of your mandator databases is myisam? The default table type in your database should be innodb.
-
sorry for the late respons.
I think that the first time i installed i-doit, inodb was disabled.
I changed MYISAM to INODB in the mysqldump file, and do a i-doit db update.
everything was fine nowMels