Jump to content

RobS

Members
  • Posts

    29
  • Joined

  • Last visited

Everything posted by RobS

  1. Hi Samyah thank you for the continued flow up. Yes I received a refund for Request for Callback. I was told by the developers of the other two modules that they did accept the refund request although I have not yet received anything back. What really strikes me as odd is why PrestaShop itself has not responded back to me for the modules we purchased from them. As I mentioned in my original post, I purchased the three following made by PrestaShop modules during their 20% off Christmas sale. 1. Abandoned Cart Reminder Pro 2. Box Notification 3. Call Back The sale had a voucher code. But when we went to our cart and tried to checkout, the problem was that the place where you were supposed to enter this code could not be found by myself and two of our other staff members as we were all looking for it together at the same time. We literally had three people in our office who could not find it. So we proceeded with our purchase thinking this would not be a problem. We thought all we would have to do is contact PrestaShop Customer Support first thing Monday morning and they would surely honor the discount and make everything right. They refused to apply the discount telling us it was our mistake for not entering the code. When we asked them to point out where this code was supposed to be entered this was even more troubling. See the screenshot and look and see for yourself if you can find it. Either way to me this was a very innocent and honest oversight especially with the print being so very tiny and hard to see AND the fact that it does not even display at all on mobile devices which two of us were on that day. I cannot for the life of me understand why they would refuse us this discount. On top of this the module called Call Back was denied a refund by PrestaShop and I can only assume this because they never even responded to us for this request. The reason for us asking is because the module came with broken english without any way to change it. See attached for a screenshot of this. Notice where it reads " Please enter your phone number, we remind you less than three hours". We remind you less than three hours? Perhaps this is a personal preference that we wish to present ourselves to our visits with proper englisg but either way we should not be forced to use this or be denied a refund if they are not willing to help us fix it. The settings on this module also cannot be changed. Tell me would you set a call back with someone for 12 hours away? Sure call me back in 12 hours and we remind you in three? Really?Anyways, why all the trouble to refund for a module that clearly has issues and the fact that they will not even work with you to correct or change anything? As to the other post on the Abandon Cart module we have found that it is creating free discount codes for every email it sends our even though we have that option completely turned off. Again no real help with getting that fixed either. Thanks
  2. Samyah thank you for your response and I appreciate it coming from a spirit that is not so defensive. Our order numbers are below. We understand now that the discount offered was only available for modules that had been developed by the PrestaShop team. That was our oversight and we will live with it. But what has not been addressed and is still very troubling is that for the three modules that were developed by Prestashop we have yet to receive any discount for the two we did keep (that were actually usable) nor have we received a refund for the one (Call Back) that was totally useless. They also are listed below. The real sad thing here is that when we asked about this discount being applied to our account the response we received was totally unacceptable. Please see my first post (second paragraph) for more details on that. Thanks > Order #269465 & Order #269223 • Abandoned Cart Reminder Pro
By PrestaShop 







 • Box Notification (Popup)
