Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: manual upgrade sql  (Read 7752 times)

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
manual upgrade sql
« on: April 25, 2014, 11:30:16 AM »
Hi,
i am trying to upgrade manually but i get this message and i dont know what to do?
Help please!?

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: manual upgrade sql
« Reply #1 on: April 25, 2014, 11:56:42 AM »
Do you use prefix on your tables?
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: manual upgrade sql
« Reply #2 on: April 25, 2014, 12:29:11 PM »
i removed "ac_" before running if you ask about that? i think i had to delete it on 50 places inside sql file

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: manual upgrade sql
« Reply #3 on: April 25, 2014, 01:56:58 PM »
Well. Error suggests that table 'tax_rates' does not exists.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: manual upgrade sql
« Reply #4 on: April 25, 2014, 02:09:36 PM »
can you give me a hint why is this happend and where i fix it?

thx

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: manual upgrade sql
« Reply #5 on: April 25, 2014, 04:45:42 PM »
Look in your Mysql database and look for missing table.
I do not know what you are doing and can not see your database. Can not give you hints. sorry.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: manual upgrade sql
« Reply #6 on: April 25, 2014, 05:04:21 PM »
do you think tax_rates are missing when you check my tables?

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: manual upgrade sql
« Reply #7 on: April 25, 2014, 05:08:46 PM »
this error  i get when i try to upgrade to 1.1.8 from admin area

Offline abantecart

  • Administrator
  • Hero Member
  • *****
  • Posts: 4358
  • Karma: +298/-10
    • View Profile
    • Ideal Open Source Ecommerce Solution
Re: manual upgrade sql
« Reply #8 on: April 25, 2014, 06:15:37 PM »
you have 9u9_ prefix on your tables. You need to have this in your upgrade SQL script if you run it manually.
Please  rate your experience or leave your review
We need your help to build better free open source ecommerce platform for everyone. See how you can help

Offline popustda

  • Full Member
  • ***
  • Posts: 153
  • Karma: +9/-4
    • View Profile
Re: manual upgrade sql
« Reply #9 on: April 26, 2014, 04:03:54 AM »
i did what you said and i get following error when importing sql in phpmyadmin
please check picture. i hope you can help me

Thanks

 

Powered by SMFPacks Social Login Mod