Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Alle installationsbezogenen Probleme hier posten. Dies sollte die erste Anlaufstelle bei Problemen sein.
Post Reply
kiwix
Posts: 65
Joined: Fri 25. Feb 2005, 09:40

Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Post by kiwix »

Hallo zusammen,

nach langer Zeit habe ich heute eine alte 1.2.8'er Installation auf den aktuellen Stand gebracht,
aber bei den Modulen gab es ein paar Probleme und es hat sich herausgestellt, dass in den
Update Scripten irgendwo das anlegen einiger Tabellen fehlt.

Da ich nicht genau weis, in welcher Version die entsprechenden Module aufgenommen wurden,
habe ich hier mal das Script angehängt, was ich mir aus den Sourcen zusammen kopiert habe:

Code: Select all

-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpwcms_ads_campaign`
--

CREATE TABLE `phpwcms_ads_campaign` (
  `adcampaign_id` int(11) NOT NULL auto_increment,
  `adcampaign_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `adcampaign_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `adcampaign_status` int(1) NOT NULL default '0',
  `adcampaign_title` varchar(255) NOT NULL default '',
  `adcampaign_comment` text NOT NULL,
  `adcampaign_datestart` datetime NOT NULL default '0000-00-00 00:00:00',
  `adcampaign_dateend` datetime NOT NULL default '0000-00-00 00:00:00',
  `adcampaign_maxview` int(11) NOT NULL default '0',
  `adcampaign_maxclick` int(11) NOT NULL default '0',
  `adcampaign_maxviewuser` int(11) NOT NULL default '0',
  `adcampaign_curview` int(11) NOT NULL default '0',
  `adcampaign_curclick` int(11) NOT NULL default '0',
  `adcampaign_curviewuser` int(11) NOT NULL default '0',
  `adcampaign_type` int(11) NOT NULL default '0',
  `adcampaign_place` int(11) NOT NULL default '0',
  `adcampaign_data` mediumtext NOT NULL,
  PRIMARY KEY  (`adcampaign_id`),
  KEY `adcampaign_status` (`adcampaign_status`,`adcampaign_datestart`,`adcampaign_dateend`,`adcampaign_type`,`adcampaign_place`),
  KEY `adcampaign_maxview` (`adcampaign_maxview`,`adcampaign_maxclick`,`adcampaign_maxviewuser`),
  KEY `adcampaign_curview` (`adcampaign_curview`,`adcampaign_curclick`,`adcampaign_curviewuser`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_ads_formats`
--

CREATE TABLE `phpwcms_ads_formats` (
  `adformat_id` int(11) NOT NULL auto_increment,
  `adformat_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `adformat_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `adformat_status` int(1) NOT NULL default '0',
  `adformat_title` varchar(25) NOT NULL default '',
  `adformat_width` int(5) NOT NULL default '0',
  `adformat_height` int(5) NOT NULL default '0',
  `adformat_comment` text NOT NULL,
  PRIMARY KEY  (`adformat_id`),
  KEY `adformat_status` (`adformat_status`)
) TYPE=MyISAM ;


INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(1, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Leaderboard', 728, 90, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(2, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Banner', 468, 60, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(3, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Small Square', 200, 200, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(4, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Square', 250, 250, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(5, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Medium Rectangle', 300, 250, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(6, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Large Rectangle', 336, 280, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(7, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Skyscraper', 120, 600, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(8, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Wide Skyscraper', 160, 600, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(10, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Half Banner', 234, 60, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(11, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Square Button', 125, 125, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(12, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Small Rectangle', 180, 150, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(13, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Vertical Banner', 120, 240, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(14, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Mini Square', 120, 120, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(15, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Medium Scyscraper', 120, 450, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(16, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Micro Bar', 88, 31, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(17, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Vertical Rectangle', 240, 400, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(18, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Vertical Button', 120, 90, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(19, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Half Mini Square', 120, 60, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(20, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Half Page Ad', 300, 600, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(21, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Universal Flash Layer', 400, 400, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(22, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'PopUp', 250, 300, '');
INSERT INTO `phpwcms_ads_formats` (`adformat_id`, `adformat_created`, `adformat_changed`, `adformat_status`, `adformat_title`, `adformat_width`, `adformat_height`, `adformat_comment`) VALUES(23, '2007-03-19 22:30:42', '2007-03-19 22:30:42', 1, 'Target Button', 120, 150, '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_ads_place`
--

CREATE TABLE `phpwcms_ads_place` (
  `adplace_id` int(11) NOT NULL auto_increment,
  `adplace_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `adplace_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `adplace_status` int(1) NOT NULL default '0',
  `adplace_title` varchar(255) NOT NULL default '',
  `adplace_format` int(11) NOT NULL default '0',
  `adplace_width` int(11) NOT NULL default '0',
  `adplace_height` int(11) NOT NULL default '0',
  `adplace_prefix` varchar(255) NOT NULL default '',
  `adplace_suffix` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`adplace_id`),
  KEY `adplace_status` (`adplace_status`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_ads_tracking`
--

CREATE TABLE `phpwcms_ads_tracking` (
  `adtracking_id` int(11) NOT NULL auto_increment,
  `adtracking_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `adtracking_campaignid` int(11) NOT NULL default '0',
  `adtracking_ip` varchar(30) NOT NULL default '',
  `adtracking_cookieid` varchar(50) NOT NULL default '',
  `adtracking_countclick` int(11) NOT NULL default '0',
  `adtracking_countview` int(11) NOT NULL default '0',
  `adtracking_useragent` varchar(255) NOT NULL default '',
  `adtracking_ref` text NOT NULL,
  `adtracking_catid` int(11) NOT NULL default '0',
  `adtracking_articleid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`adtracking_id`),
  KEY `adtracking_campaignid` (`adtracking_campaignid`,`adtracking_ip`,`adtracking_countclick`,`adtracking_countview`),
  KEY `adtracking_cookieid` (`adtracking_cookieid`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_glossary`
--

CREATE TABLE `phpwcms_glossary` (
  `glossary_id` int(11) NOT NULL auto_increment,
  `glossary_created` datetime NOT NULL default '0000-00-00 00:00:00',
  `glossary_changed` datetime NOT NULL default '0000-00-00 00:00:00',
  `glossary_title` text NOT NULL,
  `glossary_tag` varchar(255) NOT NULL default '',
  `glossary_keyword` varchar(255) NOT NULL default '',
  `glossary_text` mediumtext NOT NULL,
  `glossary_highlight` int(1) NOT NULL default '0',
  `glossary_object` mediumtext NOT NULL,
  `glossary_status` int(1) NOT NULL default '0',
  PRIMARY KEY  (`glossary_id`),
  KEY `glossary_status` (`glossary_status`),
  KEY `glossary_tag` (`glossary_tag`),
  KEY `glossary_keyword` (`glossary_keyword`),
  KEY `glossary_highlight` (`glossary_highlight`)
) TYPE=MyISAM ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_language`
--

CREATE TABLE `phpwcms_language` (
  `lang_id` varchar(255) NOT NULL default '',
  `lang_html` int(1) NOT NULL default '1',
  `lang_type` int(1) NOT NULL default '0',
  `EN` text NOT NULL,
  `DE` text NOT NULL,
  `BG` text NOT NULL,
  `CA` text NOT NULL,
  `CZ` text NOT NULL,
  `DA` text NOT NULL,
  `EE` text NOT NULL,
  `ES` text NOT NULL,
  `FI` text NOT NULL,
  `FR` text NOT NULL,
  `GR` text NOT NULL,
  `HU` text NOT NULL,
  `IT` text NOT NULL,
  `LT` text NOT NULL,
  `NL` text NOT NULL,
  `NO` text NOT NULL,
  `PL` text NOT NULL,
  `PT` text NOT NULL,
  `RO` text NOT NULL,
  `SE` text NOT NULL,
  `SK` text NOT NULL,
  `VN` text NOT NULL,
  PRIMARY KEY  (`lang_id`)
) TYPE=MyISAM;
Außerdem scheinen die folgenden Tabellen nicht mehr benötigt zu werden:

phpwcms_blog
phpwcms_forum

Kann ich die "dropen"?

Gruß
KiWiX
kiwix
Posts: 65
Joined: Fri 25. Feb 2005, 09:40

Re: Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Post by kiwix »

Oops,

ich sehe gerade, dass ich noch folgende Fehlermeldung

Code: Select all

 	{STATUS_MESSAGE}
Fatal error: _setConfig failed in /var/www/phpwcms_r213/include/inc_lib/dbcon.inc.php on line 513
bekommen, wenn ich im Shop/Produkte - Einstellungen anklicke.

Fehlt noch was?

update

es scheint an der Tabelle phpwcms_sysvalue zu liegen, das folgende Script hat's (suboptimal) erledigt, besser wäre bestimmt ein ALTER TABLE:

Code: Select all

drop table `phpwcms_sysvalue`;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `phpwcms_sysvalue`
--

CREATE TABLE `phpwcms_sysvalue` (
  `sysvalue_key` varchar(255) NOT NULL default '',
  `sysvalue_group` varchar(255) NOT NULL default '',
  `sysvalue_lastchange` int(11) NOT NULL default '0',
  `sysvalue_status` int(1) NOT NULL default '0',
  `sysvalue_vartype` varchar(100) NOT NULL default '',
  `sysvalue_value` text NOT NULL,
  PRIMARY KEY  (`sysvalue_key`),
  KEY `sysvalue_group` (`sysvalue_group`),
  KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM ;
Gruß
KiWiX
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Post by juergen »

Hallo Kiwix,

aber es fehlen doch die gesamten Änderungen in den Feldern. Wenn du das so machst, rate ich mal, dass das System keine Artikel mehr abspeichern kann.
Was du willst kannst du dir doch einfach aus den sql-updates jeder Version zusammenmergen, wenn du schon nicht das (allemal bequemere) Update Skript nicht nutzen möchstest.

Nur .. mal ... so
kiwix
Posts: 65
Joined: Fri 25. Feb 2005, 09:40

Re: Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Post by kiwix »

Hallo, DF6IH,

ich habe doch das Update Script verwendet. Die einzelnen Update SQL Scripts ab der 127'er DB Version und die einzelnen Optionen aus dem update.php, aber die o.a. Tabellen und deren Einträge habe danach gefehlt. Das mit drop und create table habe ich nur gemacht, da bei meiner DB die Tabelle eh' leer war.

Mir ging's eher darum, dass wohl einige Tabellen beim Update nicht erstellt werden, aber da mein Server gerade abgeraucht ist :-( und ich den neu aufsetze, werde ich den Update Prozess gleich nochmal prüfen.

Gruß
KiWiX
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Update von 1.2.8 auf aktuelle Version 1.3.9-fehlen Tabellen

Post by juergen »

nö, update funktioniert einwandfrei!
Post Reply