Page 2 of 3
Re: Cant Success While Transfreing Old DB Table
Posted: 24 May 2017, 11:47
by c a g a t a y
Is there anyone from Phoca developers?
I need an urgent help to migrate my phoca data to Joomla 3.7.x
Please
Re: Cant Success While Transfreing Old DB Table
Posted: 25 May 2017, 12:50
by c a g a t a y
Mr Jan
I need your urgent help. Are you busy?
Re: Cant Success While Transfreing Old DB Table
Posted: 28 May 2017, 13:40
by Jan
Hi,
I need your urgent help. Are you busy?
yes, my problem is, that I have my regular job, so hard to reach me in right time
Re: Cant Success While Transfreing Old DB Table
Posted: 28 May 2017, 16:12
by c a g a t a y
yes, my problem is, that I have my regular job, so hard to reach me in right time
Are you alone? No one else??
Please look here
viewtopic.php?f=2&t=57839&sid=c9f39ff21 ... 9f#p146304
Re: Cant Success While Transfreing Old DB Table
Posted: 29 May 2017, 10:52
by Jan
Hi, you need to work with the new table. When you migrate, then you should see the same date in new table like you have in old table. Then you can continue with changing the ordering (INSERT INTO ...)
So:
https://www.phoca.cz/development/50-joo ... o-joomla-3
When you make the export, then you need to change the sql which will import the items (from pp to p), so new table get the items.
Mostly the best way is to use other database or other prefixes.
Jan
Re: Cant Success While Transfreing Old DB Table
Posted: 29 May 2017, 10:54
by Jan
Hi, yes, these are free extensions made in free time (by me developer and Benno and Christine - testing, documentation, forum, ...)
see:
viewtopic.php?f=2&t=57839&p=146389#p146389
Jan
Re: Cant Success While Transfreing Old DB Table
Posted: 12 Jun 2017, 15:27
by c a g a t a y
Hi Jan
I am writing to you about one month
And I cant solve this issue
I cant transfer my PhocaGuestbook verison: 2.0.7 data to PhocaGuestbook verison: 3.0.6
I am losting my 10 years guesbook posts
Can i ask a unique question for you?
If i can send my old Phoca DB tables to you (via email) can you convert and send them ot me as a new table?
Is it possible? I think it is 30 mins time for you
Please...Please...Please...Please...Please...Please...
Best regards
Re: Cant Success While Transfreing Old DB Table
Posted: 13 Jun 2017, 22:58
by Jan
Hi, you can send me it but really no idea when I will be to take a look at it. It is not for 30 minutes as I don't have any 2.5 site running on my test site, etc. and unfortunately my time is very limited - I should release Phoca Cart stable in 2014 but it is still in RC version and my priority is to release the stable as soon as possible so I spend all my free time to finish it
Re: Cant Success While Transfreing Old DB Table
Posted: 20 Jun 2017, 10:37
by c a g a t a y
lets go step by step
avsr3_phocaguestbook_items (3.x table)
avsr3_ppphocaguestbook_items (2.5 table)
When i run this query:
Code: Select all
INSERT INTO `avsr3_phocaguestbook_items` (id, catid, parent_id, lft, level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time) SELECT id+1 AS id, 10013 AS catid, 1 AS parent_id, ordering AS lft, 1 AS level, username, userid, email, homesite, ip, title, content, date, published, checked_out, checked_out_time FROM `avsr3_ppphocaguestbook_items`
I am getting this error;
#1062 - Duplicate entry '6' for key 'PRIMARY'
Re: Cant Success While Transfreing Old DB Table
Posted: 21 Jun 2017, 16:28
by Jan
was your new table empty when crated (avsr3_phocaguestbook_items (3.x table))?