Author Topic: tp7 to tp9 conversion  (Read 2542 times)

0 Members and 1 Guest are viewing this topic.

wingfield

  • Full Member
  • ***
  • Posts: 59
    • View Profile
tp7 to tp9 conversion
« on: 2014-08-27 21:04:53 »
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