Hello,
after running zenphoto setup, I've got this error:

Zenphoto Error
MySQL Query ( SELECT DISTINCT ownerid FROM foh4_commentsWHERE type IN ("images","_images") ) failed. Error: Unknown column 'ownerid' in 'field list'

what can I do?

Please tell us the version of Zenphoto you are running and how it was installed.

There should be no reason for the ownerid field to be missing as is will be created when Zenpoto is installed. You should try running the setup program again.

ello I get a similar error,

I have just upgraded from 1.0.8 to the latest vs 1.2.6. I tried a couple of times to run the install file, which is sucessfull but on viewing the large images or refreshing the database, I am presented with the following error. ANy help would be much appreciated.

All the Best

Arooga1

MySQL Query ( SELECT DISTINCT ownerid FROM zen_commentsWHERE type IN ("images","_images") ) failed. Error: Unknown column 'ownerid' in 'field list'

Setup will have created a setup log during installation. Please post the results of that log, specially anything referencing the ownerid field.

Hi SBillard, thanks for your fast reply, I believe you are looking for the following information, from this location /www/photos/zp-data/.

I look forward to hearing from you.

Best Regards
Arooga1

Zenphoto Setup v1.2.6[4335]
warn: PHP mbstring package [Your internal characater set is [b]ISO-8859-1[/b]] Setting [i]mbstring.internal_encoding[/i] to [b]UTF-8[/b] in your [i]php.ini[/i] file is recommended to insure accented and multi-byte characters function properly.
warn: MySQL version 4.1.22 Version 4.1 or greater is required. Use a lower version at your own risk.Version 5.0 or greater is prefered.
warn: MySQL field collations [Image and Album tables] You should consider porting your data to UTF-8 and changing the collation of the database fields to utf8_unicode_ci
warn: Zenphoto core files [Some files are missing or their [i]filemtimes[/i] seem out of variance] Perhaps there was a problem with the upload. You should check the following files: index.php rss-comments.php rss-news-comments.php rss-news.php rss.php themes/default/404.php themes/default/album.php themes/default/archive.php themes/default/contact.php themes/default/image.php themes/default/images/50percent.png themes/default/images/img-bg.gif themes/default/images/tag.png themes/default/index.php themes/default/password.php themes/default/register.php themes/default/search.php themes/default/slideshow-controls.png themes/default/slideshow.css themes/default/slideshow.php themes/default/styles/dark.css themes/default/styles/light.css themes/default/styles/sterile-dark.css themes/default/styles/sterile-light.css themes/default/theme.png themes/default/themeoptions.php themes/default/theme_description.php themes/effervescence_plus/images/25percent.png themes/effervescence_plus/images/50percent.png themes/effervescence_plus/images/50percentwhite.png themes/effervescence_plus/images/arrow_right.png themes/effervescence_plus/images/dark-bullet.png themes/effervescence_plus/images/dark_arrow_right.png themes/effervescence_plus/images/err-passwordprotected.gif themes/effervescence_plus/images/imageDefault.png themes/effervescence_plus/images/logo.png themes/effervescence_plus/images/multimediaDefault.png themes/effervescence_plus/images/search.png themes/effervescence_plus/images/slimbox/closelabel.gif themes/effervescence_plus/images/slimbox/loading.gif themes/effervescence_plus/images/slimbox/nextlabel.gif themes/effervescence_plus/images/slimbox/prevlabel.gif themes/effervescence_plus/images/smooth/carrow1.gif themes/effervescence_plus/images/smooth/carrow2.gif themes/effervescence_plus/images/smooth/fleche1.gif themes/effervescence_plus/images/smooth/fleche1.png themes/effervescence_plus/images/smooth/fleche2.gif themes/effervescence_plus/images/smooth/fleche2.png themes/effervescence_plus/images/smooth/loading-bar-black.gif themes/effervescence_plus/images/smooth/open.gif themes/effervescence_plus/images/smooth/open.png Zenphoto.package
Notice: "Module mod_rewrite" is working. The Zenphoto option "mod_rewrite" is "enabled".

Please run setup again, this time add ?debug to the URL--/zenphoto/zp-core/setup.php?debug.

