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 Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"

More
15 years 5 months ago #68904 by sozzled
Replied by sozzled on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
There you go! We have the cause, the effect and the remedy. All that's needed now is the implementation strategy which, in this case, requires a change to the webhosting provider. I think this now resolves the issue. Good luck. :)
Blue Eagle vs. Crypsis reference guide
Read my blog and
[img

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

More
15 years 5 months ago #68946 by PaulyPaul
Replied by PaulyPaul on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
Changing hosting provider is easier said then done sozzled!

I accept the Kunena team won't change the code but can I test hacking it by adding the SET SQL_MAX_JOIN_SIZE=# statement somewhere?

Would anyone be so kind to say where that somewhere should be?

Cheers!

Paul

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

More
15 years 5 months ago #70437 by PaulyPaul
Replied by PaulyPaul on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
Any help with my request above? I can't accept the only fix is to change hosting provider as this would surely be a problem with many shared hosting services?

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

More
15 years 5 months ago #70447 by xillibit
Replied by xillibit on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
I don't know where is the issue, maybe you have just a table corrupted, i do'nt know.

Can-you put the result of SHOW VARIABLES LIKE 'max_join_size'; in phpmyadmin ?

You can set SET SQL_BIG_SELECTS=1, just before the annoying query to see if it's works better...
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
15 years 5 months ago #70770 by PaulyPaul
Replied by PaulyPaul on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
Hi xillibit,

The result of SHOW VARIABLES LIKE 'max_join_size'; was

max_join_size = 900000

When you refer to "annoying query" above, what do you mean?

Rgds

Paul

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

More
15 years 5 months ago #70772 by fxstein
Replied by fxstein on topic Re: Kunena Internal Error - "500 - JDatabaseMySQL::query: 1104"
How big is your forum?

This setting already allows for 900,000 records in a single join. Do you have more than 900,000 posts/topics?

This might indeed be a corrupted database. When did you first start using Kunena or Fireboard? What was the first version?
We love stars on the Joomla Extension Directory . :-)

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

Time to create page: 0.251 seconds