Export/Import Guestbook_items joomla 1.5 > 2.5

Phoca Guestbook - creating guestbooks in Joomla! CMS
kitevik
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 08 Dec 2012, 14:10

Export/Import Guestbook_items joomla 1.5 > 2.5

Post by kitevik »

Hi there,
i tried to export my items with phpadmin from my old phocaguestbook (joomla 1.5) to the new one in Joomla 2.5 , but it dont works...
Mysql say: #1062 - Duplicate entry '3' for key 'PRIMARY'

Can somebody tell me what im doing wrong? Thank you for your patience.
Kitevik
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Post by Jan »

Hi, seems like you are trying to import some items which are in the database included, so the tables should be empty before importing :idea:
If you find Phoca extensions useful, please support the project
kitevik
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 08 Dec 2012, 14:10

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Post by kitevik »

I tried a lot of things. .... i just want to now if it is possible, to pass the old stuff to the new book....but in a easy way, without knowledge from a programer. I show you the 2 EXPORT sqls : (first the old, than the new one)>>>

-- phpMyAdmin SQL Dump
-- version 3.4.7
--
-- Host: localhost
-- Erstellungszeit: 08. Dez 2012 um 13:27
-- Server Version: 5.5.28
-- PHP-Version: 5.2.17-0.dotdeb.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `usr_web694_1`
--

--
-- Daten für Tabelle `jos_phocaguestbook_items`
--

INSERT INTO `jos_phocaguestbook_items` (`id`, `catid`, `sid`, `username`, `userid`, `email`, `homesite`, `ip`, `title`, `content`, `date`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`) VALUES
(3, 1, 0, 'Jan', 0, '', '', '80.38.166.66', 'Wieder im kalten D', '<p>Vielen Dank für die nette Betreuung bei Euch, wir werden Euch weiterempfehlen.</p><p>Jan und Clemens </p>', '2008-11-29 16:20:18', 1, 62, '2011-10-17 12:15:12', 2, ''),
(4, 1, 0, 'Lisa', 0, '', '', '80.38.1 (and so on, finaly: than:)
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

NEW:
-- phpMyAdmin SQL Dump
-- version 3.4.7
--
-- Host: localhost
-- Erstellungszeit: 08. Dez 2012 um 13:26
-- Server Version: 5.5.28
-- PHP-Version: 5.2.17-0.dotdeb.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `usr_web694_5`
--

--
-- Daten für Tabelle `jo256_phocaguestbook_items`
--

INSERT INTO `jo256_phocaguestbook_items` (`id`, `catid`, `sid`, `username`, `userid`, `email`, `homesite`, `ip`, `title`, `alias`, `content`, `incoming_page`, `date`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 1, 0, 'Ute und Karin', 0, '', '', '188.85.176.40', 'Urlaub Januar 2012', 'urlaub-januar-2012', '<p>War super bei Euch.<img src="media/editors/tinymce/jscripts/tiny_mce/plugins/emotions/img/smiley-kiss.gif" alt="Kiss" title="Kiss" /></p>', '', '2012-11-30 15:53:38', 1, 0, '0000-00-00 00:00:00', 1, '', 'de-DE');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
it would be gently if you help me. maybe ill do an other one.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47794
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Post by Jan »

Did you follow this guide:
https://www.phoca.cz/documents/50-phoca/ ... -joomla-25

It is step by step how I did

Jan
If you find Phoca extensions useful, please support the project
User avatar
bodine
Phoca Newbie
Phoca Newbie
Posts: 2
Joined: 10 Feb 2021, 19:31

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Post by bodine »

Hello,

I am wondering if it is possible to export-import guestbook items from version 1.5.3 to 3.0.11 from a back up saved to disk.

Or should I start a new topic for this question?
christine
Phoca Hero
Phoca Hero
Posts: 2710
Joined: 28 Nov 2010, 17:20

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Post by christine »

Hi,

Joomla 1.5 is very outdated and also Joomla 2.5. No more Core updates and Security Releases for these versions.

How to migrate extensions from Joomla 1.5 to Joomla 2.5
https://www.phoca.cz/documents/50-phoca ... -joomla-25

How to migrate extensions from Joomla 2.5 to Joomla 3
https://www.phoca.cz/documents/50-phoca ... o-joomla-3

Migration Joomla 1.5 to 3.X
https://docs.joomla.org/Joomla_1.5_to_3 ... _Migration

Kind regards
Christine
Post Reply