vQmod

vQmod

While strictly modules, product feeds and OpenCart extensions should be standalone and modular, some require modifications to the OpenCart core. Modifying OpenCart core files greatly reduces your ability to upgrade your store to later versions, and can affect other modules and extensions. vQmod provides a mechanism by which modules requiring OpenCart core modifications can be installed without damaging the integrity of your core system for upgrades. vQmod keeps a list of filenames and changes required, in the form of one XML file per extension. These changes are then created as the core files are used, and the resulting files are stored as cached copies which are executed instead of the original, core PHP or TPL file.

Installing vQmod

If you wish to upgrade your store, or have a 3rd party extension that you have not used before, it is advisable that you use the vQmod system. The vQmod download and instructions for installation can be found here:https://github.com/vqmod/vqmod.

Once you have downloaded the appropriate vQmod zip file provided in the link, you need to uncompress the zip file and FTP the vQmod folder to your site's root directory. From the Filezilla screenshot below, we can see the root directory of this store is located at public_html/opencart in the Remote site side. Uploading the vQmod folder here will make the vqmod folder visible in public_html/opencart.

vQmod advises you to set the permissions to writable for the vqmod/vqcache folders, index.php, and admin/index.php. In Filezilla you can right click on a file or folder, select "File Permissions...", and enter 755 or 777 in the "Numeric value" to set it to writable.

The next step in installing vQmod is to visit the install page in your store. Enter your store's location in your browser, then "vqmod/install" afterwards. If your store is located at "www.mystore.com", the vQmod install page would be located at "www.mystore.com/vqmod/install". The following text will appear on the page if it was installed correctly: "VQMOD HAS BEEN INSTALLED ON YOUR SYSTEM!".

System Requirements OpenCart 2.3.0.2

System / Server requirements

OpenCart requires certain technical requirements to be met for the store to operate properly. First, a web server must be created to make the OpenCart store publicly available on the web. Domain names and hosting services can easily be purchased for an affordable price.

When selecting a hosting service, you should check to see that these server requirements are provided and installed on their web servers:

These extensions must be enabled for OpenCart to install properly on the web server.

• Web Server (Apache suggested)
• PHP 5.3+(1.5.x at least 5.2+)
• Database (MySQLi suggested)

Required PHP libraries / modules

• Curl
• ZIP
• Zlib
• GD Library
• Mcrypt
• Mbstrings
• Xml

The above PHP extensions should be available by almost all hosting providers, during the install processa it will check you have them all enabled. You should contact your hosting provider if one is missing.

Introducing Microsoft Surface Studio

Introducing Microsoft Surface Studio

Introducing Microsoft Surface Studio - Video

How to cancel credit in opencart

Suppose it may happen, customer purchase something from your website but after successful transaction, you come to know that particular product is not in stock.

Now you have to give refund to that customer as a credit amount so customer can use that amount in future.

For that do following:

1.Go to customers section
2.go to that particular customer
3.There, you will see “Transactions” tab. Press it and enter amount and description. Click Add Transaction.
4.That’s it. Now your customer get credit and mail also send to that customer (Tested in OP 2)

Validation of viewstate MAC failed.

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Hello Friend, I have face this issue many time on online live website project.

Solution : 

Set the machinekey in the web config file.

If you want to generate the machinkey as per .net framework or see the below generated key.

Click Hear

Framework version

Asp.net 1.1

<machineKey validationKey="4B6124F1A96C1D90C2EB5298094895EBB9B1AB2227971EAC82E46D6E9B3E9
76CE56A7629E8C4E6C1AEF7A3B4F47681B60119D792EA47613971729564072DEB2A"
decryptionKey="4DD6849D7B818F86F6566B4AEDF1A9BD134DA1994236F8B8"
validation="SHA1" /> 

Asp.net 2.0

<machineKey validationKey="713BBE182A80928A389952B90A305817D43D87DF110B8F1BF4CF3D5628013F
8F93460838C28092EE99106FA2056191A9E3D9D4412607ADB55FE61193CFE30112"
decryptionKey="146AEAA8D1D915B020764CAF11EBD91A4C63B7D8898D13BDA7915F2E14E
92B41" validation="SHA1" decryption="AES" />

Asp.net 4.0

<machineKey validationKey="9BDD1AED72B3669A61961D2E1140865B6737FD394BCA2F4923C90F23CDCF
EE4E522A6E63EF6DA2BCD2DF736C917BBD47EEDCC570B46A623906334757A53ACF21"
decryptionKey="628176C339754EFADF3449C40A400ED185EC0DEBE8290331E3BD70AF463B
BDFA" validation="SHA1" decryption="AES" />

Asp.net 4.5

<machineKey validationKey="4047C7FA412278CF4A5D19BC670739DC9526FFB72F96C29D37A58807E1E4D8
374B6A19C97F7F27C73DB8AC81F5FA389138A9EB3F4752A578035966D5763BB72D"
decryptionKey="93BD9A1F3D1281400E1F5A3CCFF831F1249DC86930226D6B987E00007B989
DD5" validation="SHA1" decryption="AES" />

How to delete one array element from array

i) unset() method


$Array = array("test1","test2","test3","test3");

unset($Array[2]);

ii) array_diff_key() method


$Array = array("test1","test2","test3","test3");

array_pop($Array);

iii) array_splice() method


$Array = array("test1","test2","test3","test3");

array_splice($Array,1,2);

iv) array_diff() method


$Array = array("test1","test2","test3","test3");

array_shift($Array);

Primary key in SQL Server

Primary key is a single field or combination of fields that uniquely defines a record.
None of the fields that are part of the primary key can contain a null value.
A primary key column cannot contain NULL values.
Each table can have only ONE primary key.

We can create a primary key in table with the CREATE TABLE statement.
Syntax

The syntax to create a primary key using the CREATE TABLE statement:

CREATE TABLE table_name
(
  column1 datatype { NULL | NOT NULL } PRIMARY KEY,
  column2 datatype { NULL | NOT NULL },
  ...
 
);

Example :

CREATE TABLE Persons
(
Employee_Id int NOT NULL PRIMARY KEY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Department varchar(255),
Salary money
)


DROP a PRIMARY KEY Constraint

We can also drop the PRIMARY KEY constraint, using the below example:

ALTER TABLE Employee
DROP CONSTRAINT pk_EmployeeID