Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /homep

Réduire
X
 
  • Filtrer
  • Heure
  • Afficher
Tout effacer
nouveaux messages

  • Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /homep

    Bonjour
    j'ai beau chercher une explication sur internet mais je ne trouve pas
    pourquoi régulièrement quand je charge un composant, dans ce cas ci "Phoca Gallery" je vois ce genre de ligne
    "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /homepages/17/d333222074/htdocs/monsite/libraries/joomla/database/database/mysql.php on line 293, boolean given in /homepages/17/d333222074/htdocs/monsite/libraries/joomla/database/database/mysql.php on line 293"

    j'ai ouvert le fichier en question et ca correspond à ca
    Code PHP:
        public function getNumRows($cursor null)
        {
            return 
    mysql_num_rows($cursor $cursor $this->cursor);
        } 
    j'ai fait l'installation de la galerie en local et tout est parfait, mais plantage sur le site "test" en ligne
    désolée de vous déranger à chaque fois et merci à vous

  • #2
    Re : Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /

    en lisant certains post du forum je me suis dit peut etre faut-il activer le mode débogage
    et là .... horreur, malheur

    JDatabaseMySQL::query: 1146 - Table 'xxxxxxx.e6cu5_phocagallery' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg FROM `e6cu5_phocagallery` AS a LEFT JOIN `e6cu5_languages` AS l ON l.lang_code = a.language LEFT JOIN e6cu5_users AS uc ON uc.id=a.checked_out LEFT JOIN e6cu5_users AS uua ON uua.id=a.userid LEFT JOIN e6cu5_phocagallery_categories AS c ON c.id = a.catid LEFT JOIN e6cu5_users AS ua ON ua.id = c.owner_id LEFT JOIN e6cu5_phocagallery_img_votes_statistics AS v ON v.imgid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
    Call stack
    # Function Location
    1 JAdministrator->dispatch() JROOT/administrator/index.php:46
    2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153
    3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
    4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
    5 JController->execute() JROOT/administrator/components/com_phocagallery/phocagallery.php:39
    6 PhocaGalleryCpController->display() JROOT/libraries/joomla/application/component/controller.php:760
    7 JController->display() JROOT/administrator/components/com_phocagallery/controller.php:48
    8 PhocaGalleryCpViewPhocaGalleryImgs->display() JROOT/libraries/joomla/application/component/controller.php:721
    9 JView->get() JROOT/administrator/components/com_phocagallery/views/phocagalleryimgs/view.html.php:28
    10 JModelList->getItems() JROOT/libraries/joomla/application/component/view.php:386
    11 JModelList->getStart() JROOT/libraries/joomla/application/component/modellist.php:128
    12 JModelList->getTotal() JROOT/libraries/joomla/application/component/modellist.php:265
    13 JModel->_getListCount() JROOT/libraries/joomla/application/component/modellist.php:231
    14 JDatabaseMySQL->execute() JROOT/libraries/joomla/application/component/model.php:318
    15 JError::raiseError() JROOT/libraries/joomla/database/database/mysql.php:548
    16 JError::raise() JROOT/libraries/joomla/error/error.php:251
    Dernière édition par JCASF à 05/07/2012, 23h34

    Commentaire


    • #3
      Re : Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /

      je me réponds à moi meme
      pour ce qui est du warning machin c'est ici la solution : installer les fichiers de la base de données "à la main"

      Commentaire

      Annonce

      Réduire
      Aucune annonce pour le moment.

      Partenaire de l'association

      Réduire

      Hébergeur Web PlanetHoster
      Travaille ...
      X