CATEGORY MUST HAVE A TITLE

[axolotl]

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

[Benno]

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

[axolotl]

Hi Beno,

thank you, it works.

greets
michael

[Benno]

You're welcome!
Kind regards,
Benno

[sinbaddang]

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

[Benno]

@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--> https://www.phoca.cz/documents/17-phoca- ... em-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/frsre ... 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

[sinbaddang]

i've done it. That's really helpful. Thanks a lot

[Benno]

You're welcome!

Kind regards,
Benno

[denzel]

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

[Jan]

Hi, did you enable debug mode to test if there is no problem in database?