grrr Simple Scripts

pupa

It just didn't work for me, so i tried installing Zenphoto as per the instructions here. I presently have ZP installed in a folder, but i want it in the top level of my site, so I unzipped it there. I input my Database Information, and everything looks fine, except i have a login username/password and nothing i've tried works. Help!

pupa

Allow me to clarify: I used Simple Scripts to install Zenphoto to a folder /zenphoto/ on my host. When i did this, it returned a message: "your admin username/password is such-and-such". Later, i wanted to upgrade and tried to use Simple Scripts for the upgrade, but it messed up my installation, so i tried uploading v1.3 to my host one level up, ie not in a "zenphoto/" folder, just in with my index.html. The setup.php came up OK and i put the SQL Database Info from my previous installation and all seems well EXCEPT there is a log in field and nothing i try there is working. On the previous installations, Simple Scripts sent me the login info. Where do i find this? Thanks!

pupa

...oh, one other thing: when i try to log in with the username/password from my other zenphoto installation, i get this:

MySQL Query ( SELECT * FROM `zp_administrators` WHERE `valid` = '1' ) failed. MySQL returned the error Unknown column 'valid' in 'where clause'

pupa

Well, i've installed/uninstalled Zenphoto 1.3 three times. I have that existing installation one folder level down, maybe that's messing something up. I get the setup.php page ok, and enter the Database Info, but at the bottom is a log-in username/password, and i've tried every combination of username/password i can think of and nothing. I can't even reset it because i have "no mail handler configured". Help?

acrylian

We don't know nothing about SimpleScripts and we actually neither care or support those.

If you install Zenphoto manually as we recommend, you have to set your username and password yourself after installation.
I suspect you maybe use the same database for the manual install.

The fix is to delete the db table "administrators" manually and rerun setup (as written on our troubleshooting as well). You should delete the SimpleScripts install.

Regarding the error we had one report before but never seen ourselves. So please do what my collegue suggests there:
http://www.zenphoto.org/support/topic.php?id=7472#post-43899

pupa

Thanks for the answer. I successfully installed Zenphoto on another server by following your instructions, so I know it works. My question is: why do i get a username/password field at the bottom of the setup.php page? (instead of "Go" or "Stop") I've tried the username/password for my server, for my existing zenphoto admin page (which is in a folder one level down); I even created a new mySQL user and associated it with my database, all with no luck. It seems to me that this Zenphoto installation shouldn't be aware of the original installation in a folder one level down...I'm loathe to delete my existing installation out of fear of somehow losing my data, that's why i'm doing it this way...Thanks for any advice.

acrylian

You get the username/password field at the bottom because you have already an installations. I assume SimpleScripts might use the same database prefix "zp_" for the tables as Zenphoto does if you don't set anything else. So both installs use exactly the same database. Either you delete all tables or you change the prefix. You can do that in `zp-data/zp-config.php`.

pupa

Again, thanks for the reply. OK, I got my v1.3 running by creating a new database. Now i want to import the data from my "old" database. but i get this error:

Error

SQL query:

--
-- Dumping data for table `zp_administrators`
--

MySQL said: Documentation
#1054 - Unknown column 'password' in 'field list'

acrylian

If you haven't entered anything on the backend, you don't need to import (Zenphoto has also its own tool for that btw).

Just move any possible images and albums from the root albums folder to the one of the right install. Zenphoto will discover them.

Setup will ask you to set a new admin user and password anyway.

pupa

I have all my albums and images and theme working, my sticking point is the descriptions and tags for the images. I'm not sure how to export/import from my original db to the new one i made. The tags moved over ok, which was huge. Thanks!

sbillard

You have to export (backup) and import (restore) the database with the same version of zenphoto that created it. Otherwise you may get issues with database fields which have changed over time. Restore will ignore those fields, but that may not be very successful for the password field. Of coures, you can do the import, drop the administrator's table and re-run setup. Re create your administrator and you will be good to go.

pupa

Again, thanks for the help. I pretty much got v1.3 working, only my image descriptions and assigned tags are missing. I can't figure out how to Import/Export one column from a table, so I may end up having to copy and past everything, which would be a major bore as there are about 300 images. I can't Export/Import just the zp_images because there are different fields between the two versions. Any workarounds would be appreciated, thanks for the input!

acrylian

As said Zenphoto has its own backup utility for this. Please read this: http://www.zenphoto.org/2009/03/troubleshooting-zenphoto/#40

pupa

This is what i want to do: copy my Zenphoto installation up one level on my server (it's in a "zenphoto" folder now, i want it in the root of my public_html) and update from 1.26 to 1.3. I followed the upgrade instructions exactly, copying my installation up one level then deleting the zp-core folder, etc, and uploading the new files. I ran setup and after entering my database info, i get a login field at the bottom of the setup page. I can change the table prefix and get new tables, but then the data -- most importantly about 400 desc fields -- are empty. The one thing I DON'T want to do is remove my working installation, that's the motivation for installing a second copy to update.

pupa

OK...i think i got it: i created a new, blank database, then Restored from my last backup. There were some errors cuz of the the extra tables in the newer version database, and my login wouldn't work. So I dropped the Administrator table and now it seems to be working. All my descriptions are there. I think someone might have suggested doing it like this, but it took me a few (40?) times installing everything to understand what was meant. Again thanks to everyone who helped.

acrylian

The link I posted tells what to do to move (or copy or import) an installation actually.