Post by Jansuh » Fri Jun 22, 2018 3:08 am

When i try to upload the taxonomy file from google i get a popup with internal server error and nothing has uploaded.

Any pointers on how to troubleshoot this?

Thanks

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm


Post by straightlight » Fri Jun 22, 2018 10:06 pm

No OC version posted. Check the error / access logs noticing the recent error messages when uploading files from OC.

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 Jansuh » Sat Jun 23, 2018 11:37 pm

Sorry i am on version 2.3.0.2

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm


Post by straightlight » Sat Jun 23, 2018 11:41 pm

And the access logs entries about recent errors when uploading files?

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 Jansuh » Sun Jun 24, 2018 1:17 am

Where do i find that log? I have directadmin and that has no error logs. The errorlog of opencart has only this:

2018-06-23 16:58:18 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 16:58:18 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 16:58:19 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:08:11 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:08:12 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:08:12 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:56:09 - PHP Warning: A non-numeric value encountered in /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_category.php on line 222
2018-06-23 17:56:09 - PHP Warning: A non-numeric value encountered in /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_category.php on line 442
2018-06-23 17:56:09 - PHP Warning: A non-numeric value encountered in /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_category.php on line 442
2018-06-23 17:56:09 - PHP Warning: A non-numeric value encountered in /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_catalog_controller_product_category.php on line 442
2018-06-23 17:57:15 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:57:15 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:57:15 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:59:04 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:59:05 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27
2018-06-23 17:59:05 - PHP Notice: Undefined index: g-recaptcha-response in /home/pureandtim/domains/pureandtimeless.nl/public_html/catalog/controller/extension/captcha/google_captcha.php on line 27

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm


Post by Jansuh » Sun Jun 24, 2018 1:31 am

Found some more in directadmin:

[Sat Jun 23 19:29:18.313829 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50866] mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Error: Table 'pureandtim_oc1.oc_google_base_category_to_category' doesn't exist<br />Error No: 1146<br />SELECT google_base_category_id, (SELECT name FROM `oc_google_base_category` gbc WHERE gbc.google_base_category_id = gbc2c.google_base_category_id) AS google_base_category, category_id, (SELECT name FROM `oc_category_description` cd WHERE cd.category_id = gbc2c.category_id AND cd.language_id = '2') AS category FROM `oc_google_base_category_to_category` gbc2c ORDER BY google_base_category ASC in /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db/mysqli.php:40, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:18.313866 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50866] mod_fcgid: stderr: Stack trace:, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:18.313870 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50866] mod_fcgid: stderr: #0 /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db.php(16): DB\\MySQLi->query('SELECT google_b...', Array), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:18.313873 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50866] mod_fcgid: stderr: #1 /home/pureandtim/domains/pureandtimeless.nl/public_html/admin/model/extension/feed/google_base.php(87): DB->query('SELECT google_b...'), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:18.313876 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50866] mod_fcgid: stderr: #2 /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php( in /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db/mysqli.php on line 40, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490227 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Error: Table 'pureandtim_oc1.oc_google_base_category' doesn't exist<br />Error No: 1146<br />DELETE FROM oc_google_base_category in /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db/mysqli.php:40, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490249 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: Stack trace:, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490252 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #0 /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db.php(16): DB\\MySQLi->query('DELETE FROM oc_...', Array), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490256 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #1 /home/pureandtim/domains/pureandtimeless.nl/public_html/admin/model/extension/feed/google_base.php(27): DB->query('DELETE FROM oc_...'), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490267 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #2 /home/pureandtim/domains/pureandtimeless.nl/public_html/vqmod/vqcache/vq2-system_storage_modification_system_engine_loader.php(184): ModelExtensionFeedGoogleBase->import('# Google_Produc...'), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490271 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #3 /home/pureandtim/domains/pureandtimeless.nl/public_html/system/engine/proxy.php(25): Loader->{closure}(Array, Array), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490274 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #4 /home/pureandtim/domains/pureandtimeless.nl/public_html/admin/controller/extension/feed/google_base.php(143): Proxy->__call('import', Array), referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC
[Sat Jun 23 19:29:26.490277 2018] [fcgid:warn] [pid 61033:tid 140543048402688] [client 83.82.250.9:50869] mod_fcgid: stderr: #5 /home/pureandtim/domains/pureandtimele in /home/pureandtim/domains/pureandtimeless.nl/public_html/system/library/db/mysqli.php on line 40, referer: https://www.pureandtimeless.nl/admin/in ... 1qB70p9BoC

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm


Post by straightlight » Sun Jun 24, 2018 2:23 am

Caused by a corrupted installation regarding the database error message you have. As for the Google Captcha service, I would suggest to use the CSRF Protection Form with Johnathan's Captcha extension from the Marketplace.

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 Jansuh » Sun Jun 24, 2018 4:47 pm

Ok thanks,

Tried install on a different place, get the googlebase part from the database and import into my site but that also don't have the google base entry in the database.

Do you have the insert into commands for me?

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm


Post by Jansuh » Sun Jun 24, 2018 5:13 pm

Fixed it already.

De-installed the googlebase part and re-installed it.

Sometimes you miss the simpelest solutions. Thanks for looking in to it

New member

Posts

Joined
Fri Apr 20, 2018 8:13 pm

Who is online

Users browsing this forum: No registered users and 11 guests