Page 1 of 1
problem to migrate from 2.5 to 3.7.3
Posted: 13 Jul 2017, 20:42
by yades
Hi
T read this
https://www.phoca.cz/development/50-joo ... o-joomla-3
and I have an error message at step importing data.
#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 'phpMyAdmin SQL Dump
Thx for your help
Yades
Re: problem to migrate from 2.5 to 3.7.3
Posted: 13 Jul 2017, 23:11
by Jan
Hi, do you get some exact error message which includes the problematic SQL query code?
Jan
Re: problem to migrate from 2.5 to 3.7.3
Posted: 14 Jul 2017, 11:15
by yades
Hi jan
This is the fully error message
Requête SQL :
phpMyAdmin SQL Dump
-- version 4.4.15.7
--
http://www.phpmyadmin.net
--
-- Client : mysql55-151.perso
-- Généré le : Jeu 13 Juillet 2017 à 18:46
-- Version du serveur : 5.5.55-0+deb7u1-log
-- Version de PHP : 5.6.30-0+deb8u1
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
MySQL a répondu: Documentation
#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 'phpMyAdmin SQL Dump
-- version 4.4.15.7
--
http://www.phpmyadmin.net
--
-- Clien' at line 1
Re: problem to migrate from 2.5 to 3.7.3
Posted: 15 Jul 2017, 10:37
by yades
Hello
I posted fully error message getting from phpmyadmin. I'm not expert in this area. Is that message may help you to solve my problem?
Otherwise how to get exact error message which includes the problematic SQL query code
Yades
Re: problem to migrate from 2.5 to 3.7.3
Posted: 15 Jul 2017, 11:31
by yades
Hi folks
I solved this problem. Actually it was encoding issue and not phoca issue. I found with error message with google a forum which talks about this issue. i guess when I opened backup sql file with notepad to change prefix table, I had to modify encoding. So to fix the problem with notepad you "save as" with ANSI encoding and next when you import in new database, you select compatibility mpde ANSI. And it's perfect
Yades
Re: problem to migrate from 2.5 to 3.7.3
Posted: 19 Jul 2017, 17:51
by Jan
Ok