missing mysql table og_gs_fontStyles

[PeterG]

Hi,
I noticed the mysql table of opengoo og_gs_fontStyles is missing (which will make my sql-backup fail). Can anyone help? I don't know what happened to this table and opengoo is working anyway but my sql-backup fails.

[Edit] Forgot to mention: I had 1.3beta and upgraded to 1.3.1 but the table is still missing.

Regards

      Peter

[ignacio]

It is strange that it disappeared. You can create it again with this SQL:

Code: [Select]

CREATE TABLE  `opengoo`.`og_gs_fontStyles` (
  `FontStyleId` int(11) NOT NULL,
  `BookId` int(11) NOT NULL,
  `FontId` int(11) NOT NULL,
  `FontSize` decimal(8,1) NOT NULL default '10.0',
  `FontBold` tinyint(1) NOT NULL default '0',
  `FontItalic` tinyint(1) NOT NULL default '0',
  `FontUnderline` tinyint(1) NOT NULL default '0',
  `FontColor` varchar(6) collate utf8_unicode_ci NOT NULL default '',
  PRIMARY KEY  USING BTREE (`FontStyleId`,`BookId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

[PeterG]

Hi,
a little late I know but thank your for your answer which solved the problem (after I manually dropped the table which was not shown but nevertheless mentioned as existing when I tried to create it again). I had not seen the answer as I hadn't got a notice about the answer (forgot to activate the notify option it seems...).

Regards
     Peter