hello all,
I've downloaded tp9 and am attempting to convert tp7 MYSQL db to tp9. in doing this, I'm getting the below error message (partial since I hit the 5000 character limit). any thoughts on how to fix this.
======================================================
Opening database for conversion.
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
[Microsoft][ODBC Driver Manager] Function sequence error
[Microsoft][ODBC Driver Manager] Function sequence error
Identifying database...
Database server type is MySQL.
Mappings: {u'TEXT': u'longtext', u'COUNTER': u'int(11) not null primary key auto_increment', u'FLAG': u'bit', u'INT64': u'bigint(20)', u'DATE': u'varchar(32)', u'ID': u'int(11)', u'INT32': u'int(11)', u'INT16': u'smallint(5)', u'BIN64': u'tinyblob', u'BLOB': u'longblob', u'WCHAR': u'varchar'}
Removing pre-v7 cruft.
Exec (nocheck): drop table [ActiveUsers]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"ActiveUsers"' at line 1
Exec (nocheck): drop table [CurrentUsers]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"CurrentUsers"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"CurrentUsers"' at line 1
Exec (nocheck): drop table [Logins]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"Logins"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"Logins"' at line 1
Exec (nocheck): drop table [DoesPathHaveThumbs]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"DoesPathHaveThumbs"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"DoesPathHaveThumbs"' at line 1
Exec (nocheck): drop table [GalleryThumbStart]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"GalleryThumbStart"' at line 1
<1064•42000>
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]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 '"GalleryThumbStart"' at line 1
Exec (nocheck): drop table [GetThumbnail]
[MySQL][ODBC 5.3(a) Driver][mysqld-5.6.20]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use nea
Best Regards,
David Meinert