Author Topic: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart  (Read 7618 times)

Offline MaxterPC

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« on: September 19, 2016, 11:29:52 PM »
Perform the update manually (simply download the upgrade file indicated) and copy folders "code" as indicated but the content of external static get this error page: "There has-been a critical mistake processing your request

Please check AbanteCart mistake and webserver logs for more details. You can check Error log in the Control Panel if it is functional. Otherwise, refer to Error log located on your web server

Report this problem to AbanteCart team (do not change email subject) "


And in the error log that is what appears, thank you very much for your help

database error: AbanteCart core v.1.2.6 Error:
SELECT c.customer_id,
c.firstname,
c.lastname,
c.loginname,
c.email,
c.sms,
c.status,
c.approved,
c.customer_group_id,
CONCAT(c.firstname, ' ', c.lastname) AS name,
cg.name AS customer_group
FROM ab1p_customers c
LEFT JOIN ab1p_customer_groups cg ON (c.customer_group_id = cg.customer_group_id) ORDER BY c.date_added DESC LIMIT 0,10 in <b>/home/ensasapb/public_html/prueba/core/database/amysqli.php</b> on line <b>106</b>

2016-09-20 3:26:14 - database error: AbanteCart core v.1.2.6 Error:
SELECT tr.tax_class_id,
tr.rate AS rate, tr.rate_prefix AS rate_prefix,
tr.threshold_condition AS threshold_condition,
tr.threshold AS threshold,
tr.tax_exempt_groups AS tax_exempt_groups,
COALESCE( td1.title,td2.title) as title,
COALESCE( NULLIF(trd1.description, ''),
NULLIF(td1.description, ''),
NULLIF(trd2.description, ''),
NULLIF(td2.description, ''),
COALESCE( td1.title,td2.title)
) as description,
tr.priority
FROM ab1p_tax_rates tr
LEFT JOIN ab1p_tax_rate_descriptions trd1 ON
(tr.tax_rate_id = trd1.tax_rate_id AND trd1.language_id = '2')
LEFT JOIN ab1p_tax_rate_descriptions trd2 ON
(tr.tax_rate_id = trd2.tax_rate_id AND trd2.language_id = '0')
LEFT JOIN ab1p_tax_classes tc ON tc.tax_class_id = tr.tax_class_id
LEFT JOIN ab1p_tax_class_descriptions td1 ON
(tc.tax_class_id = td1.tax_class_id AND td1.language_id = '2')
LEFT JOIN ab1p_tax_class_descriptions td2 ON
(tc.tax_class_id = td2.tax_class_id AND td2.language_id = '0')
WHERE (tr.zone_id = '0' OR tr.zone_id = '0')
AND tr.location_id in (SELECT z2l.location_id
FROM ab1p_zones_to_locations z2l, ab1p_locations l
WHERE z2l.location_id = l.location_id and z2l.zone_id = '0')
ORDER BY tr.priority ASC in <b>/home/ensasapb/public_html/prueba/core/database/amysqli.php</b> on line <b>106</b>


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« Reply #1 on: September 20, 2016, 02:49:34 AM »
Please, try to run these sql-queries via phpMyAdmin and post mysql explanations about errors.

#1
Code: [Select]
SELECT c.customer_id,
c.firstname,
c.lastname,
c.loginname,
c.email,
c.sms,
c.status,
c.approved,
c.customer_group_id,
CONCAT(c.firstname, ' ', c.lastname) AS name,
cg.name AS customer_group
FROM ab1p_customers c
LEFT JOIN ab1p_customer_groups cg ON (c.customer_group_id = cg.customer_group_id)
ORDER BY c.date_added
DESC LIMIT 0,10

#2
Code: [Select]
SELECT tr.tax_class_id,
tr.rate AS rate, tr.rate_prefix AS rate_prefix,
tr.threshold_condition AS threshold_condition,
tr.threshold AS threshold,
tr.tax_exempt_groups AS tax_exempt_groups,
COALESCE( td1.title,td2.title) as title,
COALESCE( NULLIF(trd1.description, ''),
NULLIF(td1.description, ''),
NULLIF(trd2.description, ''),
NULLIF(td2.description, ''),
COALESCE( td1.title,td2.title)
) as description,
tr.priority
FROM ab1p_tax_rates tr
LEFT JOIN ab1p_tax_rate_descriptions trd1 ON
(tr.tax_rate_id = trd1.tax_rate_id AND trd1.language_id = '2')
LEFT JOIN ab1p_tax_rate_descriptions trd2 ON
(tr.tax_rate_id = trd2.tax_rate_id AND trd2.language_id = '0')
LEFT JOIN ab1p_tax_classes tc ON tc.tax_class_id = tr.tax_class_id
LEFT JOIN ab1p_tax_class_descriptions td1 ON
(tc.tax_class_id = td1.tax_class_id AND td1.language_id = '2')
LEFT JOIN ab1p_tax_class_descriptions td2 ON
(tc.tax_class_id = td2.tax_class_id AND td2.language_id = '0')
WHERE (tr.zone_id = '0' OR tr.zone_id = '0')
AND tr.location_id in (SELECT z2l.location_id
FROM ab1p_zones_to_locations z2l, ab1p_locations l
WHERE z2l.location_id = l.location_id and z2l.zone_id = '0')
ORDER BY tr.priority ASC
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« Reply #2 on: September 20, 2016, 03:05:56 AM »
Perform the update manually (simply download the upgrade file indicated) and copy folders "code" as indicated but the content of external static get this error page: "There has-been a critical mistake processing your request

Hello. Did you forget to run upgrade.sql? Check this guide http://docs.abantecart.com/pages/upgrade/manual.html

Offline MaxterPC

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« Reply #3 on: September 20, 2016, 10:50:12 AM »
Perform the update manually (simply download the upgrade file indicated) and copy folders "code" as indicated but the content of external static get this error page: "There has-been a critical mistake processing your request

Hello. Did you forget to run upgrade.sql? Check this guide

Hi, sorry but not how. I upload the edited file to hosting Upgrade.sql or through phpMyAdmin? And as I run? Sorry, but I'm something newbies in loque has to do with databases. Thank you very much for your help

Offline MaxterPC

  • Newbie
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Re: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« Reply #4 on: September 20, 2016, 12:11:57 PM »
Please, try to run these sql-queries via phpMyAdmin and post mysql explanations about errors.

#1054 - Unknown column 'c.sms' in 'field list'
#1054 - Unknown column 'tr.tax_exempt_groups' in 'field list'

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 5774
  • Karma: +274/-2
    • View Profile
Re: Please help! Attempt to update 1.2.5 to 1.2.6 AbanteCart
« Reply #5 on: September 21, 2016, 01:44:11 AM »
Hi, sorry but not how. I upload the edited file to hosting Upgrade.sql or through phpMyAdmin? And as I run? Sorry, but I'm something newbies in loque has to do with databases. Thank you very much for your help

Hello. Run upgrade.sql is very important part of upgrade. You need to open phpMyadmin in your hosting panel then select AbanteCart database > click Import > select upgrade.sql and click Continue button.

 

Powered by SMFPacks Social Login Mod