data import from geeklog to serendipity failed

[Guest]

Hi!

After reading about migration from geeklog 1.3.11 to serendipity 0.8 at phpkitchen.com, i did want to give it a try, too.

But unfortunately the impot of my geeklog database fails if using the import data function at the admin section off my fresh serendipity blog. You can look at a screenshot here. The following error is reported:

Table 'geeklog.serendipity_authors' doesn't exist

I think it's a permission problem of the MySQL-database User, isn't it? Where should this table exist or be placed?

Thank you for tips!

[garvinhicking]

The problem is that Serendipity 0.8 only supports importing Blogs frmo the SAME database as serendipity is in. If the source DB is different, s9y looks inside that DB for the s9y tables, and of course fails.

This issue has been fixed in Serendipity 0.9 already - but you can easily bypass this bug if you copy the tables of your geeklog DB to the s9y DB and then start the import from there. You can delete the geeklog tables after that, then.

Best regards,
Garvin

[geeklog]

Hi!

The problem is that Serendipity 0.8 only supports importing Blogs frmo the SAME database as serendipity is in. If the source DB is different, s9y looks inside that DB for the s9y tables, and of course fails.

First of all thank you for the answer, what a beautiful pain ...

OK, but how do i get the geeklog database tables in the serendipity database? Could i import an mysql-dump of the geeklog DB in serendipity anywhere? I am not allowed to use phpMyAdmin at my webserver, i have only shell access ...

This issue has been fixed in Serendipity 0.9 already - but you can easily bypass this bug if you copy the tables of your geeklog DB to the s9y DB and then start the import from there. You can delete the geeklog tables after that, then.

Is it a problem if i don't use the "gl_" prefix in my geeklog database for the import? And i am using some special plugins, so the DB differs from a normal fresh install, i think.

Best regards,
Garvin

bye, Miklas

[garvinhicking]

Hi!

First of all thank you for the answer, what a beautiful pain ...

[x] hurt me plenty

OK, but how do i get the geeklog database tables in the serendipity database? Could i import an mysql-dump of the geeklog DB in serendipity anywhere? I am not allowed to use phpMyAdmin at my webserver, i have only shell access ...

Yes, you could just make a SQL-Dump of the geeklog table, and then import that dump to your s9y table; with PMA it would be quite easy, but you can also do it with "mysqldump geeklog > geeklog.sql ; mysql serendipity < geeklog.sql". Or, if you have straight access to the mysql data dir, just copy geeklog/* to serendipity/.

Is it a problem if i don't use the "gl_" prefix in my geeklog database for the import? And i am using some special plugins, so the DB differs from a normal fresh install, i think.

The prefix doesn't matter, as long as you installed serendipity with a prefix - if you installed both without a prefix you might run into trouble if tables are named the same.

The import with geeklog has only been tested without plugins, so I can't tell you if the import works on a altered DB...

Regards,
Garvin

[Demian Turner]

Hi Miklas

> Hmm, i posted at the Installation forum here:
>
> data import from geeklog to serendipity failed
> http://www.s9y.org/forums/viewtopic.php?p=13014
>
> The answer from one serendipity developer tells me that i have to import
> the geeklog tables to the serendipity DB because the source DB hasn't to
> be different, otherwise the import fails in serendipity 0.8 (fixed in
> 0.9).
>
> How did you import your geeklog DB, did you copied the tables to teh
> serendipity DB?
>
that's funny, i used two different DBs. Using the s9y wizard I just entered the details for my remote phpkitchen database (s9y was running on localhost) and althought it took around 1 min it just worked! I had root privileges on both DBs and my geeklog DB looked like this:

Code: Select all

mysql> show tables;
+---------------------+
| Tables_in_geeklog   |
+---------------------+
| access              |
| article_images      |
| blocks              |
| commentcodes        |
| commentmodes        |
| comments            |
| commentspeedlimit   |
| cookiecodes         |
| custom_alexaranking |
| dateformats         |
| events              |
| eventsubmission     |
| featurecodes        |
| features            |
| frontpagecodes      |
| group_assignments   |
| groups              |
| links               |
| linksubmission      |
| maillist            |
| personal_events     |
| plugins             |
| pollanswers         |
| pollquestions       |
| pollvoters          |
| postmodes           |
| quote               |
| sessions            |
| sortcodes           |
| staticpage          |
| statuscodes         |
| stories             |
| storysubmission     |
| submitspeedlimit    |
| topics              |
| tzcodes             |
| usercomment         |
| userindex           |
| userinfo            |
| userprefs           |
| users               |
| vars                |
| weather             |
| weather_cache       |
| weather_forecast    |
+---------------------+
45 rows in set (0.00 sec)

for s9y i used the default settings, which was for tablenames with prefixes:

Code: Select all

mysql> show tables;
+-----------------------------+
| Tables_in_serendipity       |
+-----------------------------+
| serendipity_authors         |
| serendipity_category        |
| serendipity_comments        |
| serendipity_config          |
| serendipity_entries         |
| serendipity_entrycat        |
| serendipity_entryproperties |
| serendipity_exits           |
| serendipity_images          |
| serendipity_pending_authors |
| serendipity_plugins         |
| serendipity_references      |
| serendipity_referrers       |
| serendipity_shoutbox        |
| serendipity_spamblocklog    |
| serendipity_suppress        |
+-----------------------------+

> Not sure why your import didn't work, perhaps you customised some
> > tables or had extra tables? Mine was quite a stock install, only
> > customisations were custom blocks + themes.
>
> I dont use the "gl_" geeklog database prefix, could that be a problem? And
> yes, i think i have some extra tables, i.e the News plugin from
> squatty.com or the ban and HTTP-Referer plugin.
>
maybe try blowing away the additional plugins, i can't see why it wouldn't work for you if it worked for me

cheers

Demian