- Posts: 16
- Thank you received: 2
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
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
- NickJWStone
-
Topic Author
- Offline
- Junior Member
-
Less
More
13 years 10 months ago - 13 years 10 months ago #128157
by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
I am at the moment, will try it in Firefox right now
update: same error in Firefox
update: same error in Firefox
Last edit: 13 years 10 months ago by NickJWStone.
Please Log in or Create an account to join the conversation.
13 years 10 months ago #128161
by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
use this:
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 t.id!=t.poll_id AND p.id IS NULL
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 t.id!=t.poll_id AND p.id IS NULL
Please Log in or Create an account to join the conversation.
- NickJWStone
-
Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 16
- Thank you received: 2
13 years 10 months ago #128162
by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Gives the same error
#1062 - Duplicate entry '1-42' for key 'pollid'
Please Log in or Create an account to join the conversation.
13 years 10 months ago #128169
by 810
Replied by 810 on topic Upgrade from K2.0 to K.2.0.1 SQL failed
So did the poll worked on K2.0 or on K1.7
Please Log in or Create an account to join the conversation.
13 years 10 months ago #128173
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.
- NickJWStone
-
Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 16
- Thank you received: 2
13 years 10 months ago #128175
by NickJWStone
Replied by NickJWStone on topic Upgrade from K2.0 to K.2.0.1 SQL failed
Please Log in or Create an account to join the conversation.
Time to create page: 0.252 seconds