Home› General support

install hangs on tables update

sirius Member
in General support
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.

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

Comments

  • acrylian Administrator, Developer
    Any other errors in the server error log?
  • sbillard Member
    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.)
  • sirius Member
    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...
  • sirius Member
    GRANT USAGE ON *.* TO 'xxx'@'%' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxx'
    is in bold.
  • sbillard Member
    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.
  • sirius Member
    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?
  • sirius Member
    in the zenphoto.cfg info about MySQL database seems correct.
  • acrylian Administrator, Developer
    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.
  • sirius Member
    yes i know.
    we didnt change anything with the server databse . it is the zenphoto upgrade which went wrong and is causing the problem.
  • acrylian Administrator, Developer
    Sorry, I have no idea. I did not encounter this issue on several updates on normal shared hosts.
  • sbillard Member
    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?
  • sirius Member
    i changed name of database to "no capitals" and datbase rights warning did go away, but setup still hangs on update tables...:(
  • acrylian Administrator, Developer
    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?
  • sirius Member
    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
  • sbillard Member
    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.
Sign In or Register to comment.