Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Question Convert SMF 1.1.10 to Kunena 1.5.6

More
16 years 5 months ago - 16 years 5 months ago #32396 by ormuz
Replied by ormuz on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
it works! thanks a lot

But i'm losing 2000 messages, the script give me this error:
Code:
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 '' at line 1

Any idea?
Last edit: 16 years 5 months ago by ormuz.

Please Log in or Create an account to join the conversation.

More
16 years 5 months ago #32397 by mythus
Replied by mythus on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
Greetings,

You need to open up your .sql file containing your messages and search for all '' entries and remove em. For somereason it hates those because it interputs those as code or whatnot. For example, my site is Legends of Nor'Ova. Well I had to go in and remove all ' in the database to make it read NorOva instead.

Once doing that, try again and it should work. It's a pain, but hey... at least there's a way to convert :).

Please Log in or Create an account to join the conversation.

More
16 years 5 months ago #32398 by ormuz
Replied by ormuz on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
mythus wrote:

Greetings,

You need to open up your .sql file containing your messages and search for all '' entries and remove em. For somereason it hates those because it interputs those as code or whatnot. For example, my site is Legends of Nor'Ova. Well I had to go in and remove all ' in the database to make it read NorOva instead.

Once doing that, try again and it should work. It's a pain, but hey... at least there's a way to convert :).


The only " I have is in all the others sql files too, smf_users, smf_categories ...etc

Is this
Code:
SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

I think I can't remove that...

Please Log in or Create an account to join the conversation.

More
16 years 5 months ago #32401 by mythus
Replied by mythus on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
No, you can't remove that.

I am willing to be it is finding a '' in smf_messages. Probably a ' that got changed into '' by the wonderful database demons.

Please Log in or Create an account to join the conversation.

More
16 years 5 months ago #32531 by StAlex
Replied by StAlex on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
ormuz wrote:

Any idea?

Please, send a full stdout of script. May be it contain full SQL-instruction. It can help to find solution for you.

Please Log in or Create an account to join the conversation.

More
16 years 5 months ago #32871 by admiral_trigger_happy
Replied by admiral_trigger_happy on topic Re:Convert SMF 1.1.10 to Kunena 1.5.6
mythus wrote:

No, you can't remove that.

I am willing to be it is finding a '' in smf_messages. Probably a ' that got changed into '' by the wonderful database demons.


I tried to do a conversion and got a similar problem

The export is putting '' (two separate inverted commas) where it finds a ' in the body text when I exported my tables too.

I'm did a find replace for '', to qqw, then I did a find replace '' to \' and I did a find replace for qqw, back to '',
(I'm pretty sure the '', is supposed to be like that thats why I changed them to something else then back)

Hopefully this will fix it, I'll report back

Please Log in or Create an account to join the conversation.

Time to create page: 0.654 seconds