Kunena 6.2.6 released

The Kunena team has announce the arrival of Kunena 6.2.6 [K 6.2.6] which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x. This version addresses most of the issues that were discovered in K 6.1 / K 6.2 and issues discovered during the last development stages of K 6.2

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question Upgrade from K2.0 to K.2.0.1 SQL failed

More
11 years 9 months ago #11 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
can you show the content from: kunena_polls table and kunena_polls_users table

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

More
11 years 9 months ago #12 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Poll worked on 2.0

Kunena Polls:


Kunena Polls users:
Attachments:

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

More
11 years 9 months ago #13 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
in the mean time you can make installation to succeed by removing that query from installer
administrator/components/com_kunena/install/kunena.install.upgrade.xml on your site
line 385+ contains this query

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

More
11 years 9 months ago #14 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
can you show the data not the table.

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

More
11 years 9 months ago - 11 years 9 months ago #15 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Sorry, didn't get that:

Kunena Polls seems empty:
SELECT*
FROM`*- _kunena_polls`
LIMIT 0 , 30

Kunena Polls users has the following:


Really appreciating your quick reply!
Attachments:
Last edit: 11 years 9 months ago by NickJWStone.

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

More
11 years 9 months ago #16 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Ok, so polls are messed up. It seems there is no data more. So remove all in Kunena Polls users . Then you can try to update again

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

More
11 years 9 months ago #17 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Same error after removal:

Query: UPDATE #__kunena_polls_users AS a INNER JOIN #__kunena_topics AS t ON t.id=a.pollid LEFT JOIN #__kunena_polls AS p ON p.id=a.pollid SET a.pollid=t.poll_id WHERE t.poll_id>0 AND p.id IS NULL

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

More
11 years 9 months ago #18 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
then remove the tables. and install again.

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

More
11 years 9 months ago #19 by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Just did that. Install succeful, although all avatars are (once again) gone?

Existing Poll is displayed although voting is not possible (poll doesn't exits, which is logis as I removed all content from database, but why displaying it?)

Thanks for your help sorting this out, I hope everything else is still working.

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

More
11 years 9 months ago #20 by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
What kind of integration do you use. Cb or jomsocial or only kunena.

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

Time to create page: 0.428 seconds