1.4.3 install error

I am just trying a plain vanilla install of 1.4.3.
It just doesn't take off; this is the first screen I see after I upload the files and browse to /gallery page:
http://nypics.in/gallery/

I have NO issues installing 1.4.2.4 on the same server.. check out http://nypics.in/gallery1/ which is the first page of 1.4.2.4 fresh upload files.

Can you tell whats exactly wrong here ?

Comments

  • eh, I hope this question gets attention of people other than spambots :|
  • acrylian Administrator, Developer
    It does..;-) Either you did not correctly upload the zp-core folder or the permissions are not correctly set (your ftp client and/or server may cause that).
  • I just did what I used to do with previous versions...
    1.) Download the zip file from site.
    2.) Unzip on local computer.
    3.) Upload the entire unzipped folder.
    4.) Access the site by addressing it via its URL (to start the setup process).

    You maybe right when you say permission issues - but I wanted to let you know that the plain simple install process (outlined above) fails for 1.4.3
  • Okay, so I did the following to resolve:
    • `mkdir zp-data`
      `touch zp-data/debug.log`
      `touch zp-data/setup.log`
      `chmod g+w zp-data/debug.log zp-data/setup.log`
      For some reasons zenphoto setup wasn't able to make these directories/files.
    • After doing the above steps manually, the setup seems to work.
    Note that I am on a shared hosting where the user with with the web-server runs (www-data) is different than the user - and this may cause those failures. I would like to re-iterate though that this was not a problem with the earlier versions.

    Are debug.log and setup.log new concepts introduced in 1.4.3 ?
  • acrylian Administrator, Developer
    Sorry, I will have to pass that to my colleague sbillard. All I can say that I installed 1.4.3 sucessfully the exact same way on two shared hosts (and one is one of the biggest over here).
  • Okay, now when I access the setup URL, I get this:

    `

    {Wed, 04 Jul 2012 17:15:58 GMT}

    Backtrace: USER ERROR: MySql Error: ( INSERT INTO [prefix]options` (`name`,`ownerid`,`theme`,`value`) VALUES ('magick_font_size',0,"",'18') ON DUPLICATE KEY UPDATE `value`='18'</em> ) failed. MySql returned the error <em>Table 'shivampatel2_db.zenphoto_options' doesn't exist</em> in /mnt/users/shivampatel2/home/httpdocs/gallery/zp-core/functions-db-MySQL.php on line 59 trigger_error called from query (functions-db-MySQL.php [59]) from setOption (functions-basic.php [361]) from lib_Imagick_Options->__construct (lib-Imagick.php [45]) from require_once (lib-Imagick.php [26]) from require_once (functions-basic.php [182]) from require_once (functions.php [18]) from require_once (template-functions.php [10]) from index.php [6]
    Now I don't understand this. This is the first page of the setup where it does the basic tests. At this point, none of the database tables are supposed to be created.

    Why is the code expecting a database table at this point. FYI, I have imagick installed and looks like its trying to insert some related data to a table - which obviously will be created in future by the setup code.

    Please let me know if I am wrong.

    Also, please dont' get annoyed by my repeated posts - I just want to be your beta tester bringing out various peculiar issues one can face/is facing.
  • acrylian Administrator, Developer
    If you are performing an upgrade, it is expecting a table. So this is a clean new install then? I have not experienced this and have no idea right now. My colleague is the setup expert actually and hopefully have an idea.

    Regarding beta tester: We welcome that (and specifially regular ones!) but maybe next time with the beta and not the final release...;-)
  • Would you believe how did I solve the previous error !!
    I installed zenphoto-1.4.2.4 upto the point where it creates the database tables.

    Then I stopped with 1.4.2.4 and refreshed the 1.4.3 setup page and that error went away (understandably now that it found the tables where it wanted to insert).

    And yes, I am seeing all these errors when trying to install 1.4.3 afresh !
  • acrylian Administrator, Developer
    Now that sounds weird and surely should not be that way...
  • The problem seems to be with Imagick trying to set options before there is a database established. I will look into this and see what can be done.
  • I have made a change in the nightly builds that should prevent this problem. Unfortunately, none of my installs has Imagick available so I cannot test. (The problem seems unique to Imagick.)
  • Thats great Stephen. Thanks.
    I am also facing a peculiar bug with imagick. Nothing that breaks the functionality but definitely a logic check somewhere which prevents IPTC details getting populated to the tables.

    If you want I can file it as a bug report or I can provide the details here. Its simple to reproduce and I guess pretty straighforward to fix as well (for you I mean- I am still digging in the code to see where exactly its happening).
  • Probably best you file a ticket. Include the offending image as well. Sadly, I have no access to Imagic, so the ticket will have to wait for someone who does.
  • lake Member
    I am having the very same issue and errors, saying "Table 'db_db.zenphoto_options' doesn't exist". This IS an upgrade, so there were tables already in place. There is a table called zp_options, but not zenphoto_options.

    I am at a total loss, as I am not a programmer. I am upgrading due to an .htaccess hack, and it's been an all day nightmare. I finally got the setup page to show after multiple attempts, but it would not accept my database credentials. So I actually created a new user on the database, hoping that would get me in. After entering that info, the page when blank, and now I'm finding those errors in the log.

    ANY ideas or assistance would be greatly appreciated!
  • From your description is sounds like you managed to change your database prefix.
  • lake Member
    I changed nothing, but recognized the issue so I have changed the database prefix to zp_ in the zenphoto.cfg file and uploaded to the server, and that much seems to be resolved. However, the rest of the error message remains, identical to Shivam Patel's error above:

    Backtrace: USER ERROR: MySql Error: ( INSERT INTO `[prefix]options` (`name`,`ownerid`,`theme`,`value`) VALUES ('magick_font_size',0,"",'18') ON DUPLICATE KEY UPDATE `value`='18' ) failed. MySql returned the error Unknown column 'theme' in 'field list' in /home/shsaddle/public_html/zenphoto/zp-core/functions-db-MySQL.php on line 59
    trigger_error called
    from query (functions-db-MySQL.php [59])
    from setOption (functions-basic.php [361])
    from lib_Imagick_Options->__construct (lib-Imagick.php [45])
    from require_once (lib-Imagick.php [26])
    from require_once (functions-basic.php [182])
    from require_once (functions.php [18])
    from require_once (template-functions.php [10])
    from index.php [6]

    Still just getting a blank page, and really need help finding a solution. Server error log shows nothing. Ideas?
  • lake Member
    Again, I am really NOT a coder, so am way over my head. I have studied all of the files referenced in the error log, and still wonder if it has something to do with the db prefix? The trigger_error begins with line 59 on the functions-db-MySQL.php file, which refers to the prefix:

    if($errorstop) {
    $sql = str_replace($_zp_conf_vars['mysql_prefix'], '['.gettext('prefix').']',$sql);
    $sql = str_replace($_zp_conf_vars['mysql_database'], '['.gettext('DB').']',$sql);
    trigger_error(sprintf(gettext('%1$s Error: ( %2$s ) failed. %1$s returned the error %3$s'),DATABASE_SOFTWARE,$sql,db_error()), E_USER_ERROR);
    }

    Again, ANY assistance would be greatly appreciated!
  • Did you actually try the solution shown in this thread?Installing the nightly build?
  • lake Member
    I don't know what the nightly build is, but assumed it was an update to the program. I only downloaded the upgrade two days ago, so assumed it was the latest version. If I am misunderstanding, please advise.
  • Nightly builds of the trunc branch are the cumulative set of bug fixes to the latest release. Nightly builds are found from a link on the main site webpage. Generally you would download and install the most recent if you have been recommended to install the nightly build.

    Of course when you download something is very different from when it was created. The 1.4.3 release was made on the first of July.
  • lake Member
    So, if I understand you correctly, the 1.4.3 release does not include the fix referenced above? Should I download the most recent, or the one from two weeks ago that you refer to?
  • Well, what did my post say? "Generally you would download and install the most recent if you have been recommended to install the nightly build."

    You know it really helps if you try to read and understand what is posted.
  • lake Member
    Excuse me, but did I not attempt multiple times to define myself as inexperienced? Your statement "Generally you would download and install the most recent if you have been recommended to install the nightly build" I found a bit misleading, as I thought you might also have been referring to the one most immediately following the above-referenced post.

    I fail to see what the sarcasm and obvious disdain towards users looking for answers seek to accomplish. I saw it prevalent throughout the forum, so shouldn't be surprised. I also saw a LOT of the same types of technical issues over and over, with very little true solutions offered other than "check your server log", or "it must be something you did wrong".

    More power to you. I found the documentation lacking, negative and sarcastic responses to real questions, and a product that has caused me WAY more headaches than it's worth. For the record, I found a solution to the problem, ironically on a different website (thanks so much). Obviously will not be recommending the software to any other clients.
  • You said you were inexperienced, not that you could not read. We do expect at least that from people.
  • lake Member
    Obviously, you are a Chief Developer as well as a Chief Ass. Actually, allow me to offer you a little lesson in grammar. The use of the word "generally" is most effective in sentences when followed by a contrasting statement, such as: "Generally you would download and install the most recent if you have been recommended to install the nightly build, but in your situation I would recommend downloading the build from July 9th instead, as that should be sufficient to resolve your issue." My follow up question was simply to clarify that you had not accidentally omitted the latter part of the sentence in your reply. A simple "the most recent" would have been a sufficient reply. You chose to go with hateful sarcasm instead.

    So as you can see, I can read. I just can't read poor grammar, nor your mind.
  • acrylian Administrator, Developer
    @lake: Mind your tone please. We expect that you learn a bit yourself. The nightly builds are referenced in the forum rules and can easily found on the download page. On their page they are explained as well.
Sign In or Register to comment.