Page 1 of 1
How to import all the entrys from a guest book
Posted: Tue 6. Oct 2009, 23:04
by 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?
Re: How to import all the entrys from a guest book
Posted: Wed 7. Oct 2009, 11:49
by flip-flop
via db update if it is the same db.
Or insert it into the table using phpmyAdmin.
Knut
Re: How to import all the entrys from a guest book
Posted: Thu 8. Oct 2009, 08:31
by culda_a
ok thank you , the update is out of the question, the way with using phpmyAdmin will be but can you explain how?
Re: How to import all the entrys from a guest book
Posted: Thu 8. Oct 2009, 13:18
by 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.
Re: How to import all the entrys from a guest book
Posted: Thu 8. Oct 2009, 18:43
by 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?
Re: How to import all the entrys from a guest book
Posted: Thu 8. Oct 2009, 19:10
by juergen
stefan !
you did miss all the 38 entries of your book ... ONLY Data if book strctures are the same ...
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 08:39
by culda_a
Can you explain me what you mean or what I have to do?
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 13:30
by 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
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 17:45
by culda_a
hi Knut, no problem I can provide templates but where to send them?
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 17:51
by 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
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 18:05
by 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
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 18:43
by juergen
... what about the id ? take a look or hire someone to do do ...
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 18:48
by 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.
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 19:02
by 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
Re: How to import all the entrys from a guest book
Posted: Fri 9. Oct 2009, 19:20
by culda_a
thank you I will try to see if I manage this