Problem z bazą danych

[Mathias_]

Witam

Cóż bawiłem się dzisiaj bazą danych i spieprzyłem kilka rzeczy (wiem, dobry jestem). Naprawiłem większość błędów, ale mam problem z kalendarzem:

Nieznana kolumna 'event_date' w field list
Plik: /home/accounts_s/xxxxx/public_html/Sources/Subs-Calendar.php
Linia: 296

Podmieniłem plik na standardowy, ale tutaj wszystko jest ok. Obstawiam, że chdozi o plik kalendarza w bazie danych.

Teoretycznie więc moja prośba ogranicza się do tego czy ktoś mógłby wrzucić oryginalne pliki: smf_calendar
smf_calendar_holidays

Pozdrawiam,
M_

[flapjack]

a co za problem wyciagnac je z paczki instalacyjnej?

[zegarek]

Wejdź w phpmyadmin wybierz swoją bazę danych usuń tabele smf_calendar i smf_calendar_holidays.

Potem uruchom zapytanie SQL cały czas mając wybraną swoją bazę danych i wpisz w następującej kolejności.

Kod: [Zaznacz]

CREATE TABLE IF NOT EXISTS `smf_calendar` (
  `id_event` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `start_date` date NOT NULL DEFAULT '0001-01-01',
  `end_date` date NOT NULL DEFAULT '0001-01-01',
  `id_board` smallint(5) unsigned NOT NULL DEFAULT '0',
  `id_topic` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `id_member` mediumint(8) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_event`),
  KEY `start_date` (`start_date`),
  KEY `end_date` (`end_date`),
  KEY `topic` (`id_topic`,`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
Potem :

Kod: [Zaznacz]

CREATE TABLE IF NOT EXISTS `smf_calendar_holidays` (
  `id_holiday` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `event_date` date NOT NULL DEFAULT '0001-01-01',
  `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id_holiday`),
  KEY `event_date` (`event_date`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=132 ;

Na koniec jeszcze to :

Kod: [Zaznacz]

INSERT INTO `smf_calendar_holidays` (`id_holiday`, `event_date`, `title`) VALUES
(1, '0004-01-01', 'New Year''s'),
(2, '0004-12-25', 'Christmas'),
(3, '0004-02-14', 'Valentine''s Day'),
(4, '0004-03-17', 'St. Patrick''s Day'),
(5, '0004-04-01', 'April Fools'),
(6, '0004-04-22', 'Earth Day'),
(7, '0004-10-24', 'United Nations Day'),
(8, '0004-10-31', 'Halloween'),
(9, '2008-05-11', 'Mother''s Day'),
(10, '2009-05-10', 'Mother''s Day'),
(11, '2010-05-09', 'Mother''s Day'),
(12, '2011-05-08', 'Mother''s Day'),
(13, '2012-05-13', 'Mother''s Day'),
(14, '2013-05-12', 'Mother''s Day'),
(15, '2014-05-11', 'Mother''s Day'),
(16, '2015-05-10', 'Mother''s Day'),
(17, '2016-05-08', 'Mother''s Day'),
(18, '2017-05-14', 'Mother''s Day'),
(19, '2018-05-13', 'Mother''s Day'),
(20, '2019-05-12', 'Mother''s Day'),
(21, '2020-05-10', 'Mother''s Day'),
(22, '2008-06-15', 'Father''s Day'),
(23, '2009-06-21', 'Father''s Day'),
(24, '2010-06-20', 'Father''s Day'),
(25, '2011-06-19', 'Father''s Day'),
(26, '2012-06-17', 'Father''s Day'),
(27, '2013-06-16', 'Father''s Day'),
(28, '2014-06-15', 'Father''s Day'),
(29, '2015-06-21', 'Father''s Day'),
(30, '2016-06-19', 'Father''s Day'),
(31, '2017-06-18', 'Father''s Day'),
(32, '2018-06-17', 'Father''s Day'),
(33, '2019-06-16', 'Father''s Day'),
(34, '2020-06-21', 'Father''s Day'),
(35, '2008-06-20', 'Summer Solstice'),
(36, '2009-06-20', 'Summer Solstice'),
(37, '2010-06-21', 'Summer Solstice'),
(38, '2011-06-21', 'Summer Solstice'),
(39, '2012-06-20', 'Summer Solstice'),
(40, '2013-06-21', 'Summer Solstice'),
(41, '2014-06-21', 'Summer Solstice'),
(42, '2015-06-21', 'Summer Solstice'),
(43, '2016-06-20', 'Summer Solstice'),
(44, '2017-06-20', 'Summer Solstice'),
(45, '2018-06-21', 'Summer Solstice'),
(46, '2019-06-21', 'Summer Solstice'),
(47, '2020-06-20', 'Summer Solstice'),
(48, '2008-03-19', 'Vernal Equinox'),
(49, '2009-03-20', 'Vernal Equinox'),
(50, '2010-03-20', 'Vernal Equinox'),
(51, '2011-03-20', 'Vernal Equinox'),
(52, '2012-03-20', 'Vernal Equinox'),
(53, '2013-03-20', 'Vernal Equinox'),
(54, '2014-03-20', 'Vernal Equinox'),
(55, '2015-03-20', 'Vernal Equinox'),
(56, '2016-03-19', 'Vernal Equinox'),
(57, '2017-03-20', 'Vernal Equinox'),
(58, '2018-03-20', 'Vernal Equinox'),
(59, '2019-03-20', 'Vernal Equinox'),
(60, '2020-03-19', 'Vernal Equinox'),
(61, '2008-12-21', 'Winter Solstice'),
(62, '2009-12-21', 'Winter Solstice'),
(63, '2010-12-21', 'Winter Solstice'),
(64, '2011-12-22', 'Winter Solstice'),
(65, '2012-12-21', 'Winter Solstice'),
(66, '2013-12-21', 'Winter Solstice'),
(67, '2014-12-21', 'Winter Solstice'),
(68, '2015-12-21', 'Winter Solstice'),
(69, '2016-12-21', 'Winter Solstice'),
(70, '2017-12-21', 'Winter Solstice'),
(71, '2018-12-21', 'Winter Solstice'),
(72, '2019-12-21', 'Winter Solstice'),
(73, '2020-12-21', 'Winter Solstice'),
(74, '2008-09-22', 'Autumnal Equinox'),
(75, '2009-09-22', 'Autumnal Equinox'),
(76, '2010-09-22', 'Autumnal Equinox'),
(77, '2011-09-23', 'Autumnal Equinox'),
(78, '2012-09-22', 'Autumnal Equinox'),
(79, '2013-09-22', 'Autumnal Equinox'),
(80, '2014-09-22', 'Autumnal Equinox'),
(81, '2015-09-23', 'Autumnal Equinox'),
(82, '2016-09-22', 'Autumnal Equinox'),
(83, '2017-09-22', 'Autumnal Equinox'),
(84, '2018-09-22', 'Autumnal Equinox'),
(85, '2019-09-23', 'Autumnal Equinox'),
(86, '2020-09-22', 'Autumnal Equinox'),
(87, '0004-07-04', 'Independence Day'),
(88, '0004-05-05', 'Cinco de Mayo'),
(89, '0004-06-14', 'Flag Day'),
(90, '0004-11-11', 'Veterans Day'),
(91, '0004-02-02', 'Groundhog Day'),
(92, '2008-11-27', 'Thanksgiving'),
(93, '2009-11-26', 'Thanksgiving'),
(94, '2010-11-25', 'Thanksgiving'),
(95, '2011-11-24', 'Thanksgiving'),
(96, '2012-11-22', 'Thanksgiving'),
(97, '2013-11-21', 'Thanksgiving'),
(98, '2014-11-20', 'Thanksgiving'),
(99, '2015-11-26', 'Thanksgiving'),
(100, '2016-11-24', 'Thanksgiving'),
(101, '2017-11-23', 'Thanksgiving'),
(102, '2018-11-22', 'Thanksgiving'),
(103, '2019-11-21', 'Thanksgiving'),
(104, '2020-11-26', 'Thanksgiving'),
(105, '2008-05-26', 'Memorial Day'),
(106, '2009-05-25', 'Memorial Day'),
(107, '2010-05-31', 'Memorial Day'),
(108, '2011-05-30', 'Memorial Day'),
(109, '2012-05-28', 'Memorial Day'),
(110, '2013-05-27', 'Memorial Day'),
(111, '2014-05-26', 'Memorial Day'),
(112, '2015-05-25', 'Memorial Day'),
(113, '2016-05-30', 'Memorial Day'),
(114, '2017-05-29', 'Memorial Day'),
(115, '2018-05-28', 'Memorial Day'),
(116, '2019-05-27', 'Memorial Day'),
(117, '2020-05-25', 'Memorial Day'),
(118, '2008-09-01', 'Labor Day'),
(119, '2009-09-07', 'Labor Day'),
(120, '2010-09-06', 'Labor Day'),
(121, '2011-09-05', 'Labor Day'),
(122, '2012-09-03', 'Labor Day'),
(123, '2013-09-09', 'Labor Day'),
(124, '2014-09-08', 'Labor Day'),
(125, '2015-09-07', 'Labor Day'),
(126, '2016-09-05', 'Labor Day'),
(127, '2017-09-04', 'Labor Day'),
(128, '2018-09-03', 'Labor Day'),
(129, '2019-09-09', 'Labor Day'),
(130, '2020-09-07', 'Labor Day'),
(131, '0004-06-06', 'D-Day');

[zegarek]

...

[Mathias_]

Ok działa, dzięki za pomoc.