Post by globalmahi » Wed Sep 15, 2021 2:36 pm

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.

Newbie

Posts

Joined
Tue Sep 14, 2021 1:12 pm

Post by thekrotek » Wed Sep 15, 2021 3:19 pm

You should contact extension developer.

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com


User avatar
Expert Member

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by ADD Creative » Wed Sep 15, 2021 4:21 pm

Look in your PHP error log or server error logs for more details of what is causing the 500 error.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by globalmahi » Wed Sep 15, 2021 4:26 pm

ADD Creative wrote:
Wed Sep 15, 2021 4:21 pm
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,

******************************
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??

Newbie

Posts

Joined
Tue Sep 14, 2021 1:12 pm

Post by JNeuhoff » Wed Sep 15, 2021 4:35 pm

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by globalmahi » Wed Sep 15, 2021 4:39 pm

JNeuhoff wrote:
Wed Sep 15, 2021 4:35 pm
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.
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...

Newbie

Posts

Joined
Tue Sep 14, 2021 1:12 pm

Post by globalmahi » Wed Sep 15, 2021 4:44 pm

JNeuhoff wrote:
Wed Sep 15, 2021 4:35 pm
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.
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.
*******************************************

Newbie

Posts

Joined
Tue Sep 14, 2021 1:12 pm

Post by JNeuhoff » Wed Sep 15, 2021 4:56 pm

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


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by straightlight » Wed Sep 15, 2021 6:18 pm

globalmahi wrote:
Wed Sep 15, 2021 4:44 pm
JNeuhoff wrote:
Wed Sep 15, 2021 4:35 pm
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.
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.
*******************************************
Except that using OCMod / VQMod are modifications themselves.

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by paulfeakins » Wed Sep 15, 2021 6:40 pm

globalmahi wrote:
Wed Sep 15, 2021 2:36 pm
As I wants to back my website.
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


User avatar
Guru Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by ADD Creative » Wed Sep 15, 2021 7:40 pm

You could try clearing your storage/modification folder.

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom
Who is online

Users browsing this forum: mandom, Semrush [Bot], Stinger23 and 250 guests