Home› General support

error : ...zenphoto tables haven't been created

sou Member
in General support
when i enter to the http://domain.com/zenphoto/
here is what i got

Zenphoto Error
MySQL Query ( SELECT `name`, `value` FROM `zp_options` ) Failed. Error: Table 'zen-oktay.zp_options' doesn't exist
It looks like your zenphoto tables haven't been created. You may need to run the setup script.

when i run the setup script.

**************************
PHP version 4.1.0 or greater
PHP GD support
PHP mySQL support
zp-config.php file
mySQL setup in zp-config.php
connect to MySQL
MySQL version 3.2.3 or greater
connect to the database zen-oktay
.htaccess file (RewriteEngine is ON)
.htaccess RewriteBase
albums folder
cache folder

All of theese checks are green
*********************
but there is an error on the bottom like that
' DB Error, could not list tables MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-oktay LIKE 'zp_%'' at line 1 '

how can i solve this problem?

Comments

  • sou Member
    and when enter the phpmyadmin page
    here is what i got

    zen(0)
    No tables found in database.

    how can i solve this problem?
  • acrylian Administrator, Developer
    I think your db name does not match your settings:
    `MySQL Query ( SELECT name, value FROM zp_options ) Failed. Error: Table 'zen-oktay.zp_options'`
    indicates that your db is called zen-oktay, but your second post indicates that it in fact is called simply "zen".
    Check your mysql data in your zp-config.php file within zp-core.
  • sbillard Member
    You need to get the nightly build. The problem is with special characters in the database name. This is fixed in the nightly build.
  • tom4panic Member
    I'm having this same error pop up after I click the "Go" link. What is a nightly build?
  • acrylian Administrator, Developer
    The nightly build is the version we are working currently on to become zenphoto 1.1.4. It contains already many bugfixes: www.zenphoto.org
  • tom4panic Member
    acrylian, for ZenPhoto to work for me, I should wait until version 1.1.4 is finished and install it?
  • sbillard Member
    The nightly build is quite stable at the moment. You can download and install it, it should work just fine for you.
  • tom4panic Member
    Should I delete all other files and perform a fresh install with this(zenphoto-2008-01-23-trunk.zip) file?
  • sbillard Member
    That is always best. Be sure to note your mysql configuration information first as you will be asked for it by setup.
Sign In or Register to comment.