DB encodings vs Import [Was: Error (ERROR_OBSOLETE_DATA)]

stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 12:15

I've ran into an odd error, which seems to focus on accented characters.

Two times now I've migrated, both single user and multiuser (clean install both times), from Gallery 1 with the end result that the accented character in an album name becomes mangled.

When I try to fix it (edit album, change name), I got the following

Error Detail -
Error (ERROR_OBSOLETE_DATA) : UPDATE g2_Item SET g_title=? WHERE g_id=? (�gúst 2003-Bland í poka|10)

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 588 (GalleryStatus::error)
    * in modules/core/classes/GalleryStorage.class at line 142 (DatabaseStorage::saveEntity)
    * in modules/core/classes/GalleryEntity.class at line 294 (GalleryStorage::saveEntity)
    * in modules/core/classes/GalleryItem.class at line 409 (GalleryEntity_core::save)
    * in modules/core/ItemEditItem.inc at line 237 (GalleryItem_core::save)
    * in modules/core/ItemEdit.inc at line 95 (ItemEditItem::handleRequest)
    * in main.php at line 173 (ItemEditController::handleRequest)
    * in main.php at line 87
    * in main.php at line 80

The album name should be "
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Wed, 2005-09-07 12:20

@error obsolete data:
try: site admin -> maintenance -> delete db cache, it should solve it

@accent problems:
seems to an import / migrate from g1 issue.
hope jmullan knows more.
not sure if the db encoding is ok, maybe you should try an ascii encoded db.
 
stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 12:34

Delete DB cache worked it's magic.

Hope the accent problem doesn't give you too much of a headache
 
stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 13:38

Well I'll be...

I now installed this as a Multi-site album, got the error, tried the delete db cache and still the error persists

 Error (ERROR_OBSOLETE_DATA) : UPDATE g2_Item SET g_title=? WHERE g_id=? (�gúst 2003-Bland í poka|10)

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 588 (GalleryStatus::error)
    * in modules/core/classes/GalleryStorage.class at line 142 (DatabaseStorage::saveEntity)
    * in modules/core/classes/GalleryEntity.class at line 294 (GalleryStorage::saveEntity)
    * in modules/core/classes/GalleryItem.class at line 409 (GalleryEntity_core::save)
    * in modules/core/ItemEditItem.inc at line 237 (GalleryItem_core::save)
    * in modules/core/ItemEdit.inc at line 95 (ItemEditItem::handleRequest)
    * in main.php at line 173 (ItemEditController::handleRequest)
    * in main.php at line 87
    * in main.php at line 80
 
stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 13:41

The �? problem also appears in Images which start with an accented character

 Error (ERROR_OBSOLETE_DATA) : UPDATE g2_Item SET g_title=? WHERE g_id=? (� tívolí í Danmörku|50)

    * in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 588 (GalleryStatus::error)
    * in modules/core/classes/GalleryStorage.class at line 142 (DatabaseStorage::saveEntity)
    * in modules/core/classes/GalleryEntity.class at line 294 (GalleryStorage::saveEntity)
    * in modules/core/classes/GalleryItem.class at line 409 (GalleryEntity_core::save)
    * in modules/core/ItemEditItem.inc at line 237 (GalleryItem_core::save)
    * in modules/core/ItemEdit.inc at line 95 (ItemEditItem::handleRequest)
    * in main.php at line 173 (ItemEditController::handleRequest)
    * in main.php at line 87
    * in main.php at line 80
    * in /home/gunna/www/gallery/main.php at line 3

I'm going back to a single installation to see if that doesn't work
 
stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 13:55

I have managed a workaround.

I manually edit the album name in the database, clearing the uppercase accented letters, delete DB cache and then I can name the items with upper case accented letters!
 
stalfur

Joined: 2005-09-06
Posts: 6
Posted: Wed, 2005-09-07 15:17

I'm now testing with ascii encoded db and it's even worse, now æ and í become ?? and even if I can fix them after database cache clearance, they reset the next time I delete the cache, back to ??