Piwigo.org

Stefan V.B. · 2016-03-14 12:43:00

Hello,

I have updated from Piwigo 2.7.0 to 2.8.0. The update has obviously destroyed the pwg_history table. It cannot be repaired anymore (neither automatically nor manually).

In Piwigo I get the following message at the end of the page: Warning: [mysql error 1146] Table 'zirbitzkogel_at.pwg_history' doesn't exist

Unfortunately I have made no MySQL database backup.

Is there a way to manually generate the pwg_history table? What is the SQL command for generating pwg_history with the correct fields and data types?

Thanks for your help,

Stefan

Piwigo version: 2.8.0
PHP version: 5.3.3-7+squeeze19
MySQL version: 5.1.73
Piwigo URL: http://zirbitzkogel.at/photos/

plg · 2016-03-14 12:50:24

Hi Stefan,

Code:

CREATE TABLE `pwg_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  `user_id` mediumint(8) unsigned NOT NULL default '0',
  `IP` varchar(15) NOT NULL default '',
  `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL,
  `category_id` smallint(5) default NULL,
  `tag_ids` varchar(50) default NULL,
  `image_id` mediumint(8) default NULL,
  `summarized` enum('true','false') default 'false',
  `image_type` enum('picture','high','other') default NULL,
  `format_id` int(11) unsigned default NULL,
  `auth_key_id` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `history_i1` (`summarized`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Stefan V.B. · 2016-03-14 13:38:53

Thank you plg. This solved my problem.

Best regards,

Stefan

Piwigo.org

Announcement

#1 2016-03-14 12:43:00

[resolved] pwg_history destroyed after updating to Piwigo 2.8.0

#2 2016-03-14 12:50:24

Re: [resolved] pwg_history destroyed after updating to Piwigo 2.8.0

Code:

#3 2016-03-14 13:38:53

Re: [resolved] pwg_history destroyed after updating to Piwigo 2.8.0

Board footer