Re: MySQLdb connection error (Error:1064)
anatoly techtonik <[email protected]>
| Newsgroups | gmane.comp.bug-tracking.roundup.user |
|---|---|
| Message-ID | <CAPkN8xLnvoqXY_jpa-xbcfOVrdtuC9Vospy0LesRuQ5kW6fLog@mail.gmail.com> |
On Mon, Feb 11, 2013 at 2:58 PM, Ahsan <[email protected]> wrote: > Hi, > > When I run this command: /c:\Python27\Scripts\roundup-admin initialise/ > I got this error: > > */File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in > defaulterrorhandler > raise errorclass, errorvalue > _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 '_filename TEXT,_length REAL,_md5sum > TEXT,_name > TEXT,_type TEXT,id INTEGER PRIMAR' at line 1")/* > > I am configuring an already working Tracker, so I think this wont be the > issue of Syntax? > > I am using: > windows 7 (64 bit) > Python 2.7 > roundup 1.4.8 + local modifications > Mysql server 5.6 with also MySQLdb for python > > Anyone can guide me on right direction? why this error this coming out? > I don't know the reason, but I'd check: MySQLdb version vs MySQL version. Too new MySQL version. Error in your Roundup code. MySQL never worked with Roundup. -- anatoly t. ------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb _______________________________________________ Roundup-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/roundup-users