if you encounter this error "MODS CACHE PATH NOT WRITEABLE"
just add this file in vqmod directory "mods.cache"
so it looks like "vqmod\mods.cache"
Just create a new text file and rename it into mods.cache, don't forget to remove the txt extension.
Don't forget to set file permission to 644 to "mods.cache" file
Don't put anything into the file. Just refresh your web and no more error.
All About Opencart
Tuesday, August 26, 2014
Wednesday, May 21, 2014
how to create popup terms and conditions in opencart
If you have custom footer module, you can put the code below :
<ul class="list">
<li ><a class="colorbox" href="index.php?route=information/information/info&information_id=4">About Us</a></li>
<li><a class="colorbox" href="index.php?route=information/information/info&information_id=3
">Privacy Policy</a></li>
<li><a class="colorbox" href="index.php?route=information/information/info&information_id=5
">Terms & Conditions</a></li>
</ul>
don't forget to put this script in footer.tpl of your theme.
<script type="text/javascript">
<!--
$(document).ready(function() {
$('.colorbox').colorbox({
width: 750,
height: 550
});
});
//-->
</script>
Friday, April 25, 2014
To make telephone number field box only accept number
catalog/view/javascript/common.js
add this function in the bottom file
Thanks to : avvici -arvixe-
add this function in the bottom file
function isNumberKey(evt) {
var charCode = (evt.which) ? evt.which : event.keyCode
if (charCode > 31 && (charCode < 48 || charCode > 57)) {
return false;
} else {
return true;
}
}
<input type="text" name="telephone" onkeypress="return isNumberKey(event)" value="<?php echo $telephone; ?>" size="32"/>
Thanks to : avvici -arvixe-
Tuesday, April 22, 2014
It takes a long time to login to administration
If you ever feel it takes to long to login to your opencart administrator, just do this :
Turn off Auto Update Currency, in System->Settings->Local
Trust me, it works.
Turn off Auto Update Currency, in System->Settings->Local
Trust me, it works.
Sunday, March 30, 2014
How to turn off Magic Quotes GPC in opencart installation
First edit the .htaccess.txt
# 2. If your cart has magic quotes enabled, This may work to disable it:
# php_flag magic_quotes_gpc Off
# uncomment it
php_flag magic_quotes_gpc Off
Save it.
Rename it to .htaccess
Done. Refresh your opencart installation.
# 2. If your cart has magic quotes enabled, This may work to disable it:
# php_flag magic_quotes_gpc Off
# uncomment it
php_flag magic_quotes_gpc Off
Save it.
Rename it to .htaccess
Done. Refresh your opencart installation.
Tuesday, February 25, 2014
Add table prefix in mysql database for opencart
If you ever install an opencart without table prefix, you'll get troubles when using some custom modules. (Especially with the table ORDER, RETURN and OPTION. Because that is same as MYSQL Syntax., you'll get error when calling such as "SELECT * FROM ORDER")
Here is what you do to add prefix on the table.
Enter the database you want to change the table prefix.
put below command in SQL Tab and run it. Just change the RED one. Example : my_prefix_ into oc_
and my_database into yourdatabasename
Paste it on the notepad first.
Here is what you do to add prefix on the table.
Enter the database you want to change the table prefix.
put below command in SQL Tab and run it. Just change the RED one. Example : my_prefix_ into oc_
and my_database into yourdatabasename
SELECT Concat('ALTER TABLE ', TABLE_NAME, ' RENAME TO my_prefix_', TABLE_NAME, ';') FROM information_schema.tables WHERE table_schema = 'my_database'
run it in SQl Tab in PHPMyadmin.
Copy the results. (Don't forget click Show All, to see all result) and select it from top to bottom using your mouse, and copy it.
and remove these 3 row from the list.
ALTER TABLE option RENAME TO oc_option; (rename manualy)
ALTER TABLE return RENAME TO oc_return; (rename manualy)
ALTER TABLE order RENAME TO oc_order; (rename manualy)
ALTER TABLE return RENAME TO oc_return; (rename manualy)
ALTER TABLE order RENAME TO oc_order; (rename manualy)
if you put this on below list, it will get error. You'll have to rename it manually one by one. Not using SQL Tab.
Copy the list (list table may vary, don't use my result list, use your result list) because i already delete some lines, because it's to long.
ALTER TABLE address RENAME TO oc_address;
ALTER TABLE affiliate RENAME TO oc_affiliate;
ALTER TABLE affiliate_transaction RENAME TO oc_affiliate_transaction;
ALTER TABLE attribute RENAME TO oc_attribute;
ALTER TABLE attribute_description RENAME TO oc_attribute_description;
ALTER TABLE attribute_group RENAME TO oc_attribute_group;
ALTER TABLE attribute_group_description RENAME TO oc_attribute_group_description;
...
ALTER TABLE url_alias RENAME TO oc_url_alias;
ALTER TABLE user RENAME TO oc_user;
ALTER TABLE user_group RENAME TO oc_user_group;
ALTER TABLE weight_class RENAME TO oc_weight_class;
ALTER TABLE weight_class_description RENAME TO oc_weight_class_description;
ALTER TABLE zone RENAME TO oc_zone;
ALTER TABLE zone_to_geo_zone RENAME TO oc_zone_to_geo_zone;
ALTER TABLE affiliate RENAME TO oc_affiliate;
ALTER TABLE affiliate_transaction RENAME TO oc_affiliate_transaction;
ALTER TABLE attribute RENAME TO oc_attribute;
ALTER TABLE attribute_description RENAME TO oc_attribute_description;
ALTER TABLE attribute_group RENAME TO oc_attribute_group;
ALTER TABLE attribute_group_description RENAME TO oc_attribute_group_description;
...
ALTER TABLE url_alias RENAME TO oc_url_alias;
ALTER TABLE user RENAME TO oc_user;
ALTER TABLE user_group RENAME TO oc_user_group;
ALTER TABLE weight_class RENAME TO oc_weight_class;
ALTER TABLE weight_class_description RENAME TO oc_weight_class_description;
ALTER TABLE zone RENAME TO oc_zone;
ALTER TABLE zone_to_geo_zone RENAME TO oc_zone_to_geo_zone;
Copy the list put it on SQL Tab Box and run it.
there you go. please refresh it if you don't see the result changes. just change between database, and back again. you will see all your tables already have a prefix on it.
Don't Forget to manually rename the 3 tables (OPTION, RETURN and ORDER), don't use SQL you'll get error.
First Select the table, then click OPERATIONS Tab,
Rename it to oc_order. (example). That's it.
Thank you for reading. Hope it'll help you.
Tuesday, January 15, 2013
Internal Server Error on WAMP
Just activate Rewrite_module in apache
go to WAMP Menu : Apache -> Apache Modules ->rewrite_module
go to WAMP Menu : Apache -> Apache Modules ->rewrite_module
Subscribe to:
Posts (Atom)