iGalerie

Vous n'êtes pas identifié(e).

Annonce

Un message d'erreur qui s'affiche ? Un mot de passe oublié ? L'ajout de fichier qui ne marche pas ?
Pensez d'abord à lire la FAQ, vous y trouverez probablement une solution à votre problème.

#1 22-10-2023 17:12:29

Knut
Membre
Lieu : Norway
Inscription : 27-12-2013
Messages : 75
Site Web

upgrade from 3.0.18 to 3.0.19-21 failing

I have tried to upgrade manually from 17 to 21 directly and the album front page is ok, but can not load images.
So I went back to versjon 17 and upgraded to  18. This worked well.
Then I upgrade from 18 to 19 and I got failure again. Even though in all occations the script report successful transfer.
I have other albums where the upgrade to version 21 has no issues. So the issue is with one larger ablum.
Here the last failure report from versjon 18 of the album which will not go to version 19-21.
Help appreciated.
Knut

#47
Dato : 2023-10-22 14:55:58.257064
iGalerie : 3.0.17
PHP : 7.4.33
Type : PHP_EXCEPTION
Fil : index.php
Ligne : 22
Side : album/54/tags/1904,29,23,1508
Meldinger : Undefined class constant 'TPL_REGEXP'

#46
Dato : 2023-10-04 17:13:25.809263
iGalerie : 3.0.17
PHP : 7.4.33
Type : PHP_NOTICE
Fil : includes/core/Parents.class.php
Ligne : 234
Side : item/24172-tommerflotingens-siste-ar/images/46
Meldinger : Undefined offset: 63
Trace : #1 index.php(15): Gallery::start()#2 includes/gallery/classes/Gallery.class.php(682): require_once('/home/varteigh/...')#3 includes/gallery/item.php(15): GalleryItems::getInfos()#4 includes/gallery/classes/GalleryItems.class.php(463): Parents::settings(Array)
#45
Dato : 2023-10-04 12:11:37.908720
iGalerie : 3.0.17
PHP : 7.4.33
Type : PHP_NOTICE
Fil : includes/core/Parents.class.php
Ligne : 234
Side : item/10976-med-fast-grunn-under-fottene
Meldinger : Undefined offset: 46
Trace : #1 index.php(15): Gallery::start()#2 includes/gallery/classes/Gallery.class.php(682): require_once('/home/varteigh/...')#3 includes/gallery/item.php(15): GalleryItems::getInfos()#4 includes/gallery/classes/GalleryItems.class.php(463): Parents::settings(Array)

Hors ligne

#2 23-10-2023 19:09:08

gilisa
Membre
Lieu : Région parisienne (sud)
Inscription : 23-04-2012
Messages : 227
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

Hi Knut,

For you what does it mean "larger album" ? Size of file or number of file ?
How files do you have in the larger album ?

Regards.
GGA.

Hors ligne

#3 23-10-2023 20:19:32

Knut
Membre
Lieu : Norway
Inscription : 27-12-2013
Messages : 75
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

Hi gilisa
The database is about 26 Mb and I think 16000 records.
I believe there is a database issue since all other albums I have had no problems with the upgrade.
After the upgrade I can not see all records in the database using DB browser.
The problem album is originally from version 2 migrated to sqlite database.
I have backup  for version 17 and are using this.
Knut

Hors ligne

#4 23-10-2023 21:35:23

gilisa
Membre
Lieu : Région parisienne (sud)
Inscription : 23-04-2012
Messages : 227
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

Hi Knut,
When you migrate from V2 to V3 you migrate from mysql to sqlite ?
GGA.

Hors ligne

#5 24-10-2023 10:32:07

Knut
Membre
Lieu : Norway
Inscription : 27-12-2013
Messages : 75
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

Yes I did.
I noticed when I check the copy of the db-file after update to version .21 that there is a new table (Selection) added to the database.
The problem db-file has then only 50 % record available when I browse data in SQLite Studio. And when I do a 'vacuum' command to check the file I get an error saying database diskimage is malformed.
error message
[10:15:45] Error while executing SQL query on database 'sqliteProblem': database disk image is malformed

When I do an integrity check on the running copy of my db (before upgrade) I get this output from SQLite Studio which I may be need to correct.
*** in database main ***
On tree page 10074 cell 3: invalid page number 218103808
On tree page 10043 cell 50: 2nd reference to page 14885
Page 6911 is never used
Page 13319 is never used
There seem to be an issue her. I am not sure how to correct and see the problem in SQLite Studio.


I have even tried DBbrowser for SQLite software and ran the before upgrade db file
Execution finished without errors.
Result: 1 rows returned in 743ms
At line 1:
PRAGMA integrity_check;

and

Execution finished without errors.
Result: 0 rows returned in 956ms
At line 1:
PRAGMA foreign_key_check;

So this software does not find issues in the not upgraded db.

If I run the 'problem db file' on the same software I get
no issues with interity check
but for foreign_key_check I get this
Execution finished with errors.
Result: database disk image is malformed
At line 1:
PRAGMA foreign_key_check;

I data  view mode for table items I get 'loading' or now view of records after line 7310

Thanks for giving me feedback on my problem
Knut

Dernière modification par Knut (24-10-2023 10:49:36)

Hors ligne

#6 25-10-2023 12:24:05

Knut
Membre
Lieu : Norway
Inscription : 27-12-2013
Messages : 75
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

I managed to rebuild the sqlite.db file to a database without issues.

I exported the version igalerie 17 file to a new database file using a sql export file.
The sql file was imported to a new database and used to upgrade to version 21 and this worked.
Knut

Hors ligne

#7 25-10-2023 13:22:39

gilisa
Membre
Lieu : Région parisienne (sud)
Inscription : 23-04-2012
Messages : 227
Site Web

Re : upgrade from 3.0.18 to 3.0.19-21 failing

Great to fix your trouble.
Very often when the database is corrupted the migration does not work.
When I migrate form V2 to V3 my database was corrupted I just use phpmyadmin
to fix my trouble and the migration was done.
Your web site is very interesting and very good job.

Hors ligne

Pied de page des forums