IMPORTANT MESSAGE REGARDING THE FORUM

As you may already know, the JoomlaWorks Forum is powered by Kunena (the only decent forum component for Joomla).

Unfortunately, the latest update for Kunena has seemingly broken all code snippets (old and new) in the forum.

Until this message is removed, please paste any code as regular text - in other words, don't use the [code]...[/code] tags in Kunena's post editor.

Keyword

1364 Field 'checked_out' doesn't have a default value

  • Massimo
  • Massimo's Avatar Topic Author
  • Offline
  • New Member
More
2 weeks 6 days ago #179466 by Massimo
Salve a tutti,
Utilizzo Joomla ( Joomla! 3.9.5 Stable [ Amani ] 9-April-2019 15:00 GMT ) e K2 (K2 v2.10.3)   con versione PHP 7.3.29 oramai da anni e tutto ha sempre funzionato benissimo quando improvvisamente e non so darmi spiegazioni, mi accade questo problema.
Facendo un checkup generale di sistema dal pannello controllo Joomla ho un blocco in " joso8_k2_items tabella".
Spuntando e chiedendo lo sblocco il sistema mi ritorna l'errore in oggetto ovvero
"1364 Field 'checked_out' doesn't have a default value".
Il risultato è che cliccando sui titoli degli articoli mostrati in una categoria ( ovviamente front end) mi da errore 404, come se l'articolo non esistesse.

Qualcuno sa darmi lumi in merito ?

Grazie anticipatamente per il cortese aiuto. 

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

More
2 weeks 13 hours ago #179490 by Fotis
My guess is that your hosting company performed some database upgrade causing these issues. Try upgrading K2 to v2.10.4 from getk2.org/downloads/?f=K2_Development_Release.zip as it will update some database columns to be compatible with newer versions of MySQL and MariaDB.

Additionally, I highly recommend you upgrade Joomla to v3.10.x as well. It's really safe to do so.

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Massimo
  • Massimo's Avatar Topic Author
  • Offline
  • New Member
More
1 week 5 days ago #179493 by Massimo
Many thanks for suggestions, I have updated both Joomla and k2 but still matter remains.
However even if it does not unlock table problem, links on titles work fine.
I think I just will ignore that in future.

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

More
1 week 3 days ago #179499 by Fotis
If you know how to use phpMyAdmin, load up your site's database and then open the schema for the xyz_k2_items table. In the table you'll see, it should mention a line for this column (checked_out). Can you take a screenshot and paste it back here?

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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


Powered by Kunena Forum