Page 1 of 1

Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 08 Dec 2012, 14:49
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

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 09 Dec 2012, 00:56
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:

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 09 Dec 2012, 02:39
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.

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 25 Dec 2012, 14:03
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

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 10 Feb 2021, 19:49
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?

Re: Export/Import Guestbook_items joomla 1.5 > 2.5

Posted: 10 Feb 2021, 20:15
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