Hi,
Our website is on Joomla 4.4.1 and since our migration there's a problem in the database.
When I look in Maintenance-Global Check-in there's a record available on jos_abbook table
But when I select to check it in, it throws an error message
An error has occurred.
1292 Truncated incorrect DECIMAL value: ''
When I am working with the component, many of the titles/headers are not correct and when we store anything in the database it throws an error as well, though most of the values are stored.
Is there something I can do to fix this database error ?
Thnx in advance !!!
Hi,
may be the charset of the old database differs from the charset of the new database. Try to do the migration again paying attention to the charset type.
Hi Frederica,
We migrated a few months ago and it took a lot of time and energy.
Everything if working fine now except for Abook.
As I really do not feel comfortable about doing this migration once again, is there maybe another option to solve this ?
I don't understand in which field the error occurs. Please send me a screenshot of the error.
Image 1 - Global Check In (https://www.dropbox.com/scl/fi/buayfd6zvgp03ctjccdcv/Abook_001.jpg?rlkey=76raseqbby1z69ndh83bah416&dl=1)
Image 2 - Global Check In (https://www.dropbox.com/scl/fi/86yfqdpxakiv74n8ui4cs/Abook_002.jpg?rlkey=t6e2lax5jl13taraaimilyj4h&dl=1)
Image 3 - Category Issue (https://www.dropbox.com/scl/fi/1yk7kw332ccg9ae57yu2v/Abook_003.jpg?rlkey=wzpabjlkk8jel9gvz9uzpwwg3&dl=1)
Image 4 - Category Issue (https://www.dropbox.com/scl/fi/xtkos0eztbcnqnv3vy2oi/Abook_004.jpg?rlkey=u1nb7jgaxk4yjgvpepqjhz1o8&dl=1)
Image 5 - Book Issue (https://www.dropbox.com/scl/fi/t57eonb4tldr9jciv3qjo/Abook_005.jpg?rlkey=ygs4d9v5j0qc7l3sydkb90til&dl=1)
Image 6 - Book Issue (https://www.dropbox.com/scl/fi/lx5didfq1sfnt15b7j3hu/Abook_006.jpg?rlkey=p5g9st08bm4qp8rf32gfhpo42&dl=1)
Hi,
I fixed the translation file, the error was caused by some carriage returns which I have now removed.
Please, try to install the latest beta version but take a backup before updating it.
To allow me to better understand the error "1292 Truncated incorrect DECIMAL value: ''" you have to enable joomla debug then send me a screenshot of the full error. May be a numeric field is empty but the error does not specify the name of field.
Goodmorning Federica,
I took some snapshots from the error 1292 Global CheckIn error
You can find those here :
Error 1292 Global CheckIn 001 (https://www.dropbox.com/scl/fi/9zrplbj1r7h73ca1asbcj/Debug-Global-CheckIn-001.jpg?rlkey=fes7xuqx2an1qdd8r88qyblyw&dl=1)
Error 1292 Global CheckIn 002 (https://www.dropbox.com/scl/fi/lpjxgzco8zbqeu862iiyx/Debug-Global-CheckIn-002.jpg?rlkey=yhr8ee3q7wzbism33wrk4d8h4&dl=1)
And I installed this translation file sample_abook_zz_zz_language_pack_4_0_2 as 4_0_2 is the beta version.
But this doesnot solve the problem yet ...
I hope the debug info is what you are looking for, please let me know if you need more / something else !
There are two problem: one related to translation file and the other related to a database field. Let's start with the first one.
Quote from: Healing Beyond Medicine on 11 December 2023, 09:40:45And I installed this translation file sample_abook_zz_zz_language_pack_4_0_2 as 4_0_2 is the beta version.
But this doesnot solve the problem yet ...
sample_abook_zz_zz_language_pack_4_0_2 is not a valid language but only a sample useful to create a real language file.
Uninstall it.
You have to install the latest abook 4.0.2beta instead.
Check if administrator/language/en-GB/en-GB.com_abook.ini exists. If yes, rename this file or move it.
Alright !!!
Installed the new beta version component, module and plugins.
Checked the administrator but no en-GB.com_abook.ini exists in administrator/language/en-GB/
The issues in the component itself are solved now.
Changes can be saved without error messages, all headers look fine.
The global checkIn however, is still throwing the same errorMessage.
Great! Let's go on to the second problem.
Go to the book list then check which book have a lock (padlock icon), write down the ID. Important: you don't have to click on the padlock.
Look for this ID in the database in #__abbook table (replace "#_" suffix with your suffix). Send me an export of this row.
Super !!!
The padlocks were visible on two books
ID 47 Sacred Circuitry (=name of the book)
ID 175 Alien Event (=name of the book)
I don't know how to export only 2 rows from the book DataBase, so exported the complete book in SQL (approx. 200 records)
abook in SQL (https://www.dropbox.com/scl/fi/2bbc9jifo5fpyvm8hp9cu/jos_abbook.sql?rlkey=tcua6re1zjddzl0b0i6tjmyi5&dl=1)
In your database the "id" field of table jos_abbook is not AUTO_INCREMENT.
This could be a problem when joomla try to reset the lock of book.
Try to set the "id" field of table jos_abbook as AUTO_INCREMENT.
When I take a look in the database, the ID Fields states AUTO_INCREMENT
ID field (https://www.dropbox.com/scl/fi/9bir9jokpfqviwxuxoae3/ID-Field-Auto_Increment.jpg?rlkey=s8hlpm5f7maao0f6y6su3ihbm&dl=1)
This is what you mean, right ?
You are right, in your export the AUTO_INCREMENT is applied at the end of the file. Sorry but I had not seen it.
Try to click the padlock icon of the books "Sacred Circuitry" and "Alien Event". Let me know if some error occurs.
YESSSSSSS !
That worked :-)
I just opened the books and saved them again... the padlock disappeared as well as the global check-in message.
You made my day, Federica!
Thank you so much for your support!
Much love
~ Philip
:) good!
If you want to try another test, you have to open a book and then close the browser without saving. The padlock icon should appear again. Then click on the padlock icon to unlock the book and check that everything is OK.
Yes, I followed your script to the letter and that test works fine too
Very good!