ZenphotoCMS Forum
Error: "Unknown column 'password' in 'field list'" - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Error: "Unknown column 'password' in 'field list'" (/thread-2006.html)



Error: "Unknown column 'password' in 'field list'" - mypart - 2007-12-31

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/




Error: "Unknown column 'password' in 'field list'" - aitf311 - 2007-12-31

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




Error: "Unknown column 'password' in 'field list'" - mypart - 2007-12-31

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




Error: "Unknown column 'password' in 'field list'" - milesenglish - 2008-01-18

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'




Error: "Unknown column 'password' in 'field list'" - acrylian - 2008-01-18

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




Error: "Unknown column 'password' in 'field list'" - milesenglish - 2008-01-18

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?




Error: "Unknown column 'password' in 'field list'" - sbillard - 2008-01-19

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.




Error: "Unknown column 'password' in 'field list'" - milesenglish - 2008-01-21

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




Error: "Unknown column 'password' in 'field list'" - acrylian - 2008-01-21

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




Error: "Unknown column 'password' in 'field list'" - sbillard - 2008-01-21

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