Page 1 of 1

Internal server error when uploading taxonomy file in googlebase module

Posted: Fri Jun 22, 2018 3:08 am
by Jansuh
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

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Fri Jun 22, 2018 10:06 pm
by straightlight
No OC version posted. Check the error / access logs noticing the recent error messages when uploading files from OC.

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Sat Jun 23, 2018 11:37 pm
by Jansuh
Sorry i am on version 2.3.0.2

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Sat Jun 23, 2018 11:41 pm
by straightlight
And the access logs entries about recent errors when uploading files?

Re: Internal server error when uploading taxonomy file in googlebase module

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

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Sun Jun 24, 2018 1:31 am
by Jansuh
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

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Sun Jun 24, 2018 2:23 am
by straightlight
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.

Re: Internal server error when uploading taxonomy file in googlebase module

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

Re: Internal server error when uploading taxonomy file in googlebase module

Posted: Sun Jun 24, 2018 5:13 pm
by Jansuh
Fixed it already.

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

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