Hi,
Since the time I upgraded from 1.2.13 to 1.2.14. Site giving errors. I upgraded through Admin Panel. Admin area is working good but Store front was not, So I checked the error log and found that Brand scrolling list was the main cause so I disabled the block. Then site started opening but error log was full with errors. Below are some of them. Please have a look and update me.
2019-05-02 2:55:20 -
Name
Info
9100::App Error
Error: Unable to identify file path to template form/form_csrf.tpl! Check blocks in the layout or enable debug mode to get more details. 10002
Trace:
#0 /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 350
#1 /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/html.php on line 1842
#2 /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/html.php on line 985
#3 /home/scorp4hj/public_html/blackpantherinternational.com/admin/view/default/template/pages/setting/setting.tpl on line 48
#4 /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 718
2019-05-02 2:56:16 - error: AbanteCart core v.1.2.14 Maximum execution time of 90 seconds exceeded in <b>/home/scorp4hj/public_html/blackpantherinternational.com/core/lib/image.php</b> on line <b>209</b>
2019-05-02 2:59:27 - App Warning: AbanteCart core v.1.2.14 Warning: Accessing store with non-configured or unknown domain ( 192.163.193.248/ ).
Check setting of your store domain URL in System Settings. Loading default store configuration for now. in /home/scorp4hj/public_html/blackpantherinternational.com/core/lib/config.php on line 228
-------------------
2019-05-02 3:08:06 -
Name
Info
9101::App Warning
Extension banner_manager overrides core template with blocks/banner_block/one_by_one_slider_banner_block.tpl in /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 342
9101::App Warning
Extension banner_manager overrides core template with blocks/banner_block_content.tpl in /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 342
---------------------
When I try to edit Product and click on General Tab It shows below error. How to resolve this?
SQL Error: Table 'scorp4hj_bpidb.bpi_product_stock_locations' doesn't exist
Error No: 1146
SQL: SELECT * FROM bpi_product_stock_locations psl LEFT JOIN bpi_locations l ON l.location_id = psl.location_id WHERE psl.product_id=119 AND psl.product_option_value_id IS NULL ORDER BY psl.sort_order in /home/scorp4hj/public_html/blackpantherinternational.com/core/database/amysqli.php on line 114
Quote from: scorpbond on May 01, 2019, 11:23:14 PM
9100::App Error
Error: Unable to identify file path to template form/form_csrf.tpl!
Check that this file exist or have correct permissions
https://github.com/abantecart/abantecart-src/blob/master/public_html/admin/view/default/template/form/form_csrf.tpl
https://github.com/abantecart/abantecart-src/blob/master/public_html/storefront/view/default/template/form/form_csrf.tpl
Quote from: scorpbond on May 01, 2019, 11:23:14 PM
2019-05-02 2:56:16 - error: AbanteCart core v.1.2.14 Maximum execution time of 90 seconds exceeded in <b>/home/scorp4hj/public_html/blackpantherinternational.com/core/lib/image.php</b> on line <b>209</b>
This indicate that image resize is fail. Usually two reasons:
1. server have not enough RAM
2. server stop resize of image or multiply images due to "Maximum execution time"
Quote from: scorpbond on May 01, 2019, 11:23:14 PM
2019-05-02 2:59:27 - App Warning: AbanteCart core v.1.2.14 Warning: Accessing store with non-configured or unknown
It is not an issue and mean someone (usually bots) access your site with IP or any other way
Quote from: scorpbond on May 01, 2019, 11:23:14 PM
9101::App Warning
Extension banner_manager overrides core template with blocks/banner_block/one_by_one_slider_banner_block.tpl in /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 342
9101::App Warning
Extension banner_manager overrides core template with blocks/banner_block_content.tpl in /home/scorp4hj/public_html/blackpantherinternational.com/core/engine/view.php on line 342
This is regular debug info. Disable debugger in admin to hide it.
Quote from: scorpbond on May 01, 2019, 11:23:14 PM
When I try to edit Product and click on General Tab It shows below error. How to resolve this?
SQL Error: Table 'scorp4hj_bpidb.bpi_product_stock_locations' doesn't exist
Error No: 1146
SQL: SELECT * FROM bpi_product_stock_locations psl LEFT JOIN bpi_locations l ON l.location_id = psl.location_id WHERE psl.product_id=119 AND psl.product_option_value_id IS NULL ORDER BY psl.sort_order in /home/scorp4hj/public_html/blackpantherinternational.com/core/database/amysqli.php on line 114
Error is clear. Some tables in database are missing. Usually this mean sql part of upgrade is fail
When I try to edit Product and click on General Tab It shows below error. How to resolve this?
SQL Error: Table 'scorp4hj_bpidb.bpi_product_stock_locations' doesn't exist
Error No: 1146
SQL: SELECT * FROM bpi_product_stock_locations psl LEFT JOIN bpi_locations l ON l.location_id = psl.location_id WHERE psl.product_id=119 AND psl.product_option_value_id IS NULL ORDER BY psl.sort_order in /home/scorp4hj/public_html/blackpantherinternational.com/core/database/amysqli.php on line 114
[/quote]
Error is clear. Some tables in database are missing. Usually this mean sql part of upgrade is fail
[/quote]
I tried so many times but SQL database is not upgrading properly. So how we can create it manually in My SQL. Let me know the Query command in sql.
Repost in case you miss it
Quote from: Basara on May 02, 2019, 01:27:31 AM
Some tables in database are missing. Usually this mean sql part of upgrade is fail
So you need to add missing column/tables manually or restore your backup
Quote from: Basara on May 20, 2019, 01:22:06 AM
Repost in case you miss it
Quote from: Basara on May 02, 2019, 01:27:31 AM
Some tables in database are missing. Usually this mean sql part of upgrade is fail
So you need to add missing column/tables manually or restore your backup
Quote from: Basara on May 20, 2019, 01:22:06 AM
Repost in case you miss it
Quote from: Basara on May 02, 2019, 01:27:31 AM
Some tables in database are missing. Usually this mean sql part of upgrade is fail
So you need to add missing column/tables manually or restore your backup
I restored it many time but still problem not resolving. Please tell me the steps how I can create it manually. I am new to this but if you guide me I shall do it.
Hello.
When you restore you should restore files and database. Same with upgrade, there are files and database part.
Check the doc on manual upgrade
https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually
Quote from: natdroid on May 23, 2019, 01:36:29 AM
Looking for an upgrade help https://www.fiverr.com/nattoben/upgrade-abantecart-and-help-resolve-upgrade-issues
We just took this route, and it was a lifesaver! NATTOBEN restored an otherwise dead site, updated it to 1.2.15 and brought it back to life within 24 hours. Thank you so much for the lead!