help me,can't into "Site Admin"

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 07:55

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

bharat

Joined: 2002-05-21
Posts: 7994

Posted: Thu, 2004-11-11 08:05

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.

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 08:27

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!

bharat

Joined: 2002-05-21
Posts: 7994

Posted: Thu, 2004-11-11 09:25

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.

jamzyamz

Joined: 2004-01-12
Posts: 154

Posted: Thu, 2004-11-11 10:52

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.

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 11:24

my first version is G2.......

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 14:15

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

Kevitt

Joined: 2004-11-06
Posts: 3

Posted: Thu, 2004-11-11 14:49

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 :\

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 15:42

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/../../../)

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 15:47

oh,my god,my site is down!

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Thu, 2004-11-11 15:48

*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

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 17:38

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

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Thu, 2004-11-11 17:56

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!)

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 18:28

sorry,my english is very bad,so i may be can't completely understand the README,*sigh*.....

i'll try once tomorrow,thank you!

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 18:35

if you would like to help me resolve this problem by winvnc,please contact my msn,thanks!

supercn

Joined: 2004-11-10
Posts: 17

Posted: Thu, 2004-11-11 19:20

oh.... it works fine now, but i'm not sure what will happen next? bless me!

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 07:55
	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
	XUser login Username: * Password: * Create new account Request new password
bharat Joined: 2002-05-21 Posts: 7994	Posted: Thu, 2004-11-11 08:05
	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.

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 08:27
	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!

bharat Joined: 2002-05-21 Posts: 7994	Posted: Thu, 2004-11-11 09:25
	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.

jamzyamz Joined: 2004-01-12 Posts: 154	Posted: Thu, 2004-11-11 10:52
	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.

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 11:24
	my first version is G2.......

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 14:15
	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

Kevitt Joined: 2004-11-06 Posts: 3	Posted: Thu, 2004-11-11 14:49
	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 :\

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 15:42
	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/../../../)

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 15:47
	oh,my god,my site is down!

mindless Joined: 2004-01-04 Posts: 8601	Posted: Thu, 2004-11-11 15:48
	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

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 17:38
	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

mindless Joined: 2004-01-04 Posts: 8601	Posted: Thu, 2004-11-11 17:56
	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!)

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 18:28
	sorry,my english is very bad,so i may be can't completely understand the README,sigh..... i'll try once tomorrow,thank you!

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 18:35
	if you would like to help me resolve this problem by winvnc,please contact my msn,thanks!

supercn Joined: 2004-11-10 Posts: 17	Posted: Thu, 2004-11-11 19:20
	oh.... it works fine now, but i'm not sure what will happen next? bless me!

help me,can't into "Site Admin"

XUser login