cotonti.com : update error https://www.cotonti.com Laatste forum onderwerpen Cotonti en Sun, 19 Apr 2026 03:40:34 -0000 Trustmaster OK, that idea with indexes wasn't brilliant. Many users have similar problems upon upgrade, so we'll remove those problematic lines in 0.9.15.

]]> Wo, 09 Okt 2013 06:39:59 -0000 musashi9
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
 

]]> Wo, 09 Okt 2013 00:35:56 -0000 Trustmaster Oops, that means you already had the index we tried to add in that patch. Remove contents from 'modules/page/patch_0.9.14.sql' (you don't need to run those lines) and try updating again.

]]> Di, 08 Okt 2013 19:11:33 -0000 musashi9 Hello I uploaded all the files and ran install.php and I get this error

2013-10-08 02:33

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

#0  cot_diefatal(SQL error 42000: Syntax error or access violation: 1061 Duplicate key name 'page_title') called at [/home/mysite/public_html/system/database.php:478]
#1  CotDB->query(ALTER TABLE `sed_pages` ADD INDEX `page_title` (`page_title`)) called at [/home/mysite/public_html/system/database.php:420]
#2  CotDB->runScript(/* 0.9.14 update table schema for larger data sets, #981 */
ALTER TABLE `cot_pages` ADD INDEX `page_ownerid` (`page_ownerid`);
ALTER TABLE `cot_pages` ADD INDEX `page_begin` (`page_begin`);
ALTER TABLE `cot_pages` ADD INDEX `page_expire` (`page_expire`);
ALTER TABLE `cot_pages` ADD INDEX `page_title` (`page_title`);
) called at [/home/mysite/public_html/system/extensions.php:83]
#3  cot_apply_patches(modules/page/setup, 0.9.12) called at [/home/mysite/public_html/system/extensions.php:498]
#4  cot_extension_install(page, 1, 1) called at [/home/mysite/public_html/modules/install/inc/install.update.php:279]
#5  include(/home/mysite/public_html/modules/install/inc/install.update

Then after going to my site and ADMIN I see this

Done

  • Applied patch ./setup/siena/patch_0.9.14-01.sql: OK
  • Applied patch ./setup/siena/patch_0.9.14-02.inc: OK
  • Applied patch ./setup/siena/patch_0.9.14-03.sql: OK
  • Updating Module "forums"
  • Removed 5 hook bindings
  • Installed 5 hook bindings
  • Updated structure configuration options
  • Updated authorization locks
  • Module "forums" has been updated to version 0.9.15
  • Updating Module "page"
  • Removed 7 hook bindings
  • Installed 7 hook bindings
  • Updated structure configuration options
  • Updated authorization locks

 

In extensions Moudules Pages: it has this

Version: 0.9.12 / 0.9.15

0.9.12 is red and 0,9,15 has a green background

When I click update for this module I get an Ajax No Module error

Should I be worried???

]]> Di, 08 Okt 2013 02:37:33 -0000