Problem z instalacją JEvent

[romecki_cz]

Mam taki problem. Podczas instalacji komponentu JEvents wyskakuje mi komunikat "Wymagana instalacja tabeli bazy danych", a wraz z nim bardzo długa informacja, oczywiście w języku angielskim. Nie bardzo wiem co z tym zrobić.

Instalowałem ten sam komponent na dwóch innych serwerach i wszystko było ok, bez żadnych problemów.

Poniżej dodaję link do screena tego komunikatu.

Bardzo proszę o pomoc.

http://img713.imageshack.us/img713/9697/jevent.jpg

[ryba_krakow]

Mam taki problem. Podczas instalacji komponentu JEvents wyskakuje mi komunikat "Wymagana instalacja tabeli bazy danych", a wraz z nim bardzo długa informacja, oczywiście w języku angielskim. Nie bardzo wiem co z tym zrobić.

Instalowałem ten sam komponent na dwóch innych serwerach i wszystko było ok, bez żadnych problemów.

Poniżej dodaję link do screena tego komunikatu.

Bardzo proszę o pomoc.

http://img713.imageshack.us/img713/9697/jevent.jpg
Mam dokładnie taki sam problem.
Przy próbie zainstalowania jevents 1.4.2.1 jest podobnie, z tym, że błąd wyświetla:



JInstaller::install: Błąd SQL DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 34 SQL=CREATE TABLE IF NOT EXISTS `ops_events` ( `id` int(12) NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '1', `title` varchar(100) NOT NULL default '', `content` longtext NOT NULL default '', `adresse_info` VARCHAR(120) NOT NULL default '', `contact_info` VARCHAR(120) NOT NULL default '', `extra_info` VARCHAR(240) NOT NULL default '', `color_bar` VARCHAR(8) NOT NULL default '', `useCatColor` TINYINT(1) NOT NULL default '0', `state` tinyint(3) NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL default '', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` varchar(4) NOT NULL default '', `reccurweekdays` varchar(20) NOT NULL default '', `reccurweeks` varchar(10) NOT NULL default '', `approved` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `access` int(11) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `ops_events` ( `id` int(12) NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '1', `title` varchar(100) NOT NULL default '', `content` longtext NOT NULL default '', `adresse_info` VARCHAR(120) NOT NULL default '', `contact_info` VARCHAR(120) NOT NULL default '', `extra_info` VARCHAR(240) NOT NULL default '', `color_bar` VARCHAR(8) NOT NULL default '', `useCatColor` TINYINT(1) NOT NULL default '0', `state` tinyint(3) NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL default '', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` varchar(4) NOT NULL default '', `reccurweekdays` varchar(20) NOT NULL default '', `reccurweeks` varchar(10) NOT NULL default '', `approved` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `access` int(11) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
Komponent Zainstaluj: Błąd SQL DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 34 SQL=CREATE TABLE IF NOT EXISTS `ops_events` ( `id` int(12) NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '1', `title` varchar(100) NOT NULL default '', `content` longtext NOT NULL default '', `adresse_info` VARCHAR(120) NOT NULL default '', `contact_info` VARCHAR(120) NOT NULL default '', `extra_info` VARCHAR(240) NOT NULL default '', `color_bar` VARCHAR(8) NOT NULL default '', `useCatColor` TINYINT(1) NOT NULL default '0', `state` tinyint(3) NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL default '', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` varchar(4) NOT NULL default '', `reccurweekdays` varchar(20) NOT NULL default '', `reccurweeks` varchar(10) NOT NULL default '', `approved` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `access` int(11) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `ops_events` ( `id` int(12) NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '1', `title` varchar(100) NOT NULL default '', `content` longtext NOT NULL default '', `adresse_info` VARCHAR(120) NOT NULL default '', `contact_info` VARCHAR(120) NOT NULL default '', `extra_info` VARCHAR(240) NOT NULL default '', `color_bar` VARCHAR(8) NOT NULL default '', `useCatColor` TINYINT(1) NOT NULL default '0', `state` tinyint(3) NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL default '', `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` varchar(4) NOT NULL default '', `reccurweekdays` varchar(20) NOT NULL default '', `reccurweeks` varchar(10) NOT NULL default '', `approved` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `access` int(11) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;


Bardzo proszę o pomoc

[Emmers]

Również mam ten sam problem. Próbowałem go rozwiązać , ale nie udało się . I jak widzę nikt nie ma pomysłu

[zwiastun]

Czy instalujesz najnowszą wersję JEvents?
Przyczyna tkwi prawdopodobnie w nowej wersji MySQL na Twoim serwerze.