Jump to content

Erreur sql message prestashop

Emilo
 Share

Recommended Posts

Emilo Newbie

Emilo

Posted
Posted (edited)

Bonjour à tous,

 

Je suis nouvelle dans ce forum et j'avoue que là, je bute sur un soucis et j'aurai besoin de votre aide. J'ai installé un presta en local et je suis en train de le remplir. J'ai une boutique en ligne déjà existante en version 1.5 qui a déjà tellement de bugs que j'ai préféré créer une nouvelle boutique avec la version 1.6 et comme je suis en local, mon phpmyadmin ne supporte pas mon import de base de données car trop volumineuse. Alors j'ai cherché sur le web et j'ai tenté bigdump. Et depuis, voici le 1er message d'erreur  et le second en dessous que j'ai qui m'empêche de créer produits, règles de taxes, etc... Pourriez-vous m'aider s'il vous plaît ? Pour info, j'ai forcer la compil et vider le cache.

 

[PrestaShopDatabaseException]

Unknown column 'trg.deleted' in 'where clause'
 

					SELECT id_tax_rules_group					FROM (						SELECT COUNT(*) n, product_shop.id_tax_rules_group						FROM ps_product p						 INNER JOIN ps_product_shop product_shop		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)						JOIN ps_tax_rules_group trg ON (product_shop.id_tax_rules_group = trg.id_tax_rules_group)						WHERE trg.active = 1 AND trg.deleted = 0						GROUP BY product_shop.id_tax_rules_group						ORDER BY n DESC						LIMIT 1					) most_used LIMIT 1

at line 791 in file classes/db/Db.php

786.         if ($webservice_call && $errno) {787.             $dbg = debug_backtrace();788.             WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);789.         } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {790.             if ($sql) {791.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');792.             }793. 794.             throw new PrestaShopDatabaseException($this->getMsgError());795.         }796.     }

 

Notice: Trying to get property of non-object in /Applications/MAMP/htdocs/prestashop/classes/Tools.php on line 1227

Notice: Undefined property: BablicSDK::$snippet in /Applications/MAMP/htdocs/prestashop/modules/bablic/sdk.php on line 224

[PrestaShopDatabaseException]

Unknown column 'product_attribute_shop.id_product' in 'on clause'

Edited by Emilo (see edit history)
Link to comment
Share on other sites
stevent Newbie

stevent

Posted
Posted

Plus ou moins meme soucis après une migration de base de données : 

 

[PrestaShopDatabaseException]

Error writing file '/dev/shm/MYkeapZ0' (Errcode: 12)
 

        SELECT
            p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`,
            IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
            pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
            pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
            DATEDIFF(
                p.`date_add`,
                DATE_SUB(
                    "2017-04-11 00:00:00",
                    INTERVAL 180 DAY
                )
            ) > 0 AS new
        FROM `pre7153_product` p
         INNER JOIN pre7153_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
        LEFT JOIN `pre7153_product_attribute_shop` product_attribute_shop
            ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
         LEFT JOIN pre7153_stock_available stock
            ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
        LEFT JOIN `pre7153_product_lang` pl ON (
            p.`id_product` = pl.`id_product`
            AND pl.`id_lang` = 1 AND pl.id_shop = 1
        )
        LEFT JOIN `pre7153_image_shop` image_shop
            ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
        LEFT JOIN `pre7153_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
        LEFT JOIN `pre7153_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
        WHERE product_shop.`active` = 1
        AND product_shop.`show_price` = 1
         AND p.`visibility` IN ("both", "catalog")
         AND p.`id_product` IN (5, 7, 20431, ......( j'ai viré les lignes inutiles )....... 3097, 86880, 86881, 86882, 86883, 86884, 86885, 3099, 86886, 86887, 86888, 3098, 3100, 3101, 3103, 58995, 3009)
         AND EXISTS(SELECT 1 FROM `pre7153_category_product` cp
                JOIN `pre7153_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` IN (3))
                WHERE cp.`id_product` = p.`id_product`)
        ORDER BY product_shop.price DESC
        LIMIT 0, 5
at line 791 in file classes/db/Db.php

 

786. if ($webservice_call && $errno) {
787. $dbg = debug_backtrace();
788. WebserviceRequest::getInstance()->setError(500, '
 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
789. } elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) {
790. if ($sql) {
791. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
792. }
793.
794. throw new PrestaShopDatabaseException($this->getMsgError());
795. }
796. }
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...