×
Kunena 6.0.1.1 released (09 Jul 2022)

The Kunena team has announce the arrival of Kunena 6.0.1.1 [K 6.0.1.1] which is now available for download as a native Joomla extension for J! 4.1.x. This version addresses most of the issues that were discovered in K 6.0.1.1 and issues discovered during the development stages of K 6.0

Question Getting strange errors on Kunena

More
4 weeks 7 hours ago - 4 weeks 6 hours ago #1 by billh210
I have run the diagnostics and cleaned the database but still getting errors, is there a way to export the messages and do a clean install?
What would cause this all of the sudden It has been working fine.
.ErrorDuplicate entry '0' for key 'PRIMARY

'ErrorException throw at line 668 in file /home/basctx/public_html/libraries/joomla/database/driver/mysqli.php with message 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 ' 'test')' at line 3

Now just got a new error

ErrorException throw at line 668 in file /home/basctx/public_html/libraries/joomla/database/driver/mysqli.php with message 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 ' 'I have expired the memberships early to prep the new site for registrations.\r' at line 3
Last edit: 4 weeks 6 hours ago by billh210.

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

More
3 weeks 6 days ago #2 by Leen
Is the joomla and kunena version and extensions and plug-ins completely up to date?.
And has something else been changed, eg a different PHP version has been set?

L.v.d.A

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

More
3 weeks 6 days ago #3 by billh210
Updated to the latest Kunena and running Joomla 3.10, just changed the php to 8.0

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

More
3 weeks 6 days ago #4 by Leen
was the problem not there with your previous php version ?

L.v.d.A

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

More
3 weeks 5 days ago #5 by billh210
Yes it was there, I updated to PHP 8 thinking that would fix it.

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

More
3 weeks 5 days ago #6 by rich
You can try following:
Important! First create a backup of your database!
Then download and install the extension Admin Tools . You just have to select UTF-8 Multibyte under "Change Database Collation" (it is already preset) and run it. After that (as recommended) click on "Repair & Optimise Tables".
 

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

More
3 weeks 5 days ago #7 by billh210
Tried that still getting an error
Error
Duplicate entry '0' for key 'PRIMARY'

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

More
3 weeks 4 days ago - 3 weeks 4 days ago #8 by Leen
Is the Error Reporting set to maximum in the Joomla site as well?
latest joomla version is 3.10.10. And sometimes also helps with Extensions: Update Sites right at number to everything and then check the box on the left to select everything and then click rebuild. after that click on update extensions clear cache and on new search to make sure everything is up to date
the problem with the website is that with a hoster or is it at a local server like Wamp or Xampp.
And do you sometimes use extra extensions or plug-ins such as JCH optimizer.
sometimes it can help if you also include your Report Configuration 
www.kunena.org/docs/en/manual/backend/to...report-configuration

L.v.d.A
Attachments:
Last edit: 3 weeks 4 days ago by Leen.

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.075 seconds