my url is http://www.tahoeunderground.com/zenphoto/zp-core/setup.php.

So I set up my username, password, host, and database info entered in the zp-setup.php. It then asks me for a login and password. Im assuming the login is the username i created for the database and the password is the password for the database. I enter those and I get redirected to the "zenphoto upgrade page" http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?checked ,where it asks for a login and password. I accepts nothing and keeping bouncing back to the "zenphoto upgrade page". I tried to request a reset a couple times and received no email. Whats my next move? I really want to integrate this program into my website but this is not proving to be that "easy". please help

Have you installed a previous version of zenphoto? What version are you installing now?

Anyway, the user/password for the database need not be the same as for your login to zenphoto. In fact, we would recommend that they be different.

The general procedure for password problems is found here http://www.zenphoto.org/2007/12/troubleshooting-zenphoto/#16

Also check your zp-config.php file to be sure it does not have a user/password configured.

No, no previous program installed, I just downloaded it from your website two days ago so I assume the version is 1.1.7. I will try to use the link you gave but when you say to be sure my zp-config.php does not have a user/password configured we might have something because the first thing I tried to do with this issue was to configure zp-config.php to include my username, password, host, and database name. I added the info to the file and reuploaded. The program then was able to connect to the database, I believe, but then prompted me to input the user and password, which never let me past that point. So, do I need to erase the user and password info from the zp-config file and leave the host name and database name? And do I need to change the "true" back to false for a first time download of the program?

There are two different user/passwords we are talking about here. Best to prefix them to be sure we are on the same track.

MySQL Admin user/passwords are the ones you configured when you setup your database. They are used solely for connecting to the database and are stored in the zp-config.php file with the lines:
`$conf['mysql_user'] = "";

$conf['mysql_pass'] = "";`

There is also a Zenphoto Admin user/password. These should not be stored in zp-config.php. They are stored in a database table named 'administrators' (prefixed with whatever you set as your database table prefix.)

I think the best thing for you to do at this point is to drop the tables from your zenphoto database, delete the zp-config.php file from the zp-core folder. Clear any zenphoto browser cookies and re-run the setup program.

This should prompt you for you MySQL information but should not ask for a user/password for zenphoto. Once you have clicked the GO button you should get a link to setup your zenphoto user/password.

Ok. I dropped the tables from the database via my phpadmin. I then deleted the whole database and created a new one. I entered the mysql user,password,database name and changed the false to true option for a new install on the zp-config.php file. I also deleted all cookies. I then went to the setup page... http://www.tahoeunderground.com/zenphoto/zp-core/setup.php. All I had to do was click go and I was able to set up a new user and password. I entered a couple more lines of info like my website info, clicked save, and now im on this page... http://www.tahoeunderground.com/zenphoto/zp-core/admin.php# ... where I cant get past. I entered the 2nd login and password from the admin.php# page and both were rejected. I then entered zenphoto as the login (the database name on my host) and the password for it was rejected also, but the login "zenphoto" came back, just asking me for my password. Ive tried all combos of both! Which one should I use Can I find the any info i need in my phpadmin? I know we are close here... I can taste it!

The zenphoto version you are running is not to be the 1.1.7 release. With the 1.1.7 release the version and release numbers are displayed at the bottom of the Admin or Setup pages. So, download version 1.1.7 and try that.

Forgot to mention you should drop your 'administrators' table prior to running the setup so you start without any zenphoto user/password.

I downloaded it from your website. I thought that was the most recent version. Should I do the nightly update or do a full reinstall. Do you have a direct link to 1.1.7? i deleted the whole database and made a new one. I checked to be sure there were no tables in the database when I tried again. Thank you for your time by the way!

Of course it depends on when you do the download. Yesterday was the release of 1.1.7. Anyway, you are running 1.1.6, so get 1.1.7 from http://www.zenphoto.org/

Ok. I reuploaded zenphoto from your website. I uploaded the zp-config.php with the information for my zenphoto database. I then went to http://www.tahoeunderground.com/zenphoto
which redirects me to http://www.tahoeunderground.com/zenphoto/zp-core/setup.php It gives me the "GO" link at the bottom of the page to create the tables in my database. When I click "GO" it takes me here... http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?checked&create=zp_options,zp_albums,zp_images,zp_comments,zp_administrators,zp_admintoalbum,zp_tags,zp_obj_to_tag . The page says...

