cannot create category

[Tris3k]

I have the same problem. (not sure if is erroring on install but i have installed 7 times now) each time displays the same errors.

I also get the following on the images tab

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fhlinux130/s/shakeyfaces.co.uk/user/htdocs/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fhlinux130/s/shakeyfaces.co.uk/user/htdocs/libraries/joomla/database/database/mysql.php on line 344

Warning: Invalid argument supplied for foreach() in /home/fhlinux130/s/shakeyfaces.co.uk/user/htdocs/administrator/components/com_phocagallery/libraries/phocagallery/render/renderadmin.php on line 65

Thanks,
Tristan

[Tris3k]

Found a solution: use the files from the most uptodate phoca package and use the "com_phocagallery_ftp_install.zip" to install the mod.

Follow 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 (where Joomla! is running):

components/com_phocagallery
administrator/components/com_phocagallery
images/phocagallery
3. Copy all folders and files (except front and language folders and their 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 ( phocagallery_tmp/front ) into your server's folder:

components/com_phocagallery
5. Copy all files which are saved in language folder on your PC ( phocagallery_tmp/language ) 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 (these were copied by FTP), 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.

[StandardsDT]

I'm having a very similar problem. I installed using the FTP Instructions and now when I try to create a new category from the drop down or the configuration page I just get redirected to the Administrator Interface (index.php) for Joomla whenever I click on "New". Creating a Category is not possible at all. Any one know what is going on?

::Edit::

I think I may have found the culprit. The "New" button points to the same link in the address bar that points to categories. Why it redirects me to index.php for Joomla I have no idea.

administrator/index.php?option=com_phocagallery&view=phocagallerycs#

How can I fix this?!

[Jan]

Hi, try to check if all tables and all colums are stored in your database, you can compare it with install.bak file.

Jan

[StandardsDT]

Where can I find the database and install.bak. I looked in the backup folder under administrator but saw no file.

::Edit::

Nevermind I found it all. I compared the install.bak file to categories table and everything was fine.

I also just found out that the same issue applies to images.