AbanteCart Community

Shopping Cart Operations => Support => Topic started by: CTGO.co on March 26, 2019, 09:22:25 AM

Title: report
Post by: CTGO.co 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

Title: Re: report
Post by: Basara on March 26, 2019, 09:39:17 AM

Looks like you have partially updated store. Files are new but database is old

Title: Re: report
Post by: CTGO.co on March 26, 2019, 09:55:56 AM

Quote from: Basara on March 26, 2019, 09:39:17 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

Title: Re: report
Post by: kawadw 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.  :(

Title: Re: report
Post by: Basara on March 27, 2019, 01:39:22 AM

Quote from: kawadw on March 26, 2019, 11:36:24 PM

5. Run the upgrade. sql script.

Before that you have to change database prefix
https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually

Title: Re: report
Post by: natdroid on March 27, 2019, 04:00:50 AM

That dude may help you https://www.fiverr.com/nattoben/upgrade-abantecart-and-help-resolve-upgrade-issues (https://www.fiverr.com/nattoben/upgrade-abantecart-and-help-resolve-upgrade-issues)

Title: Re: report
Post by: CTGO.co 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

Title: Re: report
Post by: kawadw 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.

Title: Re: report
Post by: Basara on March 29, 2019, 01:16:43 AM

Quote from: kawadw on March 28, 2019, 09:11:37 PM

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

Title: Re: report
Post by: kawadw 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.

Title: Re: report
Post by: CTGO.co on April 01, 2019, 09:31:12 AM

Hi Guys!

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


Regards
SAMY