Forums / Cotonti / Support / update error

0.9.13 > 0.9.14

musashi9
#38133 2013-10-09 00:35


Fatal error

2013-10-09 00:30

SQL error 42000: Syntax error or access violation: 1061 Duplicate key name 'user_name'

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 1061 Duplicate key name 'user_name') called at [/home/mysite/public_html/system/database.php:478]
#1  CotDB->query(ALTER TABLE `sed_users` ADD INDEX `user_name` (`user_name`)) called at [/home/mysite/public_html/system/database.php:420]
#2  CotDB->runScript(/* 0.9.14-01 update table schema for larger data sets, #981 */
ALTER TABLE `cot_cache` MODIFY `c_value` MEDIUMTEXT collate utf8_unicode_ci;
ALTER TABLE `cot_users` MODIFY `user_auth` MEDIUMTEXT collate utf8_unicode_ci;

ALTER TABLE `cot_users` ADD INDEX `user_name` (`user_name`);
ALTER TABLE `cot_users` ADD INDEX `user_maingrp` (`user_maingrp`);
ALTER TABLE `cot_users` ADD INDEX `user_email` (`user_email`);
ALTER TABLE `cot_users` ADD INDEX `user_sid` (`user_sid`);
ALTER TABLE `cot_users` ADD INDEX `user_lostpass` (`user_lostpass`);) called at [/home/mysite/public_html/system/extensions.php:83]
#3  cot_apply_patches(./setup/siena, 0.9.13-01) called at [/home/mysite/public_html/modules/install/inc/install.update.php:271]
#4  include(/home/mysite/public_html/modules/install/inc/install.update.php) called at [/home/mysite/public_html/install.php:139]

but now my page module is updated so that is good