Halfway there in conversion

[geoffstr]

I actually got the conversion to start working.

Then I got this error message"

Converting...
Converting topics (part 2)... Unsuccessful!
This query:
UPDATE `screenpr_test`.screenpr_log_topics
SET ID_TOPIC = 452
WHERE tempID = 1162692822;
Caused the error:

Unknown column 'tempID' in 'where clause'

Can anyone help please?

Thanks

[JayBachatero]

[SMF Converter] Yabb - 2.1

[geoffstr]

Thanks for the reply.
Using the Yabb instead of the standard convert I received this error:

Converting topics (part 1)... Unsuccessful!
This query:
SELECT ID_BOARD, tempID
FROM `screenpr_test`.screenpr_boards
WHERE tempID != '';
Caused the error:

Unknown column 'tempID' in 'field list'


Your thoughts?

[JayBachatero]

You used the files that I linked to?  That should take care of that error.

[geoffstr]

Getting close!

Got most of the way through then received this error:

Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `screenpr_test`.screenpr_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2

[JayBachatero]

http://docs.simplemachines.org/index.php?topic=1079.0

[geoffstr]

Well, of course my host won't upgrade Mysql from version 5.0.45.

2 questions:

Where do I find the "upgrade_1_1.sql"?

Or better yet, I really don't care about bringing over thr YaBB smilies. IS there a way to bypass this so I can complete the transfer to SMF?

[JayBachatero]

Umm look for the string in convert.php and in the yabb21_to_smf.php files.

[geoffstr]

OK. Am I being really dense?

I searched in Convert.php & yabb_to_smf.php for the string:

upgrade_1_1.sql

..and could not locate it in the files.

[geoffstr]

I am still getting this error:

Converting...
Converting attachments (if the mod is installed)... Successful.
Cleaning up (part 1)... Successful.
Cleaning up (part 2)... Successful.
Converting polls and poll choices... Successful.
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `screenpr_test`.screenpr_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2


I could not find the "upgrade_1.1.sql" in either convert or the yabb convert files..

Can anyone help?

I'm so close I can taste it.

..and I really want to drop kick YaBB into the nearest garbage can!

[SleePy]

Common conversion errors.

[b4sakenxx]

Hi guys, I'm new to SMF and am trying to convert from YaBB2.1 as a test.  I am also getting the unknown tempID error like geoffstr did. 

--edit--
I'm trying to convert to 1.1.4 because thats what was on the site.  i don't know if this really has any bearing on it.  I had tried to use the standard converter and it never got past my personal messages.
---------

--EDIT--
The issues seems to have resolved itself after I ran the converter again.  ^_^

I am using the files attached in [SMF Converter] Yabb - 2.1 .  Any ideas or help would be much appreciated.  Thank you!

Converting topics (part 1)... Unsuccessful!
This query:
SELECT ID_BOARD, tempID
FROM `ibaraki_smf`.smf_boards
WHERE tempID != '';
Caused the error:

Unknown column 'tempID' in 'field list'

[JayBachatero]

Make sure that you overwrite the files and not resume.  That file should work.

[b4sakenxx]

--EDIT2--
Well it seems i can't get through these errors.  I found that someone had made another converter file that was supposed to take care of the dupilicate errors during poll conversion.  but when i tried it I got this error:

Converting topics (part 2)... Unsuccessful!
This query:

    ALTER TABLE `ibaraki_smf`.smf_log_topics
    ADD PRIMARY KEY (ID_TOPIC, ID_MEMBER),
    DROP COLUMN tempID;

Caused the error:

    Duplicate entry '267-196' for key 1


With the files at the beginning of the yabb2.1 to smf topic, I actually get to the posts conversions where i get the errors below.

I would greatly appreciate any ideas or help.


--Edit--

I did a search and came up with some old posts of the same issue.  will check them out.



well, just like geoffstr was, i am now soooo close.  haha.  unfortunately the conversion craps out at polls.  so far, each time i've come up with errors, all i had to do was rerun the converter, overwriting of course.

this time i get this error.

Converting poll votes... Unsuccessful!
This query:
ALTER TABLE `ibaraki_smf`.smf_poll_choices
ADD PRIMARY KEY (ID_POLL, ID_CHOICE);
Caused the error:

Duplicate entry '16777215-0' for key 1

i've rerun the coverter twice since this error came up and it always get stuck here.  any ideas?

[b4sakenxx]

I'm not terribly sure what the problem is, but I finally managed to get the forum converted.  Thanks for the tips and help along the way.

In the end I decided to just increase the cstep to skip whatever it was that was messing up.  the forum looks and works fine from what I can tell.
---

I guess my last question, since I already here, is whether or not it's possible to set board access based on age/gender, or if that is specific to YaBB?

[JayBachatero]

With SMF it's not possible to do this by default.  I believe there is a mod for this though.  THis one is a popular request for mods.  Take a look at the mod site and check there .

And welcome to SMF .