- Postagens: 23
- Obrigados Recebidos: 0
Erro Php componente Phoca Gallery
- ha0015
-
Autor do Tópico
- Offline
- JCB! Iniciante
-
Menos
Mais
14 anos 3 meses atrás #51477
por ha0015
ha0015 created the topic: Erro Php componente Phoca Gallery
Boa Tarde,
Alguem sabe realmente o porque desse erro a minha platafoma é Windows Uol Host.
PHP Warning: Invalid argument supplied for foreach() in E:\home\ecsta\Web\components\com_phocagallery\models\categories.php on
Ja consultei alguns topicos, que diziam pra execuatr esse comando no PHPmyadmin.
DROP TABLE IF EXISTS `jos_phocagallery`;
CREATE TABLE `jos_phocagallery` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`videocode` text,
`vmproductid` int(11) NOT NULL default '0',
`imgorigsize` int(11) 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',
`params` text,
`metakey` text,
`metadesc` text,
`extlink1` text,
`extlink2` text,
`extid` varchar(255) NOT NULL default '',
`extl` varchar(255) NOT NULL default '',
`extm` varchar(255) NOT NULL default '',
`exts` varchar(255) NOT NULL default '',
`exto` varchar(255) NOT NULL default '',
`extw` varchar(255) NOT NULL default '',
`exth` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) TYPE=MyISAM CHARACTER SET `utf8`;
DROP TABLE IF EXISTS `jos_phocagallery_categories`;
CREATE TABLE `jos_phocagallery_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`owner_id` 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 '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`approved` 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',
`hits` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`accessuserid` text,
`uploaduserid` text,
`deleteuserid` text,
`userfolder` text,
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`params` text,
`metakey` text,
`metadesc` text,
`extid` varchar(255) NOT NULL default '',
`exta` varchar(255) NOT NULL default '',
`extu` varchar(255) NOT NULL default '',
`extauth` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;
DROP TABLE IF EXISTS `jos_phocagallery_votes`;
CREATE TABLE `jos_phocagallery_votes` (
`id` int(11) NOT NULL auto_increment,
`catid` 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,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_comments`;
CREATE TABLE `jos_phocagallery_comments` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` 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',
`params` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_votes_statistics`;
CREATE TABLE `jos_phocagallery_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`count` int(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- removed in 2.6.0
-- DROP TABLE IF EXISTS `jos_phocagallery_user_category`;
-- CREATE TABLE `jos_phocagallery_user_category` (
-- `id` int(11) NOT NULL auto_increment,
-- `catid` int(11) NOT NULL default 0,
-- `userid` int(11) NOT NULL default 0,
-- PRIMARY KEY (`id`),
-- KEY `catid` (`catid`,`userid`)
-- ) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- version 2.5
DROP TABLE IF EXISTS `jos_phocagallery_img_votes`;
CREATE TABLE `jos_phocagallery_img_votes` (
`id` int(11) NOT NULL auto_increment,
`imgid` 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,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_img_votes_statistics`;
CREATE TABLE `jos_phocagallery_img_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default 0,
`count` int(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- version 2.6.0
DROP TABLE IF EXISTS `jos_phocagallery_user`;
CREATE TABLE `jos_phocagallery_user` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default 0,
`avatar` varchar(40) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`approved` 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,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_img_comments`;
CREATE TABLE `jos_phocagallery_img_comments` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` 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',
`params` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `jos_phocagallery_categories` ADD `extauth` VARCHAR( 255 ) NOT NULL AFTER `exta`;
Mas não deu certo alguem pode ajudar ?
Agradeço pela atenção.
Haroldo Neves.
Alguem sabe realmente o porque desse erro a minha platafoma é Windows Uol Host.
PHP Warning: Invalid argument supplied for foreach() in E:\home\ecsta\Web\components\com_phocagallery\models\categories.php on
Ja consultei alguns topicos, que diziam pra execuatr esse comando no PHPmyadmin.
DROP TABLE IF EXISTS `jos_phocagallery`;
CREATE TABLE `jos_phocagallery` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`filename` varchar(250) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`videocode` text,
`vmproductid` int(11) NOT NULL default '0',
`imgorigsize` int(11) 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',
`params` text,
`metakey` text,
`metadesc` text,
`extlink1` text,
`extlink2` text,
`extid` varchar(255) NOT NULL default '',
`extl` varchar(255) NOT NULL default '',
`extm` varchar(255) NOT NULL default '',
`exts` varchar(255) NOT NULL default '',
`exto` varchar(255) NOT NULL default '',
`extw` varchar(255) NOT NULL default '',
`exth` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`)
) TYPE=MyISAM CHARACTER SET `utf8`;
DROP TABLE IF EXISTS `jos_phocagallery_categories`;
CREATE TABLE `jos_phocagallery_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default 0,
`owner_id` 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 '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`approved` 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',
`hits` int(11) NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`accessuserid` text,
`uploaduserid` text,
`deleteuserid` text,
`userfolder` text,
`latitude` varchar(20) NOT NULL default '',
`longitude` varchar(20) NOT NULL default '',
`zoom` int(3) NOT NULL default '0',
`geotitle` varchar(255) NOT NULL default '',
`params` text,
`metakey` text,
`metadesc` text,
`extid` varchar(255) NOT NULL default '',
`exta` varchar(255) NOT NULL default '',
`extu` varchar(255) NOT NULL default '',
`extauth` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) TYPE=MyISAM CHARACTER SET `utf8`;
DROP TABLE IF EXISTS `jos_phocagallery_votes`;
CREATE TABLE `jos_phocagallery_votes` (
`id` int(11) NOT NULL auto_increment,
`catid` 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,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_comments`;
CREATE TABLE `jos_phocagallery_comments` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` 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',
`params` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_votes_statistics`;
CREATE TABLE `jos_phocagallery_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 0,
`count` int(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- removed in 2.6.0
-- DROP TABLE IF EXISTS `jos_phocagallery_user_category`;
-- CREATE TABLE `jos_phocagallery_user_category` (
-- `id` int(11) NOT NULL auto_increment,
-- `catid` int(11) NOT NULL default 0,
-- `userid` int(11) NOT NULL default 0,
-- PRIMARY KEY (`id`),
-- KEY `catid` (`catid`,`userid`)
-- ) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- version 2.5
DROP TABLE IF EXISTS `jos_phocagallery_img_votes`;
CREATE TABLE `jos_phocagallery_img_votes` (
`id` int(11) NOT NULL auto_increment,
`imgid` 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,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_img_votes_statistics`;
CREATE TABLE `jos_phocagallery_img_votes_statistics` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default 0,
`count` int(11) NOT NULL default '0',
`average` float(8,6) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
-- version 2.6.0
DROP TABLE IF EXISTS `jos_phocagallery_user`;
CREATE TABLE `jos_phocagallery_user` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default 0,
`avatar` varchar(40) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`approved` 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,
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `jos_phocagallery_img_comments`;
CREATE TABLE `jos_phocagallery_img_comments` (
`id` int(11) NOT NULL auto_increment,
`imgid` int(11) NOT NULL default 0,
`userid` int(11) NOT NULL default 0,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL default '',
`comment` 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',
`params` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `jos_phocagallery_categories` ADD `extauth` VARCHAR( 255 ) NOT NULL AFTER `exta`;
Mas não deu certo alguem pode ajudar ?
Agradeço pela atenção.
Haroldo Neves.
Please Entrar ou Registrar to join the conversation.