Update data all tables worked except for this error re the database
ALTER TABLE Test_app_entity_41 CHANGE Date Logged - Opened (hrs) Date Logged - Opened (hrs) varchar(1) CHARACTER SET utf8mb4
1064
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '- Opened (hrs) Date Logged - Opened (hrs) varchar(1) CHARACTER SET utf8mb4' at line 1
So far this error does not seem to have caused any issue
database error on update
- support
- Site Admin
- Posts: 6231
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: database error on update
I see. Looks like you have custom field in database.
File from archive replace to install/autoupdate/
And run /install/autoupdate/data_prepare_from_2.6_to_2.7.php again
Let me know if it works ok now.
File from archive replace to install/autoupdate/
And run /install/autoupdate/data_prepare_from_2.6_to_2.7.php again
Let me know if it works ok now.
- Attachments
-
- data_prepare_from_2.6_to_2.7.zip
- (2.06 KiB) Downloaded 118 times
-
- Investor
- Posts: 417
- Joined: 19 Dec 2018, 02:33
- Name: Robert McDonald
- Location: Auckland, New Zealand
- Company Name: Unicloud
- Contact:
Re: database error on update
Not sure what you mean by custom field , however that new patch seemed to work