Member
Member
mypart   2007-12-31, 17:24
#1

Hi there,
I got problems again, maybe due to not properly updating to 1.1.3 (?).
After creating a new album and uploading one photo to it I already got an error-message which I don't recall exactly but it also had to do something with the "Unknown column 'password' in 'field list'". The album-folder was created though and the pic was uploaded.
Now when I click on "Edit" in the AdminPanel I get the following error message straight away:
`[code]

Zenphoto Error

MySQL Query ( INSERT INTO zen_albums (folder, subalbum_sort_type, album_sortdirection, sort_type, image_sortdirection, password, title) VALUES ('quito', 'Manual', '0', '', '', '', 'quito'); ) Failed. Error: Unknown column 'password' in 'field list'

[/code]`
The error also shows up on my gallery's indexpage now:
http://www.mypartofthe.net/photo/zenphoto/

Member
Member
aitf311   2007-12-31, 19:04
#2

Did you rerun setup? If not, you need to do so.

Member
Member
mypart   2007-12-31, 19:17
#3

Hmm, thought I did after I first had problems with my DataBase Prefix, but as it seems I didn't.
Everyting seems to work fine again now, thanks so much!!
Also for helping me out now with a couple of n00b or RTFM questions ;-)

Cheers

Member
Member
milesenglish   2008-01-18, 19:54
#4

Hi, I have this same error and I see that it was suggested to re-run the setup. How do I do that?

Thanks,
Miles

the error:
MySQL Query ( INSERT INTO my photosalbums (folder, subalbum_sort_type, album_sortdirection, sort_type, image_sortdirection, password, title) VALUES ('test', 'Manual', '0', 'Filename', '1', '', 'test'); ) Failed. Error: Unknown column 'password' in 'field list'

Administrator
Administrator
acrylian   2008-01-18, 20:57
#5

You should have run setup while installing. Just point your browser to //zp-core/setup.php

Member
Member
milesenglish   2008-01-18, 21:17
#6

I did run it when I installed ZP. Everything worked fine - I created 4 albums and uploaded a bunch of images. A couple months later (today) I tried to log in but forgot my password. I used the link to Email password, changed my username and password and logged on. I then tried to create a new album and got the error message above. I re-ran the setup link and still get the same error.

Any thoughts?

Member
Member
sbillard   2008-01-19, 03:32
#7

Can you look at your database and see if the password field exists? If it does not, then you need to run setup.php to create it again.

Member
Member
milesenglish   2008-01-21, 17:32
#8

I'm sorry, I'm not super saavy with this stuff. I think I checked the database correctly and did NOT find a password field. Here's a screen cap that shows where I checked. What do you think?
www.milesenglish.com/images/database.jpg

Administrator
Administrator
acrylian   2008-01-21, 18:09
#9

The screenshot you posted shows the tables not the columns. You need to click on the names to see the thte columns, in this case for password look within "albums" and "images".

Member
Member
sbillard   2008-01-21, 18:11
#10

Just run setup.php again to be sure. This problem has always in the past been because the table fields were not created.

  
Powered By MyBB, © 2002-2026 MyBB Group.
Made with by Curves UI.