Phoca Download - warning mysql_num_rows() expects parameter 1...

**SimonG** · 05/06/2013, 09h50

Re : Phoca Download - warning mysql_num_rows() expects parameter 1...

Bonjour,

Par la suite, 2 options s'offrent à moi: installer ou upgrader. J'ai lu un peu partout qu'il était préférable d'utiliser "upgrader". Une fois réalisé, lorsque je désire aller dans n'importe quelle section, par example "files" j'obtiens une erreur phpmyadmin "warning mysql_num_rows() expects parameter 1 in www/.../mysqli.php line 263"

S'il s'agit d'une première installation, il faut installer l'extension et non la mettre à jour.

**dcrette** · 05/06/2013, 10h03

Re : Phoca Download - warning mysql_num_rows() expects parameter 1...

J'ai tout d'abord installer l'extension puis rencontrer le problème...

J'ai donc désinstaller l'extension et réinstaller en choisissant l'option "upgrade" mais avec le même résultat...

Apparemment d'après le site web de phoca dans la section de résolution des problèmes, il s'agit d'un problème de requête sql:

Installation Problem Solving

http://www.phoca.cz/documents/17-phoca-download-component/231-installation-problem-solving68

This guide describes how to solve installation problems in Joomla! 1.5 or in Joomla! 2.5. If you use Joomla! 3 or newer version, use standard Joomla! extension manager to install or update the components. In case of problems with large components, see: How to install large components with help of FTP in Joomla! Phoca Download is a large component, so problems can occur on some servers while installation. Mostly there are two main problems. Phoca Download tables were not created while installing Mostly you get the following system message "Error while Saving Phoca Download Categories" or this PHP error message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ... while using Phoca Download. Getting this system message or php error message is caused by not installed Phoca Download tables in the Joomla!. Please enable debug mode in your Joomla! administration site and take a look at your database to see if the installation script created Phoca Download tables correctly. If not, you must create them manually. The SQL queries, which install Phoca Download tables into your database, are saved in install.bak file. You will find this file in the Phoca Download component ZIP package. Since Joomla! 3 you will find the SQL files in ZIP package in folder: install/sql/mysql/ If you are installing Phoca Download, just copy all SQL queries and run them in e.g. phpMyAdmin. But beware, because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you must rename them, e.g.: #__phocadownload to TablePrefix_phocadownload TablePrefix is the prefix you selected while installing Joomla! . Make sure that you delete #_ at the start of the line; you only need one _ . Do this for all queries. If you are updating Phoca Download, it means that some tables from previous installation of Phoca Download exist, so you must run SQL queries of tables which don't currently exist in the database. The automatic upgrade script knows that it should add only the new tables... but if you got an error while upgrading, or you choose to upgrade manually you will have to run the SQL query manually. You should use install.bak or install.utf8.sql file, but here there are SQL queries for all tables, so you must run only SQL queries for the new tables , not all tables, because if you add the existing tables then these existing tables will be overwritten . You will find the install.bak or install.utf8.sql file in the Phoca Download component ZIP package. Just copy the SQL queries of new tables and run them in e.g. phpMyAdmin. But be aware, because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you must rename them, e.g.: #__phocadownload to TablePrefix_phocadownload TablePrefix is the prefix you selected while installing Joomla! . Make sure that you delete #_ at the start of the line; you only need one _ If you have all tables in your database check the columns of your tables. E.g. in Phoca Download version 1.1.0 there is new colum: date and this should be added into table: #__phocadownload_sections. In case you are upgrading e.g. from 1.0.5 to 1.1.0 and you got some error message while automatically upgrading of Phoca Download tables, check the #_phocadownload_sections table and if date column is missed, then run the SQL query for 1.1.0 version: ALTER TABLE `#__phocadownload_sections` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `access`; Phoca Download is not installed and blank page is displayed If you get blank page while installing Phoca Download. It can be caused by not enough PHP Memory or CPU on your server. Installation procedure in Joomla! doesn't have enough time for unzipping Phoca Download ZIP file. If you are using Joomla! 1.6 or newest version, see this article: How to install large components with help of FTP in Joomla! The following guide is obsolete. In this case the best way how to install Phoca Download is uploading data via FTP. But it is not all you need to do because some information about Phoca Download should be stored in Joomla!. You should do the following steps : 1.Download the latest Phoca Download ZIP file and unzip it somewhere on your PC. E.g. create phocadownload_tmp folder on your PC and unzip the file here. 2. Create the following folders on your server : components/com_phocadownload administrator/components/com_phocadownload images/phocadownload 3. Copy all folders and files from phocadownload_tmp folder into your server's folder: administrator/components/com_phocadownload 4. Copy all files which are saved in front folder on your PC into your server's folder: components/com_phocadownload 5. Copy all files which are saved in languagefolder on your PC into your server's folders: language administrator/language Now all needed files should be saved on your server. 6. Download com_phocadownload_ftp_install.zip file from Phoca Download download site and install it in your Joomla! administration site: Go to Extensions » Install/Uninstall. Now you are in Extensions Manager. Click on: Upload Package File - select the com_phocadownload_ftp_install.zip file from your disc and click on Upload File &Install. This file is very small. It doesn't contain Phoca Download files , so there shouldn't be any problem with PHP Memory or CPU anymore. After installation you can select if you want Install or Upgrade Phoca Download.

Je vais essayé cette méthode ce soir et je publirai le résultat...

**dcrette** · 05/06/2013, 18h32

Re : Phoca Download - warning mysql_num_rows() expects parameter 1...

Alors dans l'archive zip phocaDownload et plus précisement dans le fichier "install.bak.sql" il faut remplacer les "#__" par le préfixe des tabes et continuer comme pour une extension normale!

A la fin cliquer sur installer plutôt que upgrade car pour la 2ème option je rencontrai toujours le même problème...

Voilà merci et bonne soirée

Phoca Download - warning mysql_num_rows() expects parameter 1...

[RÉGLÉ] Phoca Download - warning mysql_num_rows() expects parameter 1...

Commentaire

Commentaire

Commentaire

Annonce

Partenaire de l'association