search

Kuestenschmiede / MapsBundle

The interactive maps brick of the Contao GIS-kit con4gis.
https://maps.con4gis.org
GNU Lesser General Public License v3.0
7 stars 6 forks source link

Installationsprobleme bei Datenbankaktualisierung #25

Closed eBlick closed 5 years ago

eBlick commented 5 years ago

In zwei unterschiedlichen Installation erhalte ich bei der Erstinstallation der Maps eine Fehlermeldung beim Datenbank-Update. Das Anlegen der Tabelle scheitert über dis Install-Tool.

[2019-09-07 11:21:31] app.CRITICAL: An exception occurred. {"exception":"[object] (Doctrine\DBAL\Exception\SyntaxErrorException(code: 0): An exception occurred while executing 'CREATE TABLE tl_c4g_maps (\n id int(10) unsigned NOT NULL auto_increment,\n pid int(10) unsigned NOT NULL default '0',\n sorting int(10) unsigned NOT NULL default '0',\n tstamp int(10) unsigned NOT NULL default '0',\n name varchar(100) NOT NULL default '',\n profile int(10) unsigned NOT NULL default '0',\n profile_mobile int(10) unsigned NOT NULL default '0',\n published char(1) NOT NULL default '1',\n is_map char(1) NOT NULL default '',\n width varchar(64) NOT NULL default '',\n height varchar(64) NOT NULL default '',\n margin varchar(128) NOT NULL default '',\n calc_extent varchar(10) NOT NULL default '',\n show_locations char(1) NOT NULL default '2',\n min_gap int(10) unsigned NOT NULL default '0',\n awesomeicon varchar(20) NOT NULL default '',\n center_geox varchar(20) NOT NULL default '',\n center_geoy varchar(20) NOT NULL default '',\n center_rotation int NOT NULL default 0 '',\n zoom varchar(20) NOT NULL default '10',\n geolocation char(1) NOT NULL default '',\n geolocation_zoom int(10) unsigned NOT NULL default '16',\n hide_when_in_tab char(1) NOT NULL default '',\n restrict_area char(1) NOT NULL default '',\n restr_bottomleft_geox varchar(20) NOT NULL default '',\n restr_bottomleft_geoy varchar(20) NOT NULL default '',\n restr_topright_geox varchar(20) NOT NULL default '',\n restr_topright_geoy varchar(20) NOT NULL default '',\n include_sublocations char(1) NOT NULL default '1',\n location_type char(10) NOT NULL default '',\n loc_geox varchar(20) NOT NULL default '',\n loc_geoy varchar(20) NOT NULL default '',\n locstyle int(10) unsigned NOT NULL default '0',\n zIndex int(10) unsigned NOT NULL default '0',\n loc_only_in_parent char(1) NOT NULL default '',\n exemptFromFilter char(1) NOT NULL default '',\n filterByBaseLayer blob NULL,\n loc_label varchar(100) NOT NULL default '',\n tooltip varchar(100) NOT NULL default '',\n tooltip_length int(100) NOT NULL default '30',\n enablePopup char(1) NOT NULL default '1',\n popupType char(10) NOT NULL default 'text',\n popupTemplate varchar(64) NOT NULL default '',\n popup_info text NULL,\n popup_async char(1) NOT NULL default '',\n popup_extend char(1) NOT NULL default '0',\n loc_linkurl varchar(255) NOT NULL default '',\n loc_onclick_zoomto int(10) unsigned NOT NULL default '0',\n loc_minzoom int(10) unsigned NOT NULL default '0',\n loc_maxzoom int(10) unsigned NOT NULL default '0',\n tab_source varchar(100) NOT NULL default '',\n async_content char(1) NOT NULL default '',\n tab_pid int(10) unsigned NOT NULL default '0',\n tab_pid1 int(10) unsigned NOT NULL default '0',\n tab_labeldisplay char(10) NOT NULL default '1ST_MORE',\n tab_tooltipdisplay char(10) NOT NULL default '1ST_MORE',\n tab_directlink char(1) NOT NULL default '',\n tab_force_target_blank char(1) NOT NULL default '',\n tab_whereclause text NULL,\n tabJoinclause text NULL,\n tab_orderby varchar(128) NOT NULL default '',\n tab_filter_alias char(1) NOT NULL default '',\n data_file binary(16) NULL,\n data_folder binary(16) NULL,\n split_geojson char(1) NOT NULL default '',\n geojson_attributes text NULL,\n geojson_zoom char(1) NOT NULL default '',\n data_url varchar(255) NOT NULL default '',\n data_content text NULL,\n data_projection char(5) NOT NULL default '',\n data_forcenodes char(1) NOT NULL default '1',\n data_additionalgeometries char(1) NOT NULL default '',\n data_layername varchar(254) NOT NULL default '',\n data_hidelayer char(1) NOT NULL default '',\n hide_child char(1) NOT NULL default '',\n initial_opened char(1) NOT NULL default '',\n showPopupOnActive char(1) NOT NULL default '',\n forums blob NULL,\n forum_jumpto int(10) unsigned NOT NULL default '0',\n forum_reassign_layer char(10) NOT NULL default 'NO',\n ovp_request text NULL,\n ovp_bbox_limited char(1) NOT NULL default '1',\n link_id int(10) unsigned NOT NULL default '0',\n protect_element char(1) NOT NULL default '',\n permitted_groups blob NULL,\n use_specialprofile char(1) NOT NULL default '',\n specialprofile int(10) unsigned NOT NULL default '0',\n specialprofile_mobile int(10) unsigned NOT NULL default '0',\n specialprofile_groups blob NULL,\n cluster_locations char(1) NOT NULL default '',\n cluster_distance varchar(100) NOT NULL default '',\n cluster_fillcolor varchar(6) NOT NULL default '4975A8',\n cluster_fontcolor varchar(6) NOT NULL default 'ffffff',\n cluster_zoom int(10) unsigned NOT NULL default '17',\n cluster_popup char(1) NOT NULL default '',\n zoom_locations char(1) NOT NULL default '',\n hover_location char(1) NOT NULL default '',\n hover_style int(10) unsigned NOT NULL default '0',\n be_optimize_checkboxes_limit int(10) unsigned NOT NULL default '10',\n cssClass varchar(255) NOT NULL default '',\n PRIMARY KEY (id),\n KEY pid (pid)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;':\n\nSQLSTATE[42000]: Syntax error or access violation: 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 ''',\n zoom varchar(20) NOT NULL default '10',\n geolocation char(1) NOT NULL' at line 20 at domain/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:99, Doctrine\DBAL\Driver\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 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 ''',\n zoom varchar(20) NOT NULL default '10',\n geolocation char(1) NOT NULL' at line 20 at domain/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:109, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 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 ''',\n zoom varchar(20) NOT NULL default '10',\n geolocation char(1) NOT NULL' at line 20 at domain/contao/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:107)"} []

coastforge-mei commented 5 years ago

Ich gehe davon aus, dass Du die 6.2.2 installiert hast. Mit meiner Datenbank konnte ich das Problem nicht nachstellen. Ich habe im Sourcecode einen Fehler entdeckt und in der 6.2.3 behoben. Bitte mal testen.

eBlick commented 5 years ago

Bestens. Habe es gelöscht und erneut installiert. Nun wurde die Tabelle anstandslos angelegt :-)