Forums / Cotonti / Support / errors after install.php

musashi9
#40822 2015-04-24 04:06

Hi I updated all the files after updating to the latest release,then I ran install.php and get this

 

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:574]
#1  CotDB->query(ALTER TABLE `sed_users` ADD INDEX `user_name` (`user_name`)) called at [/home/mysite/public_html/system/database.php:516]
#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:81]
#3  cot_apply_patches(./setup/siena, 0.9.13-01) called at [/home/mysite/public_html/modules/install/inc/install.update.php:269]
#4  include(/home/mysite/public_html/modules/install/inc/install.update.

This post was edited by musashi9 (2015-04-24 04:26, 8 years ago)