Jump to content

skindiddle

Members
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • First Name
    Dar
  • Last Name
    Jo

skindiddle's Achievements

Newbie

Newbie (1/14)

0

Reputation

1

Community Answers

  1. Ah, my host is Heart Internet and I just found this post about a Magento shop that says... "Contact Heart Internet Support Team (by rasing a ticket) and ask them to allow “CREATE TEMP TABLE” permissions on your database. Heart stop this by default for security reasons" ( http://www.solarpolar.co.uk/installing-magento-on-heart-internet-shared-server/ ) That's one to bear in mind for any Heart customers. Now 1-click update rollback isn't working. Great. An hour of restoring files and database ahead. Very tempting to just plow on, as everything seems to be working, but better not. Thanks for the feedback.
  2. Hi, I've just upgraded from version 1.6.0.9 to 1.6.1.2 using the 1-click Upgrade mod, to fix an issue with images not displaying in the back end. The upgrade seems to have fixed it, but I wanted to find out if I should be worried about the database errors reported by the upgrade mod. I've copied them below, with the database and user names changed. As I've only added categories so far and no products (apart from the default sample ones) are present, do the errors below that look to be related to moving/merging images and attributes matter at all? SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `ps_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'USERNAMEHERE'@'%' to database 'DATABASENAMEHERE' SQL 1.6.1.0 1146 in UPDATE `image_transform` JOIN `ps_image` USING (`id_product`) SET `ps_image`.`cover`=NULL: Table 'DATABASENAMEHERE.image_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `image_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_image_shop` WHERE `cover`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'USERNAMEHERE'@'%' to database 'DATABASENAMEHERE' SQL 1.6.1.0 1146 in UPDATE `image_shop_transform` JOIN `ps_image_shop` USING (`id_product`, `id_shop`) SET `ps_image_shop`.`cover`=NULL: Table 'DATABASENAMEHERE.image_shop_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `ps_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1: Access denied for user 'USERNAMEHERE'@'%' to database 'DATABASENAMEHERE' SQL 1.6.1.0 1146 in UPDATE `attribute_transform` JOIN `ps_product_attribute` USING (`id_product`) SET `ps_product_attribute`.`default_on`=NULL: Table 'DATABASENAMEHERE.attribute_transform' doesn't exist SQL 1.6.1.0 1044 in CREATE TEMPORARY TABLE `attribute_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `ps_product_attribute_shop` WHERE `default_on`=1 GROUP BY `id_product`, `id_shop` HAVING c>1: Access denied for user 'USERNAMEHERE'@'%' to database 'DATABASENAMEHERE' SQL 1.6.1.0 1146 in UPDATE `attribute_shop_transform` JOIN `ps_product_attribute_shop` USING (`id_product`, `id_shop`) SET `ps_product_attribute_shop`.`default_on`=NULL: Table 'DATABASENAMEHERE.attribute_shop_transform' doesn't exist Many thanks
  3. Update: The same was happening with the products, sort of. In the front end, product images were fine. In the back end, in the list of products they were appearing as question marks. If you dug down into the product details > images they appeared ok in there. The site is running on Heart Internet and used the default installation of Prestashop via their eXtend control panel. This installed version 1.6.0.9. After installing the 1-click Upgrade mod and upgrading to version 1.6.1.2 the image issue appears to be fixed. Some database errors reported by the upgrade process though, so that is a worry. I'm asking about that in the upgrading forum. So whether there was something quite wrong with version 1.6.0.9 or just with how Heart Internet's system dishes it out, this may be the fix (dependent on how serious the errors turn out to be!)
  4. Hi, Is there anywhere else apart from here that I can ask questions about things that aren't working correctly in Prestashop, if questions here go unanswered? Many thanks
  5. A further thing I tried was adding in duplicates of the category image types, category_default & tm_category_default, without the _default, then regenerating thumbnails again. This also made no difference. Caching is turned off also. I'm working my way through the various suggestions related to images being replaced by question marks in the Prestashop admin area but so far no luck. Quite new to Prestashop but hoping the community here might be able to point me in the right direction.
  6. Just to clarify. This is what I see in the admin > catalog > categories when I edit a category which has an image added. The question mark image address is in the format of -site address here- /img/tmp/category_31.jpg?time=1448144836
  7. Hi, I'm in the process of setting up a shop using Prestashop 1.6.0.9. I've set up the categories first, but am starting to add the category images and have noticed that, although the image appears on the front end shop, it appears as a question mark in the back end admin area when I go in to edit the category details. I've tried regenerating images, setting permissions on the img folder as 777 and turning off seo urls but none of these fixed it. Is there anything else I can try? Many thanks
×
×
  • Create New...