henrycr Posted November 21, 2011 Share Posted November 21, 2011 Hola amigo instale en mi web este modulo Delete connections/expired vouchers/carts and optimize all tables v1.5,pero me esta dando este error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/22/6679522/html/modules/deleteconnections/deleteconnections.php on line 103 Fatal error: Call to undefined method MySQL::getValue() in /home/content/22/6679522/html/modules/deleteconnections/deleteconnections.php on line 322 alguien que por favor me ayude. Link to comment Share on other sites More sharing options...
henrycr Posted November 21, 2011 Author Share Posted November 21, 2011 ayuda amigo mi pagina va muy lenta y me dicen que esto me puede ayudar mucho. saludos henry Link to comment Share on other sites More sharing options...
henrycr Posted November 23, 2011 Author Share Posted November 23, 2011 Ayuda por favor con esto saludos henry Link to comment Share on other sites More sharing options...
Pedro Oliver Posted November 24, 2011 Share Posted November 24, 2011 http://lmgtfy.com/?q=Warning%3A+mysql_num_rows%28%29%3A+supplied+argument+is+not+a+valid+MySQL+result+resource+in Da mas información, que hay en la linea 322? Link to comment Share on other sites More sharing options...
henrycr Posted November 24, 2011 Author Share Posted November 24, 2011 Aca esta la parte final del codigo,gracias por tu ayuda. // -------------- unlink uploaded files associated with any customized product in the cart (similar to deletePictureToProduct() method ) $uploadedFiles = Db::getInstance()->ExecuteS(' SELECT cd.`value` FROM `'._DB_PREFIX_.'customized_data` cd INNER JOIN `'._DB_PREFIX_.'customization` c ON (cd.`id_customization`= c.`id_customization`) WHERE cd.`type`= 0 AND c.`id_cart`='.$idc); foreach ($uploadedFiles as $mustUnlink) { unlink(_PS_UPLOAD_DIR_.$mustUnlink['value'].'_small'); unlink(_PS_UPLOAD_DIR_.$mustUnlink['value']); } Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'customized_data` WHERE `id_customization` IN ( SELECT `id_customization` FROM `'._DB_PREFIX_.'customization` WHERE `id_cart`='.$idc.')'); Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'customization` WHERE `id_cart`='.$idc ); Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'message_readed` WHERE `id_message` IN ( SELECT `id_message` FROM `'._DB_PREFIX_.'message` WHERE `id_cart`='.$idc.')' ); Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'message` WHERE `id_cart`='.$idc ); Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'cart_discount` WHERE `id_cart` = '.$idc); Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'cart_product` WHERE `id_cart` = '.$idc); // ignore TABLES fianet_fraud and prestafraud_carts // ------- FINALLY (no multilingual aspect, so avoid calling parent -- just delete it from here) return Db::getInstance()->Execute('DELETE FROM `'._DB_PREFIX_.'cart` WHERE `id_cart` = '.$idc); } public function OrderExists() { return (bool)Db::getInstance()->getValue('SELECT `id_cart` FROM `'._DB_PREFIX_.'orders` WHERE `id_cart` = '.(int)$this->id); } } ?> Link to comment Share on other sites More sharing options...
henrycr Posted November 25, 2011 Author Share Posted November 25, 2011 No hay nadie que le haya pasado algo parecido con este modulo saludos henry Link to comment Share on other sites More sharing options...
shacker Posted November 27, 2011 Share Posted November 27, 2011 que version de presta tienes? Link to comment Share on other sites More sharing options...
henrycr Posted November 29, 2011 Author Share Posted November 29, 2011 Tengo la version PS 1.1.0.5 Link to comment Share on other sites More sharing options...
shacker Posted November 29, 2011 Share Posted November 29, 2011 este modulo solo funciona a partir de 1.2 Link to comment Share on other sites More sharing options...
henrycr Posted November 29, 2011 Author Share Posted November 29, 2011 Como se podria entonces por favor borrar conexiones y optimizar la base de datos en mi version de PS ? gracias henry Link to comment Share on other sites More sharing options...
shacker Posted November 29, 2011 Share Posted November 29, 2011 desinstala todos los modulos de estadisticas de tu tienda. excepto la de catalogo Link to comment Share on other sites More sharing options...
Recommended Posts