Skip to content

MySQL vendor table option AUTO_INCREMENT causes syntax error #301

Closed
rncain opened this Issue Feb 24, 2012 · 0 comments

2 participants

@rncain
rncain commented Feb 24, 2012

Version: 1.6.3
MySQL Version: 5.1.58
PHP Version: 5.3.6

Description:

When a mysql schema table is defined with:


propel-gen insert-sql causes syntax error

Expected:
Generation is successful

Actual:
An error is thrown - [propel-sql-exec] 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 ''100000'' at line 37

Note:
In generator/lib/platform/MysqlPlatform.php quotes parameter values
Removing the quoting seems to work for this parameter

@rncain rncain added a commit to rncain/Propel that referenced this issue Feb 25, 2012
@rncain rncain Issue #301 Fix MySQL quote issue for table options 53c437d
@willdurand willdurand closed this in 841448e Mar 5, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.