How to import all the entrys from a guest book

[culda_a]

How to import all the entrys from a guest book (from an old version) in the new version 345 phpwcms?

is there a way?

[flip-flop]

via db update if it is the same db.
Or insert it into the table using phpmyAdmin.

Knut

[culda_a]

ok thank you , the update is out of the question, the way with using phpmyAdmin will be but can you explain how?

[flip-flop]

phpMyAdmin

If there is an empty table "phpwcms_guestbook" in your new db:

1. Old db:
- Export only the table "phpwcms_guestbook" into a file

2. New db:
- Import this file into the new db

Thats all.

[culda_a]

Ok I have done the export:

Code: Select all

-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 08, 2009 at 11:36 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `sctr_sana`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpwcms_guestbook`
--

CREATE TABLE IF NOT EXISTS `phpwcms_guestbook` (
  `guestbook_id` int(11) NOT NULL AUTO_INCREMENT,
  `guestbook_cid` int(11) NOT NULL DEFAULT '0',
  `guestbook_msg` text COLLATE latin1_general_ci NOT NULL,
  `guestbook_name` text COLLATE latin1_general_ci NOT NULL,
  `guestbook_email` text COLLATE latin1_general_ci NOT NULL,
  `guestbook_created` int(11) NOT NULL DEFAULT '0',
  `guestbook_trashed` int(1) NOT NULL DEFAULT '0',
  `guestbook_url` text COLLATE latin1_general_ci NOT NULL,
  `guestbook_show` int(1) NOT NULL DEFAULT '0',
  `guestbook_ip` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `guestbook_useragent` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `guestbook_image` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `guestbook_imagename` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`guestbook_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=38 ;

but when I go to guest book content is not showing... in the database is visible but in site not... what should I do?

In article content if I check is say " No guestbook entry available"
should I do something else?

[juergen]

stefan !

you did miss all the 38 entries of your book ... ONLY Data if book strctures are the same ...

[culda_a]

Can you explain me what you mean or what I have to do?

[flip-flop]

wiki: phpwcms_guestbook I don´t know your problems, it is not complicated.

This is the last posting to this topic of me. -> Please donate or provide an template to publish or whatever.

Knut

[culda_a]

hi Knut, no problem I can provide templates but where to send them?

[flip-flop]

.... but where to send them?

publish them in this forum
or
in your wiki (I supply an account to you if you would like)
or
via eMail to me. (I would publish them in your wiki).

Knut

[culda_a]

great I will do that, about the guest book belive me I have done the same like in the wiki , export the database, imported in the new database...all is fine in it but the problem is that is not appear in the guest book content part...it say that is no entry

[juergen]

... what about the id ? take a look or hire someone to do do ...

[culda_a]

I try to learn on this forum how to do things ... I see hat only you guys are forming now the real comunity around 10 people so that's why I ask you all this questions on forum not on getacoder.com, but thanks anyway

I will enter them again manualy.

[flip-flop]

Last sentences in wiki article

guestbook cp:
You find the associated alias-ID of a guestbook in the db table column guestbook_cid.

Ore
The alias-ID in your guestbook cp must be the same like the ID in the db table column guestbook_cid.
If in the db table column guestbook_cid more then one ID exist, you have more then one guestbooks in several contentparts.

Knut

[culda_a]

thank you I will try to see if I manage this