need help with joomlaboard

[Vera]

Hi,
I could really need some help. I've tried converting from my Joomlaboard forum (1.1.2 Stable) to my SMF forum 1.1 RC3. Since I didn't find any converter called Joomlaboard I downloaded the one called Simpleboard. It didn't work though, the converter couldn't find the settings for Simpleboard.

Therefore I followed an advice, that I received from another thread somewhere in this forum, that I should copy the configuration.php - file to the SMF-directory and write the path to this directory twice. Now the conversion worked but not perfectly. The posts were not converted and this it the most important thing to convert I think.

There was this message:

"This query:
INSERT INTO `vimammor_se`.smf_messages
(ID_MSG, ID_TOPIC, posterTime, SUBSTRING(m.subject, 1, 255), ID_MEMBER, posterName, posterEmail, posterIP, ID_BOARD, body, modifiedName, icon)...............................

Caused the error:

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 'SUBSTRING(m.subject, 1, 255), ID_MEMBER, posterName, posterEmail, posterIP, ID_B' at line 2".

AND I have another problem as well - the administration center has disappeared and doesn't show anymore when I log in as the admin.

Is there any way to fix this?? I don't know anything about My SQL...

Or is there a way to copy/convert the posts manually? If so I will simply try to uninstall everything and install it again. If not - I will have to satisfy with Joomlaboard...

best regards

[Vera]

Hi,
I read this tip in another forum. Do you think this could help? Of course I'd have to reinstall everything but I'm willing to give it another try:

"There is also a file in administrator/component/com_joomlaboard called joomlaboard_config.php.
What if you copy and rename this to simpleboard_config.php?"

hoping to get reply... 

[Oldiesmann]

The SQL error is a bug in the converter. I'll look at that in a minute.

[Vera]

Okay,
thanks for your reply!

[mivaho]

Hi,

Getting the same error for a simpleboard conversion. Did you have a change to look at it Oldiesmann?

Thnx,
Michel

[JayBachatero]

Try this one.

[mivaho]

Hi JayBachatero,

Thnx, worked like a charm. Have some errors on the avatars, but all messages are converted.

Michel

[JayBachatero]

What was the avatar error?

[Vera]

I will try it as soon as the possible, JayBachatero, and then get back to you.

[Vera]

Thank you!
It worked like a dream. I had no problem with the avatars...

One problem still remains though. The administrationcenter has disappeared and I can't administer the forum anymore   

Anyone got a great idea?

[Vera]

I just noticed that the posts are not possible to read! Between every word there is a (img width=). So it didnt' work like a dream after all 

[JayBachatero]

I'll look into this later on tonight or tomorrow.

[jjmaxi]

I have same problem like Vera 

[Hessix]

hey jayBachatero, your file is working very good, thx

[ockabewis]

Try this one.

The converter worked successfully for me, but all the messages got screwed up.  They all show up like this:

[img width=][img width=]pray[img width=]that[img width=]you[img width=]hav[img width=][img width=]b[img width=][img width=]n[img width=]bl[img width=][img width=][img width=][img width=]d[img width=]dur[img width=]n[img width=][img width=]th[img width=][img width=][img width=]P[img width=]al[img width=][img width=][img width=]and[img width=]Prov[img width=]rb[img width=][img width=]d[img width=]vot[img width=]on.[img width=]For[img width=]tho[img width=][img width=][img width=]that[img width=]hav[img width=][img width=][img width=]tuck[img width=][img width=]t[img width=]out,[img width=]you[img width=]hav[img width=][img width=]now[img width=]cr[img width=]at[img width=]d[img width=]a[img width=]\"hab[img width=]t\"[img width=]of[img width=][img width=]p[img width=]nd[img width=]n[img width=][img width=]t[img width=][img width=][img width=][img width=]w[img width=]th[img width=][img width=]od[img width=][img width=]ach[img width=]and[img width=][img width=]v[img width=]ry[img width=]day.[img width=][img width=][img width=][img width=]ncoura[img width=][img width=][img width=]you[img width=]to[img width=]cont[img width=]nu[img width=][img width=]your[img width=]da[img width=]ly[img width=]qu[img width=]t[img width=][img width=]t[img width=][img width=][img width=][img width=]w[img width=]th[img width=]th[img width=][img width=]Lord.

Any ideas?

P.S. - Oh, and it assigned the group value of 0 to all users including the admin.   I had to go in via phpMyAdmin and change the group id on the admin account back to 1 so I could get into the admin interface.

[BartTheDevil89]

Try this one.

The converter worked successfully for me, but all the messages got screwed up.  They all show up like this:

[img width=][img width=]pray[img width=]that[img width=]you[img width=]hav[img width=][img width=]b[img width=][img width=]n[img width=]bl[img width=][img width=][img width=][img width=]d[img width=]dur[img width=]n[img width=][img width=]th[img width=][img width=][img width=]P[img width=]al[img width=][img width=][img width=]and[img width=]Prov[img width=]rb[img width=][img width=]d[img width=]vot[img width=]on.[img width=]For[img width=]tho[img width=][img width=][img width=]that[img width=]hav[img width=][img width=][img width=]tuck[img width=][img width=]t[img width=]out,[img width=]you[img width=]hav[img width=][img width=]now[img width=]cr[img width=]at[img width=]d[img width=]a[img width=]\"hab[img width=]t\"[img width=]of[img width=][img width=]p[img width=]nd[img width=]n[img width=][img width=]t[img width=][img width=][img width=][img width=]w[img width=]th[img width=][img width=]od[img width=][img width=]ach[img width=]and[img width=][img width=]v[img width=]ry[img width=]day.[img width=][img width=][img width=][img width=]ncoura[img width=][img width=][img width=]you[img width=]to[img width=]cont[img width=]nu[img width=][img width=]your[img width=]da[img width=]ly[img width=]qu[img width=]t[img width=][img width=]t[img width=][img width=][img width=][img width=]w[img width=]th[img width=]th[img width=][img width=]Lord.

Any ideas?

P.S. - Oh, and it assigned the group value of 0 to all users including the admin.   I had to go in via phpMyAdmin and change the group id on the admin account back to 1 so I could get into the admin interface.

I've got the same probleme!

[BartTheDevil89]

I found an answer  :

Change

$row['body'] = preg_replace('~[img size=(\d+)]~i', '[img width=$1]', $row['body']);

into

$row['body'] = preg_replace('~\[img size=(\d+)\]~i', '[img width=$1]', $row['body']);

[JayBachatero]

Interesting.  I fix it locally and come to see that the answer was found .  SimpleBoard 1.0 & 1.1

[dpk]

thanks guys, this took care of it for me too. however, all the converted posts have backslashes (\) before all quotation marks and apostrophes. How can I fix that?

[JayBachatero]

Try using the converter in this topic: SimpleBoard 1.0 & 1.1.  Also did the admin account get transfered correctly?