Pages (2): 1 2   
Member
Member
Shivam Patel   04-07-2012, 06:15
#1

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 ?

Member
Member
Shivam Patel   04-07-2012, 08:47
#2

eh, I hope this question gets attention of people other than spambots :|

Administrator
Administrator
acrylian   04-07-2012, 09:13
#3

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).

Member
Member
Shivam Patel   04-07-2012, 17:03
#4

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

Member
Member
Shivam Patel   04-07-2012, 17:08
#5

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 ?

Administrator
Administrator
acrylian   04-07-2012, 17:13
#6

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).

Member
Member
Shivam Patel   04-07-2012, 17:25
#7

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.

Administrator
Administrator
acrylian   04-07-2012, 17:56
#8

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...;-)

Member
Member
Shivam Patel   04-07-2012, 17:57
#9

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 !

Administrator
Administrator
acrylian   04-07-2012, 18:00
#10

Now that sounds weird and surely should not be that way...

Member
Member
sbillard   04-07-2012, 23:19
#11

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.

Member
Member
sbillard   05-07-2012, 01:07
#12

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.)

Member
Member
Shivam Patel   05-07-2012, 16:51
#13

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).

Member
Member
sbillard   05-07-2012, 17:06
#14

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.

Member
Member
lake   23-07-2012, 07:18
#15

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!

Member
Member
sbillard   23-07-2012, 16:46
#16

From your description is sounds like you managed to change your database prefix.

Member
Member
lake   23-07-2012, 18:58
#17

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?

Member
Member
lake   24-07-2012, 17:31
#18

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!

Member
Member
sbillard   24-07-2012, 18:10
#19

Did you actually try the solution shown in this thread?Installing the nightly build?

Member
Member
lake   24-07-2012, 20:50
#20

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.

Pages (2): 1 2   
  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.