Have a webpage with 2000 articles ?
Need to replace a certain keyword with a new one?
Use the string below.
UPDATE tablename SET fieldname = REPLACE(fieldname, ‘the text you want to replace’, ‘new text goes here’);
Archive for PROGRAMMING
Mass replace in mySQL
open cart hung up on checkout
Ran into a small bug with an opencart installation today. When processing a paypal credit card order, it would process but continue to show the customer “Please Wait”. If the customer did not have their e-mail open, they would not see that the order processed. This was causing many people to re-enter the order, then demand a refund. Huge waste of time!
The problem is due to the email check adding a single “blank” email to the additional email list. Please make the following changes to fix the problem.
1. Open catalog/model/checkout/order.php
2. Find line 379.
3. Replace with:
