Jump to content


  • Posts

  • Joined

  • Last visited

Profile Information

  • Location
  • Activity

1sweetman's Achievements


Newbie (1/14)




Community Answers

  1. Yes - I have tried unhooking it and doing a hard refresh....made no difference.....re-hooked it again.
  2. Hi, Having just upgraded to latest version and having a look around have noticed that on the product pages the boxes no longer align properly and things are 'squished' together. I have had a look around but will admit to not knowing where to begin. I have attached an image showing what I mean. Any assistance greatly accepted and my thanks in advance.
  3. I am using Prestashop version I am updating items using the CSV import option. Within the Long Description box I have added the following <p>Fun Novelty Routemaster Red Bus Mug</p><p>If you are looking for a novelty gift that's practical and looks great, then check out our funky kitchen and ceramics range.</p><p>The range is made from dolomite ceramics and finished in a high gloss glaze. Each comes in a decorative gift box to complete the look, plus if it's a kitchen item then dolomite is food and microwave safe but cannot be put in the dishwasher.</p><p></p><p></p><p></p><p>Dimension</p><p>Height 10cm</p><p>Width 13.5cm</p><p>Depth 8.5cm</p> It is 512 characters in length (including spaces) It is saved in UTF-8 format It successfully uploads but only the first 391 characters appear within my shop. I can and have manually edited the product and all 512 characters go in and now work but there are another 2163 items in the same CSV file to double check for missing descriptions. Where have I gone wrong? Is there a character limit for the CSV import? If so what is the workaround for longer descriptions? Thanks in advance for your assistance
  4. Hi, I am just wondering if anyone has a working example of a Prestashop running MultiStore that I could visit (Retail side obviously, not Admin) as am looking at how it works/looks etc before trying to combine the 3 different sites I currently run under 3 different Prestashops. Thanks in advance folks
  5. Hi, thanks for that info I will look into it but first I'd like to resolve the issue that I seem to have with countries...... You are correct there is an issue in Localization > Countries - they are all duplicated plus there is some rather erroneous information e.g Zimbabwe (appears 3 times) ISO code ZW, Zone = Florida...... How would you/someone/anyone recommend clearing this up? Resetting a table somewhere? Or do I just have to work through Localization > Countries one at a time deleting the incorrect ones? Many thanks in advance. P.S. While asking if I block most countries does the mobile side still work or do I have to whitelist the providers IP's
  6. Hi, After a barrage of brute force attacks I have decided to use the geolocation option under Preferences to block certain countries however when I go to Preferences > Geolocation and want to review the countries I wish to accept/decline each country appears multiple times. Algeria - 3 times Angola - 4 times United Kingdom - twice etc Something has obviously gone wrong somewhere - what is best solution to fix? Reset the table in db? Which table? Drop the table and import a fresh table from a test shop? Delete the .dat file? Using version Many thanks in advance
  7. HI, Could someone please clarify the following for me. I had a site www.mckreddy-windsor.co.uk running oscommerce and it had a robots.txt file at www.mckreddy-windsor.co.uk/robots.txt. I have now installed prestashop at www.mckreddy-windsor.co.uk/catalog and I have generated the robots.txt file and can visit it here at www.mckreddy-windsor.co.uk/catalog/robots.txt. (also checked it on google webmaster tools and they can see it here too) I have since deleted the old osc robots.txt file Question 1 - the robots.txt file is now in the root of my catalog but not the root of my site - is this ok? Question 2 - if it needs to be in the root of my site can I just copy and paste it to the correct location? Question 3 - if it needs to be in root can prestashop be configured to generate it in the correct directory? if not can you suggest a small batch programme that will automatically copy it to right directory when it is regenerated. Many thanks for your assistance.
  8. Hi I have just tried to upgrade from to using 1-click autoupgrade module - it 'completed' with warnings. However when trying to log into admin all I now get is a directory tree showing www.mysite.com/myadmin/autoupgrade and nothing else. Restored backup, checked available disk space (40gb free) and reran upgrade - same message 'completed' with warnings except this time back office is available and "seems" to be working ok.....checked through upgrade log and found these [ERROR] error on extract using pclzip : PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature [WARNING] error when trying to upgrade module blockreinsurance. [ERROR] error on extract using pclzip : PCLZIP_ERR_BAD_FORMAT (-10) : Unable to find End of Central Dir Record signature [WARNING] error when trying to upgrade module themeinstallator. [WARNING] error when trying to upgrade module trackingfront. [WARNING] error when trying to upgrade module vatnumber. [WARNING] error when trying to upgrade module watermark. [WARNING] error when trying to upgrade module yotpo. Shall I restore 1.6.05 again? Or can I just reset/reinstall these modules? A brief search on PCLZIP_ERR_BAD_FORMAT implies might be a space issue but have checked and there is over 40gb free at moment Thanks in advance. .
  9. Hi sorry for any confusion re database and prestashop. 3 - I'm a curious bugger and like to learn so when database became rather large I experimented - in phpmyadmin I used export function to export a few or the larger tables and have a look. I used gedit (word type programme on linux) to open them and have a look around. As of 10 minutes ago I exported ps_product_lang and have selected n example from their (attached file) From INSERT INTO `ps_product_lang` (`id_product`, `id_shop`, `id_lang`, `description`, `description_short`, `link_rewrite`, `meta_description`, `meta_keywords`, `meta_title`, `name`, `available_now`, `available_later`) I would expect description, description_short, link_rewrite, meta_description, meta_keywords, meta_title, name, available_now and available_later to change with every addition/alteration to the product. Correct? I wouldn't expect id_product and id_shop to change (and they don't) Correct? Personally with my little experience of mysql I wouldn't have expected id_lang to change but it does. Is this correct? As you will see from the attached file there have been 5 minor changes in this product (liquid volume, font size, description etc) times 9000 products etc this soon becomes a very large table. Ideally I only want/need the latest revision. 2 - I am not aware of any module installed that would have altered/adjusted/started this functionality or even if this functionality is 'wrong' Again thanks for your assistance/help with this matter. Example.txt
  10. Hi, no that is not the case....prestashop as far as I know doesnt store the history but the database does - my most popular product has had some 100+ updates over the last 18 months and each update to the product writes to the database - using a text editor/spreadsheet I can see all of the product changes most of which are redundant now.....I just want to clear them out and keep the most recent version (or even say just the last months changes) Unfortunately the SQL commands are beyond my comprehension.
  11. Hi, thanks for info re the link. I already have the module installed and use it regularly but it was more the products history I wanted to cleanse. Some of my products have had 20-30 updates and I was hoping to get rid of some/all of the older entries and just keep the current/latest info.
  12. While researching solutions I can across this script and was wondering if someone can advise if is safe to run on prestashop database - or suggest alterations to get it working. https://github.com/silverstripe-labs/silverstripe-recipes/blob/master/model/tools/SanitiseTasks.php Thanks in advance for any assistance
  13. Do you have a link to an example? Do you have any images you can upload showing problem? What version of prestashop are you using? A lot more info would be helpful in assisting you.
  14. I have the same problem Prestashop 1.6 will not let you play a video on the product page. The video I am using plays on all of the browsers through a html page. My htpp.conf file is correct as is my mime file. If using the video link on the Large description page you can get the file manager to upload and give a green tick but it does not upload the file giving a blank page. If you enter the code for your video whether it is wmv, avi ,ogg etc direct into the source box Prestatshop fails to find the file giving you a question mark in the video box for the product page. We have spent days on this without success. If you source you video direct from youtube it works but we want to source our video from our own server. Does anybody have a way of resolving this problem. Regards
  • Create New...

Important Information

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