philipsoutham / py-mysql2pgsql

Tool for migrating/converting from mysql to postgresql.
http://packages.python.org/py-mysql2pgsql/
MIT License
455 stars 169 forks source link

AttributeError: 'NoneType' object has no attribute 'group' #97

Open GiperScriper opened 8 years ago

GiperScriper commented 8 years ago

Traceback (most recent call last): File "/usr/local/bin/py-mysql2pgsql", line 38, in mysql2pgsql.Mysql2Pgsql(options).convert() File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/mysql2pgsql.py", line 31, in convert Converter(reader, writer, self.file_options, self.run_options.verbose).convert() File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/lib/converter.py", line 22, in convert tables = [t for t in (t for t in self.reader.tables if t.name not in self.exclude_tables) if not self.only_tables or t.name in self.only_tables] File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/lib/converter.py", line 22, in tables = [t for t in (t for t in self.reader.tables if t.name not in self.exclude_tables) if not self.only_tables or t.name in self.only_tables] File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/lib/mysql_reader.py", line 200, in return (self.Table(self, t[0]) for t in self.db.list_tables()) File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/lib/mysql_reader.py", line 87, in init self._load_indexes() File "/usr/local/lib/python2.7/dist-packages/mysql2pgsql/lib/mysql_reader.py", line 162, in _load_indexes index['columns'] = [re.search(r'(\w+)', col).group(1) for col in match_data.group(2).split(',')] AttributeError: 'NoneType' object has no attribute 'group'

kworr commented 7 years ago

Please, add some MySQL schema examples showing what you are running into.