by matt | Feb 10, 2017 | Prestashop, SQL, Uncategorized
Database of your Prestashop project could be really huge after some time because of all the junk stats related data. The most of such data is not needed at all and it is only takes space on your server and slows the whole project down significantly. The best example...
by matt | May 31, 2016 | SQL, Uncategorized, WordPress
If you want to get all the WooCommerce products ready to be saved into a CSV / Excel file run the following query: SELECT ID, post_status, post_title, post_content, post_excerpt, guid FROM `wp_posts` WHERE (`post_status` = 'publish' OR `post_status` = 'draft') AND...
by matt | May 5, 2016 | Prestashop, SQL, Uncategorized
During the years I have been working on Prestashop professionally I gathered many useful SQL queries which help you to overcome some unusual tasks. Here is a collection of useful SQL queries for Prestashop project ready to be fired. This is my personal collection from...
by matt | Sep 28, 2014 | SQL, Uncategorized
Find the file config.inc.php and add this line: $cfg['ExecTimeLimit'] = 0; 12 $cfg['ExecTimeLimit'] = 0; then php/php.ini In the php/php.ini find the following commands post_max_size = 8M upload_max_filesize = 2M max_execution_time = 30 max_input_time = 60...
by matt | Aug 22, 2014 | SQL, Uncategorized
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); 1 UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring"); ...
by matt | Aug 22, 2014 | SQL, Uncategorized, WordPress
DELETE FROM wp_comments WHERE comment_approved = 'spam'; 1 DELETE FROM wp_comments WHERE comment_approved = 'spam';...
