solved - Migration to Joomla 2.5 / problem with SQL update

Phoca Gallery - image gallery extension
Ulli Rühl
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 26 Oct 2012, 15:18
Location: Solms, Germany
Contact:

solved - Migration to Joomla 2.5 / problem with SQL update

Post by Ulli Rühl »

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
, but I get the following error message:
Image

Does anyone have an idea what I'm doing wrong. Or how can I fix it? :idea: :cry:

In Phoca Guestbook I had no problems. The migration went very well with no problems. :D

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: solved - Migration to Joomla 2.5 / problem with SQL upda

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply