1. Vertabelo
  2. Questions
0
Résolu

MySQL generated SQL not importing - parse error on quotes

Eric Norton il y a 8 ans • mis à jour par Rafał Strzaliński (Senior Engineer) il y a 8 ans • 6

I'm trying to import sql generated from vertabelo and I'm getting parse errors on any columns that have been put into double quotations. This has changed because the generated files did not do this before. My model is set to Mysql 5.5 and I'm definitely importing into mysql 5.5.


Any one know what the deal is with this?

JE SUIS SATISFAIT
Évaluation de satisfaction
Note de satisfaction par Eric Norton il y a 8 ans
À l'étude
Rafał Strzaliński (Senior Engineer) il y a 8 ans
Résolu
Rafał Strzaliński (Senior Engineer) il y a 8 ans

Hi,


This is a bug. Thanks for the report. We'll fix it ASAP.


Workaround: Please find&replace double quotes '"' with backquote '`' by hand. If your're *nix user please

run command:

sed -i -e 's/"/`/g' create.sql




Eric Norton il y a 8 ans

Thanks!

Rafał Strzaliński (Senior Engineer) il y a 8 ans

Hi,


The fix is availabe on production.


Vish Sab il y a 8 ans

The fix did not work. I tried with sql exported from mysql.

Rafał Strzaliński (Senior Engineer) il y a 8 ans

Hi Vish,


Could you tell us more about what is not working for you? I've imported script generated by vertabelo without any problems.

Service d'assistance aux clients par UserEcho