Cant Success While Transfreing Old DB Table

[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

[c a g a t a y]

Mr Jan
I need your urgent help. Are you busy?

[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

[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

[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

[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

[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

[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

[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'

[Jan]

was your new table empty when crated (avsr3_phocaguestbook_items (3.x table))?