Opencart Error No: 2006 UPDATE oc_currency SET value = ‘1.00000’, date_modified hatası

Opencart sitelerde kur değerini otomatik güncelleme işlemi mysql de timeout a sebep olabilir , bunun sonucunda opencart admin panele geremeyebilirsiniz , çözümü için phpmyadmin e erişiniz ve aşağıdaki sorguyu çalıştırınız.

UPDATE setting s SET s.value = ‘0’ WHERE s.key = ‘config_currency_auto’ AND s.value = ‘1’

setting yazan bölümü kendi opencart setting tablo adınız ile değiştiriniz , örneğin Sizde de oc_setting şeklinde olabilir.

Error No: 2006
UPDATE oc_currency SET value = ‘1.00000’, date_modified

Oepncart Bu sayfaya erişim izniniz bulunmuyor. Lütfen sistem yöneticinize başvurunuz. Eğer yönetici iseniz kullanıcı grublarından yönetici izinlerini ayarlayınız Hatası

Merhaba; Opencart yönetici panelinizde Bu sayfaya erişim izniniz bulunmuyor. Lütfen sistem yöneticinize başvurunuz. Eğer yönetici iseniz kullanıcı grublarından yönetici izinlerini ayarlayınız şeklinde bir hata alıyor iseniz paneliniz üzerinden ya da herhangi bir şekilde phpmyadmin e erişiniz ,user_group tablonuzu bulup içine giriniz, üst yönetici yazan bölümün yanındaki permission tablosuna aşağıdaki satırı giriniz ve kaydediniz , sorun düzelmiş olacaktır.

