just now,i upgrade my G2 to Nightly Build "gallery2-2004-11-10.tar.gz",when i into the "site admin",have error.
Error (ERROR_STORAGE_FAILURE)
* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 720 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (mysqldatabasestorage::search)
* in modules/core/classes/Gallery.class at line 176 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryToolkitHelper_medium.class at line 543 (gallery::search)
* in modules/core/classes/GalleryCoreApi.class at line 1839 (gallerytoolkithelper_medium::getredundantpriorities)
* in modules/core/module.inc at line 475 (gallerycoreapi::getredundanttoolkitpriorities)
* in modules/core/SiteAdmin.inc at line 74 (coremodule::getsiteadminviews)
* in modules/core/classes/GalleryView.class at line 245 (siteadminview::loadtemplate)
* in main.php at line 281 (siteadminview::doloadtemplate)
* in main.php at line 47
* in main.php at line 40
Posted: Thu, 2004-11-11 07:55
Posts: 7994
Did you remember to delete all of your G2 data and reinstall completely from scratch when you installed the new version? We don't yet provide a G2 -> G2 upgrade path (though that's coming soon). Read the "upgrading" section of the README for more details.
Posts: 17
oh,i already read the "README" file,but i can't delete all my data,because i upload a lot of photos in my gallery. watting for the G2->G2 upgrade path.....thanks!
Posts: 7994
We won't be providing an official upgrade path from the alpha version of G2 you're using now (which is why we tell you not to store anything in G2 yet that you're not willing to delete). Depending on what version you were using before, you can probably do some table alteration SQL to get most of the way there yourself. Look around in this forum -- there have been some recent topics on do-it-yourself upgrading.
Posts: 154
A good tip someone here mentioned a while ago was to upload all pics to a g1 instal, then when reinstalling g2 do the migrate from g1>g2
That way your pics are always in the g1 install, if you need to kill g2 and reinstal it.
Posts: 17
my first version is G2.......
Posts: 17
i have renname g2_TkOperationMap to g2_TkOperatnMap,
g2_TkOperationMimeTypeMap to g2_TkOperatnMimeTypeMap,g2_TkOperationParameterMap TkOperatnParameterMap
now i can into "Site Admin",but i found other problem after i rename those table done
i can't active the modules and can't set the "default sort oder,default layout and the default theme"
screenshot:
http://www.supercn.net/General.png
http://www.supercn.net/Modules.png
Posts: 3
Maybe try setting buffered debug and see if there's some info there?
Look in config.php, change...
$gallery->setDebug(false); --> $gallery->setDebug('buffered');
Then revisit those pages and see if any useful info.
Also, when I started having template caching issues, someone pointed me toward the test harness page. You'll need your setup pass from config.php to enter. You'll find it at [yourGalleryURL]/lib/tools/test/
Try FluchCache and FlushTemplates
Just grasping at straws here :\
Posts: 17
Smarty Debug Console :
included templates & config files (load time in seconds):
gallery:templates/error.tpl (0.18670) (total)
gallery:templates/debug.tpl (0.18192)
assigned template variables:
{$SCRIPT_NAME} /main.php
{$l10Domain} modules_core
{$main} Array (5)
error => Error (ERROR_STORAGE_FAILURE)<UL><LI...
debug => file_exists(/***/***/***...
markupType => bbcode
validationUri => http%3A%2F%2Fwww.supercn.info%2Fmain....
gallery => Array (1)
version => 2.0-alpha-3 (Farva)
assigned config file variables (outer template scope):
{#files#} Array (0)
{#vars#} Array (0)
------------------------------------------------------------------------
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 362 (gallerystatus::error)
in modules/core/classes/GalleryStorage.class at line 113 (mysqldatabasestorage::loadentities)
in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 89 (gallerystorage::loadentities)
in modules/core/classes/GalleryCoreApi.class at line 2009 (galleryentityhelper_simple::loadentitiesbyid)
in modules/core/classes/GalleryView.class at line 313 (gallerycoreapi::loadentitiesbyid)
in modules/core/ShowItem.inc at line 44 (showitemview::_getitem)
in modules/core/classes/GalleryView.class at line 209 (showitemview::getthemename)
in main.php at line 281 (showitemview::doloadtemplate)
in main.php at line 47
in main.php at line 40
Gallery Debug Output
file_exists(/***/***/***/gallery2/photodata/sessions/25e4146611f2f9b78ce194e8436c6478)
clearstatcache()
filesize(/***/***/***/gallery2/photodata/sessions/25e4146611f2f9b78ce194e8436c6478)
fopen(/***/***/***/gallery2/photodata/sessions/25e4146611f2f9b78ce194e8436c6478,
rb, 0)
flock(Resource id #17, 6, )
fread(Resource id #17, 3941)
flock(Resource id #17, 3, )
fclose(Resource id #17)
[1100188085] can't guarantee 5 -- extending!
file_exists(/***/***/***/gallery2/photodata/cache/entity/0/0/5.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
file_exists(/***/***/***/gallery2/photodata/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/../../../modules/core/ShowItem.inc)
file_exists(/***/***/***/gallery2/photodata/cache/module/core/0/0/0.inc)
file_exists(/***/***/***/gallery2/photodata/cache/entity/0/0/6.inc)
--------------------------------------------------------------------------------
(mysql): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN ('6')
--------------------------------------------------------------------------------
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/comment/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/gd/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/imageframe/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/imagemagick/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/members/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/migrate/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/netpbm/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/register/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/remote/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/search/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/helpers/../../../../modules/uploadapplet/module.inc)
file_exists(/***/***/***/gallery2/modules/core/classes/GalleryAlbumItem.class)
mysql error: [1054: Unknown column 'g2_AlbumItem.g_theme' in 'field list']
in EXECUTE("SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp,
g2_Entity.g_isLinkable, g2_Entity.g_linkId,
g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber,
g2_Entity.g_entityType, g2_ChildEntity.g_parentId,
g2_FileSystemEntity.g_pathComponent, g2_Item.g_canContainChildren,
g2_Item.g_description, g2_Item.g_keywords, g2_Item.g_ownerId,
g2_Item.g_summary, g2_Item.g_title, g2_Item.g_viewedSinceTimestamp,
g2_AlbumItem.g_layout, g2_AlbumItem.g_theme, g2_AlbumItem.g_orderBy,
g2_AlbumItem.g_orderDirection FROM g2_Entity, g2_ChildEntity,
g2_FileSystemEntity, g2_Item, g2_AlbumItem WHERE g2_Entity.g_id IN (6) AND
g2_ChildEntity.g_id=g2_Entity.g_id AND
g2_FileSystemEntity.g_id=g2_Entity.g_id AND g2_Item.g_id=g2_Entity.g_id
AND g2_AlbumItem.g_id=g2_Entity.g_id")
--------------------------------------------------------------------------------
(mysql): SELECT g2_Entity.g_id, g2_Entity.g_creationTimestamp,
g2_Entity.g_isLinkable, g2_Entity.g_linkId,
g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber,
g2_Entity.g_entityType, g2_ChildEntity.g_parentId,
g2_FileSystemEntity.g_pathComponent, g2_Item.g_canContainChildren,
g2_Item.g_description, g2_Item.g_keywords, g2_Item.g_ownerId,
g2_Item.g_summary, g2_Item.g_title, g2_Item.g_viewedSinceTimestamp,
g2_AlbumItem.g_layout, g2_AlbumItem.g_theme, g2_AlbumItem.g_orderBy,
g2_AlbumItem.g_orderDirection FROM g2_Entity, g2_ChildEntity,
g2_FileSystemEntity, g2_Item, g2_AlbumItem WHERE g2_Entity.g_id IN (6)
AND g2_ChildEntity.g_id=g2_Entity.g_id AND
g2_FileSystemEntity.g_id=g2_Entity.g_id AND g2_Item.g_id=g2_Entity.g_id
AND g2_AlbumItem.g_id=g2_Entity.g_id
--------------------------------------------------------------------------------
1054: Unknown column 'g2_AlbumItem.g_theme' in 'field list'
adodb_mysql._execute(SELECT g2_Entity.g_id,
g2_Entity.g_creationTimestamp, g2_Entity....) % line 810, file: adodb.inc.php
adodb_mysql.execute(SELECT g2_Entity.g_id,
g2_Entity.g_creationTimestamp, g2_Entity...., Array[1]) % line 326, file: DatabaseStorage.class
mysqldatabasestorage.loadentities(Array[1]) % line 113, file: GalleryStorage.class
gallerystorage.loadentities(Array[1]) % line 89, file: GalleryEntityHelper_simple.class
galleryentityhelper_simple.loadentitiesbyid(6) % line 2009, file: GalleryCoreApi.class
realpath(/***/***/***/gallery2/modules/core/classes/../../../)
Posts: 17
oh,my god,my site is down!
Posts: 8601
*sigh*
please search the forums for these things!
http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=22646&highlight=schema
http://gallery.menalto.com/index.php?name=PNphpBB2&file=viewtopic&t=21725&highlight=schema
Posts: 17
I've just committed a schema change in core.
If you update to the latest CVS or a nightly snapshot from tonight or later then you'll find your existing G2 no longer works.
Easiest solution is a fresh install as described in the README.
If you really want to keep your existing data you need to move the g_theme, g_orderBy and g_orderDirection columns from table g2_Item to g2_AlbumItem. This means create the columns in g2_AlbumItem, copy the existing data, and remove the columns in g2_Item.
Sql to copy the existing data is something like:
update g2_AlbumItem, g2_Item set g2_AlbumItem.g_theme = g2_Item.g_theme, g2_AlbumItem.g_orderBy = g2_Item.g_orderBy, g2_AlbumItem.g_orderDirection = g2_Item.g_orderDirection where g2_AlbumItem.g_id = g2_Item.g_id;
but i execute this sql:
update g2_AlbumItem, g2_Item set g2_AlbumItem.g_theme = g2_Item.g_theme, g2_AlbumItem.g_orderBy = g2_Item.g_orderBy, g2_AlbumItem.g_orderDirection = g2_Item.g_orderDirection where g2_AlbumItem.g_id = g2_Item.g_id;
prompt:
#1064 - You have an error in your SQL syntax near '
g2_Item SET g2_AlbumItem.g_theme = g2_Item.g_theme,
g2_AlbumItem.g_orderBy = g2' at line 1
Posts: 8601
yeah, good luck with that.
(translation: if that post isn't enough info for you to get your setup working then you shouldn't have disregarded what the G2 README told you.. sorry!)
Posts: 17
sorry,my english is very bad,so i may be can't completely understand the README,*sigh*.....
i'll try once tomorrow,thank you!
Posts: 17
if you would like to help me resolve this problem by winvnc,please contact my msn,thanks!
Posts: 17
oh.... it works fine now, but i'm not sure what will happen next? bless me!