AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: Karlos on January 25, 2015, 10:56:14 AM

Title: critical error
Post by: Karlos on January 25, 2015, 10:56:14 AM

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.

Title: Re: critical error
Post by: Basara on January 26, 2015, 12:24:42 AM

Hello

Please post last errors from AbanteCart error log (http://forum.abantecart.com/index.php/topic,834.msg3085.html#msg3085)

Title: Re: critical error
Post by: Karlos on January 26, 2015, 02:11:26 PM

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

Title: Re: critical error
Post by: Basara on January 27, 2015, 12:18:26 AM

Quote from: Karlos on January 26, 2015, 02:11:26 PM

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)

Title: Re: critical error
Post by: dls2004 on January 27, 2015, 05:01:18 PM

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.

Title: Re: critical error
Post by: Karlos on January 27, 2015, 05:58:53 PM

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