HI.
I have updated EE, and have tried running the installer, however an error apepars:
A Database Error Occurred
Error Number: 1060
Duplicate column name 'can_search'
ALTER TABLE exp_member_groups ADD COLUMN can_search char(1) NOT NULL default 'n'
Filename: updates/ud_009.php
Line Number: 112I have tried commenting out that line from the config file, however when trying to run the installer again a similar error appears in relation to the NEXT line in the file.. After continuously trying and commenting out about 15 lines i give up..
I wanted to then roll back to how everything was before, so i uploaded my backed up system and themes folder. I then went into phpmyadmin, and imported my backed up sql db. An error appeared:
Error
SQL query:
--
-- Dumping data for table `exp_accessories`
--
INSERT INTO `exp_accessories` ( `accessory_id` , `class` , `member_groups` , `controllers` , `accessory_version` )
VALUES ( 2, 'Hide_template_groups_acc', '1|5', 'addons|addons_accessories|addons_extensions|addons_fieldtypes|addons_modules|addons_plugins|admin_content|admin_system|content|content_edit|content_files|content_files_modal|content_publish|design|homepage|members|myaccount|tools|tools_communicate|tools_data|tools_logs|tools_utilities', '1.0' ) ;
MySQL said: Documentation
#1062 - Duplicate entry '2' for key 'PRIMARY'I tried logging into admin, which worked, however i clicked on Content > Edit, but an error appears:
Fatal error: Call to undefined function ee() in /clientdata/apache-www/b/e/mywebsite.com.au/www/system/expressionengine/libraries/EE_Table.php on line 57
Right now i don’t think i will worry about upgrading EE. I would just like everything to go back to how it was working before.
ANY HELP would be much appreciated!