Database error after new user registration attempt

rpeverley

Joined: 2009-07-02
Posts: 3
Posted: Thu, 2009-07-02 20:43

I just recently upgraded Gallery2 from version 2.2.x to 2.3. My web host is Powweb. After the upgrade, users are no longer able to create accounts using the Registration module. After providing the required info in the registration screen, the user is presented with the following message:

"Database Error" screen, with the text "An error has occurred while interacting with the database."

Everything else seems to work fine. I can manually create user account in Site Admin. I can create/delete/edit albums, etc. I've deactivated the Registration v.1.0.14 plugin. I tried deleting it and reinstalling it. I also tried reverting back to the 1.0.8 module which resulted in no change.

I would appreciate any help in resolving this issue.

G2 System Information
Gallery URL = http://www.peverley.com/main.php
Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.4.7 cgi
Webserver = Apache
Database = mysqlt 5.0.45-log, lock.system=database
Toolkits = Exif, Getid3, ImageMagick, LinkItemToolkit, Thumbnail, SquareThumb, Gd, ArchiveUpload
Acceleration = partial/1800, partial/1800
Operating system = Linux cgi1101.int.bizland.net 2.6.29.4 #1 SMP Mon Jun 1 13:08:14 EDT 2009 i686
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_5_7; en-us) AppleWebKit/530.18 (KHTML, like Gecko) Version/4.0.1 Safari/530.18
Rows in GalleryAccessMap table = 30
Rows in GalleryAccessSubscriberMap table = 906
Rows in GalleryUser table = 11
Rows in GalleryItem table = 904
Rows in GalleryAlbumItem table = 34
Rows in GalleryCacheMap table = 20

Debug Information

Notice: Undefined index: GalleryEntity in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class on line 91

Warning: array_keys() [function.array-keys]: The first argument should be an array in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class on line 91

Warning: Invalid argument supplied for foreach() in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class on line 91

Notice: Undefined index: GalleryEntity in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class on line 99

Notice: Undefined index: entityType in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class on line 53

Warning: Invalid argument supplied for foreach() in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryStorage/GalleryStorageExtras.class on line 244

Notice: Undefined index: parent in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryStorage/GalleryStorageExtras.class on line 276

Notice: Undefined index: column in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryStorage/GalleryStorageExtras.class on line 287

Notice: Undefined index: column in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryStorage/GalleryStorageExtras.class on line 288

Notice: Undefined index: value in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryStorage/GalleryStorageExtras.class on line 288

Warning: Cannot modify header information - headers already sent by (output started at /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPersistent.class:91) in /hermes/web05/b1457/pow.rpeverley/htdocs/modules/core/classes/GalleryPhpVm.class on line 142
Database Error
An error has occurred while interacting with the database.
Back to the Gallery
Error Detail -
Error (ERROR_STORAGE_FAILURE)
in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 303 (gallerycoreapi::error)
in modules/core/classes/GalleryStorage.class at line 324 (gallerystorageextras::saveentity)
in modules/core/classes/GalleryEntity.class at line 294 (mysqlstorage::saveentity)
in modules/register/UserSelfRegistration.inc at line 124 (gallerypendinguser::save)
in main.php at line 250 (userselfregistrationcontroller::handlerequest)
in main.php at line 104
in main.php at line 88
Login or register to post comments
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 11018
Posted: Thu, 2009-07-02 21:00

Try following this FAQ:
FAQ: I get ERROR_STORAGE_FAILURE when adding new photos or creating albums, what should I do?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Login or register to post comments
rpeverley

Joined: 2009-07-02
Posts: 3
Posted: Thu, 2009-07-02 21:33

Thanks for the quick reply. I followed the steps in the FAQ you referred to. I modified the SequenceId limit as instructed. There was no change in the registration process. The end result is still the database error.
Login or register to post comments
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 11018
Posted: Fri, 2009-07-03 03:27

Put gallery into debug mode and post back. I'll take a look at your gallery to see if it tells me anymore.

FAQ: How to set/use Gallery in debug mode?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Login or register to post comments
rpeverley

Joined: 2009-07-02
Posts: 3
Posted: Fri, 2009-07-03 04:24

I've put my gallery in buffered debug mode. Thank you for your time and effort.

Login or register to post comments
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 11018
Posted: Fri, 2009-07-03 05:51

Let's try these:

Check file integrity:
FAQ: How can I make sure that my installation files are all intact?

Clear database cache:
FAQ: How can I clear cached data?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Login or register to post comments