Global Check-in | jos_abbook table

Started by Healing Beyond Medicine, 30 November 2023, 15:45:31

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9
Print
Go Down Pages1 2 3
User actions

Healing Beyond Medicine

30 November 2023, 15:45:31
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 !!!
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

#1
01 December 2023, 18:49:24
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.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

Healing Beyond Medicine

#2
05 December 2023, 15:31:14
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 ?

federica

#3
05 December 2023, 17:07:19
I don't understand in which field the error occurs. Please send me a screenshot of the error.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

#5
08 December 2023, 19:44:24
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.
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

Healing Beyond Medicine

#6
11 December 2023, 09:40:45
Goodmorning Federica,

I took some snapshots from the error 1292 Global CheckIn error
You can find those here :
Error 1292 Global CheckIn 001

Error 1292 Global CheckIn 002


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 !
Print
Go Up Pages1 2 3
User actions