zenphoto forums » Installation Support

"Incorrect table name" in ZP setup

(4 posts)
  • Started 10 months ago by telemarknerd
  • Latest reply from fretzl

  1. telemarknerd

    Member
    Joined: Jul '12
    Posts: 10

    My website was hacked I think because I didn't update zp for a year and a half. I've deleted my albums and zp files off my server and am trying to do a fresh install of the newest version. Every time I get part way through the setup I get stuck at the "about to create tables" part. I get a series of "table creation failures" saying I have an incorrect table name eg.:

    Table creation failure:
    Query: CREATE TABLE IF NOT EXISTS Gallery/zenphoto_captcha ( id int(11) UNSIGNED NOT NULL auto_increment, ptime int(32) UNSIGNED NOT NULL, hash varchar(255) NOT NULL, PRIMARY KEY (id) ) CHARACTER SET utf8 COLLATE utf8_unicode_ci;
    Error: Incorrect table name 'Gallery/zenphoto_captcha'

    Can anyone please help me where to go from here?

    Posted 10 months ago #

  2. Zenphoto development team
    sbillard

    Chief Developer
    Joined: May '07
    Posts: 9,766

    Your database prefix appears to be "gallery/zenphoto". You need to change that so there is no "/" in the name.

    Don't forget to read the Forum rules and usage resources
    Posted 10 months ago #

  3. telemarknerd

    Member
    Joined: Jul '12
    Posts: 10

    Thanks sbillard. That solved the problem. I was also wondering in order to disable magic_quotes_gpc, which .htaccess file to add 'php_value magic_quotes_gpc off' in (the file in the zenphoto root folder, or in /zp-data)?. Also, does it matter where in the file the text is inserted?

    Many thanks,

    Posted 10 months ago #

  4. Zenphoto support team
    fretzl

    Moderator
    Joined: Sep '08
    Posts: 528

    Use the .htaccess file in the root folder.
    I always put it on top of the file, just before
    <IfModule mod_rewrite.c>

    Don't forget to read the Forum rules and usage resources
    Posted 10 months ago #

RSS feed for this topic

Reply

You must log in to post.