\
Category: Support | Downloads
Avoid changing date on data import
Each time we import data from a file into EMDI, the date on each line imported, being modified. To avoid this, when selecting the fields to be inserted, in a blank column, we assign the Modify field. So because the field is empty it will not be affected and therefore the date will remain as […]
Assign OnKeyDown event on TAdvDBFormPanel (Delphi)
This is an easy way to assign onkeydown event in all edit controls created by TAdvDBFormPanel:
1 2 3 4 5 6 7 8 9 10 | var i:integer; editp:TDBAdvEdit; begin for i:=0 to AdvDBFormPanel1.layout.Items.Count - 1 do if AdvDBFormPanel1.layout.Items.Items[i].DataControl = dcedit then begin editp:=(AdvDBFormPanel1.layout.Items.Items[i].EditCtrl as TDBAdvEdit); editp.OnKeyDown:=Edit1KeyDown; end; |
Opencart 2.2 redirect issue
If you want to redirect your old site pages to new opencart 2.x, add the following code to the end of .htaccess: (the example is from virtuemart to opencart 2.2)
1 2 | RewriteCond %{THE_REQUEST} /index\.php\?page=shop.browse&category_id=330&option=com_virtuemart&Itemid=2 [NC] RewriteRule ^ https://www.newdomain.com/index.php?route=product/category&path=3_328_408_330 [L,R=302] |
.htaccess error: Option All not allowed here
If you get a white page and in logs: “Option All not allowed here” replace in .htaccess
1 | Options All -Indexes |
with
1 | Options +SymlinksIfOwnerMatch |
Keep network drive alive
An easy method to keep network connections without any interruption is to create a scheduled task that calls a script that maps a certain folder every 5 minutes. 1. Create a .bat file for example: netrefresh.bat contained
1 | net use x: \\SERVER\files |
2. Create a scheduled task using the following in command prompt
1 | SCHTASKS /Create /ST 12:00 /ET 23:59 /TN NETREFRESH /SC minute /MO 5 /TR "c:\netrefresh.bat" |
3. Check if task created […]
Error pagination page={page} in SEO (Opencart)
A simple solution to fix this issue is to make some modifications in: /system/library/pagination.php Search for
1 2 3 4 5 6 7 8 | if ($page > 1) { $output .= '<li><a href="' . str_replace('&page={page}', '', $this->url) . '">' . $this->text_first . '</a></li>'; if($page - 1 === 1){ $output .= '<li><a href="' . str_replace('&page={page}', '', $this->url) . '">' . $this->text_prev . '</a></li>'; } else { $output .= '<li><a href="' . str_replace('{page}', $page - 1, $this->url) . '">' . $this->text_prev . '</a></li>'; } } |
and replace with
1 2 3 4 5 6 7 8 9 | if ($page > 1) { $output .= '<li><a href="' . str_replace(array('&page={page}', '?page={page}'), '', $this->url) . '">' . $this->text_first . '</a></li>'; if ($page - 1 === 1) { $output .= '<li><a href="' . str_replace(array('&page={page}', '?page={page}'), '', $this->url) . '">' . $this->text_prev . '</a></li>'; } else { $output .= '<li><a href="' . str_replace('{page}', $page - 1, $this->url) . '">' . $this->text_prev . '</a></li>'; } } |
also find
1 | $output .= '<li><a href="' . str_replace('&page={page}', '', $this->url) . '">' . $i . '</a></li>'; |
and replace with
1 | $output .= '<li><a href="' . str_replace(array('&page={page}', '?page={page}'), '', $this->url) . '">' . $i . '</a></li>'; |
Source: http://forum.opencart-russia.ru/threads/oshibka-paginacii-page-page-pri-seo.4583/
Drive connection to network may be lost
On the server: To turn off the autodisconnect feature, open a command prompt, type the following line, and then press ENTER:
1 | net config server /autodisconnect:-1 |
On the client:
1 | restart or gpupdate /force |
Mail server setup using ISP config
Automated installation on Ubuntu 16.04
1 2 3 4 5 6 7 | apt-get update && apt-get -y upgrade apt-get install -y unzip cd /tmp wget --no-check-certificate -O installer.tgz "https://github.com/servisys/ispconfig_setup/tarball/master" tar zxvf installer.tgz cd *ispconfig* bash install.sh |
source: https://www.howtoforge.com/tutorial/ispconfig-automated-install-script How to disable spamfilter- and antivirus functions in ISPConfig 3 If you use a mailserver wil very low ram (< 500 MB) and a slow CPU then it might be nescessary to disable the spam- and antivirus filter functions in ISPConfig 3 as amavisd and clamav […]
Change category image size in Journal theme (OpenCart)
The category image size in Journal is predefined as 175×175. You can change this if you edit the file: /catalog/controller/journal2/category.php and change these 2 lines:
1 2 | $image_width = $this->journal2->settings->get('refine_image_width', 175); $image_height = $this->journal2->settings->get('refine_image_height', 175); |
If you want to change the custom section image size go to custom section->edit module->General Options->Image Dimensions