Author Topic: report  (Read 650 times)

Offline SAMY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +5/-21
  • SAMY
    • View Profile
report
« on: March 26, 2019, 09:22:25 AM »
Hello!

When I am trying to edit the orders which been required before upgrading to last version, I get the next error:


AbanteCart
There has been a critical error processing your request
SQL Error: Table 'u8526052_ac2.ac_order_product_stock_locations' doesn't exist
Error No: 1146
SQL: SELECT * FROM ac_order_product_stock_locations WHERE order_product_id=139 in /home/u8526052/public_html/core/database/amysqli.php on line 114

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


Check AbanteCart Troubleshooting Guide


Need help? Contact for support


Go to main page
Project Homepage|Documentation|Support Forums|Marketplace



What am missing in this case please??

Thank you...

Regards
SAMY
Thanks Abantecart for being in my life & for your Support
REGARDS
SAMY

Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4312
  • Karma: +202/-0
    • View Profile
Re: report
« Reply #1 on: March 26, 2019, 09:39:17 AM »
Looks like you have partially updated store. Files are new but database is old
“Chuck Norris is so amazing.”
― Mother Teresa

Offline SAMY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +5/-21
  • SAMY
    • View Profile
Re: report
« Reply #2 on: March 26, 2019, 09:55:56 AM »
Looks like you have partially updated store. Files are new but database is old


Thank you for support BASARA!

What I have to do in this case please and how to fix this??

Thanks for help

Regards
Thanks Abantecart for being in my life & for your Support
REGARDS
SAMY

Offline kawadw

  • Newbie
  • *
  • Posts: 3
  • Karma: +2/-0
    • View Profile
Re: report
« Reply #3 on: March 26, 2019, 11:36:24 PM »
SAMY I have had the same exact problem today.

1. Backup your application and database.
2. On your web server look for a file ../public_html/upgrade.sql
3. Download that file.
4. Go to your database interface (phpAdmin)
5. Run the upgrade. sql script.

I hope this helps you out.

I tried posting the sql but the forum kept saying I'm posting an external link.  :(


Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4312
  • Karma: +202/-0
    • View Profile
Re: report
« Reply #4 on: March 27, 2019, 01:39:22 AM »
“Chuck Norris is so amazing.”
― Mother Teresa

Offline natdroid

  • Jr. Member
  • **
  • Posts: 98
  • Karma: +30/-2
    • View Profile
    • Contact
Re: report
« Reply #5 on: March 27, 2019, 04:00:50 AM »

Offline SAMY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +5/-21
  • SAMY
    • View Profile
Re: report
« Reply #6 on: March 27, 2019, 09:18:02 AM »
hello,

thank you for your comments guys.

1. I have the question about running the upgrade.sql  how that's gonna be done?? in the attachment a screenshot for uploading the file's result.

2. recently prefix is (ac_) shall i change it or gonna be same??


regards
Thanks Abantecart for being in my life & for your Support
REGARDS
SAMY

Offline kawadw

  • Newbie
  • *
  • Posts: 3
  • Karma: +2/-0
    • View Profile
Re: report
« Reply #7 on: March 28, 2019, 09:11:37 PM »
I'm using GoDaddy. 
1. Under cPanel there is section called Files. 
2. Click File Manager.  There you should see your Linux file system. 
3. Click on public_html.  AbanteCart leaves its upgrade files in this directory including upgrade.sql. 
4. Double clicking the file downloads it to your local machine. 
5. Go to your downloads directory on your local machine.  You can open it to see the sql commands that should have ran when the upgrade ran.  Look for a Create Table command that includes the table that AbanteCart says it is missing.  If its not there message back, otherwise keep going.

6.If your local machine is Windows don't save the file just close it out.  Windows saves with different carriage returns than UNIX based systems. 

7. Go back to cPanel and look in the section called Databases. 
8. Click phpMyAdmin. 
9. On the left side is a list of your schemas.  If you let AbanteCart build the database the name will look like a string of numbers and letters.  Click that. 
10. If you break the tree down you should see a whole bunch of tables that start with ac_ .  Now at the top of the screen click Import. 
11. Click Choose File. 
12. Select upgrade.sql that you downloaded. 
13. Leave the other options default then click Go.  You should be good to go after that.

Notes:  For this update I didn't see anything that would effect any of the other tables so I didn't change the prefix.  Not the safest way, but in this instance I didn't have anything in the tables that were being altered.

If you have data that you need in the tables that the upgrade.sql file will alter then LISTEN to Basara and follow the AbanteCart directions.


Offline Basara

  • Administrator
  • Hero Member
  • *****
  • Posts: 4312
  • Karma: +202/-0
    • View Profile
Re: report
« Reply #8 on: March 29, 2019, 01:16:43 AM »
Notes:  For this update I didn't see anything that would effect any of the other tables so I didn't change the prefix.  Not the safest way, but in this instance I didn't have anything in the tables that were being altered.

This is wrong way, 1.2.14 does have important changes in database
“Chuck Norris is so amazing.”
― Mother Teresa

Offline kawadw

  • Newbie
  • *
  • Posts: 3
  • Karma: +2/-0
    • View Profile
Re: report
« Reply #9 on: March 31, 2019, 11:04:34 AM »
Again Basara is very correct always follow the directions.  In my case I didn't have to do this.  Sorry.

Offline SAMY

  • Full Member
  • ***
  • Posts: 222
  • Karma: +5/-21
  • SAMY
    • View Profile
Re: report
« Reply #10 on: April 01, 2019, 09:31:12 AM »
Hi Guys!

Thank you for your support, that's helped me so much.


Regards
SAMY
Thanks Abantecart for being in my life & for your Support
REGARDS
SAMY

 

Powered by SMFPacks Social Login Mod