Comments

• mowgli597 Member

  July 2012

  After further investigation I've isolated the problem to a "require_once" statement in a file used in my site which generates a standard layout for each page.
  
  The statement is:

  
  define('ROOT', ($_SERVER['DOCUMENT_ROOT']));
  define('WEBPATH', '/zenphoto');
  define('ZENFOLDER1', 'zp-core');
  
  //require_once(ROOT. "/" . WEBPATH . "/" . ZENFOLDER1 . "/template-functions.php");
  
  

  I use template-functions.php to display random thumbnails on the bottom of each page.
  
  If I comment out the above line then pages display correctly.
  
  If the line is kept in then I get the error shown above:

  
  Zenphoto has detected a change in your installation.
  
  Zenphoto 1.4.3[10393] has been copied over an unknown release.
  
  Please reinstall the following setup files from the 1.4.3 [10393] release:
  
  zp-core/setup.php
  zp-core/setup/setup-functions.php
  zp-core/setup/setup-option-defaults.php
  zp-core/setup/setup-primitive.php
  zp-core/setup/setup-sqlform.php
  zp-core/setup/setup.css
  zp-core/setup/setup_permissions_changer.php
  zp-core/setup/setup_set-mod_rewrite.php
  zp-core/setup/setup_themeOptions.php
  
  The change detected is critical. You must run setup for your site to function.
  
  

  This happens even after a completely fresh installation of Zenphoto 1.4.3
  
  It works fine with 1.4.2.4
  
  Michael
• acrylian Administrator, Developer

  July 2012

  Most of your warnings are warnings. Zenphoto compares the file time and that does not match if you upload files later or have custom files. It is meant as a warning in case someone sneaked in unwanted stuff to your site.
  
  Regarding using functions outside ZP the 1.4.3 release has a bug because some internal path handling changed because of the clone feature. You need to install the trunk nightly. Also the code changed a little which is already documented here:
  http://www.zenphoto.org/news/zenphoto-as-a-plug-in-using-zenphoto-functions-from-outside-zenphoto
• mowgli597 Member

  July 2012

  Thank you for the reply.
  
  Have uploaded and installed zenphoto-2012-07-09-trunk nightly and updated the plug-in code as shown on the referenced page.
  
  However I'm still getting the same error.
  
  All the core files were uploaded at the same time??
  
  Michael
• sbillard Member

  July 2012

  Please be more detailed. Do those lines appear within Zenphoto scripts or just in external pages on your site? If the latter, does your site work normally when accessed directly?
  
  Looking at how that particular error is generated, either the database scripts have not loaded or the option table is empty. I suspect that the former is the case and is caused by some script error in the loading process. Please examine your PHP script error log for any errors reported.
  
  Also please describe the folder structure of your site and the exact values for each of your defines.
• mowgli597 Member

  July 2012

  Thanks again for your response.
  
  The standalone Zenphoto part of the installation works fine after the upgrade. The new, clean install uses the default theme. I created a new set of database tables for this clean install and uploaded a few images into a test album.
  
  The Setup log shows the following errors regarding the database:

  
  Warn: MySql Version 5.0.0 or greater is required. Version 5.5.0 or greater is preferred. Use a lower version at your own risk. [Current MySql version: 5.1.63]
  
  Completed system check
  
  Query ALTER TABLE `zp_images` DROP FOREIGN KEY ``zp_images`_ibfk1` Failed. 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 'zp_images`_ibfk1`' at line 1
  
  Query ALTER TABLE `zp_comments` DROP FOREIGN KEY ``zp_comments`_ibfk1` Failed. 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 'zp_comments`_ibfk1`' at line 1
  
  

  The error appears whenever I try to access the main site, both from within Zenphoto using the "Home" link or if I try to access the site's home page direct.
  
  The main site uses a file called "PageTop.php" which is used to give a banner and a navigation sidebar for every page (i.e. the site's "theme"). Every main site page calls PageTop.php when loaded.
  
  PageTop.php is located in the site's development root directory (public_html/development).
  
  Zenphoto is located in a folder called "zenphoto" which is also in the site's development root directory
  
  PageTop.php includes the Zenphoto plug-in code which is now:

  
  1 <?php
  2 /*
  3 * This script is an example of how to use Zenphoto content from a Non-Zenphoto WEB page.
  4 * You must define SERVERPATH and WEBPATH to correctly point at the Zenphoto installation.
  5 * Here we are presuming that the running script is in the root of the WEBsite and the
  6 * Zenphoto installation is in a folder named "zenphoto" within that root folder.
  7 */
  8
  9 define('SERVERPATH',str_replace('\\','/',dirname(__FILE__)).'/zenphoto');
  10 define('WEBPATH','/'.basename(dirname(__FILE__)).'/zenphoto');
  11
  12 /*
  13 * Now we "include" the Zenphoto template functions. This will instantiate the Zenphoto 14 installation
  15 * and make all theme functions available to us.
  16
  17 */
  18 require_once(SERVERPATH.'/zp-core/template-functions.php');
  20 ?>
  
  

  The defines as shown above give the following values:
  
  SERVERPATH: /home/bpskdk/public_html/development/zenphoto
  WEBPATH: /development/zenphoto
  
  If I comment out line 18 then the error disappears and I can access the main site files (but of course I lose the Zenphoto plug-in functionality on my site).
  
  The same setup worked (and continues to work) fine with 1.4.2.4
  
  Michael
• mowgli597 Member

  July 2012

  I should have added that the option table contains data.
  
  Michael
• sbillard Member

  July 2012

  You can ignore the setup errors. They are not an issue.
  
  What you have done seems correct. Probably at this point you should create a ticket on this. We will probably have to give you debug files to try to trace the issue so the ticket method is the best tracker.
• mowgli597 Member

  July 2012

  Ticket #2203 raised.
  
  Thanks for your help.