Jump to content

swankiat

Members
  • Posts

    9
  • Joined

  • Last visited

1 Follower

swankiat's Achievements

Newbie

Newbie (1/14)

0

Reputation

  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. The way I fixed this problem is add ob_clean(); at tcpdf.php between line 8066 & 8068. Have a try!
  5. 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~
  6. 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 ~
  7. 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~
  8. You can set the transparency at the configuration. If you set to 50, you might get the same result as PNG image.
×
×
  • Create New...