Vous n'êtes pas identifié(e).
- Discussions : Actives | Sans réponse
Annonce
Pensez d'abord à lire la FAQ, vous y trouverez probablement une solution à votre problème.
Pages : 1
#1 22-10-2023 17:12:29
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
#3 23-10-2023 20:19:32
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
#5 24-10-2023 10:32:07
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
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
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
Pages : 1