database missing _updates table - Joomla! Forum - community, help and support


how resolve this?

i don't know if installing new or updating joomla
so can create table

code: select all

create table if not exists `#__updates` (
  `update_id` int(11) not null auto_increment,
  `update_site_id` int(11) default 0,
  `extension_id` int(11) default 0,
  `name` varchar(100) default '',
  `description` text not null,
  `element` varchar(100) default '',
  `type` varchar(20) default '',
  `folder` varchar(20) default '',
  `client_id` tinyint(3) default 0,
  `version` varchar(32) default '',
  `data` text not null,
  `detailsurl` text not null,
  `infourl` text not null,
  `extra_query` varchar(1000) default '',
  primary key (`update_id`)
) engine=innodb default charset=utf8 comment='available updates';


you'll find tables definition in installation/sql/mysql/joomla.sql





Comments

Popular posts from this blog

Joomla 3.3 Installation Error message - Joomla! Forum - community, help and support

Multilanguage infinite redirect loop error. - Joomla! Forum - community, help and support

trim media limit reached