Hi,

i was in the process of upgrading to 1.4.2.x to 1.4.3.3, the install hangs on about to update tables.
I get a warning about insufficient rights for database, but the warning is incorrect:
Your Database user must have Alter, Create, Delete, Drop, Index, Insert, Select and Update rights.

Quote:Grants found:

GRANT USAGE ON . TO 'xxxxxxx'@'%' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON xxxxxx.* TO 'xxxxxxx'@'%'
i am a bit lost, and website is of course broken...

Any other errors in the server error log?

Do either of these rights listed belong to the user id you assigne to the Zenphoto installation? (The line should be in Bold if so.)

These are all other messages:

PHP version 5.2.11 . PHP Version 5.0.5 or greater is required. Version 5.3 or greater is strongly recommended. Use earlier versions at your own risk.

PHP magic_quotes_gpc [is enabled] We strongly recommend disabling magic_quotes_gpc. For more information See What is magic_quotes_gpc and why should it be disabled? in the Zenphoto troubleshooting guide.

File Permissions [are losjes (0666)] Warning! click for details

The Zenphoto filesystem character define is UTF?8 [no test performed] Warning! click for details

MySql version 5.1.55. MySql Version 5.0.0 or greater is required. Version 5.5.0 or greater is preferred. Use a lower version at your own risk.

SHOW TABLES found: _admin_to_object, _administrators, _albums, _captcha, _comments, _images, _menu, _news, _news2cat, _news_categories, _obj_to_tag, _options, _pages, _plugin_storage, _search_cache, _tags

I did follow the install upgrade instructions...

GRANT USAGE ON . TO 'xxx'@'%' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxx'
is in bold.

That user has not been given any rights but access to your databases. So you need to fix somethig: either you have not identified the user/database correctly in Zenphoto or you have not given the user the necessary database rights.

Well, this is an upgrade, the zenphoto site was working, so i suppose the user rights were ok.
how do i check if id of user/database is correct in zenphoto?

in the zenphoto.cfg info about MySQL database seems correct.

The user sbillard referred to is the database user on your server. Zenphoto is not involved in that as that is a server configuration. You might need to contact your host about that.

yes i know.
we didnt change anything with the server databse . it is the zenphoto upgrade which went wrong and is causing the problem.

Sorry, I have no idea. I did not encounter this issue on several updates on normal shared hosts.

Zenphoto does not set any database priviledges. In fact in your case it could not even if it wanted to because the user YOU have configured in Zenphoto does not have any significant database rights.

So, first, is the user indicated the one you intended to configure? If not fix that in the config file. If so, grant him the rights Zenphoto needs.

Just for the record, how was your original version of Zenphoto installed?

i changed name of database to "no capitals" and datbase rights warning did go away, but setup still hangs on update tables...

So the database rights warning is aways and where hanges the setup? Errors in the error log of the server and/or zenphoto logs?

If it is again the database user I again suggest to contact your host about this if you didn't configure the server yourself. I don't think we changed anything in that regard.

Also I repeat the question of sbillard how the old version has been installed. Manually or using an install helper script?

there are no warnings anymore in zenphoto setup regarding the database user rights. The upgrade hangs when i click Go, with message on screen: about to update tables.....
old version was from feb. 2012, installed same way with procedure as described in install instructions.
i fear i will have to erase the site and start from scratch with fresh install.

complete message from zenphoto upgrade:
Welcome to Zenphoto! This page will set up Zenphoto on your web server.
Systems Check:

Updating current Zenphoto release
Log security
PHP version 5.2.11
Warning!

PHP Version 5.0.5 or greater is required. Version 5.3 or greater is strongly recommended. Use earlier versions at your own risk.
PHP Sessions.
PHP Register Globals
PHP Safe Mode
PHP magic_quotes_gpc [is enabled]
Warning!

We strongly recommend disabling magic_quotes_gpc. For more information See What is magic_quotes_gpc and why should it be disabled? in the Zenphoto troubleshooting guide.
PHP magic_quotes_runtime
PHP magic_quotes_sybase
PHP gettext() support
PHP mbstring package
Graphics support: PHP GD library bundled (2.0.34 compatible)
zenphoto.cfg file
File Permissions [are loose (0666)] Warning! click for details
The Zenphoto filesystem character define is UTF?8 [no test performed] Warning! click for details
Image URIs appear require the filesystem character set.
PHP MySQL support for configured Database
PHP PDO_MySQL support
MySql version 5.1.55
Warning!

MySql Version 5.0.0 or greater is required. Version 5.5.0 or greater is preferred. Use a lower version at your own risk.
Database setup in configuration file
SQL mode
Database access rights
SHOW TABLES found: _admin_to_object, _administrators, _albums, _captcha, _comments, _images, _menu, _news, _news2cat, _news_categories, _obj_to_tag, _options, _pages, _plugin_storage, _search_cache, _tags
Database field collations
Zenphoto core files
Zenphoto core file permissions
.htaccess file (RewriteEngine is ON)
.htaccess RewriteBase is /
robots.txt file [Not created] Notice! click for details
albums folder
cache folder
locale folders
uploaded folder
zp-data folder
HTML cache folder (cache_html)
Third party plugins folder (plugins)

Database tables to update: _options, _albums, _images, _comments, _administrators, _admin_to_object, _tags, _obj_to_tag, _captcha, _pages, _news2cat, _news_categories, _news, _menu, _plugin_storage, _search_cache

The above is, of course, what Setup does display, not any kind of error log. Please describe what you mean by "hangs". Does the screen change at all? Does the browser try to load a script? That sort of thing.

Find your PHP error log and see what it contains.

Look in the installation zp-data folder for both the setup log and possibly a debug log and see if they tell us anything.