critical error

[Karlos]

Hi,

Just tried to upgrade from 1.1.9 to 1.2.  All seems to be upgrading then this message appears  as below.

"There has been a critical error processing your request."

At this point I have to abandon it and reload a back up version of 1.1.9 to be able to get my site back.

Any ideas why this may happen ?

Thanks.

[Basara]

Hello

Please post last errors from AbanteCart error log

[Karlos]

Hi Basara,

Error report below:

2015-01-26 18:57:53 - database error:  AbanteCart core v.1.1.9 Error: Can't DROP 'ac_languages_index'; check that column/key exists<br />Error No: 1091<br />
ALTER TABLE `tyx_languages`
  DROP INDEX ac_languages_index,
  ADD UNIQUE INDEX ac_languages_idx (language_id,code);
in <b>/home/twinspec/public_html/sunpools.co.uk/core/database/mysql.php</b> on line <b>114</b>

Does this mean anything to you ?

Thanks

[Basara]

Hi Basara,

Error report below:

2015-01-26 18:57:53 - database error:  AbanteCart core v.1.1.9 Error: Can't DROP 'ac_languages_index'; check that column/key exists<br />Error No: 1091<br />
ALTER TABLE `tyx_languages`
  DROP INDEX ac_languages_index,
  ADD UNIQUE INDEX ac_languages_idx (language_id,code);
in <b>/home/twinspec/public_html/sunpools.co.uk/core/database/mysql.php</b> on line <b>114</b>

Does this mean anything to you ?

Thanks

Hi.
Yes this mean something wrong with your database.
Did you modify something in core files?
Anyway please run table repair in phpmyadmin (ask your hosting provider how to do that in your Cpanel)

[dls2004]

Hi Karlos,

Check your index values in MyPHPAdmin (CPanel) for table tyx_languages. It may be that your index for table tyx_languages is not ac_languages_index but might be tyx_languages_index. This would cause that line of the script upgrade.sql to fail.

you may need to rename the index.

[Karlos]

Hi Guys,

Thanks for your help. 

As I have only have a few products on the website at the moment , I have made a copy then deleted AbanteCart. I have now installed a new copy of 1.2  and this has loaded up with no problems.  Just got go through and set it all up again.....

Thanks again