a:2:{s:6:”access”;a:129:{i:0;s:17:”catalog/attribute”;i:1;s:23:”catalog/attribute_group”;i:2;s:20:”catalog/cachemanager”;i:3;s:16:”catalog/category”;i:4;s:16:”catalog/download”;i:5;s:19:”catalog/information”;i:6;s:20:”catalog/manufacturer”;i:7;s:14:”catalog/option”;i:8;s:15:”catalog/product”;i:9;s:14:”catalog/review”;i:10;s:19:”common/filemanager-“;i:11;s:18:”common/filemanager”;i:12;s:13:”design/banner”;i:13;s:13:”design/layout”;i:14;s:14:”extension/feed”;i:15;s:16:”extension/module”;i:16;s:17:”extension/payment”;i:17;s:18:”extension/shipping”;i:18;s:15:”extension/total”;i:19;s:16:”feed/google_base”;i:20;s:19:”feed/google_sitemap”;i:21;s:20:”localisation/country”;i:22;s:21:”localisation/currency”;i:23;s:21:”localisation/geo_zone”;i:24;s:21:”localisation/language”;i:25;s:25:”localisation/length_class”;i:26;s:25:”localisation/order_status”;i:27;s:26:”localisation/return_action”;i:28;s:26:”localisation/return_reason”;i:29;s:26:”localisation/return_status”;i:30;s:25:”localisation/stock_status”;i:31;s:22:”localisation/tax_class”;i:32;s:21:”localisation/tax_rate”;i:33;s:25:”localisation/weight_class”;i:34;s:17:”localisation/zone”;i:35;s:12:”module/EDseo”;i:36;s:14:”module/account”;i:37;s:16:”module/affiliate”;i:38;s:13:”module/banner”;i:39;s:17:”module/bestseller”;i:40;s:15:”module/carousel”;i:41;s:15:”module/category”;i:42;s:14:”module/ep_html”;i:43;s:24:”module/facebook_comments”;i:44;s:18:”module/facebook_lb”;i:45;s:16:”module/fbconnect”;i:46;s:15:”module/featured”;i:47;s:18:”module/google_talk”;i:48;s:18:”module/information”;i:49;s:13:”module/latest”;i:50;s:16:”module/slideshow”;i:51;s:14:”module/special”;i:52;s:12:”module/store”;i:53;s:22:”module/visitor_counter”;i:54;s:14:”module/welcome”;i:55;s:16:”payment/alertpay”;i:56;s:24:”payment/authorizenet_aim”;i:57;s:21:”payment/bank_transfer”;i:58;s:14:”payment/cheque”;i:59;s:11:”payment/cod”;i:60;s:21:”payment/free_checkout”;i:61;s:14:”payment/liqpay”;i:62;s:20:”payment/moneybookers”;i:63;s:14:”payment/nochex”;i:64;s:15:”payment/paymate”;i:65;s:16:”payment/paypoint”;i:66;s:26:”payment/perpetual_payments”;i:67;s:14:”payment/pp_pro”;i:68;s:17:”payment/pp_pro_uk”;i:69;s:19:”payment/pp_standard”;i:70;s:15:”payment/sagepay”;i:71;s:22:”payment/sagepay_direct”;i:72;s:18:”payment/sagepay_us”;i:73;s:19:”payment/twocheckout”;i:74;s:28:”payment/web_payment_software”;i:75;s:14:”payment/webpos”;i:76;s:16:”payment/worldpay”;i:77;s:27:”report/affiliate_commission”;i:78;s:22:”report/customer_credit”;i:79;s:21:”report/customer_order”;i:80;s:22:”report/customer_reward”;i:81;s:16:”report/newreport”;i:82;s:24:”report/product_purchased”;i:83;s:21:”report/product_viewed”;i:84;s:18:”report/sale_coupon”;i:85;s:17:”report/sale_order”;i:86;s:18:”report/sale_return”;i:87;s:20:”report/sale_shipping”;i:88;s:15:”report/sale_tax”;i:89;s:14:”sale/affiliate”;i:90;s:12:”sale/contact”;i:91;s:11:”sale/coupon”;i:92;s:13:”sale/customer”;i:93;s:19:”sale/customer_group”;i:94;s:10:”sale/order”;i:95;s:11:”sale/return”;i:96;s:12:”sale/voucher”;i:97;s:18:”sale/voucher_theme”;i:98;s:16:”setting/setting-“;i:99;s:15:”setting/setting”;i:100;s:14:”setting/store-“;i:101;s:13:”setting/store”;i:102;s:18:”shipping/alicioder”;i:103;s:17:”shipping/citylink”;i:104;s:13:”shipping/flat”;i:105;s:13:”shipping/free”;i:106;s:13:”shipping/item”;i:107;s:23:”shipping/parcelforce_48″;i:108;s:15:”shipping/pickup”;i:109;s:19:”shipping/royal_mail”;i:110;s:12:”shipping/ups”;i:111;s:13:”shipping/usps”;i:112;s:15:”shipping/weight”;i:113;s:11:”tool/backup”;i:114;s:8:”tool/csv”;i:115;s:14:”tool/error_log”;i:116;s:12:”total/coupon”;i:117;s:12:”total/credit”;i:118;s:14:”total/handling”;i:119;s:19:”total/low_order_fee”;i:120;s:12:”total/reward”;i:121;s:14:”total/shipping”;i:122;s:15:”total/sub_total”;i:123;s:12:”total/taksit”;i:124;s:9:”total/tax”;i:125;s:11:”total/total”;i:126;s:13:”total/voucher”;i:127;s:9:”user/user”;i:128;s:20:”user/user_permission”;}s:6:”modify”;a:129:{i:0;s:17:”catalog/attribute”;i:1;s:23:”catalog/attribute_group”;i:2;s:20:”catalog/cachemanager”;i:3;s:16:”catalog/category”;i:4;s:16:”catalog/download”;i:5;s:19:”catalog/information”;i:6;s:20:”catalog/manufacturer”;i:7;s:14:”catalog/option”;i:8;s:15:”catalog/product”;i:9;s:14:”catalog/review”;i:10;s:19:”common/filemanager-“;i:11;s:18:”common/filemanager”;i:12;s:13:”design/banner”;i:13;s:13:”design/layout”;i:14;s:14:”extension/feed”;i:15;s:16:”extension/module”;i:16;s:17:”extension/payment”;i:17;s:18:”extension/shipping”;i:18;s:15:”extension/total”;i:19;s:16:”feed/google_base”;i:20;s:19:”feed/google_sitemap”;i:21;s:20:”localisation/country”;i:22;s:21:”localisation/currency”;i:23;s:21:”localisation/geo_zone”;i:24;s:21:”localisation/language”;i:25;s:25:”localisation/length_class”;i:26;s:25:”localisation/order_status”;i:27;s:26:”localisation/return_action”;i:28;s:26:”localisation/return_reason”;i:29;s:26:”localisation/return_status”;i:30;s:25:”localisation/stock_status”;i:31;s:22:”localisation/tax_class”;i:32;s:21:”localisation/tax_rate”;i:33;s:25:”localisation/weight_class”;i:34;s:17:”localisation/zone”;i:35;s:12:”module/EDseo”;i:36;s:14:”module/account”;i:37;s:16:”module/affiliate”;i:38;s:13:”module/banner”;i:39;s:17:”module/bestseller”;i:40;s:15:”module/carousel”;i:41;s:15:”module/category”;i:42;s:14:”module/ep_html”;i:43;s:24:”module/facebook_comments”;i:44;s:18:”module/facebook_lb”;i:45;s:16:”module/fbconnect”;i:46;s:15:”module/featured”;i:47;s:18:”module/google_talk”;i:48;s:18:”module/information”;i:49;s:13:”module/latest”;i:50;s:16:”module/slideshow”;i:51;s:14:”module/special”;i:52;s:12:”module/store”;i:53;s:22:”module/visitor_counter”;i:54;s:14:”module/welcome”;i:55;s:16:”payment/alertpay”;i:56;s:24:”payment/authorizenet_aim”;i:57;s:21:”payment/bank_transfer”;i:58;s:14:”payment/cheque”;i:59;s:11:”payment/cod”;i:60;s:21:”payment/free_checkout”;i:61;s:14:”payment/liqpay”;i:62;s:20:”payment/moneybookers”;i:63;s:14:”payment/nochex”;i:64;s:15:”payment/paymate”;i:65;s:16:”payment/paypoint”;i:66;s:26:”payment/perpetual_payments”;i:67;s:14:”payment/pp_pro”;i:68;s:17:”payment/pp_pro_uk”;i:69;s:19:”payment/pp_standard”;i:70;s:15:”payment/sagepay”;i:71;s:22:”payment/sagepay_direct”;i:72;s:18:”payment/sagepay_us”;i:73;s:19:”payment/twocheckout”;i:74;s:28:”payment/web_payment_software”;i:75;s:14:”payment/webpos”;i:76;s:16:”payment/worldpay”;i:77;s:27:”report/affiliate_commission”;i:78;s:22:”report/customer_credit”;i:79;s:21:”report/customer_order”;i:80;s:22:”report/customer_reward”;i:81;s:16:”report/newreport”;i:82;s:24:”report/product_purchased”;i:83;s:21:”report/product_viewed”;i:84;s:18:”report/sale_coupon”;i:85;s:17:”report/sale_order”;i:86;s:18:”report/sale_return”;i:87;s:20:”report/sale_shipping”;i:88;s:15:”report/sale_tax”;i:89;s:14:”sale/affiliate”;i:90;s:12:”sale/contact”;i:91;s:11:”sale/coupon”;i:92;s:13:”sale/customer”;i:93;s:19:”sale/customer_group”;i:94;s:10:”sale/order”;i:95;s:11:”sale/return”;i:96;s:12:”sale/voucher”;i:97;s:18:”sale/voucher_theme”;i:98;s:16:”setting/setting-“;i:99;s:15:”setting/setting”;i:100;s:14:”setting/store-“;i:101;s:13:”setting/store”;i:102;s:18:”shipping/alicioder”;i:103;s:17:”shipping/citylink”;i:104;s:13:”shipping/flat”;i:105;s:13:”shipping/free”;i:106;s:13:”shipping/item”;i:107;s:23:”shipping/parcelforce_48″;i:108;s:15:”shipping/pickup”;i:109;s:19:”shipping/royal_mail”;i:110;s:12:”shipping/ups”;i:111;s:13:”shipping/usps”;i:112;s:15:”shipping/weight”;i:113;s:11:”tool/backup”;i:114;s:8:”tool/csv”;i:115;s:14:”tool/error_log”;i:116;s:12:”total/coupon”;i:117;s:12:”total/credit”;i:118;s:14:”total/handling”;i:119;s:19:”total/low_order_fee”;i:120;s:12:”total/reward”;i:121;s:14:”total/shipping”;i:122;s:15:”total/sub_total”;i:123;s:12:”total/taksit”;i:124;s:9:”total/tax”;i:125;s:11:”total/total”;i:126;s:13:”total/voucher”;i:127;s:9:”user/user”;i:128;s:20:”user/user_permission”;}}

Ayhan ARDA

Opencart Resim boyutu limitini arttırmak

admin\controller\common\filemanager.php dosyasını açın ve içerisinde aşağıdaki satırları bulun.

if ($this->request->files[‘image’][‘size’] > 300000) {
$json[‘error’] = $this->language->get(‘error_file_size’);
}

Buradaki 300000 değerini değiştirebilirsiniz. Sağına 1 sıfır koymak yeterli olabilir.

Tabi ,  server tarafında da ayrıca bir limit olmamalıdır.

Modify OpenCart upload image size limits

Opencart tam uyumlu hosting için webhosting sitesinin hosting paketlerini inceleyebilirsiniz.

Ayhan  ARDA