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 Cant open forum category after update (K1.7.1)

Baze
Topic Author
Offline
Premium Member

14 years 3 months ago #114835 by Baze

Replied by Baze on topic Re: Cant open forum category after update (K1.7.1)

With debugging enabled when i try to open category (from Index) I get the following error:

500 - JDatabaseMySQL::query: 1064 - 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 '--jos_kunena_categories WHERE id='29'' at line 1 SQL=SELECT parent FROM --jos_kunena_categories WHERE id='29'

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

Baze
Topic Author
Offline
Premium Member

14 years 3 months ago #114857 by Baze

Replied by Baze on topic Re: Cant open forum category after update (K1.7.1)

bump, i'm really stuck guys, any idea how can i sort this out?

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

xillibit
Offline
Administrator

14 years 3 months ago #114880 by xillibit

Replied by xillibit on topic Re: Cant open forum category after update (K1.7.1)

This kind of query is used in two places : kunena.php (408) and router.php (334), check in these files if there is a query looking liek :

Code:

SELECT parent FROM --jos_kunena_categories WHERE id

instead of

Code:

SELECT parent FROM #__kunena_categories WHERE id

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

The following user(s) said Thank You: Baze

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

Baze
Topic Author
Offline
Premium Member

14 years 3 months ago #114889 by Baze

Replied by Baze on topic Re: Cant open forum category after update (K1.7.1)

in kunena.php on line 408 i had

Code:

$kunena_db->setQuery ( "SELECT parent FROM --#__kunena_categories WHERE id='{$catid}'" );

in router.php i have

Code:

$quesql = 'SELECT parent FROM #__kunena_categories WHERE id=' . ( int ) $vars ['catid'];

i've changed the code in kunena.php to

Code:

$kunena_db->setQuery ( "SELECT parent FROM #__kunena_categories WHERE id='{$catid}'" );

but i still got the same error, i've enabled debugging again and i still see:

500 - JDatabaseMySQL::query: 1064 - 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 '--jos_kunena_categories WHERE id='66'' at line 1 SQL=SELECT parent FROM --jos_kunena_categories WHERE id='66'

is there any other file having this line??

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

Baze
Topic Author
Offline
Premium Member

14 years 3 months ago #114891 by Baze

Replied by Baze on topic Re: Cant open forum category after update (K1.7.1)

Now that's strange....after replying here i've opened the file kunena.php again and on line 408 i saw -- in front of the #__kunena_categories in the code

i've changed the code again saved the file, but on the next open, the code is there with --! Am i missing something?

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

Baze
Topic Author
Offline
Premium Member

14 years 3 months ago #114892 by Baze

Replied by Baze on topic Re: Cant open forum category after update (K1.7.1)

Oh yeah! It's working finally, after changing the file ownership and changing the code as instructed my forum is back online! Thank to everyone who helped!

btw, in the same file there is --# in front of several other lines, should i change them too??

i have:

Code:

line 581: $kunena_db->setQuery ( "SELECT thread FROM --#__kunena_messages WHERE catid='{$catid}' AND parent=0 AND thread NOT IN ({$readTopics})" );
line 585: $kunena_db->setQuery ( "UPDATE --#__kunena_sessions set readtopics='$readTopics' WHERE userid=$kunena_my->id" );
line 608: $query = "INSERT INTO --#__kunena_subscriptions_categories (catid, userid) VALUES ('$catid','$kunena_my->id')";
line 634: $query = "DELETE FROM --#__kunena_subscriptions_categories WHERE catid=$catid AND userid=$kunena_my->id";

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

Time to create page: 0.262 seconds