ERROR_STORAGE_CONNECTION while importing from Coppermine

iyiinsan

Joined: 2007-10-10
Posts: 4
Posted: Wed, 2007-10-10 20:15

I'm trying to import a Coppermine gallery to Gallery 2, and I'm getting the above error:

Quote:
Error Detail -
Error (ERROR_STORAGE_CONNECTION)

* in modules/cmmigrate/classes/CmDatabaseTools.class at line 343 (GalleryCoreApi::error)
* in modules/cmmigrate/classes/CmDatabaseTools.class at line 110 (CmDatabase::getCategories)
* in modules/cmmigrate/classes/CmDatabaseTools.class at line 148 (CmDatabaseTools::getAlbums)
* in modules/cmmigrate/ChooseCmObjects.inc at line 134 (CmDatabaseTools::getAlbumsSorted)
* in modules/cmmigrate/ChooseCmObjects.inc at line 93 (ChooseCmObjectsView::_createCmAlbumTree)
* in modules/core/SiteAdmin.inc at line 201 (ChooseCmObjectsView::loadTemplate)
* in modules/core/classes/GalleryView.class at line 300 (SiteAdminView::loadTemplate)
* in main.php at line 441 (GalleryView::doLoadTemplate)
* in main.php at line 94
* in main.php at line 83

System Information
Gallery version 2.2.3
PHP version 5.2.3 cgi-fcgi
Webserver Apache/2.0.54 (Unix) PHP/4.4.7 mod_ssl/2.0.54 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2
Database mysqli 5.0.24a-standard-log
Toolkits ImageMagick, NetPBM, Gd
Operating system Linux culligan 2.4.32-grsec+f6b+gr217+nfs+a32+fuse23+tg+++opt+c8+gr2b-v6.194 #1 SMP Tue Jun 6 15:52:09 PDT 2006 i686
Browser Mozilla/5.0 (Macintosh; U; Intel Mac OS X; en; rv:1.8.1.6) Gecko/20070809 Camino/1.5.1

I've done a Google search but couldn't find anything useful. Is there any way to solve this?

Thanks...
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Thu, 2007-10-11 14:36

i'd enable buffered debug mode to see more details about the error.
FAQ: How to set/use Gallery in debug mode?

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage
 
iyiinsan

Joined: 2007-10-10
Posts: 4
Posted: Thu, 2007-10-11 17:08

I did it, and I think this is the problem:

Quote:
Check the version of the cmmigrate plugin The version of the cmmigrate plugin is ok file_exists(/home/.mister/iyiinsan/thelike.iyiinsan.net/gallery2/modules/cmmigrate/ChooseCmObjects.inc) mysql error: [2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] in CONNECT(localhost, ?, ?, ) mysql error: [2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)] in EXECUTE("SELECT cid, name, description, parent FROM cpg_categories")

This is the whole text: http://thelike.iyiinsan.net/debug.txt
 
iyiinsan

Joined: 2007-10-10
Posts: 4
Posted: Thu, 2007-10-11 18:17

After looking at that output, I thought that it might have something to do with the Coppermine gallery, and found that it was infact a database problem from Coppermine's side. I tweaked some settings, and it now works.
 
armin2302

Joined: 2007-10-21
Posts: 9
Posted: Fri, 2007-11-02 06:57

Hi,
I am getting the same error. What did you do to make it work? I really dont want to import 700MB of pictures and a whole set of directories by hand :) Would be great if you could help.

Thanks
 
iyiinsan

Joined: 2007-10-10
Posts: 4
Posted: Fri, 2007-11-02 22:12

The gallery was not only on coppermine, but it was also on another server, in my situation. I imported the database of coppermine to my server, changed the mysql settings, and it was all OK.
 
robinart

Joined: 2008-01-13
Posts: 3
Posted: Sun, 2008-01-13 17:39

Changed mysql settings in what way? I'm having problems using this module, too.