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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login