Hi Sbillard, I have done that there is no change, that error only happens on the refresh database from admin and also now noticed one of the themes. The rest appears to work ok, though I noticed the back up was not working and on deciphering the code understood it was looking fro a backup folder to backup to, which was not in my core files.

Look fwd to your thoughts about the error.

Regards
Arooga1

The error will (presumably) occur lots of different places. Anywhere where comments might be referenced.

The issue is that the database field ownerid does not apparently exist. Possibly there is a different field albumid instead. The albumid field name should have been changed to ownerid by setup. Running setup with the debug option should have created a log of each SQL command setup made. What we need to do is find out why the SQL to change that field name did not succeed.

Hi there,

I understand what you required now...sorry, I am not a programmer. Here it is..

Zenphoto Setup v1.2.6[4335]
Full environment
pass: PHP version 5.2.9
pass: PHP Safe Mode
pass: PHP magic_quotes_gpc
pass: Graphics support: PHP GD library [i]bundled (2.0.34 compatible)[/i]
pass: PHP gettext() support
warn: PHP mbstring package [Your internal characater set is [b]ISO-8859-1[/b]] Setting [i]mbstring.internal_encoding[/i] to [b]UTF-8[/b] in your [i]php.ini[/i] file is recommended to insure accented and multi-byte characters function properly.
pass: PHP MySQL support
pass: [i]zp-config.php[/i] file
pass: [i]Strict Permissions[/i] [is in effect] On some servers Zenphoto does not function correctly with strict file/folder permissions. If you are getting permission errors run setup again and disable the option.

Click here to enable relaxed file/folder permissions.

