Importing Pmachine Pro 2.4 Comments

[coolcat]

The default Pmachine Pro 2.4 import tool works fine except that it did not import the comments along with the entries.

May I know if there is a script to import the comments? They are so precious to me and this is a big hurdle for me to make a total switch to Serendipity.

Thanks in advance.

Updates:

Discovered that the comments were not exported due to this error:

Starting import procedure...

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 5541 bytes) in /home/coolgal/public_html/serendipity/plugins/serendipity_event_s9ymarkup/serendipity_event_s9ymarkup.php on line 120

I wonder if there is anything else I can do about this since I do not own the webserver and thus have no access to the php.ini files.

[garvinhicking]

Hi!

Sadly it seems your pmachine installation is too large to be imported at once. If you cannot raise your memory limit of PHP, it will get a bit complicated.

I could offer you to import the thing on my s9y installation and then give you back a DB dump that you can use in your installation? Then I would just need the full DB dump of your pmachine DB (or at least the tables 'comments', 'weblog', 'categories', 'members').

Another way would be for you to split your DB into multiple smaller tables, but that would be a lot of work...

Best regards,
Garvin

[coolcat]

Thanks, Garvin for your kind offer. Much appreciated Anyway my hoster was kind to modify the php.ini for me and now the imports work fine - comments and all.

Now I have a different prob - most of the commentors are translated as anonymous (if they did not register as members on my site). It looks a comments table mapping problem, doesn't it?

[garvinhicking]

Hi!

Yes, it might be that the user names could not be resolved. To look into this, can you provide me a snippet of your 'categories' table and your 'members' table?

The code should actually mach the "member_id" column and cycle through all users to see if the "ID" matches the "member_id" and then fills in the "user_login" value.

Best regards,
Garvin

[coolcat]

Hi Garvin,

By snippet, do you mean the sample data or the table structure?

Here's the table structure for Categories, Members and Weblog with one sample data.

Categories Table
--------------------
id : 9
category : Tips
weblog : weblog

Members Table
------------------
id : 87
member_id : 273603019448fae0f71100
username : ratso
password : ebfc244661b66cc998c1f57b3c292cea
signature : ratso
email : ratso@ratso.com
location
url
occupation
interests
bio
bday_day
bday_month
bday_year
icq
aol_im
yahoo_im
msn_im
show_email : no
get_email : no
joindate : 1150313695
numentries : 0
numcomments : 0
lastpost : 0
status : 7
ipaddress : xxx.xxx.xxx.xxx
deft_weblog : weblog

Weblog Table
---------------
post_id
member_id
t_stamp
x_stamp
title
blurb
body
more
custom1
custom2
custom3
trackback
status
month
year
day
weblog
category
c_total
tb_total
pb_total
c_date
c_hits
m_hits
preview
showcomments
nl2brBlurb
nl2brBody
nl2brMore
nl2brC1
nl2brC2
nl2brC3
sticky
sent_pings

[garvinhicking]

Hi!

Ah, that information was useful. Now could you also send me an output like this for the "comments" table?

Best regards,
Garvin

[coolcat]

Here it is Garvin...

Comments Table
-------------------

comment_id : 3
post_id : 32
member_id : 1
t_stamp : 1068253221
body : Finished reading it the day before yesterday. Ove...
weblog : weblog
preview : 0
status : open
comment_ip

[garvinhicking]

Hi!

Oh, sorry, I'm afraid I wasn't that precise. Could you give me a dump of a comment which imports as "Anonymous" into serendipity?

And if you could check the correspondig "member_id" for that person? Because if non-users comment, I wonder where their author name is stored in pmachine!

Best regards,
Garvin