Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Syntax Error during migration after updating to 3.6.3 #189

Closed
cakleimeier opened this issue Jul 25, 2019 · 0 comments
Closed

SQL Syntax Error during migration after updating to 3.6.3 #189

cakleimeier opened this issue Jul 25, 2019 · 0 comments

Comments

@cakleimeier
Copy link

cakleimeier commented Jul 25, 2019

Description

When running the ./craft migrate/all command, I get the following error when the migration runs for a Maps field inside a Matrix:

- Create content column for Location (Address) in matrix day
    > alter column field_day_dayAddress in table {{%matrixcontent_itinerary}} to {{%content}} ...Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`content`' at line 1
The SQL being executed was: ALTER TABLE `matrixcontent_itinerary` CHANGE `field_day_dayAddress` `field_day_dayAddress` `content` 

Note that the handle of the Matrix field is "itinerary," the handle of the block is "day", the handle of the Maps field is "dayAddress", and the name of the Maps field is Location (Address).

Steps to reproduce

  1. Update Maps via composer
  2. Run ./craft migrate/all

Additional info

  • Craft version: 3.1.34
  • Maps version: 3.5.2
  • PHP version: 7.3.7
  • Database driver & version: MySQL 5.7.26
  • Other Plugins:
@Tam Tam closed this as completed in 277563e Jul 30, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant