Forums / Cotonti / Support / update error

0.9.13 > 0.9.14

musashi9
#1 2013-10-08 02:37

Members

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???
This post was edited by musashi9 (2013-10-08 02:50, 10 years ago)
Trustmaster
#2 2013-10-08 19:11

Administrators
Thanked: 263 times

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.

May the Source be with you!
musashi9
#3 2013-10-09 00:35

Members


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
 
Trustmaster
#4 2013-10-09 06:39

Administrators
Thanked: 263 times

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.

May the Source be with you!