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 ?
eh, I hope this question gets attention of people other than spambots :|
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:
[list]
[*]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.
[/list]
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 [b]not a problem[/b] with the earlier versions.
Are debug.log and setup.log new concepts introduced in 1.4.3 ?
Okay, now when I access the setup URL, I get this:
`
{Wed, 04 Jul 2012 17:15:58 GMT}
Backtrace: USER ERROR: MySql Error: ( [i]INSERT INTO [code][prefix]options(name,ownerid,theme,value) VALUES ('magick_font_size',0,"",'18') ON DUPLICATE KEY UPDATEvalue`='18'[/i] ) failed. MySql returned the error [i]Table 'shivampatel2_db.zenphoto_options' doesn't exist[/i] 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]
[/code]
Now I don't understand this. This is the [b]first[/b] 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.
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 !
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).
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!
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: ( [i]INSERT INTO [prefix]options (name,ownerid,theme,value) VALUES ('magick_font_size',0,"",'18') ON DUPLICATE KEY UPDATE value='18'[/i] ) failed. MySql returned the error [i]Unknown column 'theme' in 'field list'[/i] 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?
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: ( [i]%2$s[/i] ) failed. %1$s returned the error [i]%3$s[/i]'),DATABASE_SOFTWARE,$sql,db_error()), E_USER_ERROR);
}
Again, ANY assistance would be greatly appreciated!