Does not creat the Category

Phoca Gallery - image gallery extension
iabichino
Phoca Member
Phoca Member
Posts: 21
Joined: 18 Mar 2011, 09:27
Location: Firenze - Tuscany - Italy
Contact:

Does not creat the Category

Post by iabichino »

Hi all, I installed phoca gallery component: com_phocagallery_v3.2.0.zip
and now I am trying to creat the first category for the title but nonetheless I write the category name it keeps saying:
"Save failed with the following error: Category must have title"

Can anybody tell me what am I doing wrong or it is just a mistake or bug of the latest version released?
Thanks to all!
Antonio

p.s. Forgot to mention I am using Joomla 2.5.4
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9974
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Does not creat the Category

Post by Benno »

Hi,
try to install Phoca Gallery once more.
Try to check your database tables. (Normally this error means, not all database tables were created during installation process).
Try to search this forum: (Category must have title)

Kind regards,
Benno
iabichino
Phoca Member
Phoca Member
Posts: 21
Joined: 18 Mar 2011, 09:27
Location: Firenze - Tuscany - Italy
Contact:

Re: Does not creat the Category

Post by iabichino »

I searched in the forum: (Category must have title), the only two results I get is our 2 previous posts.

I re-installed phoca gallery component and still the same problem moreover, if I click on facebook tab i get the following error:

Table 'mediter3_dbmdw.sgj_phocagallery_fb_users' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `sgj_phocagallery_fb_users` AS a LEFT JOIN `sgj_languages` AS l ON l.lang_code = a.language LEFT JOIN sgj_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc Table 'mediter3_dbmdw.sgj_phocagallery_fb_users' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `sgj_phocagallery_fb_users` AS a LEFT JOIN `sgj_languages` AS l ON l.lang_code = a.language LEFT JOIN sgj_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc LIMIT 0, 20 Table 'mediter3_dbmdw.sgj_phocagallery_fb_users' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `sgj_phocagallery_fb_users` AS a LEFT JOIN `sgj_languages` AS l ON l.lang_code = a.language LEFT JOIN sgj_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.name asc
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9974
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Does not creat the Category

Post by Benno »

Hi,
check your Phoca Gallery database tables (e.g. with help of phpMyadmin)
You will find all Phoca Gallery necessary tables and columns in the file install.bak of the Phoca Gallery ZIP package.

To fix the facebook problem:

1. make a complete backup of your database.
2. If 'mediter3_dbmdw.sgj' is your table prefix, run this SQL query:

Code: Select all

CREATE TABLE `mediter3_dbmdw.sgj_phocagallery_fb_users` (
  `id` int(11) NOT NULL auto_increment,
  `appid` varchar(255) NOT NULL default '',
  `appsid` varchar(255) NOT NULL default '',
  `uid` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `secret` varchar(255) NOT NULL default '',
  `base_domain` varchar(255) NOT NULL default '',
  `expires` varchar(100) NOT NULL default '',
  `session_key` text,
  `access_token` text,
  `sig` text,
  `fanpageid` varchar(255) NOT NULL default '',
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `comments` text,
  `params` text,
  `language` char(7) NOT NULL default '',
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8;
Kind regards,
Benno
Post Reply