Wordpress Import II

Trench · Post by **Trench** » Wed Dec 01, 2004 2:29 am

I know I did this in a previous thread but it's been a while so I hope the mods won't mind me starting a new thread.

Anyway I downloaded the 11/30/04 snapshot and installed it with no problem. I'd also like to add that as someone who has used just about every blog platform s9y is the easiest to install.

I logged in and went to the import data function and was greeted with an error message. Screenshot. But that didn't stop me from importing. I added the WP sql dump to the S9Y database and imported the entries with no problems.

What has improved since the last time was that on the category pages they now "paginagte". Last time it was page 1 of 0.

Still some of the other bugs that I found the last time still exist.

After the entries are imported they are all closed to comments. I don't know if that's a bug or not but personally I'd prefer them to be open. I used the SQL query...

Code: Select all

UPDATE serendipity_entries SET allow_comments='true';

...to open up comments. I couldn't leave a comment however with out disabling the spam plugin. If I left it enabled I get the following message..
Screenshot.

The comment counter does not recognize the old comments. But does new ones.

When I left a comment on an old entry I would not receive an admin e-mail but I do on a new entry.

When I try to edit a comment new or old I get the following error message.

Code: Select all

Fatal error: Call to a member function on a non-object in /home/trench/public_html/s9y/include/functions_comments.inc.php on line 48

That's about all I can think of right now. I'm, going to leave it at up at http://s9y.thetrenchcoat.com and hopefully I can be of some assistance.

Post by **garvinhicking** » Wed Dec 01, 2004 12:07 pm

Hi!

Thanks a lot for your comments! I have fixed the RSS import foreach() error as well as the comment moderation screen.

The other things I have entered in our Bugtracker and assigned to evan; if you find further bugs, please add them here: http://sourceforge.net/tracker/index.ph ... tid=542822

Apart from that - the "cannot add comment" message from the antispam plugin was shown because you entered a comment which already existed in the database; duplicate comments are not allowed in the default setup of that plugin.

Thanks a lot for your help! Since you use our development version, we are very happy you try it out and live with the bugs you are facing. But we desperately work on getting those fixed, so I hope the ones left will be addressed soon!

Trench · Post by **Trench** » Wed Dec 01, 2004 3:22 pm

I turned off duplicate comments and it let me add coments to old entries with the spam plugin enabled.

Trench · Post by **Trench** » Wed Dec 01, 2004 6:21 pm

Ok, I found out why I wasn't receivng admin e-mails on old entries. When the Wordpress import was done it imported the user as "admin" since that what the main user is on Wordpress. I edited the user to reflect it as me and I receive the admin e-mails but now there are two seperate users with the same info.

Trench · Post by **Trench** » Thu Dec 02, 2004 2:04 am

Ok, I did another fresh install today of the 12/1/04 snapshot and imported my WP entries. Comments can now be edited. The new thing I found, and I did also post this at Sourceforge, was when I install the Statistics plug in it shows that every commenter is also a subscriber even though subcription is turned off. I don't know if someone commented on an entry if they would receive an e-mail or not. I don;t want to try and get a bunch of angry e-mails.

Is there an SQL query that would clear all subscriptions?

randybrown · Post by **randybrown** » Thu Dec 02, 2004 2:17 am

Trench - Could you explain what you entered into the "database host" field? I entered "localhost" - as my wp database is installed on the same server as my s9y test blog. s9y's WP import tool errors with msg: Import failed: COULDNT_COULDNT_SELECT_USER_INFO

Thanks.

Trench · Post by **Trench** » Thu Dec 02, 2004 2:36 am

Did you put the Wordpress SQL dump into the same database as Serendipity?

Guest · Post by **Guest** » Thu Dec 02, 2004 1:58 pm

Did you put the Wordpress SQL dump into the same database as Serendipity?

No. I attempted to access it from its original location (which is on the same host as the test s9y site/database).

I tried to locate documentation for this, but it isn't available. Suggestion: Place documentation on the import form, at the point where user requires it.

Can someone describe what is to be entered into the various fields in the WordPress import form?

TIA

randybrown · Post by **randybrown** » Thu Dec 02, 2004 2:39 pm

The last reply was from me (sorry, didn't log in first).

I'm not able to grok exactly what's to go in the fields for import. I looked at the source file, but it doesn't give me any clues.

Help?

Post by **garvinhicking** » Thu Dec 02, 2004 2:47 pm

Well, you need to fill into the fields the username, password, host etc. for the MySQL database to your Wordpress installation...so that Serendipity can create a connection to that Database.

Regards,
Garvin

randybrown · Post by **randybrown** » Thu Dec 02, 2004 3:35 pm

Well, you need to fill into the fields the username, password, host etc. for the MySQL database to your Wordpress installation...so that Serendipity can create a connection to that Database.

I've done that. It gives me an error.

Do I enter "localhost" for the host? If not, what?
Which username? The database or the WP admin?
Which password? The database or the WP admin?

Post by **garvinhicking** » Thu Dec 02, 2004 3:47 pm

Can't you just look up your wordpress configuration and see what's entered therE?

The host is the name of the machine where your wordpress machine runs on. That is often 'localhost', '127.0.0.1' or even the direct IP of the database.

Username is the one to MySQL.

Password is the one to MySQL.

So you only need MySQL data. (It says 'database Host', 'database User' and so on, so I do think it should be obvious that it's not related to any WordPress userdata?)

Hope that helps,
Garvin.

Trench · Post by **Trench** » Thu Dec 02, 2004 3:56 pm

Garvin, what about subscriptions? Is there a way to clear them all out? Thanks.

Update:Never mind. Fixed with SQL query...

Code: Select all

UPDATE serendipity_comments SET subscribed='false';

randybrown · Post by **randybrown** » Thu Dec 02, 2004 4:03 pm

Hi Garvin -

I had been using the WP config entries when reporting the error above. I did notice one problem with what I was entering: the table_prefix was incorrect. I changed that and got a little further.

But now I get the following error:

Import failed:

INSERT INTO serendipity_entries (title,isdraft,allow_comments,timestamp,body,authorid,last_modified,exflag,comments,author,moderate_comments) values ('UMW a proponent of learning objects', 'false', 'false', '1047741687', 'The University of Wisconsin at Milwaukee has been one of the leading proponents of the Learning Object concept.', '1', '1101999577', '0', '0', 'Randy Brown', 'false')

/ Table 'randy_wp.serendipity_entries' doesn't exist

It looks as though the script is trying to create an new table?

Post by **garvinhicking** » Thu Dec 02, 2004 5:05 pm

Ah, okay. I see - it seems to try inserting into a 'serendipity_entries' table inside the Database used for Wordpress.

So it seems to me there's a bug in the installer that doesn't switch to the s9y DB after reading an entry. I try to point tadpole to this thread, who wrote the migration stuff, and hope he can try to fix it.

As a temporary workaround, you could try to move/copy the WP-tables inside the Serendipity Database, so that they are the same...

Regards,
Garvin.

Wordpress Import II

Wordpress Import II

Re: Wordpress Import II