solved - Migration to Joomla 2.5 / problem with SQL update
Posted: 26 Oct 2012, 15:47
Hello,
first i will say sorry, for my english. German is better and Goole Tranlate is helping me.
I migratet my jommla 1.5 to 2.5 with the tool "jupgrade". Then install latest version of the wonderfull Phoca Gallery. Now I tried to update the SQL entries, as described in
Does anyone have an idea what I'm doing wrong. Or how can I fix it?
In Phoca Guestbook I had no problems. The migration went very well with no problems.
Regards
Ulli
I had previously tried to export the SQL data on my PC, Renaming, and then import the SQL data using PHPMyAdmin. Then I was always displayed an error, I had various attempts. Finally, I got the error shown above.
After hours long been Googling, I found the solution.
The solution:
- In the new SQL table (eg j25_phocagallery) see if entries are available
- If so, delete this. The table must be empty
- From the old table (eg jos_phocagallery) the entries to the clipboard
- All entries beginning with jos_ rename junction 25
- Copy the modified entries in the new database using SQL (j25_phocagallery)
- beeing Happy
I hope, the solution is helpfull for others.
regards
Ulli
first i will say sorry, for my english. German is better and Goole Tranlate is helping me.
I migratet my jommla 1.5 to 2.5 with the tool "jupgrade". Then install latest version of the wonderfull Phoca Gallery. Now I tried to update the SQL entries, as described in
, but I get the following error message:
Does anyone have an idea what I'm doing wrong. Or how can I fix it?
In Phoca Guestbook I had no problems. The migration went very well with no problems.
Regards
Ulli
I had previously tried to export the SQL data on my PC, Renaming, and then import the SQL data using PHPMyAdmin. Then I was always displayed an error, I had various attempts. Finally, I got the error shown above.
After hours long been Googling, I found the solution.
The solution:
- In the new SQL table (eg j25_phocagallery) see if entries are available
- If so, delete this. The table must be empty
- From the old table (eg jos_phocagallery) the entries to the clipboard
- All entries beginning with jos_ rename junction 25
- Copy the modified entries in the new database using SQL (j25_phocagallery)
- beeing Happy
I hope, the solution is helpfull for others.
regards
Ulli