Title: error message
Last modified: January 9, 2017

---

# error message

 *  Resolved [HDcms](https://wordpress.org/support/users/hdcms/)
 * (@hdcms)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/error-message-572/)
 * Hello,
 * I have this error message that prevents me from using your plugin because I do
   not have the map display
 * Erreur de la base de données WordPress : [Table ‘aInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    SELECT id FROM `wp_leafletmapsmarker_markers` WHERE `basemap`
   LIKE ‘mapquest%’ ORDER BY id ASC
 * Erreur de la base de données WordPress : [Table ‘aInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    SELECT id FROM `wp_leafletmapsmarker_layers` WHERE `basemap` 
   LIKE ‘mapquest%’ ORDER BY id ASC
 * Regards
 * _[ [No bumping please](http://codex.wordpress.org/Forum_Welcome#No_Bumping). ]_

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/error-message-572/#post-8635799)
 * Hi,
    can you please try uninstalling and reinstalling the plugin please? 2 database
   tables should actually be created upon installation automatically. best, Robert
 *  Thread Starter [HDcms](https://wordpress.org/support/users/hdcms/)
 * (@hdcms)
 * [9 years, 5 months ago](https://wordpress.org/support/topic/error-message-572/#post-8637899)
 * HI,
 * Thank you for your support.
    I have done it twice but I have these errors now
   Regards
 *  [CREATE command denied to user ‘XXXalterinfo’@’XXX.0.73.15’ for table ‘wp_leafletmapsmarker_markers’]
   
   CREATE TABLE wp_leafletmapsmarker_markers ( id int(6) unsigned NOT NULL AUTO_INCREMENT,
   markername varchar(255) NOT NULL, basemap varchar(25) NOT NULL, layer varchar(
   4000) NOT NULL, lat decimal(9,6) NOT NULL, lon decimal(9,6) NOT NULL, icon varchar(
   255) NOT NULL, popuptext text NOT NULL, zoom int(2) NOT NULL, openpopup tinyint(
   1) NOT NULL, mapwidth int(4) NOT NULL, mapwidthunit varchar(2) NOT NULL, mapheight
   int(4) NOT NULL, panel tinyint(1) NOT NULL, createdby varchar(60) NOT NULL, createdon
   datetime NOT NULL, updatedby varchar(60) DEFAULT NULL, updatedon datetime DEFAULT
   NULL, controlbox int(1) NOT NULL, overlays_custom int(1) NOT NULL, overlays_custom2
   int(1) NOT NULL, overlays_custom3 int(1) NOT NULL, overlays_custom4 int(1) NOT
   NULL, wms tinyint(1) NOT NULL, wms2 tinyint(1) NOT NULL, wms3 tinyint(1) NOT 
   NULL, wms4 tinyint(1) NOT NULL, wms5 tinyint(1) NOT NULL, wms6 tinyint(1) NOT
   NULL, wms7 tinyint(1) NOT NULL, wms8 tinyint(1) NOT NULL, wms9 tinyint(1) NOT
   NULL, wms10 tinyint(1) NOT NULL, kml_timestamp datetime DEFAULT NULL, address
   varchar(255) NOT NULL, gpx_url varchar(2083) NOT NULL, gpx_panel tinyint(1) NOT
   NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
 * Erreur de la base de données WordPress : [CREATE command denied to user ‘XXXalterinfo’@’XXX.
   0.73.15’ for table ‘wp_leafletmapsmarker_layers’]
    CREATE TABLE wp_leafletmapsmarker_layers(
   id int(6) unsigned NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL, basemap
   varchar(25) NOT NULL, layerzoom int(2) NOT NULL, mapwidth int(4) NOT NULL, mapwidthunit
   varchar(2) NOT NULL, mapheight int(4) NOT NULL, panel tinyint(1) NOT NULL, layerviewlat
   decimal(9,6) NOT NULL, layerviewlon decimal(9,6) NOT NULL, createdby varchar(
   60) NOT NULL, createdon datetime NOT NULL, updatedby varchar(60) DEFAULT NULL,
   updatedon datetime DEFAULT NULL, controlbox int(1) NOT NULL, overlays_custom 
   int(1) NOT NULL, overlays_custom2 int(1) NOT NULL, overlays_custom3 int(1) NOT
   NULL, overlays_custom4 int(1) NOT NULL, wms tinyint(1) NOT NULL, wms2 tinyint(
   1) NOT NULL, wms3 tinyint(1) NOT NULL, wms4 tinyint(1) NOT NULL, wms5 tinyint(
   1) NOT NULL, wms6 tinyint(1) NOT NULL, wms7 tinyint(1) NOT NULL, wms8 tinyint(
   1) NOT NULL, wms9 tinyint(1) NOT NULL, wms10 tinyint(1) NOT NULL, listmarkers
   tinyint(1) NOT NULL, multi_layer_map tinyint(1) NOT NULL, multi_layer_map_list
   varchar(4000) DEFAULT NULL, address varchar(255) NOT NULL, `clustering` tinyint(
   1) unsigned NOT NULL, gpx_url varchar(2083) NOT NULL, gpx_panel tinyint(1) NOT
   NULL, mlm_filter int(1) NOT NULL, mlm_filter_details varchar(4000) DEFAULT NULL,
   PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=utf8
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    INSERT INTO `wp_leafletmapsmarker_layers` ( `id`, `name`, `basemap`,`
   layerzoom`, `mapwidth`, `mapwidthunit`, `mapheight`, `layerviewlat`, `layerviewlon`)
   VALUES (0, ‘markers not assigned to a layer’, ‘osm_mapnik’, ’11’, ‘640’, ‘px’,‘
   480’, ”, ”);
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_markers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘osm_osmarender’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_layers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘osm_osmarender’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_markers` SET `basemap` = ‘googleLayer_satellite’
   WHERE `basemap` = ‘googleLayer_satellit’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_layers` SET `basemap` = ‘googleLayer_satellite’
   WHERE `basemap` = ‘googleLayer_satellit’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_markers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_layers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_markers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade2’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_layers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade2’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_markers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_markers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade3’;
 * Erreur de la base de données WordPress : [Table ‘alterInfo.wp_leafletmapsmarker_layers’
   doesn’t exist]
    UPDATE `wp_leafletmapsmarker_layers` SET `basemap` = ‘osm_mapnik’
   WHERE `basemap` = ‘cloudmade3’;
 *  Plugin Author [Robert Seyfriedsberger](https://wordpress.org/support/users/harmr/)
 * (@harmr)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/error-message-572/#post-8655522)
 * sorry for late reply – missed the notification.
    mmhhhh – strange anyway – seems
   like your database user is somehow restricted. I would suggest to either consult
   your hoster who should be able to tell you more about your database configuration
   or if you have access to phpmyadmin, try to execute the following to SQL statements
   to setup the basic tables needed for Leaflet Maps Marker (anyway consulting your
   hoster would still be recommended in order not to run into any issues with any
   further updates which might require database table changes):
 * sql 1
    `CREATE TABLE wp_leafletmapsmarker_markers ( id int(6) unsigned NOT NULL
   AUTO_INCREMENT, markername varchar(255) NOT NULL, basemap varchar(25) NOT NULL,
   layer varchar(4000) NOT NULL, lat decimal(9,6) NOT NULL, lon decimal(9,6) NOT
   NULL, icon varchar(255) NOT NULL, popuptext text NOT NULL, zoom int(2) NOT NULL,
   openpopup tinyint(1) NOT NULL, mapwidth int(4) NOT NULL, mapwidthunit varchar(
   2) NOT NULL, mapheight int(4) NOT NULL, panel tinyint(1) NOT NULL, createdby 
   varchar(60) NOT NULL, createdon datetime NOT NULL, updatedby varchar(60) DEFAULT
   NULL, updatedon datetime DEFAULT NULL, controlbox int(1) NOT NULL, overlays_custom
   int(1) NOT NULL, overlays_custom2 int(1) NOT NULL, overlays_custom3 int(1) NOT
   NULL, overlays_custom4 int(1) NOT NULL, wms tinyint(1) NOT NULL, wms2 tinyint(
   1) NOT NULL, wms3 tinyint(1) NOT NULL, wms4 tinyint(1) NOT NULL, wms5 tinyint(
   1) NOT NULL, wms6 tinyint(1) NOT NULL, wms7 tinyint(1) NOT NULL, wms8 tinyint(
   1) NOT NULL, wms9 tinyint(1) NOT NULL, wms10 tinyint(1) NOT NULL, kml_timestamp
   datetime DEFAULT NULL, address varchar(255) NOT NULL, gpx_url varchar(2083) NOT
   NULL, gpx_panel tinyint(1) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT
   CHARSET=utf8`
 * sql 2
    `CREATE TABLE wp_leafletmapsmarker_layers ( id int(6) unsigned NOT NULL
   AUTO_INCREMENT, name varchar(255) NOT NULL, basemap varchar(25) NOT NULL, layerzoom
   int(2) NOT NULL, mapwidth int(4) NOT NULL, mapwidthunit varchar(2) NOT NULL, 
   mapheight int(4) NOT NULL, panel tinyint(1) NOT NULL, layerviewlat decimal(9,6)
   NOT NULL, layerviewlon decimal(9,6) NOT NULL, createdby varchar(60) NOT NULL,
   createdon datetime NOT NULL, updatedby varchar(60) DEFAULT NULL, updatedon datetime
   DEFAULT NULL, controlbox int(1) NOT NULL, overlays_custom int(1) NOT NULL, overlays_custom2
   int(1) NOT NULL, overlays_custom3 int(1) NOT NULL, overlays_custom4 int(1) NOT
   NULL, wms tinyint(1) NOT NULL, wms2 tinyint(1) NOT NULL, wms3 tinyint(1) NOT 
   NULL, wms4 tinyint(1) NOT NULL, wms5 tinyint(1) NOT NULL, wms6 tinyint(1) NOT
   NULL, wms7 tinyint(1) NOT NULL, wms8 tinyint(1) NOT NULL, wms9 tinyint(1) NOT
   NULL, wms10 tinyint(1) NOT NULL, listmarkers tinyint(1) NOT NULL, multi_layer_map
   tinyint(1) NOT NULL, multi_layer_map_list varchar(4000) DEFAULT NULL, address
   varchar(255) NOT NULL, clustering tinyint(1) unsigned NOT NULL, gpx_url varchar(
   2083) NOT NULL, gpx_panel tinyint(1) NOT NULL, mlm_filter int(1) NOT NULL, mlm_filter_details
   varchar(4000) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=
   utf8`
 *  Thread Starter [HDcms](https://wordpress.org/support/users/hdcms/)
 * (@hdcms)
 * [9 years, 4 months ago](https://wordpress.org/support/topic/error-message-572/#post-8672996)
 * Hi
    I had an administrator access problem for the user of the database Thanks
   it works now 🙂

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘error message’ is closed to new replies.

 * ![](https://ps.w.org/leaflet-maps-marker/assets/icon.svg?rev=970936)
 * [Leaflet Maps Marker (Google Maps, OpenStreetMap, Bing Maps)](https://wordpress.org/plugins/leaflet-maps-marker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/leaflet-maps-marker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/leaflet-maps-marker/)
 * [Active Topics](https://wordpress.org/support/plugin/leaflet-maps-marker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/leaflet-maps-marker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/leaflet-maps-marker/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [HDcms](https://wordpress.org/support/users/hdcms/)
 * Last activity: [9 years, 4 months ago](https://wordpress.org/support/topic/error-message-572/#post-8672996)
 * Status: resolved