Keyword

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

  • Massimo
  • Massimo's Avatar Topic Author
  • Offline
  • New Member
More
1 year 3 months 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
1 year 2 months ago #179490 by JoomlaWorks
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.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Massimo
  • Massimo's Avatar Topic Author
  • Offline
  • New Member
More
1 year 2 months 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 year 2 months ago #179499 by JoomlaWorks
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?

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
1 year 2 months ago - 1 year 2 months ago #179565 by Mark Schultz
I also have this issue. I was able to workaround the issue by changing the default value of the checked_out field of the k2_items table from None to 0. See attached screenshot.  Is this a suitable solution?

 
Attachments:
Last edit: 1 year 2 months ago by Mark Schultz.

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

More
1 year 2 months ago #179566 by JoomlaWorks
It's fine :)

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

More
1 year 2 months ago #179567 by Mark Schultz
thanks. I am using MariaDB 10.3 in case that helps with a fix in the next release.

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

More
1 year 2 months ago #179575 by JoomlaWorks
Thank you. Noted.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Чирко Роман
  • Чирко Роман's Avatar
  • Offline
  • New Member
More
1 year 1 month ago - 1 year 1 month ago #179622 by Чирко Роман
Replied by Чирко Роман on topic 1364 Field 'checked_out' doesn't have a default value
yadi.sk/i/B1g9Fzq1PhR0dA
just set default value for colomn `checked_out`

Last edit: 1 year 1 month ago by Чирко Роман.

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


Powered by Kunena Forum