XMB 1.9 to phpbb

This is an archive of the phpBB 2.0.x convertors forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
prvul
Registered User
Posts: 3
Joined: Sun Jan 06, 2008 8:36 pm

XMB 1.9 to phpbb

Post by prvul » Fri Jan 18, 2008 2:59 am

I have used xmb2phpbb converter from http://sourceforge.net/project/showfile ... _id=170498. All goes well exept u2u(private messages) and attachments.
Errors i get are:

Code: Select all

Couldn't insert private message.
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'doogovorr', 45, 1, '1120739345', '504aa14a', 1, 0, 1, 0)' at line 2

INSERT INTO phpbb_privmsgs (privmsgs_id, privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_bbcode, privmsgs_enable_html, privmsgs_enable_smilies, privmsgs_attach_sig) 
					VALUES (3, , 'doogovorr', 45, 1, '1120739345', '504aa14a', 1, 0, 1, 0)
and for attachments (i have attachment mod installed) iget also lot of errors like those ones

Code: Select all

Trying to convert attachments...
Couldn't delete attachment descriptions
1146: Table 'hope.phpbb_attach_desc' doesn't exist

DELETE FROM phpbb_attach_desc


Couldn't delete attachment table
1146: Table 'hope.phpbb_attach' doesn't exist

DELETE FROM phpbb_attach

.
Couldn't insert Attachment description.
1146: Table 'hope.phpbb_attach_desc' doesn't exist

INSERT INTO phpbb_attach_desc (attach_id, attach_filename, download_count, filename, comment, mimetype, filesize, filetime) 
				VALUES (1, '36_1118648903.jpg', 289, '13.06.2005 9-29-56_0004.jpg', '', 'image/jpeg', 23222, '')


Couldn't insert Attachment data.
1146: Table 'hope.phpbb_attach' doesn't exist

INSERT INTO phpbb_attach (attach_id, post_id, privmsgs_id) VALUES (1, 153, 0)
I want to switch from xmb to phpbb3, is this the only way (xmb>phpbb2>phpbb3)?

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: XMB 1.9 to phpbb

Post by D¡cky » Fri Jan 18, 2008 4:35 am

At the present time, the only way to get from xmb to phpBB3 is to go xmb -> phpBB2 -> phpBB3.

The attachment conversion was written for a very old version of the Attachment MOD. It has not been updated for the newest version, so you will not be able to convert your attachments.

For the private messages, browse the xmb u2u table and look for u2uid 3. There should be a column named folder and a column named new. Let me know what those values are for the u2uid message 3.
Have you hugged someone today?

prvul
Registered User
Posts: 3
Joined: Sun Jan 06, 2008 8:36 pm

Re: XMB 1.9 to phpbb

Post by prvul » Fri Jan 18, 2008 11:11 am

I dont have message with u2uid in xmb_u2u table. Lowest u2uid is 4. Also there is no column new. This is all columns in xmb_u2u:
u2uid msgto msgfrom type owner folder subject message dateline readstatus sentstatus

Look at screenshoot in attachment.
Attachments
phpmyadmin.jpeg
phpmyadmin.jpeg (140.43 KiB) Viewed 759 times

Locked

Return to “[2.0.x] Convertors”