Migrating to new hosting

vasiliyb

Joined: 2006-07-18
Posts: 41
Posted: Wed, 2008-02-20 15:51

Hello!
I was migrated to new server, moved all files and database with same account data. Gallery works, i can enter to Admin section, but if i tryed to make new album or any other operations - i see error:
Database Error
An error has occurred while interacting with the database.

The exact nature of database errors is not captured unless Gallery debug mode is enabled in config.php. Before seeking support for this error please enable buffered debug output and retry the operation. Look near the bottom of the lengthy debug output to find error details.
Back to the Gallery

Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1092 (GalleryCoreApi::error)
in modules/core/classes/GalleryStorage.class at line 513 (GalleryStorageExtras::removeMapEntry)
in modules/core/classes/GalleryCoreApi.class at line 2904 (GalleryStorage::removeMapEntry)
in modules/core/classes/GalleryDataCache.class at line 755 (GalleryCoreApi::removeMapEntry)
in modules/core/classes/helpers/GalleryItemHelper_medium.class at line 1043 (GalleryDataCache::removePageData)
in modules/core/classes/helpers/GalleryEventHelper_simple.class at line 131 (GalleryItemHelper_medium::handleEvent)
in modules/core/classes/GalleryCoreApi.class at line 2247 (GalleryEventHelper_simple::postEvent)
in modules/core/classes/GalleryEntity.class at line 308 (GalleryCoreApi::postEvent)
in modules/core/classes/GalleryItem.class at line 409 (GalleryEntity::save)
in modules/core/classes/helpers/GalleryItemHelper_advanced.class at line 473 (GalleryItem::save)
in modules/core/classes/GalleryCoreApi.class at line 1641 (GalleryItemHelper_advanced::createAlbum)
in modules/core/ItemAddAlbum.inc at line 76 (GalleryCoreApi::createAlbum)
in main.php at line 199 (ItemAddAlbumController::handleRequest)
in main.php at line 87
in main.php at line 80
System Information
Gallery version 2.1.1
PHP version 5.2.0-8+etch10 apache2handler
Webserver Apache/2.2.3 (Debian) PHP/5.2.0-8+etch10
Database mysql 5.0.32-Debian_7etch5-log
Toolkits Gd
Operating system Linux frus2 2.6.18-6-686 #1 SMP Sun Feb 10 22:11:31 UTC 2008 i686
Browser Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; MRA 4.10 (build 01952); .NET CLR 1.1.4322)

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Wed, 2008-02-20 21:53

From the error message it suggests you turn debug on FAQ: How to set/use Gallery in debug mode? and try to reproduce the error, attaching the debug output to the forums ( no need for the smarty debug popup info)

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
vasiliyb

Joined: 2006-07-18
Posts: 41
Posted: Thu, 2008-02-21 18:25

Thanks!
Debug info in attachment, help me please, 2 years of work in this gallery:(

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Thu, 2008-02-21 20:55

Is that all there is? only 2 pages.
What are the steps you are taking and what is the result. Please be as detailed as possible.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
vasiliyb

Joined: 2006-07-18
Posts: 41
Posted: Fri, 2008-02-22 05:18

I was tried to make some operations and Debug Output with my comments in attachment. As variant, may be faults assigned with ubnormal rights for script on new hosting?

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Fri, 2008-02-22 08:57

From your eror log:

Quote:
1142: DELETE command denied to user 'web18'@'localhost' for table 'g2_CacheMap'

See if phpMyAdmin will help with a repair of this table.

Quote:
As variant, may be faults assigned with ubnormal rights for script on new hosting?

I don't understand the question.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
vasiliyb

Joined: 2006-07-18
Posts: 41
Posted: Sun, 2008-02-24 13:17

Thank you!
I receive answer from new hosting support "Sorry, this was my mistake.
DELETE is now enabled."
Now all is working!!

 
vasiliyb

Joined: 2006-07-18
Posts: 41
Posted: Thu, 2008-04-10 04:55

Hello again!

I have another trouble with moved gallery to new host. Now i tried and can't replace default icons(thumbs) for videos for my custom icons. Before it was without any errors.. I don't know where trouble and i don't know what i need to write to my new hoster.

Please, read attach with debug info, may be you can help me as before..

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Mon, 2008-04-14 17:12

Please start a new thread and state what steps you are doing to reproduce.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team