Jump to content

swankiat

Members
  • Content count

    9
  • Joined

  • Last visited

1 Follower

About swankiat

  • Rank
    PrestaShop Newbie
  1. Hi guys, I have solved this problem by adding new feature and delete old feature values from database. First of all, let me clarify my problem as following: 1. Upgrade prestashop from 1.4 to 1.6 1. Do some filters on category page (the URL will become #/color-red-yellow) 2. Click into any product page 3. Then hit BACK button, it will show "no product in this category" (URL become #/) So I checked my database and found that ps_layered_friendly_url has generated data that the feature vales were old and not used anymore. So how I fixed the problem (require basic MySQL knowledge, so I suggest you backup your db first): 1. Duplicate all the features at BO (for eg: color, material, etc) 2. Update id_feature in table ps_feature_value (do not create new feature values) 3. Update id_feature in table ps_feature_product 4. Delete id_feature_value which are not used anymore from ps_feature_product, ps_feature_value, ps_feature_value_lang Then rebuilding URL at module block layered navigation and the problem is fixed.
  2. To whom encounter the same problem: Slow ajax response when checkout or add / remove items, I have solved this problem. The cause of this problem is, it will execute modules that hook to "cart" when you try to do the above mentioned actions. and one of my module (affinity items) will be hooked. However this module has internal error and cause the response so slow. So when I uninstall this module, everything runs smoothly! Cheers~
  3. Hi, I am using prestashop 1.4.9. I have around 1600 products. I host my site on cloud server ( 2 vcpu, 4GB RAM, 4Mbps bandwidth). Recently when visitors increasing to certain limit (about 160 visitors) and my server will crash. Below is the error I get. ====== 130729 11:13:58 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24) 130729 11:13:59 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24) 130729 11:13:59 [ERROR] /usr/sbin/mysqld: Can't open file: './tudung2u_tudung/ps_help_access.frm' (errno: 24) 130729 11:14:03 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24) 130729 11:17:53 [ERROR] Error in accept: Too many open files 130729 11:22:10 [ERROR] Error in accept: Too many open files 130729 11:26:00 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24) 130729 11:26:04 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24) 130729 11:26:26 [ERROR] Error in accept: Too many open files 130729 11:30:43 [ERROR] Error in accept: Too many open files ====== Please kindly guide me how to solve this problem? Thanks a lot !
  4. Thanks for prompt reply! When is ajax mode ready for purchase? How much it cost? Compatible with ps 1.4? Thanks!
  5. Dear tomerg3, May I know if your module allows combo search? Let's take me as an example. I am selling shoes. In one of the categories (men shoes), I would like to allow my customers to filter search by manufacturer (nike, adidas), subcategory (sandal, sports shoes), attributes (shoes size) & features (shoes color). Could your module do that? Thanks for reply.
  6. As you said, my problem is the compatibility issue. I update jquery from 1.2.6 to 1.4.2, then it appears the error. I am using prestashop 1.2.5. So how to solve the problem if I insist to use jquery 1.4.2? Many many thanks.
  7. The way I fixed this problem is add ob_clean(); at tcpdf.php between line 8066 & 8068. Have a try!
  8. Create order from Back Office

    Guys, I found this module that could create order from back office and it is FREE ! http://addons-modules.com/prestashop-admin-modules/14--prestashop-132-admincart-with-order-recovery.html Hope it helps~
  9. [SUPER MODULE] New Order 1.0

    Guys, I found this module that could create order from back office and it is FREE ! http://addons-modules.com/prestashop-admin-modules/14--prestashop-132-admincart-with-order-recovery.html Hope it helps ~
  10. Admin Login Loop

    Hi, I met this problem before and I found out it was server problem but not coding problem. The problem is my server turn off output_buffering, so it couldn't send the header line and cause jumping back to login page after logging in successfully. The solution is turning it ON. You can either place a php.ini under the root folder to overwrite the server setting. For this solution, please consult the IT dept of your server. Hope it help~
  11. PNG as Watermark

    You can set the transparency at the configuration. If you set to 50, you might get the same result as PNG image.
  12. I am not sure whether you guys encounter the problem I met after applying this code. The scenario is like this: When you added in certain quantities to get the discount, the price will be automatically changed to after-discount price at category page, but the product page will still show original price. It will confuse customers.
×