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 JDatabaseMySQL Error in jos_fb_subscriptions [FIXED]

More
16 years 3 months ago - 16 years 3 months ago #38142 by anditko
EDiT: A Fresh installation Fixed the bug!
Here is how i get this error.
1)I create a new topic and subscribe to it.
2)Then i delete the topic
3)Then i create another topic in the same category and if i have the subscribe checkbox i get an error:

500 - JDatabaseMySQL::query: 1062 - Duplicate entry '3-62' for key 'thread' SQL=INSERT INTO jos_fb_subscriptions (thread,userid) VALUES ('3','62')

Call stack
# Function Location
1 JSite->dispatch() index.php:68
2 JComponentHelper->renderComponent() includes\application.php:124
3 require_once() libraries\joomla\application\component\helper.php:162
4 include() components\com_kunena\kunena.php:578
5 JDatabaseMySQL->query() components\com_kunena\template\anditko_psp\post.php:572
6 JError->raiseError() libraries\joomla\database\database\mysql.php:231
7 JError->raise() libraries\joomla\error\error.php:171
8 JException->__construct() libraries\joomla\error\error.php:136


And here are some possible solutions:
1)In step 2 when a topic is deleted then we must remove the subscription entry as well.
2)Or use SQL UPDATE instead of SQL INSERT

Can someone fix this bug in the upcoming kunena version? :dry:
Last edit: 16 years 3 months ago by anditko. Reason: Bug fixedRe

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

More
16 years 3 months ago #38145 by xillibit
Hello,

I just tried to reproduce your issue on Kunena 1.5.9 and i can't.

I think that something is wrong in your kunena installation, it's impossible to have this mysql error because when you create an another topic the id is different, so i don't know where is your issue.

I don't provide support by PM, because this can be useful for someone else.

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

More
16 years 3 months ago #38290 by anditko
I installed a fresh version of kunena 1.5.9 and the bug was fixed. Thanx for leting me know that the problem was only on my site.

I edited my first post but you can delete it if you want.

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

Time to create page: 0.236 seconds