Can't connect to database in Prestashop

If you are trying to setup database details for Prestashop locally and getting the following error:

"Database server was not found. Please verify the login, password and server fields."

Then try replacing localhost with 127.0.0.1 as hostname. This worked for me.

Include file in CakePHP

To include a file in your .ctp files, make the path is given from webroot. So if you have placed your file outside the "app" directory then the path will be set as include("../../file.php");

550 SSL/TLS required on the control channel

When trying to connect through FTP, if you get the following error:

"550 SSL/TLS required on the control channel"

then try adding prefix to the hostname with ftpes://

This worked for me.

Adding additional product attributes to display in Interspire shopping cart

To add additional product attributes in product details page of Interspire shopping cart we need to add an inteface in admin section to enter those details. I tried the following:

1. Admin Section: code changes
1. Open admin/templates/product_form.tpl
2. Add additional fields attribute in html format as required.
3. In admin/includes/classes/class.product.php, include the post data for inserting into database and add the fields in database as well.
4. Search for AddProductStep2
5. Add entry under lib/entities/entity.product.php

Hope this will work for you.

Customer Rewards Point Module for Interspire

This is a very interesting feature to bring customers back to your site. I have worked on a rewards point module for Interspire shopping cart.
It works on all the interspire themes and very easy to integrate.


There are 2 sections in the module:

• Admin Section
• Assign points to each product
• Check the status under Orders tab whether orders are paid or customers have redeemed points against their purchase.
• Admin can also assign loyalty points to users and assign it to their account
• Admin can also set the minimum points against every order or amount spent.

• User Section
• Users can see the points earned in their My Account section
• Users can redeem points against products

Contact me if you want to know the module in detail.