Open Script Solution

Have you ever encountered the strange behavior while you were deleting the certain records from a table in MySQL database using an application you build, which those records cannot be deleted? Well, I have! Today, I encountered this problem. This is so weird, since I have never faced this situation before. Well, after doing some investigations, this problem obviously caused by one of the primary key fields contains the comma (,) character. Why I am sure about this, because when I replace the comma character for one record, then I re-try to delete that record from that application, voila…. that record gets successfully deleted. But the main problem is not stop until that. The next question is: How then can I replace all comma characters from the rest of the other records immediately? Just for your information, there are thousand records that contain the comma character. It is impossible to update all the records one by one, even as a matter of fact, you can create a little program/tool in order to implement it using loop method throught the recordset? Well, here is the quick-solution to overcome it. Read more…

Have you ever wanted to remove the product id from the URL of your PrestaShop? For instance, by default, PrestaShop uses this URL to display the certain product named ipod-touch: /7-ipod-touch.html instead of /ipod-touch.html. Well, here is the solution how you can make it comes true. I have successfully implemented it into PrestaShop version 1.2.5. Please note that before you implement this modification, make sure you have already implemented the similar modification that will remove category id from the URL. Read more…