By PrestaShop 







 • Call Back
  3. Hello I too was wanting to remove the label "Model" from the Product Page and I did see the solution here. I located the product.css file but may I ask if someone can tell me where in the file do I place the line #product_reference > label {display:none} If someone could help that would be great. Thanks
  4. Thanks I have been looking at that Zopim I even seen a plug in offered free for it (link below) but I could not tell if it was safe for PS1.6 or not and also if it would require any coding on my end. I will look at that other one you mentioned, thank you for that. http://www.prestashop.com/forums/topic/233362-module-zopim-chat-build-own-widget-for-free/
  5. We are a simple non profit organization, that is all. I have only been sharing with everyone what I have in hope that something will change and others will be aware of what really goes on with these modules and there related purchases and just one customers horrible experience. All the technical stuff has come directly from our developers and the HostGator reps we have worked with to get all these issues worked out. Hope that helps.
  6. Here we have yet another issue that has surfaced out of the horror that has been our experience with purchasing bug infested modules on PrestaShops Add-on store while PrestaShop Support continues to refuse us any relief. The latest module and only one of the two we had left out of the 8 we purchased caused our shops site to be taken down last night and today for over 12 hours for exceeding CPU resources! There were 8 pages of nothing but this nearly 80,000 request per hour! Open connections Current Site Requests: 121.45.217.123/modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 /modules/livechat/Ajax.php 121.45.217.123 modules/livechat/Ajax.php As I already said this went on and on I am only showing here the first half of one page. And now PrestaShop Support will tell us that we must let yet another developer enter our sites backend CPanel or FTP and Admin Section and allow them to work out their bugs while they use our site and time and resources to fix a module that is supposedly from a so-called "Certified Agency" of PrestaShop! What of the 6 plus hours I had to be on the phone with our provider just trying to get these restrictions removed? What of all our visitors who showed up to a site down during a holiday week? And I could ramble on and on with this travesty!! Just read the emails from our Hosting provider below. "Hello, Your account has been abusing CPU resources for an extended period of time and has been disabled in order to ensure continued performance stability of the account and server. While we do limit each account to no more than 25% of a system's CPU in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case. Please take a moment to review this email in full as it contains important information and resources to assist you in resolving this issue. Please note that this permanent restriction requires you take further actions to gain access to and resolve the issues on your account. Howdy, Thank you for getting back with us. It appears an onslaught of requests to your livechat (which seems to no longer exist) is causing excessive usage: 184.101.55.127 - - [31/Dec/2014:10:16:34 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7360 "0" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" 90.26.49.54 - - [31/Dec/2014:10:16:35 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7362 0"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" 73.201.41.12 - - [31/Dec/2014:10:16:36 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7359 0Mozilla/5.0 (Windows NT 6.3; WOW64; Trident/7.0; Touch; MATBJS; rv:11.0) like Gecko" 75.88.218.56 - - [31/Dec/2014:10:16:34 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7361 0Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:20.0) Gecko/20100101 Firefox/20.0" 98.173.60.180 - - [31/Dec/2014:10:16:33 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7361 0128-mp3-album-downloads" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" 104.219.9.222 - - [31/Dec/2014:10:16:34 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7360 0/8-teaching-cds?p=3" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36" 98.148.45.43 - - [31/Dec/2014:10:16:42 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 500 19229 0/order-history" "Mozilla/5.0 (Macintosh; PPC Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3" 76.171.101.1 - - [31/Dec/2014:10:16:34 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7358 0/12-events" "Mozilla/5.0 (Windows NT 6.3; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" 76.31.96.116 - - [31/Dec/2014:10:16:34 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7708 0"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/39.0.2171.95 Safari/537.36" 63.153.117.233 - - [31/Dec/2014:10:16:36 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7575 0controller=search&orderby=position&orderway=desc&search_query=hearing+from+God&submit_search=" "Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; rv:11.0) like Gecko" 184.101.55.127 - - [31/Dec/2014:10:16:36 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7360 0" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0" 98.173.60.180 - - [31/Dec/2014:10:16:37 -0600] "POST /modules/livechat/Ajax.php HTTP/1.1" 404 7359 0Mozilla/5.0 (Windows NT 6.1; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0"""
  7. Maggie We had one developer who told us he already sent in his request for refund to us and yet we still have not received it from PrestaShop. $269.99 Another one of the modules in question here is the PrestaShop Call Back Module. Have you personally taken the time to look at this module? Do you not notice the grammar used on the front end is Broken English that cannot be changed? Is this acceptable by you and PrestaShop? I also noticed that you chose not to address the Voucher Code field and our difficulty in being able to locate it. It does not even display on mobile devices. Have you looked for yourself at that? If it is in truth your job to help then why not do that and make right what can be made right?
  8. We have turned all this over to our Payment provider. It does not surprise us at this point that PrestaShop would now accuse us of telling lies "you won't make the mistake of buying something that doesn't fit your needs and then having to issue a complaint saying it doesn't work when it actually does". We have proof for our claims along with screenshots of many of our issues that were discovered but no one from PrestaShop including yourself even cared enough to ask us about this. Instead we are attacked and you-all stick together. We have contacted your CEO Mr. Leveque and hopefully he will look more into this whole matter of how you do business. Thank you for you time.
  9. Sure Live Chat By BELVG - Abandoned Cart Reminder Pro By PrestaShop. Each of these required some set up with a very minimal amount of tweaking and are all performing as hoped for. I now must remove from the 2 modules that seemed to be working correctly the Live Chat Module. As we received a repot tonight from our Hosting Company saying we were nearing suspension on our account and that we were now being cashed for the next 12 hours. AND THIS IS ALL AFTER THE MODULE WAS UNINSTALLED AND DELETED FROM OUR SHOP BACKEND!
  10. Hello everyone. This weekend we purchased over $800.00 in new add-on modules for our shop from PrestaShop Add-ons Store. PrestaShop was offering a 20% Christmas Discount on all PrestaShop owned modules and so we figured why not. We just recently updated to PrestaShop version 1.6.0.9 (and loving it) and so we figured what better time to “add on” a few new features. What a nightmare! Out of the 8 we purchased only two of them were basically without any real issues. All the rest were full of bugs. We managed to reach out to one of the developers in this process and they requested access to both our CPanel and the Admin section to our store. We were hesitating to do this but because we really did want the modules to work (I mean that is why we bought them after all, right?) we decided to give it a try. Well after many hours and emails and tries we still had to uninstall and delete in the end. They would fix two or three bugs and then another one or more would show up. In all of this we fought to be patient and kind but I have to tell you what is happening now is totally unacceptable! First let me say something relating to these purchases. For one thing the sale had a voucher code. But when we went to our cart and tried to checkout, the place where you enter this code could not be found. We literally had three people in our office trying to find it. No luck. So we proceeded with our purchase thinking this would not be a problem. We thought all we would have to do is contact PrestaShop Customer Support first thing Monday morning and they would surely honor the discount and make everything right. NOT so. They refused to apply the discount telling us it was our mistake for not entering the code. When we asked them to point out where this code was supposed to be entered this was even more troubling. See the screenshot and look and see for yourself if you can find it. Either way to me this was a very innocent and honest oversight especially with the print being so very tiny and hard to see. I cannot for the life of me understand why they would refuse us this discount. One of my staff just pointed out to me that the voucher code field does not even show up and display our mobile devices. That would explain another reason why at least two of us were not able to locate it. I am sorry I could not see where to add the attached screenshot I mentioned above. But you can go to the Add-on Store and check it out that way. Secondly from a customer’s point of view I feel if a module is being offered for sale and listed as “stable” and “compatible” with the version of PrestaShop that you are using then that is what it should be. I can understand and take into account that there might be problems if you are using some third party theme but if you are only using the default bootstrap then at a minimum it should not have so many issues like the ones we had. As a consumer I also should not be put in a position and asked or expected to become a beta tester for every developer who has an module to offer. But that is exactly what we are now being asked to do and PrestaShop Support is refusing to refund our monies even after we have uninstalled and deleted everything from our store. We likewise are not comfortable with allowing whoever it might be to use both our shops front and backend as a testing ground for them to work out their bugs and whatever else. We ran our shop through WC3 and Google PageSpeed and we were shocked at the amount of bad code we were shown from some of these modules. We now have been left with no other alternative but to open a dispute through Paypal in the hope of finding some relief there. Merry Christmas to you too, PrestaShop Customer Support!
  11. I just installed a Chat and it seems ok Live Chat By BELVG
  12. Hello I am now having this same problem was there a fix in all of this that was written? Thanks
  13. Hello I read through all the post here but I am still not sure what I should do. I just upgraded to 1.6 from 1.5 and now my images are displaying very small compared to my PS development site as well as PS live Demo site. I also see on PS live Demo site many less settings in back office compared with my live site. There is even one extra column called "Scenes" in my shop unlike PS demo shop. During my testing on my own development site this image problem did not occur only now after upgrading live site with One Click Upgrade. I believe all my extra rows are left overs from 1.5 those without the "_default"behind them. Can I now just delete these rows? Also I had to change a couple of the settings to match all PS default settings like in demo shop. Should I use the "Move Image Option" and if so just what will that do? Also should I regenerate all images as I was instructed to do after making edits to some image settings? I have recently uploaded all brand new images 800x800 but they are all still displaying very small. Thanks so much.
  14. I was wondering if someone could help. I upgraded my shop yesterday from PS 1.5 to 1.6. On my test site all my images looked good but when I updated live site all my images are showing up small. I also noticed some image size preferences were still on PS 1.5 and did not change for 1.6 and so I changed those to be as they should. Do I now need to move images and also regenerate in order for images to display right size now?
  15. We just finished running the query in which all records in the ps_product_download table whose "active" field was set to 0 were purged as instructed. This eliminated 5148033 database rows resulting in the ps_product_download table becoming much more manageable in size (currently contains 459 rows). Thanks a lot
  16. This post has been picked up here: http://www.prestashop.com/forums/topic/310139-problem-with-ps-product-download-table/
  17. May I ask if you are referring to this below? Also I think I got lost by your meaning behind nobody seems to be bothered about statistics? I did try this but I will try it again maybe I missed something? Thanks These are the steps I did to purge the table: 1) did a full database backup 2) exported all product_download records where active = 1 3) truncated the product_download table 4) imported all active records back into product_download table
  18. I tried posting this in a somewhat related discussion but thought best to start anew being the issue there was quite different although the topic title was the same. My main issue is at end of post which has to do with emptying the ps_product_download table but I thought a little history might help. Upon monitoring our account's mysql usage, I noticed multiple queries of the following form being invoked when the script, /home3/hgeem/public_html/index.php was being executed: SELECT `display_filename` FROM `ps_product_download` WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1 Each query of this form was traversing over 5 million rows in the ps_product_download table of our hgeem_prst1 database, thereby taking a massive amount of time to complete its execution. To help with this, I added an index to the ps_product_download table. Observe the before and after. Before: mysql> EXPLAIN SELECT `display_filename` -> FROM `ps_product_download` -> WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1 ; +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | ps_product_download | ALL | NULL | NULL | NULL | NULL | 5188032 | Using where | +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ 1 row in set (0.01 sec) After: mysql> EXPLAIN SELECT `display_filename` FROM `ps_product_download` WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1; +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ | 1 | SIMPLE | ps_product_download | ref | i1 | i1 | 768 | const | 1 | Using where | +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ 1 row in set (0.00 sec) Notice that the total rows traversed by the sample query dropped from 5188032 to just 1, indicating a marked improvement in its overall efficiency. My problem now, however, is something else. Looking over the structure of the ps_product_download table, I observed the following fields: +---------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+---------------------+------+-----+---------+----------------+ | id_product_download | int(10) unsigned | NO | PRI | NULL | auto_increment | | id_product | int(10) unsigned | NO | MUL | NULL | | | display_filename | varchar(255) | YES | | NULL | | | filename | varchar(255) | YES | MUL | NULL | | | date_add | datetime | NO | | NULL | | | date_expiration | datetime | YES | | NULL | | | nb_days_accessible | int(10) unsigned | YES | | NULL | | | nb_downloadable | int(10) unsigned | YES | | 1 | | | active | tinyint(1) unsigned | NO | | 1 | | | is_shareable | tinyint(1) unsigned | NO | | 0 | | +---------------------+---------------------+------+-----+---------+----------------+ 10 rows in set (0.00 sec) I'm not 100% on this but it looks like this table is tracking statistical information relating to our site's product downloads. Likely any time a download is initiated on our site, one or more rows are being added to this database table resulting in the heavy accumulation of data. The following prestashop forum thread also seems to agree with this: http://www.prestasho...download-table/ I tried to empty this database table and immediately noticed a problem. I really hoped that emptying the ps_product_download would resolve this issue, but unfortunately it looks like this table also affects our visitors' ability to download their purchases from within their own user accounts on our shop. It also prevented emails from being sent to our customers with their attached download links. I had to restore from backup and now everything is back to the way it was. Does anyone know how to empty the ps_product_download table without this problem occurring? Thanks
  19. I am hoping this is the right place to post this issue. Upon monitoring our account's mysql usage, I noticed multiple queries of the following form being invoked when the script, /home3/hgeem/public_html/index.php was being executed: SELECT `display_filename` FROM `ps_product_download` WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1 Each query of this form was traversing over 5 million rows in the ps_product_download table of our hgeem_prst1 database, thereby taking a massive amount of time to complete its execution. To help with this, I added an index to the ps_product_download table. Observe the before and after. Before: mysql> EXPLAIN SELECT `display_filename` -> FROM `ps_product_download` -> WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1 ; +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | ps_product_download | ALL | NULL | NULL | NULL | NULL | 5188032 | Using where | +----+-------------+---------------------+------+---------------+------+---------+------+---------+-------------+ 1 row in set (0.01 sec) After: mysql> EXPLAIN SELECT `display_filename` FROM `ps_product_download` WHERE `filename` = 'a80863632311e78081ad5ebdd352eb099b568bdc' LIMIT 1; +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ | 1 | SIMPLE | ps_product_download | ref | i1 | i1 | 768 | const | 1 | Using where | +----+-------------+---------------------+------+---------------+------+---------+-------+------+-------------+ 1 row in set (0.00 sec) Notice that the total rows traversed by the sample query dropped from 5188032 to just 1, indicating a marked improvement in its overall efficiency. My problem now, however, is something else. Looking over the structure of the ps_product_download table, I observed the following fields: +---------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+---------------------+------+-----+---------+----------------+ | id_product_download | int(10) unsigned | NO | PRI | NULL | auto_increment | | id_product | int(10) unsigned | NO | MUL | NULL | | | display_filename | varchar(255) | YES | | NULL | | | filename | varchar(255) | YES | MUL | NULL | | | date_add | datetime | NO | | NULL | | | date_expiration | datetime | YES | | NULL | | | nb_days_accessible | int(10) unsigned | YES | | NULL | | | nb_downloadable | int(10) unsigned | YES | | 1 | | | active | tinyint(1) unsigned | NO | | 1 | | | is_shareable | tinyint(1) unsigned | NO | | 0 | | +---------------------+---------------------+------+-----+---------+----------------+ 10 rows in set (0.00 sec) I'm not 100% on this but it looks like this table is tracking statistical information relating to our site's product downloads. Likely any time a download is initiated on our site, one or more rows are being added to this database table resulting in the heavy accumulation of data. The following prestashop forum thread also seems to agree with this: http://www.prestashop.com/forums/topic/310139-problem-with-ps-product-download-table/ I tried to empty this database table and immediately noticed a problem. I really hoped that emptying the ps_product_download would resolve this issue, but unfortunately it looks like this table also affects our visitors' ability to download their purchases from within their own user accounts on our shop. It also prevented emails from being sent to our customers with their attached download links. I had to restore from backup and now everything is back to the way it was. Does anyone know how to empty the ps_product_download table without this problem occurring? Thanks
  20. Hello I am having a similar problem only after the upload I do not see anything except a question mark in place of where my logo should be. The upload does not show up anywhere. I have tried various image sizes and clearing the cache but nothing helps. Any ideas? Thanks
  21. Hello has anyone found a solution to this? I tried everything mentioned above and still no joy. Thanks
  22. Hello We are not out to take advantage of anyone. This was a long term investment for us as it no doubt will be for others looking for a similar module. The price we quoted was one we would have surely paid when we were originally looking. Of course we would be more than happy to consider offering it for less. Feel free to ask. Thanks
  23. Hello again. The PrestaShop Paypal module for donations is fine if you are okay with the Paypal transaction fees and besides that it does NOT have a feature for rounding up as mentioned above. These are two of the many reasons why we decided to invest in something else. Thanks
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More