Home› General support

Table Creation Failure

GenieB Member
in General support
On a new install, I consistently get "table creation failure" - about two pink pages full. The database shows "0" data.

I have a dedicated server, and have installed many databases before now. I installed this software on another site, same server, had problems but finally got it to work.

The setup page says that many things need fixing when they don't, such as .htaccess, robots.txt. magic_quotes etc.

I do get the GO button at the bottom and next received all of the table failures. I have checked many times that the config file in zp_data is correct.

I have been through the trouble shooting problems here.

Any idea where to turn to next?

Thank you.

Comments

  • sbillard Member
    The setup page says that many things need fixing when they don't, such as .htaccess, robots.txt. magic_quotes etc.
    Really? you know better than Zenphoto what it needs?

    With respect to the table creation: What are the user privileges of the user you have provided to Zenphoto? Can that user create tables? If not there is no way Zenphoto can do the setup.

    Maybe `Database access rights for master` is another of those "things that need fixing when they don't"
  • GenieB Member
    As for the things it says is needed, magic quotes is disabled, yet the setup advises they should be disabled. It told me I needed the .htaccess, when it was there: (add by zenphoto itself)

    '# block WEB access to Zenphoto data files
    <IfModule mod_autoindex.c>
    IndexIgnore *
    </IfModule>
    <FilesMatch "\.(htaccess|cfg|log|php)$">
    Order Allow,Deny
    Deny from all
    </FilesMatch>
    RewriteBase /gallery'

    No, there is know way I think I know better, but there it is.

    I create the database, and I have full privileges. I am not sure if there is a difference between MySql and MySQLi. The setup says all that is ok, but was just wondering.

    I have my host looking into this, as well. I did try a competitor of yours just a while ago, it did not load the setup page at all. Perhaps, it is something unrelated to zenphoto.

    My apologies if that is so.
  • acrylian Administrator, Developer
    There can be differences between the server, database and the FTP user you logged in. It could also be some security stuff getting in the way or just permissions as often.

    I can assure that ZP runs on fairly standard shared hosts packages over here (in Germany) so it does not really require anything that specific.
  • sbillard Member
    My guess is that you have file/folder permissions issues. That is the only thing that could make Zenphoto think you do not have files that are actually there.

    BUT, if that is the complete root .htaccess file on your site it is certainly not what Zenphoto created. It looks like a hybrid of the .htaccess for the `zp-data` folder and the rewrite base from the root .htaccess.

    As I mentioned before, if you are getting errors when setup tries to create a table then something in your configuration is denying Zenphoto that ability. What that might be would be pure speculation on my part.

    As for `magic_quotes` Setup is reporting what PHP says the state of the setting is. So I guess that PHP disagrees with you on the state of that setting.
  • Anniemee Member
    I'm getting the same error. My server manager has been working on all kinds of things.

    Tonight I went back to using 1.4.3.2 because I know that version works and it's a relief - just having the site working for now. And I tested 1.4.2 version and it works good too.

    But I'm having a heck of a time with any of the 1.4.4 versions of ZP. I don't think it's entirely a server or permissions problem, because we've been all over the server trying to fix this.

    What's different about 1.4.4 that's causing such indigestion on our server? My server manager said he thought this might be the problem, it's in the zenphoto.cfg file:

    `if (!defined('CHMOD_VALUE')) { define('CHMOD_VALUE',0666); }`

    He wondered if that file was overriding the proper permissions needed.
  • Anniemee Member
    BTW, my Joomla and Zencart sites aren't having any problems with the new server. It's just Zenphoto.
  • Anniemee Member
    GENIE, I've been messing around with ZP for two days. You might want to delete the install files totally and reinstall, there could be something corrupted. I had the same merry go round going on for awhile. So I started over completely and things began working again. Just my two cents.
  • acrylian Administrator, Developer
    That define is what Zenphoto tries but if the server refuses it will not work. Also if you try to set to strict permissions via Setup it also might not work. That depends on the server which Zenphoto cannot know (sadly not one server is like the other).

    On my server for example the strictest does not work because other security stuff is already running. So 755/644 is what I have to use (if 777 is needed the server is wrongly configured). You can also change that define.

    We never exclude that there is a bug in ZP but it is helpful if we can reproduce and/or encounter it ourselves. Which I sadly didn't neither on my local or several live istalls (And I just upgraded a site straight from an very ancient 1.3 install this week).
  • sbillard Member
    That define may be overriding a different file/folder permissions setting, but if it is it would be because you did not select a file/folder permissions when you ran setup.

    Normal installs will look something like:
    `
    $conf['CHMOD'] = 0644;
    if (!defined('CHMOD_VALUE')) { define('CHMOD_VALUE', $conf['CHMOD']); }
    `
Sign In or Register to comment.