У мня Джумла 1.5.9 Phoca Gallery 2.0 Устанавливается нормально (на локалхост) когда перехожу к созданию категорий то пишет вот это и категорию создать невозможно: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Zhome\localhost\www\Joomla\libraries\joomla\database\database\mysql.php on line 342 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Zhome\localhost\www\Joomla\libraries\joomla\database\database\mysql.php on line 342 Warning: Invalid argument supplied for foreach() in Zhome\localhost\www\Joomla\administrator\components\com_phocagallery\helpers\phocagallery.php on line 1248 переустанавливал 2 раза. Кто что подскажет??
у меня тоже самое ((( * Error Saving Phoca Gallery Categories Warning: Invalid argument supplied for foreach() in /var/home/gazoninua6112/data/www/gazon.in.ua/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1199 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/home/gazoninua6112/data/www/gazon.in.ua/libraries/joomla/database/database/mysql.php on line 344 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/home/gazoninua6112/data/www/gazon.in.ua/libraries/joomla/database/database/mysql.php on line 344
вот как бы ответ... кто может это же но на русском и вкратце ) 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!. Please take a look at your database (e.g. via phpMyAdmin) to see if the installation script created Phoca Gallery tables correctly. If not, you must create them manually. The SQL queries, which install Phoca Gallery tables into your database, are saved in install.bak file. You will find this file in the Phoca Gallery component ZIP package. If you are installing Phoca Gallery, just copy all SQL queries (except ALTER TABLE ... 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.: * #__phocagallery to TablePrefix_phocagallery TablePrefix is the prefix you selected while installing Joomla! 1.5 (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore}. Do this for all queries. If you are updating Phoca Gallery, then there is an issue with the MySQL database if upgrading from PhocaGallery 1.x.x. to PhocaGallery 2.x.x. PhocaGallery 1.x.x has 2 tables in the MySQL database and PhocaGallery 2.x.x has 6 tables. 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 4 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 file, but here there are SQL queries for all 6 tables, so you must run only SQL queries for the 4 new tables (tables which are not already created in your database), not all 6 tables, because if you add the first 2 tables (phoca gallery, phoca gallery categories) then these existing tables will be overwritten (and all data will be removed). You will find the install.sql (install.bak) file in the Phoca Gallery component ZIP package. Just copy the SQL queries of the 4 new tables 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.: * #__phocagallery to TablePrefix_phocagallery TablePrefix is the prefix you selected while installing Joomla! 1.5 (it is mostly 'jos_' and it should differentiate the Joomla! tables from other tables used in your database). Make sure that you delete #_ at the start of the line; you only need one _ {underscore} If you have all tables in your database (e.g. you are upgrading from 2.1.0 to 2.2.0) 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, check the #_phocagallery table and if extlink1 or extlink2 columns are missed, then run the SQL query for 2.2.0 version: ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ; ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ; If your are upgrading to 2.2.2 run also the SQL query for the 2.2.2 version: ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;
после установки появляется 2 кнопки инсталл и апдейт нужно нажать какую-то из них ))) если апдейт то сохранятся предыдущие фото фокагалери... если она была ... )))
