COMMUNITY FORUM

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

Start
Prev
1
Next
End

Massimo
Topic Author
Offline
New Member

3 years 2 months ago #179466 by Massimo

1364 Field 'checked_out' doesn't have a default value was created 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.

JoomlaWorks
Offline
Admin

3 years 2 months ago #179490 by JoomlaWorks

Replied by JoomlaWorks on topic 1364 Field 'checked_out' doesn't have a default value

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
Topic Author
Offline
New Member

3 years 2 months ago #179493 by Massimo

Replied by Massimo on topic 1364 Field 'checked_out' doesn't have a default value

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.

JoomlaWorks
Offline
Admin

3 years 2 months ago #179499 by JoomlaWorks

Replied by JoomlaWorks on topic 1364 Field 'checked_out' doesn't have a default value

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.

Mark Schultz
Offline
Junior Member

3 years 1 month ago - 3 years 1 month ago #179565 by Mark Schultz

Replied by Mark Schultz on topic 1364 Field 'checked_out' doesn't have a default value

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?

Last edit: 3 years 1 month ago by Mark Schultz.

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

JoomlaWorks
Offline
Admin

3 years 1 month ago #179566 by JoomlaWorks

Replied by JoomlaWorks on topic 1364 Field 'checked_out' doesn't have a default value

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.

Mark Schultz
Offline
Junior Member

3 years 1 month ago #179567 by Mark Schultz

Replied by Mark Schultz on topic 1364 Field 'checked_out' doesn't have a default value

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.

JoomlaWorks
Offline
Admin

3 years 1 month ago #179575 by JoomlaWorks

Replied by JoomlaWorks on topic 1364 Field 'checked_out' doesn't have a default value

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.

Чирко Роман
Offline
New Member

3 years 1 month ago - 3 years 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: 3 years 1 month ago by Чирко Роман.

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

Start
Prev
1
Next
End

COMMUNITY FORUM

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

Attachments: