Phoca
Phoca Seal

CATEGORY MUST HAVE A TITLE

CATEGORY MUST HAVE A TITLE

Postby axolotl on 24 Feb 2011, 16:18

Hi,

I know there are a topic for this!

I have install phoca download and phoca gallery. I can not create a category on both. I get the failure "CATEGORY MUST HAVE A TITLE"
Now I have look in the database, there is no table entry for poca download and poca gallery, i don't no why. I have reinstall joomla and poca.. but the problem exist. Other moduls i can install without problems.
I know from other poca version there a table exist call jos_phocagallery or jos_phocagallery_categorie.

Can I create the table manuelly? So please send me the sql_string for import the tables.

I have install joomla 1.6
poca gallery 3.0.0 RC4
poca download 2.0.0 R2)

thanks
michael
Last edited by axolotl on 24 Feb 2011, 23:35, edited 1 time in total.
axolotl
Phoca Newbie
Phoca Newbie
 
Posts: 2
Joined: 24 Feb 2011, 15:45

Google Ads


Re: CATEGORY MUST HAVE A TITLE

Postby Benno on 24 Feb 2011, 19:54

Hi,
you will find all what you need in the install.bak.sql files of Phoca Gallery 3.0.0 RC4 and Phoca Download 2.0.0 RC2
Kind regards,
Benno
User avatar
Benno
Phoca Hero
Phoca Hero
 
Posts: 4864
Joined: 04 Dec 2008, 11:58
Location: Germany

Re: CATEGORY MUST HAVE A TITLE

Postby axolotl on 24 Feb 2011, 23:38

Hi Beno,

thank you, it works.

greets
michael
axolotl
Phoca Newbie
Phoca Newbie
 
Posts: 2
Joined: 24 Feb 2011, 15:45

Re: CATEGORY MUST HAVE A TITLE

Postby Benno on 25 Feb 2011, 10:33

You're welcome!
Kind regards,
Benno
User avatar
Benno
Phoca Hero
Phoca Hero
 
Posts: 4864
Joined: 04 Dec 2008, 11:58
Location: Germany

Re: CATEGORY MUST HAVE A TITLE

Postby sinbaddang on 26 Jun 2011, 03:46

Please post a detailed step-by-step solution, i encounter the same problem without knowing how to solve. I am new to joomla and phocadownload
sinbaddang
Phoca Newbie
Phoca Newbie
 
Posts: 6
Joined: 22 Jun 2011, 16:45

Re: CATEGORY MUST HAVE A TITLE

Postby Benno on 26 Jun 2011, 13:54

@sinbaddang
You did not mention which version of Phoca Download you use.
If you use Phoca Download for joomla v1.5 see this guide: Database--> http://www.phoca.cz/documents/17-phoca-download-component/231-installation-problem-solving

If you use Phoca Download for joomla v1.6:
1. Check with help of phpMyAdmin. You should find following tables in your Database:
jos_phocadownload_
jos_phocadownload_categories
jos_phocadownload_file_votes
jos_phocadownload_file_votes_statistics
jos_phocadownload_licenses
jos_phocadownload_user_stat

2. If tables are missing you can create them manually:
>>>>Before any changes, make a compete database backup!!<<<<
Unzip the Phoca Downlaod package local on your pc. http://joomlacode.org/gf/download/frsrelease/15050/65632/com_phocadownload_v2.0.0.zip
You will find the file install.bak.sql
This file contains all sql commands to create database tables manually:
DROP TABLE IF EXISTS `jos_phocadownload_categories`;
CREATE TABLE `jos_phocadownload_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`section` int(11) NOT NULL default 0,
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`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',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`uploaduserid` text,
`accessuserid` text,
`deleteuserid` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`count` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text,
`metakey` text,
`metadesc` text,
`metadata` text,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) DEFAULT CHARSET=utf8;

-- DROP TABLE IF EXISTS `jos_phocadownload_sections`;
-- CREATE TABLE `jos_phocadownload_sections` (
-- `id` int(11) NOT NULL auto_increment,
-- `title` varchar(255) NOT NULL default '',
-- `name` varchar(255) NOT NULL default '',
-- `alias` varchar(255) NOT NULL default '',
-- `image` text,
-- `scope` varchar(50) NOT NULL default '',
-- `image_position` varchar(30) NOT NULL default '',
-- `description` text,
-- `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',
-- `access` tinyint(3) unsigned NOT NULL default '0',
-- `date` datetime NOT NULL default '0000-00-00 00:00:00',
-- `count` int(11) NOT NULL default '0',
-- `params` text,
-- `metakey` text,
-- `metadesc` text,
-- PRIMARY KEY (`id`),
-- KEY `idx_scope` (`scope`)
-- ) TYPE=MyISAM CHARACTER SET `utf8`;

DROP TABLE IF EXISTS `jos_phocadownload`;
CREATE TABLE `jos_phocadownload` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sectionid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`owner_id` int(11) NOT NULL default 0,
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`filename_play` varchar(250) NOT NULL default '',
`filename_preview` varchar(250) NOT NULL default '',
`filesize` int(11) NOT NULL default 0,
`author` varchar(255) NOT NULL default '',
`author_email` varchar(255) NOT NULL default '',
`author_url` varchar(255) NOT NULL default '',
`license` varchar(255) NOT NULL default '',
`license_url` varchar(255) NOT NULL default '',
`image_filename` varchar(255) NOT NULL default '',
`image_filename_spec1` varchar(255) NOT NULL default '',
`image_filename_spec2` varchar(255) NOT NULL default '',
`image_download` varchar(255) NOT NULL default '',
`link_external` varchar(255) NOT NULL default '',
`mirror1link` varchar(255) NOT NULL default '',
`mirror1title` varchar(255) NOT NULL default '',
`mirror1target` varchar(10) NOT NULL default '',
`mirror2link` varchar(255) NOT NULL default '',
`mirror2title` varchar(255) NOT NULL default '',
`mirror2target` varchar(10) NOT NULL default '',
`description` text,
`userid` int(11) NOT NULL Default '0',
`version` varchar(255) NOT NULL default '',
`directlink` tinyint(1) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`textonly` tinyint(1) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`confirm_license` int(11) NOT NULL default '0',
`unaccessible_file` int(11) NOT NULL default '0',
`params` text,
`metakey` text,
`metadesc` text,
`metadata` text,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) DEFAULT CHARSET=utf8;

-- DROP TABLE IF EXISTS `jos_phocadownload_settings`;
-- CREATE TABLE `jos_phocadownload_settings` (
-- `id` int(11) unsigned NOT NULL auto_increment,
-- `title` varchar(250) NOT NULL default '',
-- `value` text,
-- `values` text,
-- `type` varchar(50) NOT NULL default '',
-- PRIMARY KEY (`id`)
-- ) TYPE=MyISAM CHARACTER SET `utf8`;

-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'download_folder', 'phocadownload','', 'text');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'allowed_file_types', '{hqx=application/mac-binhex40}
-- {cpt=application/mac-compactpro}
-- {csv=text/x-comma-separated-values}
-- {bin=application/macbinary}
-- {dms=application/octet-stream}
-- {lha=application/octet-stream}
-- {lzh=application/octet-stream}
-- {exe=application/octet-stream}
-- {class=application/octet-stream}
-- {psd=application/x-photoshop}
-- {so=application/octet-stream}
-- {sea=application/octet-stream}
-- {dll=application/octet-stream}
-- {oda=application/oda}
-- {pdf=application/pdf}
-- {ai=application/postscript}
-- {eps=application/postscript}
-- {ps=application/postscript}
-- {smi=application/smil}
-- {smil=application/smil}
-- {mif=application/vnd.mif}
-- {xls=application/vnd.ms-excel{),
-- {ppt=application/powerpoint}
-- {wbxml=application/wbxml}
-- {wmlc=application/wmlc}
-- {dcr=application/x-director}
-- {dir=application/x-director}
-- {dxr=application/x-director}
-- {dvi=application/x-dvi}
-- {gtar=application/x-gtar}
-- {gz=application/x-gzip}
-- {php=application/x-httpd-php}
-- {php4=application/x-httpd-php}
-- {php3=application/x-httpd-php}
-- {phtml=application/x-httpd-php}
-- {phps=application/x-httpd-php-source}
-- {js=application/x-javascript}
-- {swf=application/x-shockwave-flash}
-- {sit=application/x-stuffit}
-- {tar=application/x-tar}
-- {tgz=application/x-tar}
-- {xhtml=application/xhtml+xml}
-- {xht=application/xhtml+xml}
-- {zip=application/x-zip}
-- {mid=audio/midi}
-- {midi=audio/midi}
-- {mpga=audio/mpeg}
-- {mp2=audio/mpeg}
-- {mp3=audio/mpeg}
-- {aif=audio/x-aiff}
-- {aiff=audio/x-aiff}
-- {aifc=audio/x-aiff}
-- {ram=audio/x-pn-realaudio}
-- {rm=audio/x-pn-realaudio}
-- {rpm=audio/x-pn-realaudio-plugin}
-- {ra=audio/x-realaudio}
-- {rv=video/vnd.rn-realvideo}
-- {wav=audio/x-wav}
-- {bmp=image/bmp}
-- {gif=image/gif}
-- {jpeg=image/jpeg}
-- {jpg=image/jpeg}
-- {jpe=image/jpeg}
-- {png=image/png}
-- {tiff=image/tiff}
-- {tif=image/tiff}
-- {css=text/css}
-- {html=text/html}
-- {htm=text/html}
-- {shtml=text/html}
-- {txt=text/plain}
-- {text=text/plain}
-- {log=text/plain}
-- {rtx=text/richtext}
-- {rtf=text/rtf}
-- {xml=text/xml}
-- {xsl=text/xml}
-- {mpeg=video/mpeg}
-- {mpg=video/mpeg}
-- {mpe=video/mpeg}
-- {qt=video/quicktime}
-- {mov=video/quicktime}
-- {avi=video/x-msvideo}
-- {flv=video/x-flv}
-- {movie=video/x-sgi-movie}
-- {doc=application/msword}
-- {xl=application/excel}
-- {eml=message/rfc822}', '', 'textarea');
--
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'disallowed_file_types', '','', 'textarea');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'upload_maxsize', '3145728','', 'text');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'enable_flash', 1,'{0=No}{1=Yes}', 'select');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'absolute_path', '','', 'text');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'description', '','', 'textareaeditor');
-- INSERT INTO `jos_phocadownload_settings` VALUES (null, 'enable_user_statistics', 1,'{0=No}{1=Yes}', 'select');




-- Remove "--" by SQL queries which you want to run in your database (don't remove it by comments)
-- UPDATE ONLY

-- version 1.0.5
-- ALTER TABLE `jos_phocadownload` ADD `directlink` tinyint(1) NOT NULL default '0' AFTER `version`;

-- version 1.0.6
DROP TABLE IF EXISTS `jos_phocadownload_user_stat`;
CREATE TABLE `jos_phocadownload_user_stat` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL default '0',
`userid` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;


-- version 1.1.0
DROP TABLE IF EXISTS `jos_phocadownload_licenses`;
CREATE TABLE `jos_phocadownload_licenses` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`description` text,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;


-- since 2.0.0 RC2
DROP TABLE IF EXISTS `jos_phocadownload_file_votes`;
CREATE TABLE `jos_phocadownload_file_votes` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL Default 0,
`userid` int(11) NOT NULL Default 0,
`date` datetime NOT NULL Default '0000-00-00 00:00:00',
`rating` tinyint(1) NOT NULL Default '0',
`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',
`params` text,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

-- since 2.0.0 RC2
DROP TABLE IF EXISTS `jos_phocadownload_file_votes_statistics`;
CREATE TABLE `jos_phocadownload_file_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`fileid` int(11) NOT NULL Default 0,
`count` int(11) NOT NULL Default '0',
`average` float(8,6) NOT NULL Default '0',
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;



-- 2.0.0 UPDATE ONLY
-- ALTER TABLE `jos_phocadownload` ADD `language` char(7) NOT NULL Default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload_categories` ADD `language` char(7) NOT NULL Default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload_licenses` ADD `language` char(7) NOT NULL Default '' AFTER `ordering` ;
-- ALTER TABLE `jos_phocadownload_user_stat` ADD `language` char(7) NOT NULL Default '' AFTER `ordering` ;
-- ALTER TABLE `jos_phocadownload` ADD `metadata` text AFTER `params` ;
-- ALTER TABLE `jos_phocadownload_categories` ADD `metadata` text AFTER `params` ;
-- ALTER TABLE `jos_phocadownload_categories` ADD `hits` int(11) NOT NULL default '0' AFTER `params` ;

-- 2.0.0 RC2 UPDATE ONLY

-- ALTER TABLE `jos_phocadownload` ADD `mirror1link` varchar(255) NOT NULL default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload` ADD `mirror1title` varchar(255) NOT NULL default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload` ADD `mirror1target` varchar(10) NOT NULL default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload` ADD `mirror2link` varchar(255) NOT NULL default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload` ADD `mirror2title` varchar(255) NOT NULL default '' AFTER `params` ;
-- ALTER TABLE `jos_phocadownload` ADD `mirror2target` varchar(10) NOT NULL default '' AFTER `params` ;

-- 2.0.0 STABLE UPDATE ONLY
-- ALTER TABLE `jos_phocadownload` ADD `userid` int(11) NOT NULL Default '0' AFTER `description` ;



For example if the table jos_phocadownload_categories is missing, you need to copy and paste this commands in the phpMyAdmin "Run SQL query/queries on database" window and press the "Go" button:
CREATE TABLE `jos_phocadownload_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`section` int(11) NOT NULL default 0,
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` varchar(255) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`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',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`uploaduserid` text,
`accessuserid` text,
`deleteuserid` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`count` int(11) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`params` text,
`metakey` text,
`metadesc` text,
`metadata` text,
`language` char(7) NOT NULL Default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) DEFAULT CHARSET=utf8;


Hope this helps,
Kind regards,
Benno
User avatar
Benno
Phoca Hero
Phoca Hero
 
Posts: 4864
Joined: 04 Dec 2008, 11:58
Location: Germany

Re: CATEGORY MUST HAVE A TITLE

Postby sinbaddang on 26 Jun 2011, 15:20

i've done it. That's really helpful. Thanks a lot
sinbaddang
Phoca Newbie
Phoca Newbie
 
Posts: 6
Joined: 22 Jun 2011, 16:45

Re: CATEGORY MUST HAVE A TITLE

Postby Benno on 27 Jun 2011, 12:00

You're welcome!

Kind regards,
Benno
User avatar
Benno
Phoca Hero
Phoca Hero
 
Posts: 4864
Joined: 04 Dec 2008, 11:58
Location: Germany

Re: CATEGORY MUST HAVE A TITLE

Postby denzel on 29 Jun 2011, 01:54

Hi all!
I have the same exact problem. When I try to create a new category I get the message "Save failed with the following error: Category must have title".
My problem is not with phoca-download but with phoca-gallery, and I think that this solution is not for the "gallery" component, but for the download "component". How can i solve?

I use:
Joomla 1.6.3
Phoca Gallery 3.0.0

Thank you in advance
Andrea
denzel
Phoca Newbie
Phoca Newbie
 
Posts: 2
Joined: 29 Jun 2011, 01:42

Re: CATEGORY MUST HAVE A TITLE

Postby Jan on 29 Jun 2011, 14:55

Hi, did you enable debug mode to test if there is no problem in database?
If you find some Phoca extensions useful, please vote for them on: extensions.joomla.org
User avatar
Jan
Phoca Hero
Phoca Hero
 
Posts: 34640
Joined: 10 Nov 2007, 18:23
Location: Czech Republic

Next

Return to Phoca Download

Who is online

Users browsing this forum: No registered users and 0 guests