[b]NOTE:[/b] This option applies only to new files and folders created by Zenphoto. You may have to change permissions on existing ones to resolve problems.
pass: MySQL setup in [i]zp-config.php[/i]
warn: MySQL version 4.1.22 Version 4.1 or greater is required. Use a lower version at your own risk.Version 5.0 or greater is prefered.
pass: Connect to the database intsands_db
pass: MySQL SQL mode
pass: MySQL access rights
pass: MySQL [i]show tables[/i] found: zen_administrators, zen_admintoalbum, zen_albums, zen_captcha, zen_comments, zen_images, zen_obj_to_tag, zen_options, zen_tags, zen_zenpage_news, zen_zenpage_news2cat, zen_zenpage_news_categories, zen_zenpage_pages
warn: MySQL field collations [Image and Album tables] You should consider porting your data to UTF-8 and changing the collation of the database fields to utf8_unicode_ci
warn: Zenphoto core files [Some files are missing or their [i]filemtimes[/i] seem out of variance] Perhaps there was a problem with the upload. You should check the following files: .htaccess index.php License.txt lighttpd_rules.conf rss-comments.php rss-news-comments.php rss-news.php rss.php themes/default/404.php themes/default/album.php themes/default/archive.php themes/default/contact.php themes/default/image.php themes/default/images/50percent.png themes/default/images/img-bg.gif themes/default/images/tag.png themes/default/index.php themes/default/password.php themes/default/register.php themes/default/search.php themes/default/slideshow-controls.png themes/default/slideshow.css themes/default/slideshow.php themes/default/styles/dark.css themes/default/styles/light.css themes/default/styles/sterile-dark.css themes/default/styles/sterile-light.css themes/default/theme.png themes/default/themeoptions.php themes/default/theme_description.php themes/effervescence_plus/404.php themes/effervescence_plus/album.php themes/effervescence_plus/archive.php themes/effervescence_plus/contact.php themes/effervescence_plus/customfunctions.php themes/effervescence_plus/gallery.php themes/effervescence_plus/image.php themes/effervescence_plus/images/25percent.png themes/effervescence_plus/images/50percent.png themes/effervescence_plus/images/50percentwhite.png themes/effervescence_plus/images/arrow_right.png themes/effervescence_plus/images/dark-bullet.png themes/effervescence_plus/images/dark_arrow_right.png themes/effervescence_plus/images/err-passwordprotected.gif themes/effervescence_plus/images/imageDefault.png themes/effervescence_plus/images/logo.png themes/effervescence_plus/images/multimediaDefault.png themes/effervescence_plus/images/search.png themes/effervescence_plus/images/slimbox/closelabel.gif themes/effervescence_plus/images/slimbox/loading.gif themes/effervescence_plus/images/slimbox/nextlabel.gif themes/effervescence_plus/images/slimbox/prevlabel.gif themes/effervescence_plus/images/smooth/carrow1.gif themes/effervescence_plus/images/smooth/carrow2.gif themes/effervescence_plus/images/smooth/fleche1.gif themes/effervescence_plus/images/smooth/fleche1.png themes/effervescence_plus/images/smooth/fleche2.gif themes/effervescence_plus/images/smooth/fleche2.png themes/effervescence_plus/images/smooth/loading-bar-black.gif themes/effervescence_plus/images/smooth/open.gif themes/effervescence_plus/images/smooth/open.png themes/effervescence_plus/images/zen-logo.jpg themes/effervescence_plus/index.php themes/effervescence_plus/indexpage.php themes/effervescence_plus/jd.gallery.css themes/effervescence_plus/news.php themes/effervescence_plus/pages.php themes/effervescence_plus/password.php themes/effervescence_plus/register.php themes/effervescence_plus/scripts/bluranchors.js themes/effervescence_plus/scripts/jd.gallery.js themes/effervescence_plus/scripts/jd.gallery.set.js themes/effervescence_plus/scripts/jd.gallery.transitions.js themes/effervescence_plus/scripts/mootools.v1.11.js themes/effervescence_plus/scripts/slimbox.js themes/effervescence_plus/scripts/swfobject.js themes/effervescence_plus/search.php themes/effervescence_plus/sidebar.php themes/effervescence_plus/simpleviewer.swf themes/effervescence_plus/slideshow-controls.png themes/effervescence_plus/slideshow.css themes/effervescence_plus/slideshow.php themes/effervescence_plus/slimbox.css themes/effervescence_plus/styles/blue and green play.css themes/effervescence_plus/styles/effervescence.css themes/effervescence_plus/styles/free chocolates.css themes/effervescence_plus/styles/kish-my father.css themes/effervescence_plus/styles/machu picchu.css themes/effervescence_plus/styles/oktoberfest.css themes/effervescence_plus/styles/poolside.css themes/effervescence_plus/styles/see you again.css themes/effervescence_plus/theme.jpg themes/effervescence_plus/themeoptions.php themes/effervescence_plus/theme_description.php themes/example/404.php themes/example/album.php themes/example/archive.php themes/example/contact.php themes/example/image.php themes/example/index.php themes/example/password.php themes/example/register.php themes/example/search.php themes/example/slideshow-controls-old.png themes/example/slideshow-controls.png themes/example/slideshow.css themes/example/slideshow.php themes/example/tag.png themes/example/theme.png themes/example/themeoptions.php themes/example/theme_description.php themes/example/zen.css themes/stopdesign/404.php themes/stopdesign/album.php themes/stopdesign/comment.php themes/stopdesign/comment_form.php themes/stopdesign/contact.php themes/stopdesign/css/comments-hide.css themes/stopdesign/css/comments-show.css themes/stopdesign/css/custom.css themes/stopdesign/css/master.css themes/stopdesign/css/photos.css themes/stopdesign/gallery.php themes/stopdesign/image.php themes/stopdesign/images/50percent.png themes/stopdesign/images/bg_gal.gif themes/stopdesign/images/bg_gal.png themes/stopdesign/images/bg_page.jpg themes/stopdesign/images/bg_path.gif themes/stopdesign/images/bg_shadow.png themes/stopdesign/images/bg_slide.gif themes/stopdesign/images/bg_slide.png themes/stopdesign/images/bg_slide_sm.gif themes/stopdesign/images/bg_slide_sm.png themes/stopdesign/images/btn_add_a_comment.gif themes/stopdesign/images/btn_all_favorites.gif themes/stopdesign/images/btn_gallery_archive.gif themes/stopdesign/images/btn_go.gif themes/stopdesign/images/btn_hide.gif themes/stopdesign/images/btn_preview.gif themes/stopdesign/images/btn_rss.gif themes/stopdesign/images/btn_save.gif themes/stopdesign/images/btn_show.gif themes/stopdesign/images/btn_submit.gif themes/stopdesign/images/btn_view_gallery.gif themes/stopdesign/images/bullet_white.gif themes/stopdesign/images/canon_sd10.jpg themes/stopdesign/images/divider_l.gif themes/stopdesign/images/divider_l.png themes/stopdesign/images/divider_r.gif themes/stopdesign/images/divider_r.png themes/stopdesign/images/err-passwordprotected.gif themes/stopdesign/images/icon_pushpin.gif themes/stopdesign/images/imageDefault.png themes/stopdesign/images/moreslide_next.gif themes/stopdesign/images/moreslide_prev.gif themes/stopdesign/images/photonav_next.gif themes/stopdesign/images/photonav_next.png themes/stopdesign/images/photonav_prev.gif themes/stopdesign/images/photonav_prev.png themes/stopdesign/images/slide_minis.gif themes/stopdesign/images/txt_backward.gif themes/stopdesign/images/txt_forward.gif themes/stopdesign/index.php themes/stopdesign/js/comments.js themes/stopdesign/normalizer.php themes/stopdesign/password.php themes/stopdesign/register.php themes/stopdesign/search.php themes/stopdesign/slideshow-controls.png themes/stopdesign/slideshow.css themes/stopdesign/slideshow.php themes/stopdesign/theme.png themes/stopdesign/themeoptions.php themes/stopdesign/theme_description.php themes/zenpage-default/404.php themes/zenpage-default/album.php themes/zenpage-default/archive.php themes/zenpage-default/contact.php themes/zenpage-default/footer.php themes/zenpage-default/gallery.php themes/zenpage-default/image.php themes/zenpage-default/images/50percent.png themes/zenpage-default/images/arrow_right.gif themes/zenpage-default/images/body.jpg themes/zenpage-default/images/footer.jpg themes/zenpage-default/images/header.jpg themes/zenpage-default/images/img-bg.gif themes/zenpage-default/images/tag.png themes/zenpage-default/index.php themes/zenpage-default/news.php themes/zenpage-default/pages.php themes/zenpage-default/password.php themes/zenpage-default/register.php themes/zenpage-default/search.php themes/zenpage-default/sidebar.php themes/zenpage-default/slideshow-controls.png themes/zenpage-default/slideshow.css themes/zenpage-default/slideshow.php themes/zenpage-default/style.css themes/zenpage-default/theme.png themes/zenpage-default/themeoptions.php themes/zenpage-default/theme_description.php Zenphoto.package zp-core/example_robots.txt
pass: [i].htaccess[/i] file ([i]RewriteEngine[/i] is [b]ON[/b])
pass: [i].htaccess[/i] RewriteBase is /photos
warn: [i]robots.txt[/i] file [Not created] Setup could not create a [i]robots.txt[/i] file.
pass: [i]albums[/i] folder
pass: [i]cache[/i] folder
pass: [i]locale[/i] folders
pass: [i]uploaded[/i] folder
pass: [i]zp-data[/i] folder
Completed system check
Checked
Begin table creation
Begin table updates
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN sort_type varchar(20); ) Failed. Error: Duplicate column name 'sort_type'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN sort_order int(11); ) Failed. Error: Duplicate column name 'sort_order'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN sort_order int(11); ) Failed. Error: Duplicate column name 'sort_order'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN height INT UNSIGNED; ) Failed. Error: Duplicate column name 'height'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN width INT UNSIGNED; ) Failed. Error: Duplicate column name 'width'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN parentid int(11) unsigned default NULL; ) Failed. Error: Duplicate column name 'parentid'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN mtime int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN mtime int(32) default NULL; ) Failed. Error: Duplicate column name 'mtime'
MySQL Query ( ALTER TABLE zen_options DROP bool, DROP description; ) Failed. Error: Can't DROP 'bool'; check that column/key exists
MySQL Query ( ALTER TABLE zen_options CHANGE value value text; ) Success.
MySQL Query ( ALTER TABLE zen_options DROP INDEX name; ) Failed. Error: Can't DROP 'name'; check that column/key exists
MySQL Query ( ALTER TABLE zen_options ADD UNIQUE (name); ) Success.
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN commentson int(1) UNSIGNED NOT NULL default '1'; ) Failed. Error: Duplicate column name 'commentson'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN subalbum_sort_type varchar(20) default NULL; ) Failed. Error: Duplicate column name 'subalbum_sort_type'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN location tinytext; ) Failed. Error: Duplicate column name 'location'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN city tinytext; ) Failed. Error: Duplicate column name 'city'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN state tinytext; ) Failed. Error: Duplicate column name 'state'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN country tinytext; ) Failed. Error: Duplicate column name 'country'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN credit tinytext; ) Failed. Error: Duplicate column name 'credit'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN copyright tinytext; ) Failed. Error: Duplicate column name 'copyright'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN date datetime default NULL; ) Failed. Error: Duplicate column name 'date'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFValid int(1) UNSIGNED default NULL; ) Failed. Error: Duplicate column name 'EXIFValid'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN hitcounter int(11) UNSIGNED default 0; ) Failed. Error: Duplicate column name 'hitcounter'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFOrientation varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFOrientation'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFMake varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFMake'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFModel varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFModel'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFDescription varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFDescription'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFArtist varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFArtist'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFCopyright varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFCopyright'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFExposureTime varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFExposureTime'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFFNumber varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFFNumber'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFFocalLength varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFFocalLength'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFFocalLength35mm varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFFocalLength35mm'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFISOSpeedRatings varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFISOSpeedRatings'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFDateTimeOriginal varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFDateTimeOriginal'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFExposureBiasValue varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFExposureBiasValue'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFMeteringMode varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFMeteringMode'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFFlash varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFFlash'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFImageWidth varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFImageWidth'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFImageHeight varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFImageHeight'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFContrast varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFContrast'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFSharpness varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFSharpness'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFSaturation varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFSaturation'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFWhiteBalance varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFWhiteBalance'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFSubjectDistance varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFSubjectDistance'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSLatitude varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSLatitude'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSLatitudeRef varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSLatitudeRef'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSLongitude varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSLongitude'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSLongitudeRef varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSLongitudeRef'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSAltitude varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSAltitude'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN EXIFGPSAltitudeRef varchar(52) default NULL; ) Failed. Error: Duplicate column name 'EXIFGPSAltitudeRef'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN image_sortdirection int(1) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'image_sortdirection'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN album_sortdirection int(1) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'album_sortdirection'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN total_value int(11) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'total_value'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN total_votes int(11) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'total_votes'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN used_ips longtext; ) Failed. Error: Duplicate column name 'used_ips'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN password varchar(255) NOT NULL default ''; ) Failed. Error: Duplicate column name 'password'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN password_hint text; ) Failed. Error: Duplicate column name 'password_hint'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN hitcounter int(11) UNSIGNED default 0; ) Failed. Error: Duplicate column name 'hitcounter'
MySQL Query ( ALTER TABLE zen_comments ADD COLUMN type varchar(52) NOT NULL default 'images'; ) Failed. Error: Duplicate column name 'type'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN total_value int(11) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'total_value'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN total_votes int(11) UNSIGNED default '0'; ) Failed. Error: Duplicate column name 'total_votes'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN used_ips longtext; ) Failed. Error: Duplicate column name 'used_ips'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN custom_data text ) Failed. Error: Duplicate column name 'custom_data'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN custom_data text ) Failed. Error: Duplicate column name 'custom_data'
MySQL Query ( ALTER TABLE zen_albums CHANGE password password varchar(255) NOT NULL DEFAULT '' ) Success.
MySQL Query ( ALTER TABLE zp_comments DROP FOREIGN KEY comments_ibfk1 ) Failed. Error: Table 'intsands_db.zp_comments' doesn't exist
MySQL Query ( ALTER TABLE zen_comments CHANGE imageid ownerid int(11) UNSIGNED NOT NULL default '0'; ) Failed. Error: Error on rename of './intsands_db/#sql-51ce_53cc2d' to './intsands_db/zen_comments' (errno: 150)
MySQL Query ( ALTER TABLE zen_comments DROP INDEX imageid; ) Failed. Error: Error on rename of './intsands_db/#sql-51ce_53cc2d' to './intsands_db/zen_comments' (errno: 150)
MySQL Query ( ALTER TABLE zen_comments ADD INDEX (ownerid); ) Failed. Error: Key column 'ownerid' doesn't exist in table
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN dynamic int(1) UNSIGNED default '0' ) Failed. Error: Duplicate column name 'dynamic'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN search_params text ) Failed. Error: Duplicate column name 'search_params'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN album_theme text ) Failed. Error: Duplicate column name 'album_theme'
MySQL Query ( ALTER TABLE zen_comments ADD COLUMN IP text ) Failed. Error: Duplicate column name 'IP'
MySQL Query ( ALTER TABLE zen_comments ADD COLUMN private int(1) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'private'
MySQL Query ( ALTER TABLE zen_comments ADD COLUMN anon int(1) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'anon'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN user varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci default '' ) Failed. Error: Duplicate column name 'user'
MySQL Query ( ALTER TABLE zen_tags CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_tags CHANGE name name varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_administrators CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_administrators CHANGE name name TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_options ADD COLUMN ownerid int(11) UNSIGNED NOT NULL DEFAULT 0 ) Failed. Error: Duplicate column name 'ownerid'
MySQL Query ( ALTER TABLE zen_options DROP INDEX name ) Success.
MySQL Query ( ALTER TABLE zen_options ADD UNIQUE unique_option (name, ownerid) ) Failed. Error: Duplicate key name 'unique_option'
MySQL Query ( ALTER TABLE zen_options CHANGE ownerid ownerid int(11) UNSIGNED NOT NULL DEFAULT 0 ) Success.
MySQL Query ( ALTER TABLE zen_admintoalbum CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_obj_to_tag CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_options CHANGE name name varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci ) Success.
MySQL Query ( ALTER TABLE zen_albums CHANGE title title TEXT ) Success.
MySQL Query ( ALTER TABLE zen_albums CHANGE place place TEXT ) Success.
MySQL Query ( ALTER TABLE zen_images CHANGE title title TEXT ) Success.
MySQL Query ( ALTER TABLE zen_images CHANGE location location TEXT ) Success.
MySQL Query ( ALTER TABLE zen_images CHANGE credit credit TEXT ) Success.
MySQL Query ( ALTER TABLE zen_images CHANGE copyright copyright TEXT ) Success.
MySQL Query ( ALTER TABLE zen_images ADD COLUMN thumbX int(10) UNSIGNED default NULL; ) Failed. Error: Duplicate column name 'thumbX'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN thumbY int(10) UNSIGNED default NULL; ) Failed. Error: Duplicate column name 'thumbY'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN thumbW int(10) UNSIGNED default NULL; ) Failed. Error: Duplicate column name 'thumbW'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN thumbH int(10) UNSIGNED default NULL; ) Failed. Error: Duplicate column name 'thumbH'
MySQL Query ( ALTER TABLE zen_zenpage_news_categories DROP INDEX cat_link; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news_categories ADD UNIQUE (cat_link); ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news DROP INDEX titlelink; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news ADD UNIQUE (titlelink); ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages DROP INDEX titlelink; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD UNIQUE (titlelink); ) Success.
MySQL Query ( ALTER TABLE zen_comments CHANGE comment comment TEXT; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news CHANGE title title TEXT; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news_categories CHANGE cat_name cat_name TEXT; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages CHANGE title title TEXT; ) Success.
MySQL Query ( ALTER TABLE zen_comments ADD COLUMN custom_data TEXT; ) Failed. Error: Duplicate column name 'custom_data'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN expiredate datetime default NULL ) Failed. Error: Duplicate column name 'expiredate'
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN expiredate datetime default NULL ) Failed. Error: Duplicate column name 'expiredate'
MySQL Query ( UPDATE zen_zenpage_pages SET parentid=NULL WHERE parentid=0 ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages CHANGE sort_order sort_order VARCHAR(48) NOT NULL default "" ) Success.
MySQL Query ( ALTER TABLE zen_albums CHANGE parentid parentid int(11) unsigned default NULL; ) Success.
MySQL Query ( ALTER TABLE zen_images CHANGE albumid albumid int(11) unsigned default NULL; ) Success.
MySQL Query ( UPDATE zen_albums SET parentid=NULL WHERE parentid=0 ) Success.
MySQL Query ( UPDATE zen_images SET albumid=NULL WHERE albumid=0 ) Success.
MySQL Query ( DELETE FROM zen_zenpage_pages WHERE titlelink="" ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages DROP INDEX titlelink; ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD UNIQUE (titlelink); ) Success.
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN rating FLOAT NOT NULL DEFAULT 0 ) Failed. Error: Duplicate column name 'rating'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN rating_status int(1) UNSIGNED default 3 ) Failed. Error: Duplicate column name 'rating_status'
MySQL Query ( UPDATE zen_albums SET rating=total_value / total_votes WHERE total_votes > 0 ) Success.
MySQL Query ( ALTER TABLE zen_images ADD COLUMN rating FLOAT NOT NULL DEFAULT 0 ) Failed. Error: Duplicate column name 'rating'
MySQL Query ( ALTER TABLE zen_images ADD COLUMN rating_status int(1) UNSIGNED default 3 ) Failed. Error: Duplicate column name 'rating_status'
MySQL Query ( UPDATE zen_images SET rating=total_value / total_votes WHERE total_votes > 0 ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN total_votes int(11) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'total_votes'
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN total_value int(11) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'total_value'
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN rating FLOAT NOT NULL DEFAULT 0 ) Failed. Error: Duplicate column name 'rating'
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN used_ips longtext; ) Failed. Error: Duplicate column name 'used_ips'
MySQL Query ( ALTER TABLE zen_zenpage_pages ADD COLUMN rating_status int(1) UNSIGNED default 3 ) Failed. Error: Duplicate column name 'rating_status'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN total_votes int(11) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'total_votes'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN total_value int(11) UNSIGNED default 0 ) Failed. Error: Duplicate column name 'total_value'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN rating FLOAT NOT NULL DEFAULT 0 ) Failed. Error: Duplicate column name 'rating'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN used_ips longtext; ) Failed. Error: Duplicate column name 'used_ips'
MySQL Query ( ALTER TABLE zen_zenpage_news ADD COLUMN rating_status int(1) UNSIGNED default 3 ) Failed. Error: Duplicate column name 'rating_status'
MySQL Query ( ALTER TABLE zen_administrators ADD COLUMN custom_data TEXT; ) Failed. Error: Duplicate column name 'custom_data'
MySQL Query ( ALTER TABLE zen_administrators CHANGE password pass varchar(64) ) Failed. Error: Unknown column 'password' in 'zen_administrators'
MySQL Query ( ALTER TABLE zen_administrators ADD COLUMN valid int(1) default 1; ) Failed. Error: Duplicate column name 'valid'
MySQL Query ( ALTER TABLE zen_administrators ADD COLUMN group varchar(64); ) Failed. Error: Duplicate column name 'group'
MySQL Query ( ALTER TABLE zen_albums ADD COLUMN watermark varchar(256) ) Failed. Error: Duplicate column name 'watermark'
MySQL Query ( ALTER TABLE zen_zenpage_pages CHANGE commentson commentson int(1) UNSIGNED default 0 ) Success.
MySQL Query ( ALTER TABLE zen_zenpage_news CHANGE commentson commentson int(1) UNSIGNED default 0 ) Success.
Done with database creation and update
Previous Release was 4335
Notice: "Module mod_rewrite" is working. The Zenphoto option "mod_rewrite" is "enabled".

Hi Sbillard,

Thanks for your help you have pointed me in the right direction with your last comment, then I searched the above for all instances of ownerid and figured out where the creation went wrong....the problem was me..I had downloaded the zp-config.php from the old vs (1.0.8) and then re-uploaded it in the zp-data folder instead of letting the setup.php create it......silly silly mistake, of course as it existed...nothing else happened, creation wise.........
Works like a dream and again I thanks you.....
Best Regards
Arooga1

Thanks for the debug information. I see the problem. Wonder why no one else has seen it.

You have a couple of choices on how to procede.

1. You can install the nightly build from tonight (21 October) where I will have placed a fix.

2. You can manually modify your database through phpMyAdmin (or such). Do the following queries:

ALTER TABLE zen_comments DROP FOREIGN KEY comments_ibfk1 ALTER TABLE zen_comments CHANGE imageid ownerid int(11) UNSIGNED NOT NULL default '0' ALTER TABLE zen_comments DROP INDEX imageid ALTER TABLE zen_comments ADD INDEX (ownerid)
(The first of these statements was wrong and caused the problems.)