Question Getting strange errors on Kunena

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

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?

Updated to the latest Kunena and running Joomla 3.10, just changed the php to 8.0

was the problem not there with your previous php version ?

Yes it was there, I updated to PHP 8 thinking that would fix it.

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".
 

Tried that still getting an error
Error
Duplicate entry '0' for key 'PRIMARY'

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

Wow, I had the opposite experience. None of my sites would upgrade through Joomla. I have spent the last 3 months rebuilding dozens of client sites from scratch in Joomla 4. The biggest issue is the mandatory images directory. I used a custom user data folder for all of my sites, and the mandatory image directory basically broke all of my websites. Also my third party extensions didn't all come up at the same time so the automatic updates never worked for me.