[Solved] Unable to upgrade to 2.3

Trying to upgrade from 2.2.6 to 2.3. No matter what I do, it says that there aren't enough permissions to upgrade. I've recreated users and reassigned ALL PRIVILEGES to each of my users and just can't get it to work. This same user worked fine for the installation of 2.2.6, which I just did a few weeks ago.

It seems to work if I go through the regular install, but it wants me to wipe my database, which I don't want to do.

I've even tried deleting the non-G2DATA folders and reuploading the 2.3 full package. No dice. This post also seems to be similar and has some posts within the past day or so: http://gallery.menalto.com/node/77367

Any suggestions?

Here's the error on "System Checks"
System Checks
PHP Version Success
FILE Directive Success
Safe Mode Success
exec() allowed Success
set_time_limit() allowed Success
Memory limit (32Mb) Success
File uploads allowed Success
Maximum upload size (2Mb) Success
Maximum POST size (8Mb) Success
Translation support Success
Storage Directory Permissions Success
Gallery file integrity Success
Database permissions Failed
Error: The configured database user does not have the required database privileges to perform the upgrade.
Failed to create, alter or drop a database test table. Check the returned error message and README.html for missing privileges and clean up the database.

Gallery version (not just "2"): 2.2.6... trying to get to 2.3
PHP version (e.g. 5.1.6): 5.2.6
PHPInfo Link (see FAQ): http://www.sagerus.com/gallery2/phpinfo.php
Webserver (e.g. Apache 1.3.33): Apache version 2.2.9 (Unix)
Database (e.g. MySql 5.0.32): MySQL version 5.0.45-community-log
Activated toolkits (e.g. NetPbm, GD): At the moment, can't get to them
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Firefox and IE both do the same

My site: http://www.sagerus.com

> This same user worked fine for the installation of 2.2.6,

the database permissions checks in g2.2.6's installer are similar to the checks performed in the g2.3 upgrade wizard.

this is really all about the database user. we added this check because yahoo and some other webhosts don't assign CREATE, ALTER and DROP table permissions to the g2 db user by default (and create sequence, etc.).

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

Thanks for the reply, valiant, but I have verified with my host that the database user/pass are set up correctly. They've even gone so far as to create a new user for me and assign rights and we still can't get through it. I'll try creating a new database later tonight when I get home from work with the same user to see where that gets me.

I think we're having the same problem. I'm using Debian 4.0 with all its default packages (mysql 5, php5).

Actually the installer works (up to the point where it detects by reading version.dat that this is not a fresh install and wants to redirect me to the updater).
It's just the updater that seems to misread the privileges on the database.

Hmm, looks like our code in the upgrade wizard doesn't properly display the actual errors. that's very unfortunate. we'll have to investigate this further.

for now, please file a bug at http://sf.net/projects/gallery/ -> trackers -> bugs.
please copy and paste the exact warning message you get from g2's upgrade wizard.

as for a solution:
let's hack your upgrade wizard to show the actual error message.

please edit the file gallery2/upgrade/steps/SystemChecksStep.class
towards the end of the file, in function _executeSql, please replace:

		$ret = $storage->execute($query, array());
		if ($ret) {
		    return array(false, _('Check the returned error message and README.html ' .
			'for missing privileges and clean up the database.'));
		}

with

		$gallery->startRecordingDebugSnippet();
		$ret = $storage->execute($query, array());
		$debugSnippet = $gallery->stopRecordingDebugSnippet();
		if ($ret) {
		    return array(false, _("Check the returned error message and README.html "
			. "for missing privileges and clean up the database. Error message: \n"
			. $debugSnippet));
		}

and then run the system checks step again.

what does it show now? (please copy and paste the exact warning / error message.

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

Excellent thanks valiant. I have deleted table gtst0Schema from the other two galleries and installation worked fine - table did not exist in the other two galleries

Bug report submitted. Thanks, all, for your help.

Dropping the gallery2.gtst0Schema table also solved it for myself. Upgrade from 2.2.4 to current.