Home› General support

error: zenphoto tables haven't been created

GordonMacDonald Member
in General support
I am receiving the following error when I try to navigate to a gallery:

Zenphoto Error
MySQL Query ( INSERT INTO `zp_options` (name, value, ownerid, theme) VALUES ('Allow_search','1',0,'zenpage-default') ) failed. Error: MySQL server has gone away
It looks like your zenphoto tables haven't been created. You may need to run the setup script.

Any suggestions?

Thanks
Gord

Comments

  • sbillard Member
    The message
    MySQL server has gone away
    Was returned by MySQL itself. Presumably this is the key to what went wrong, but I have no idea what could cause that. Perhaps your ISP can help here.

    Basically, Zenphoto has made a successful connection to the database and issued the query
    INSERT INTO zp_options (name, value, ownerid, theme) VALUES ('Allow_search','1',0,'zenpage-default')
    which resulted in this failure.

    The above query is presumably from the theme setting its default options. If this is a new installation, that would make senes, but if it is an existing one, the option should long ago have been set. That would be an indication of some other problem with database access.
  • GordonMacDonald Member
    So this is a theme issue? (I am using Zenpage-Default)
    I am not certain why the insert is taking place on a request for an image page?
    I have just backspaced in the browser from the error re-clicked the thumbnail/link and got the image.

    Do you have any other thoughts on this.

    Thanks
    Gord
  • sbillard Member
    No, it is not a theme issue. All the themes do similar things. The insert should happen only once when you first use the theme. It is setting default values for options. That is why I asked if this was a new installation. I'm guessing it is not (you did not answer that question.) That the insert happens a second time is a indication that the database is not functioning correctly.

    If retrying the image worked. (That is what happens when you backspace the browser and re-click) then there is something failing in your MySQL server. I think you need to bring this to the attention of your service provider. It is not a problem with Zenphoto.
  • GordonMacDonald Member
    Thanks
  • GordonMacDonald Member
    One final note:

    My Service provider has confirmed that they are in fact responsible for the problems I was experiencing - perhaps part of my confusion was due to the header "Zenphoto Error" at the top of the page. ZenPhoto has a great straightforward structure and interface - good work!
Sign In or Register to comment.