Phoca Galary. Создание категорий.

Тема в разделе "Phoca Gallery", создана пользователем DronXX, 21.02.2009.

  1. Offline

    DronXX Недавно здесь

    Регистрация:
    21.02.2009
    Сообщения:
    1
    Симпатии:
    0
    Подскажите, возможно ли в Phoca Gallery настроить создание категорий во фронтэнде?
     
  2.  
  3. Offline

    explorerkiev Недавно здесь

    Регистрация:
    18.03.2009
    Сообщения:
    4
    Симпатии:
    0
    Пол:
    Мужской
    У мня Джумла 1.5.9
    Phoca Gallery 2.0
    Устанавливается нормально (на локалхост)
    когда перехожу к созданию категорий то пишет вот это и категорию создать невозможно:
    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in Z:\home\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 Z:\home\localhost\www\Joomla\libraries\joomla\database\database\mysql.php on line 342

    Warning: Invalid argument supplied for foreach() in Z:\home\localhost\www\Joomla\administrator\components\com_phocagallery\helpers\phocagallery.php on line 1248

    переустанавливал 2 раза.
    Кто что подскажет??
     
  4. Offline

    bioloid Недавно здесь

    Регистрация:
    07.04.2009
    Сообщения:
    4
    Симпатии:
    0
    Пол:
    Мужской
    А можно ли разрешить создавать категории пользователями ниже админа?
     
  5. Offline

    azimut Недавно здесь

    Регистрация:
    11.06.2009
    Сообщения:
    41
    Симпатии:
    0
    Пол:
    Мужской
    "explorerkiev"
    во точно такаяже фикня и хз чо делать
    на локалхосте все стоит "денвер" MySQL5
     
  6. varakuta
    Offline

    varakuta Недавно здесь

    Регистрация:
    21.05.2009
    Сообщения:
    271
    Симпатии:
    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
     
  7. varakuta
    Offline

    varakuta Недавно здесь

    Регистрация:
    21.05.2009
    Сообщения:
    271
    Симпатии:
    2
    Пол:
    Мужской
    вот как бы ответ... кто может это же но на русском и вкратце )

    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` ;
     
  8. varakuta
    Offline

    varakuta Недавно здесь

    Регистрация:
    21.05.2009
    Сообщения:
    271
    Симпатии:
    2
    Пол:
    Мужской
    после установки появляется 2 кнопки инсталл и апдейт

    нужно нажать какую-то из них )))

    если апдейт то сохранятся предыдущие фото фокагалери... если она была

    ... )))
     

Поделиться этой страницей

Загрузка...