MySQL error during installation

ania

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

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

what can I do?

sbillard

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.

Arooga1

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_comments`WHERE `type` IN ("images","_images") ) failed. Error: Unknown column 'ownerid' in 'field list'

sbillard

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

Arooga1

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 ISO-8859-1] Setting mbstring.internal_encoding to UTF-8 in your php.ini 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 filemtimes 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".

sbillard

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

Arooga1

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

sbillard

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.

Arooga1

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 bundled (2.0.34 compatible)`
pass: PHP `gettext()` support
warn: PHP `mbstring` package [Your internal characater set is ISO-8859-1] Setting mbstring.internal_encoding to UTF-8 in your php.ini file is recommended to insure accented and multi-byte characters function properly.
pass: PHP `MySQL support`
pass: zp-config.php file
pass: Strict Permissions [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.

NOTE: 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 zp-config.php
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 show tables 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 filemtimes 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: .htaccess file (RewriteEngine is ON)
pass: .htaccess RewriteBase is `/photos`
warn: robots.txt file [Not created] Setup could not create a robots.txt file.
pass: albums folder
pass: cache folder
pass: locale folders
pass: uploaded folder
pass: zp-data 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".

Arooga1

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

sbillard

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