Phocagallery et Ovh

**SimonG** · 17/06/2013, 16h41

Re : Phocagallery et Ovh

Bonjour,

as tu jeté un œil à la documentation de Phoca Gallery :

http://www.phoca.cz/documents/2-phoca-gallery-component/203-installation-problem-solving

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 Gallery is a large component, so problems can occur on some servers while installation. Mostly there are two main problems. Phoca Gallery tables were not created while installing Mostly you get the following system message "Error while Saving Phoca Gallery Categories" or this PHP error message: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource ... while using Phoca Gallery. Getting this system message or php error message is caused by not installed Phoca Gallery tables in the Joomla! database. Please enable debug mode in your Joomla! administration site and take a look at your database to see if the installation script created Phoca Gallery tables correctly. If not, you have to create them manually. The SQL queries, which install Phoca Gallery tables into your database, are stored in install.bak file. You will find this file in the root of Phoca Gallery 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 Gallery, 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 have to rename them, e.g.: #__phocagallery to TablePrefix_phocagallery TablePrefix is the prefix you selected while installing Joomla! CMS . Make sure that you delete #_ at the start of the line; you only need one _ . Do this for all queries. If you are upgrading Phoca Gallery, and you get problems with not created tables or columns, you need to open the install.bak file which you can find in root of the installation ZIP file and compare it with your database. E.g. with help of phpMyAdmin tool. Since Joomla! 3 you will find the SQL files in ZIP package in folder: install/sql/mysql/ In install.bak or install.utf8.sql file you can see which new tables and columns were added in previous versions. So if some table doesn't exists in your database and you can see the SQL query for this table in install.bak file or install.utf8.sql, just run this query so this table will be added into your database . You need to check the upgrade sql queries too . If you compare the table in your database with SQL query of the install.bak file or install.utf8.sql and you will recognize that some columns don't exists in your tables, you need to run the SQL upgrade queries . After copying and pasting the queries into phpMyAdmin you need to remove comments characters and you need to modify the prefixes. Upgrading the tables: Because the names of tables are prepared for system installation, so they contain '#__' instead of your table prefix, you have to rename them: #__phocagallery to TablePrefix_phocagallery #__phocagallery_categories to TablePrefix_phocagallery_categories, etc. TablePrefix is the prefix you selected while installing Joomla! CMS . Make sure that you delete #_ at the start of the line; you only need one _ . Upgrading the columns: If you have all tables in your database check the columns of your tables. E.g. in Phoca Gallery version 2.2.0 there are new colums: extlink1, extlink2 and these should be added into table: #__phocagallery. In case you are upgrading e.g. from 2.1.0 to 2.2.0 and you got some error message while automatically upgrading of Phoca Gallery tables should be stored in Joomla!. You should do the following steps : 1.Download the latest Phoca Gallery ZIP file and unzip it somewhere on your PC. E.g. create phocagallery_tmp folder on your PC and unzip the file here. 2. Create the following folders on your server : components/com_phocagallery administrator/components/com_phocagallery images/phocagallery 3. Copy all folders and files from phocagallery_tmp folder into your server's folder: administrator/components/com_phocagallery 4. Copy all files which are saved in front folder on your PC into your server's folder: components/com_phocagallery 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_phocagallery_ftp_install.zip file from Phoca Gallery 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_phocagallery_ftp_install.zip file from your disc and click on Upload File & Install. This file is very small. It doesn't contain Phoca Gallery 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 Gallery.

**iwama** · 17/06/2013, 17h05

Re : Phocagallery et Ovh

Envoyé par SimonG Voir le message

Bonjour,

as tu jeté un œil à la documentation de Phoca Gallery :
http://www.phoca.cz/documents/2-phoc...roblem-solving

Merci pour ta réponse.
J'avais regardé ce post mais mon anglais étant très rudimentaire, la procédure m'a fait peur quand j'ai traduit avec google translate.

Je vais lire ça tête reposée car je ne voudrais pas faire de bêtise...

**SimonG** · 17/06/2013, 17h08

Re : Phocagallery et Ovh

Envoyé par iwama Voir le message

Merci pour ta réponse.
J'avais regardé ce post mais mon anglais étant très rudimentaire, la procédure m'a fait peur quand j'ai traduit avec google translate.

Je vais lire ça tête reposée car je ne voudrais pas faire de bêtise...

Cette doc a été traduite en français ici

Magazine d’actu

http://kiwik.net/extensions/phoca/phoca-gallery/documentation/composant/item/7-résolution-des-problèmes-d-installation

**iwama** · 17/06/2013, 18h01

Re : Phocagallery et Ovh

Envoyé par SimonG Voir le message

Cette doc a été traduite en français ici

http://kiwik.net/extensions/phoca/ph...d-installation

Ah oui là c'est un peu plus clair. Un grand merci.
Je te redis si mon soucis est résolu.
++

**RobertG** · 17/06/2013, 19h53

Re : Phocagallery et Ovh

Je n'ai personnellement jamais eu le moindre souci de compatibilité de Phoca Gallery avec OVH en mutualisé.
Je suis curieux de savoir ce que tu as eu comme problème à l'installation.

**iwama** · 18/06/2013, 10h10

Re : Phocagallery et Ovh

Je viens d'appliquer la méthode : http://kiwik.net/extensions/phoca/ph...d-installation
Un grand merci à toi SimonG.
Pour RobertG : Les tables de phocagallery ne se sont pas créées. Apparemment c'est un soucis identifié, mais peut-être pas lié à OVH. Je mettais avancer sur cette affirmation à lecture de certains posts.
++
Anthony

**SimonG** · 18/06/2013, 10h21

Re : Phocagallery et Ovh

Je ne pense pas en effet que ce problème soit lié à ovh.
Tu peux passer ton post en [réglé]

Phocagallery et Ovh

[RÉGLÉ] Phocagallery et Ovh

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Commentaire

Annonce

Partenaire de l'association