Support

 Hello,

This is just for your information... I have worked around the problem...

While trying to copy the my dev MySQL database from my workstation to a VM using Navicat I was unable to complete the migration due to a problem in the admintools tables.

MySQL reported:

[Err] [Dtf] 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 '
`created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`created_by` ' at line 10
[Err] [Dtf] Finished - Unsuccessfully

during the migration.

I have replicated by completely uninstalling AdminTools. deleting all adminTools tables, reinstalling AdmiTools and then migrating. So the problem occurs during the install of AdminTools.

I've worked around by uninstall admintools, migrating and then reinstalling on the VM.

So... just FYI.

Chris

Good to know. Thanks.

Strangely. I also migrated several sites on v2.5 and they worked fine so there must be a difference between the way data is stored on j2.5 and j3.

Very strange. It worked perfectly on all the j2.5 databases and only threw the error on the j3.3 database. I'll check to see if the v2.5 and v3 databases are both UTF8. That may have something to do with it but I suspect that you are right that it's a problem with Navicat. I had only sent the note to you because the problem only occurred on one DB and the only thing different about that db was that it contain a j3.3 install... I though that if you were doing something different on j3.3 you might want to know that there might have been a problem.

Thanks again for your response and keep up the great work on Akeeba and Admin tools. I would not want to deploy a joomla site without them!

Kind Regards
Chris