Hello All,
I install "Export/Import Tool" extension. And using this "export / Import" menu, I download my current products and make a products descriptions changes as for test purpose. Then again I upload the same file. But after that my system is not working as its shows me
********************************
This page isn’t working
shimizu-chem.net is currently unable to handle this request.
HTTP ERROR 500
********************************
Can you please explain me how should I solve this issue. As I wants to back my website.
Thank you in advance for your help.
I install "Export/Import Tool" extension. And using this "export / Import" menu, I download my current products and make a products descriptions changes as for test purpose. Then again I upload the same file. But after that my system is not working as its shows me
********************************
This page isn’t working
shimizu-chem.net is currently unable to handle this request.
HTTP ERROR 500
********************************
Can you please explain me how should I solve this issue. As I wants to back my website.
Thank you in advance for your help.
You should contact extension developer.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Look in your PHP error log or server error logs for more details of what is causing the 500 error.
Error log file shows me like this,ADD Creative wrote: ↑Wed Sep 15, 2021 4:21 pmLook in your PHP error log or server error logs for more details of what is causing the 500 error.
******************************
Stack trace:
#0 /home2/shimizuchem/ocartdata/storage/modification/system/engine/loader.php(248): ModelCatalogProduct->getProduct('43')
#1 /home2/shimizuchem/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#2 /home2/shimizuchem/ocartdata/storage/modification/catalog/controller/extension/module/featured.php(22): Proxy->__call('getProduct', Array)
#3 /home2/shimizuchem/ocartdata/storage/modification/system/engine/action.php(79): ControllerExtensionModuleFeatured->index(Array)
#4 /home2/shimizuchem/ocartdata/storage/modification/system/engine/loader.php(48): Action->execute(Object(Registry), Array)
#5 /home2/shimizuchem/public_html/catalog/controller/common/content_top.php(63): Loader->controller('extension/modul...', Array)
#6 /home2/shimizuchem/ocartdata/storage/modification/system/engine/action.php(79): Contr in /home2/shimizuchem/ocartdata/storage/modification/catalog/model/catalog/product.php on line 68
[15-Sep-2021 17:22:01 Pacific/Palau] PHP Fatal error: Uncaught Exception: Error: Table 'shimizuc_ocar776.ocam_product_pbc' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM ocam_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM ocam_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM ocam_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT price FROM ocam_product_pbc pbc WHERE pbc.product_id = p.product_id AND pbc.currency_code = 'USD' ORDER BY pbc.price ASC LIMIT 1) AS price_p in /home2/shimizuchem/public_html/system/library/db/mysqli.php on line 41
******************************
What should I need to do??
The DB table 'product_pbc' is not part of a standard OpenCart. Your error has nothing to do with the Export/Import tool. Rather, there is another 3rd party extension which introduces this extra DB table and which should be re-installed.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Thank you for your reply. How can I delete this additional DB table 'product_pbc'. If I de-install the extension which I installed in recently from "Extension-->Modification"y, did it will works?
if not, please advise me how can I delete the extensions from my open cart installed extension.
Thank you in advance...
I download this extension, (My open cart version is 3.0.3.7),
and I didn't do any modificaiton as this documentation mentioned.
*******************************************
Multiply Upload Image Files [VQMOD] & [OCMOD]
Extension added on Sep, 11 2012
as its documentation looks like this,
If you Opencart 2.0 or highr use OCMOD files!
1.Copy file multiupload_files.xml into /vqmod/xml/
2.Copy file add-image.png, search.png into /admin/view/image/filemanager/
3.Copy file mf_ajaxupload.js into /admin/view/javascript/jquery/
Please click on a star rating.
Please leave your feedback and comments.
Please contact me via email or Facebook with offers and requests.
Why extension not work?
1. You have modifaed core opencart files.
2. You have other version of VQMOD or Opencart
What to do?
1. Look at http://code.google.com/p/vqmod/ and read what is VQMOD
2. Upgrade your opencart if possibly.
3. If you don't want upgrade, look into multiupload_files.xml and modify them.
*******************************************
This extension does not cause your error either, because it doesn't introduce your extra DB table!
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Except that using OCMod / VQMod are modifications themselves.globalmahi wrote: ↑Wed Sep 15, 2021 4:44 pmI download this extension, (My open cart version is 3.0.3.7),
and I didn't do any modificaiton as this documentation mentioned.
*******************************************
Multiply Upload Image Files [VQMOD] & [OCMOD]
Extension added on Sep, 11 2012
as its documentation looks like this,
If you Opencart 2.0 or highr use OCMOD files!
1.Copy file multiupload_files.xml into /vqmod/xml/
2.Copy file add-image.png, search.png into /admin/view/image/filemanager/
3.Copy file mf_ajaxupload.js into /admin/view/javascript/jquery/
Please click on a star rating.
Please leave your feedback and comments.
Please contact me via email or Facebook with offers and requests.
Why extension not work?
1. You have modifaed core opencart files.
2. You have other version of VQMOD or Opencart
What to do?
1. Look at http://code.google.com/p/vqmod/ and read what is VQMOD
2. Upgrade your opencart if possibly.
3. If you don't want upgrade, look into multiupload_files.xml and modify them.
*******************************************
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Did you make a backup?
You should probably pay a developer to fix this one for you.
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
Guru Member