Forumlar / Cotonti / Support / errors after install.php

musashi9
#1 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.


Bu konu musashi9 tarafından düzenlendi(2015-04-24 04:26, 8 yıllar önce)
Dr2005alex
#2 2015-04-24 04:43

What version updates? 0.9.14?

WebKaa.ru - Cotonti Relax
musashi9
#3 2015-04-24 05:51

ya

Added 17 hours later:

Is my site updated? is it safe to open back to the public?

Added 8 minutes later:

hmm now my news plugin config no longer works

admin.php?m=config&n=edit&o=plug&p=news

leads me to Wrong URL


Bu konu musashi9 tarafından düzenlendi(2015-04-24 23:32, 8 yıllar önce)
Dayver
#4 2015-04-28 20:57

Added issue to github. Be sure we check this problem

Pavlo Tkachenko aka Dayver
Macik
#5 2015-10-27 23:40

Proper way is to roll back to your previous copy from backup and try to update to lates 0.9.18.1 as seem it had been solved with this 00c9cac fix.

https://github.com/macik
правильный хостинг — https://goo.gl/fjCa1F
musashi9
#6 2015-11-02 23:15

Whoa 5 months for a simple reply

This cms is dead................

Macik
#7 2015-11-03 07:15

This reply is attend not only for you but anyone who can faced same troubles. 

By the way this is free and open-source CMS so no rapid or «24/7» support declared. Otherwise you can hire qualified stuff on payment basis.

https://github.com/macik
правильный хостинг — https://goo.gl/fjCa1F