pragmaMx Support Forum

pragmaMx => Zusatzmodule => Thema gestartet von: kawaa am 30 Juni 2012, 19:25:21

Titel: [gelöst] Sommaire Paramétrable v3.2 (Customize Menu) BUG ?
Beitrag von: kawaa am 30 Juni 2012, 19:25:21
Der Block kompatibel pragmaMx 1.12.3 ?
http://www.pragmamx.org/Downloads-Sommaire-Parametrable-vdrei-zwei-Customize-Menu-view-468.html

@++

MySQL error (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 19
query: CREATE TABLE `{prefix}_sommaire` (
`groupmenu` int(2) NOT NULL default '0',
`name` varchar(200) default NULL,
`image` varchar(99) default NULL,
`lien` text,
`hr` char(2) default NULL,
`center` char(2) default NULL,
`bgcolor` tinytext,
`invisible` int(1) default NULL,
`class` tinytext,
`bold` char(2) default NULL,
`new` char(2) default NULL,
`listbox` char(2) default NULL,
`dynamic` char(2) default NULL,
`date_debut` bigint(20) unsigned NOT NULL default '0',
`date_fin` bigint(20) unsigned NOT NULL default '0',
`days` varchar(8) default NULL,
PRIMARY KEY (`groupmenu`)
) TYPE=MyISAM
in install-sommairev3.php on line 341
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 19
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (1, 'Accueil', 'icon_home.gif', './', '', '', '', 3, 'boxtitle', '', '', '', 'on', 0, 0, '')
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (2, 'Contenus', 'page_white_text.gif', '', '', '', '', 3, 'boxtitle', '', '', '', 'on', 0, 0, '')
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (3, 'Nouveautés', 'newspaper.gif', '', '', '', '', 3, 'boxtitle', '', '', '', 'on', 0, 0, '')
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (4, 'Infos', 'icon_poll.gif', '', '', '', '', 3, 'boxtitle', '', '', '', 'on', 0, 0, '')
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (5, 'Communauté ', 'icon_community.gif', '', '', '', '', 3, 'boxtitle', '', '', '', 'on', 0, 0, '')
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire' doesn't exist
query:
INSERT INTO `{prefix}_sommaire`
(`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`)
VALUES (99, '', NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 'on', 0, 0, NULL)
in install-sommairev3.php on line 365
Table 'pragmamx.mxbf5048_sommaire' doesn't exist
MySQL error (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 17
query: CREATE TABLE `{prefix}_sommaire_categories` (
`id` int(11) NOT NULL auto_increment,
`groupmenu` int(2) NOT NULL default '0',
`module` varchar(50) NOT NULL default '',
`url` text NOT NULL,
`url_text` text NOT NULL,
`image` varchar(50) NOT NULL default '',
`new` char(2) default NULL,
`new_days` tinyint(4) NOT NULL default '-1',
`class` varchar(20) default NULL,
`bold` char(2) default NULL,
`sublevel` tinyint(3) NOT NULL default '0',
`date_debut` bigint(20) unsigned NOT NULL default '0',
`date_fin` bigint(20) unsigned NOT NULL default '0',
`days` varchar(8) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM
in install-sommairev3.php on line 389
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 17
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (1, 2, 'Content', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (2, 2, 'Sections', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (3, 2, 'Encyclopedia', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (4, 2, 'Reviews', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (5, 2, 'My_eGallery', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (6, 2, 'Downloads', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (7, 2, 'Web_Links', '', '', 'tree-L.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (8, 3, 'News', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (9, 3, 'Topics', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (10, 3, 'Submit_News', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (11, 3, 'Stories_Archive', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (12, 3, 'Web_News', '', '', 'tree-L.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (13, 4, 'Impressum', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (14, 4, 'FAQ', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (15, 4, 'Surveys', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (16, 4, 'Feedback', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (17, 4, 'Recommend_Us', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (18, 4, 'Top', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (19, 4, 'maaXStat2', '', '', 'tree-L.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (20, 5, 'User_Registration', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (21, 5, 'UserGuest', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (22, 5, 'Your_Account', '', '', 'tree-T.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
MySQL error (1146):
Table '{dbname}.{prefix}_sommaire_categories' doesn't exist
query:
INSERT INTO `{prefix}_sommaire_categories`
(`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`)
VALUES (23, 5, 'Guestbook', '', '', 'tree-L.gif', '', -1, 'boxcontent', '', 0, 0, 0, '')
in install-sommairev3.php on line 422
Table 'pragmamx.mxbf5048_sommaire_categories' doesn't exist
Titel: Re:Sommaire Paramétrable v3.2 (Customize Menu) BUG ?
Beitrag von: Olaf / TerraProject am 03 Juli 2012, 12:33:34
Hi  :morning:

please edit the line: TYPE=MyISAM in ENGINE=MyISAM
Titel: Re:Sommaire Paramétrable v3.2 (Customize Menu) BUG ?
Beitrag von: kawaa am 06 Juli 2012, 03:12:35
Tnx  ;)