Zenphoto Setup
About to create tables...

Then in a red table it says...

Zenphoto Error
MySQL Query ( SELECT * FROM `zp_albums` ) Failed. Error:Table 'zenphoto.zp_albums' doesn't exist
It looks like your zenphoto tables haven't been created.You may need to run the setup script.

"run the set up script" is a link which I click, which takes me back to http://www.tahoeunderground.com/zenphoto/zp-core/setup.php with the "Go" set up tables link. It just takes me in a circle from one page to the next. This is obviosly a new problem and I'm not getting as far in the setup as I did before I installed 1.1.7. What should I do now?

Does this have to do with the problem? I was just looking at the setup.php file. At the top it says...
define('HTACCESS_VERSION', '1.1.6.0'); // be sure to change this the one in .htaccess when the .htaccess file is updated.

I then went to the .htaccess file and at the top it says...
# htaccess file version 1.1.6.0
# Update the above and the define in setup.php when you make changes to the rewrite rules!
# NOTE: Change the RewriteBase below to the absolute path to your zenphoto directory. (Or let setup.php do it for you!)

Do I need to change any of this or is it automated? Does this mean I downloaded version 1.1.6 again?
Dang I know this should be easy but...

You do not need to change the .htaccess file. It his not been modified since 1.1.6.0 so we have left the versions intact.

Run setup again this time add ?debug to the URL: `http://www.tahoeunderground.com/zenphoto/zp-core/setup.php?debug`

This will create a log of what Setup is doing and the results. First guess is that it is not succeeding in creating the tables.

Hi sbillard,
I have the same problem of joeback, I followed your steps, and what I found out in the log file is that there are those errors:

Begin table updates
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_type` varchar(20); ) Failed. Error: Duplicate column name 'sort_type'
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `sort_order` int(11); ) Failed. Error: Duplicate column name 'sort_order'
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `sort_order` int(11); ) Failed. Error: Duplicate column name 'sort_order'
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `height` INT UNSIGNED; ) Failed. Error: Duplicate column name 'height'
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `width` INT UNSIGNED; ) Failed. Error: Duplicate column name 'width'
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `parentid` int(11) unsigned default NULL; ) Failed. Error: Duplicate column name 'parentid'
MySQL Query ( ALTER TABLE `zp_images` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
MySQL Query ( ALTER TABLE `zp_albums` ADD COLUMN `mtime` int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
MySQL Query ( ALTER TABLE `zp_options` DROP `bool`, DROP `description`; ) Failed. Error: Can't DROP 'bool'; check that column/key exists

and some more, please let me know if you want me to send you also them.

my zenphoto version is 1.1.7 [1842]

Please create a ticket and post the complete file. These are expected errors if you are upgrading.

H

I'm not upgrading...
how can I create a ticket?

Please see #2 here http://www.zenphoto.org/support/topic.php?id=2831&replies=2

Your first guess was right. It doesn't get past the http://www.tahoeunderground.com/zenphoto/zp-core/setup.php page anymore to set up the tables. It did set up the tables before I did the upgrade, but I erased that database to create a new fresh one. I added "debug" to think link and the list it gives is a mile long.!? Im not going to past it here to save space. But the link is above for you to view.

You should then check the permissions that the MySQL user you assigned to zenphoto has. Your setup indicates that there might be a problem there and the result of this exercise indicates that setup is unable to create tables in the database.

I just got this message from my host... " Hi Joe,

MySQL show grants access is disabled due to shared database security
policies and cannot be enabled for client users.

You may wish to consult the developer to see if this is necessary to
run the program or if it only affects certain modules of the program. "

Is this my problem?

It is not necessary for the show grants access as this is just a warning that setup cannot tell if things are set correctly. However, the rights that setup suggests are required for zenphoto to run. In your case it appears that zenphoto does not have the correct rights. Of course, since your ISP thinks that show rights is a security problem we can't check that.