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

Error SQL syntax #10

Open
oculos opened this issue Mar 1, 2017 · 3 comments
Open

Error SQL syntax #10

oculos opened this issue Mar 1, 2017 · 3 comments

Comments

@oculos
Copy link

oculos commented Mar 1, 2017

I get the following error:

__main__ [status]: using python regex parsing code.
tosql.py:287: Warning: Field 'gender' doesn't have a default value
  connection_cursor.execute(build_insert_query(name, param_dict))
Traceback (most recent call last):
  File "tosql.py", line 550, in <module>
    billing_position}, skip_lookup = True, supress_output = True)
  File "tosql.py", line 287, in select_or_insert
    connection_cursor.execute(build_insert_query(name, param_dict))
  File "build/bdist.macosx-10.12-intel/egg/MySQLdb/cursors.py", line 205, in execute
  File "build/bdist.macosx-10.12-intel/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
_mysql_exceptions.ProgrammingError: (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 'character) VALUES (1, 1, 'Goth raver')' at line 1")

Any clue what I can do to fix it?

@LorenzBuehmann
Copy link

The converter is for SQLLite and PostgreSQL, not for MySQL databases.

@markjin1990
Copy link

Same problem here. Are you suggesting that this project is not yet ready for mysql? Thanks.

@ameerkat
Copy link
Owner

ameerkat commented Apr 3, 2017

I do have a MySQL converter, which was working previously. I'll take a look soon.

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

4 participants