Home› General support

SHOW GRANTS query failed

Chief Member
in General support
Hi am a little stuck with the installation.

I have created a database, created a user with Select, Insert, Update, and Delete rights and then linked it to the database using cPanel X. Any ideas if I'm missed anything obvious or any more information required from me to help identify why this isn't working correctly. On the setup.php page all other things are checked with a green tick.

Zenphoto Error
MySQL Query ( INSERT INTO `zp_options` (name, value) VALUES ('zenphoto_release','1219') ) Failed. Error: Table 'mark_zenphoto.zp_options' doesn't exist
It looks like your zenphoto tables haven't been created. You may need to run the setup script.

Thank you

Comments

  • sbillard Member
    Please try the nightly build.

    Also be sure the MySQL user had create rights.
  • Chief Member
    Your a star and I'm an idiot.

    I obviously screwed something up when I had my user set to all rights and after that each time I tried adding a user I only gave them the rights it was requesting in the prompt. Added create and it worked. Thank you for an amazingly fast response
  • Chief Member
    Zenphoto Error
    MySQL Query ( SELECT folder, sort_order, `show`, `dynamic`, `search_params` FROM `zp_albums` ORDER BY id ) Failed. Error: Unknown column 'dynamic' in 'field list'

    Managed to get one more step before it threw up another error. Any ideas? Sorry my knowledge of PHP and MySql is very limited.
  • sbillard Member
    This may also be a rights issue. That field should have been created by the setup program. Try setup again.
Sign In or Register to comment.