Problem in 3.5.6 performupgrade in file_caching migration [FIXED]

When things don't work as they should.
Post Reply
lsmoker
Posts: 24
Joined: Wed Sep 05, 2018 3:52 pm

Problem in 3.5.6 performupgrade in file_caching migration [FIXED]

Post by lsmoker »

I ran into a problem after running "performupgrade" in 3.5.6 (pip install) on a 2.7.4 database. It looks like the migrations did not run for the user_management and web_links apps so the user_management_useroptions, web_links_weblink, and web_links_weblink_document_types tables were not created (alphabetically the last ones). The missing tables caused a server error in the UI. I reverted back to 3.5.5 and re-ran performupgrade and it worked fine, so I haven't investigated what went wrong on 3.5.6.
Last edited by lsmoker on Thu Mar 25, 2021 2:18 pm, edited 1 time in total.
---
LeVon Smoker
lsmoker
Posts: 24
Joined: Wed Sep 05, 2018 3:52 pm

Re: Problem in 3.5.6 performupgrade in file_caching migration

Post by lsmoker »

The actual error is this...

Code: Select all

  Applying file_caching.0004_auto_20200309_0922... OK
CommandError: Error during signal_pre_upgrade signal: (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 \'."name",\n            "file_caching_cachepartitionfile"."filename",\n            "\' at line 2'), <class 'MySQLdb._exceptions.ProgrammingError'>
  Applying file_caching.0005_auto_20200322_0607...
Last edited by lsmoker on Thu Mar 25, 2021 2:18 pm, edited 1 time in total.
---
LeVon Smoker
lsmoker
Posts: 24
Joined: Wed Sep 05, 2018 3:52 pm

Re: Problem in 3.5.6 performupgrade in file_caching migration

Post by lsmoker »

Could be related to changes in this commit -> https://gitlab.com/mayan-edms/mayan-edm ... f7525cc4d9

Edit: specifically, this line -> https://gitlab.com/mayan-edms/mayan-edm ... 607.py#L32
---
LeVon Smoker
User avatar
rosarior
Developer
Developer
Posts: 649
Joined: Tue Aug 21, 2018 3:28 am
Location: Puerto Rico
Contact:

Re: Problem in 3.5.6 performupgrade in file_caching migration

Post by rosarior »

Thanks for the report and research. Opened ticket 964 to work on this ASAP: https://gitlab.com/mayan-edms/mayan-edms/-/issues/964
Post Reply