Title: Database Error. Can’t create Map!
Last modified: July 29, 2018

---

# Database Error. Can’t create Map!

 *  [robwent](https://wordpress.org/support/users/robwent/)
 * (@robwent)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-error-cant-create-map/)
 * Just installed and tried to create a new map.
 * When I try and save, I get the message:
 * Database Error. Can’t create Map!
 * If I enable debugging, I get the following:
 *     ```
       WordPress database error: [Unknown column 'width_parameter' in 'field list']
       INSERT INTO <code>wp_mapfig_premium_map</code> (<code>title</code>, <code>width</code>, <code>height</code>, <code>width_parameter</code>, <code>height_parameter</code>, <code>show_sidebar</code>, <code>show_search</code>, <code>show_measure</code>, <code>show_minimap</code>, <code>show_svg</code>, <code>show_export</code>, <code>lat</code>, <code>lng</code>, <code>zoom</code>, <code>data</code>, <code>image_olverlays</code>, <code>layers_id</code>, <code>groups_id</code>) VALUES ('Butlers Pool', '100', '500', '%', 'px', '1', '0', '0', '0', '0', '0', '52.761814022662', '-2.7390611171722', '6', '', '', '1', '0')
       ```
   
 * When I check the db, there is no width_parameter or height_parameter columns 
   so I’m not sure how it can work.
 * I’ve installed on 2 sites to test and see the same on both.
 * It’s a bit unnerving that the last update was a year ago and things like this
   happen. Is it php 7.2 compatible?
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fdatabase-error-cant-create-map%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

Viewing 1 replies (of 1 total)

 *  Thread Starter [robwent](https://wordpress.org/support/users/robwent/)
 * (@robwent)
 * [7 years, 10 months ago](https://wordpress.org/support/topic/database-error-cant-create-map/#post-10538038)
 * Looking at /lib/upgrade.php there is a function to alter this table and add the
   missing parameters.
 * It looks to me like the plugin installs an old version of the database, but then
   sets the option ‘mapfig_premium_db_version’ to 2, so the alter table functions
   never run.
 * If anyone else runs into this, go into your db with phpmyadmin and search the
   option table for ‘mapfig_premium_db_version’ and then change the value from 2
   to 0.
 * Then reload the admin page of the site and the database tables will update and
   you will be able to save a map.

Viewing 1 replies (of 1 total)

The topic ‘Database Error. Can’t create Map!’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/mapfig-premium-leaflet-map-maker_c6bebf.
   svg)
 * [AcuGIS Leaflet Maps](https://wordpress.org/plugins/mapfig-premium-leaflet-map-maker/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/mapfig-premium-leaflet-map-maker/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/mapfig-premium-leaflet-map-maker/)
 * [Active Topics](https://wordpress.org/support/plugin/mapfig-premium-leaflet-map-maker/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/mapfig-premium-leaflet-map-maker/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/mapfig-premium-leaflet-map-maker/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [robwent](https://wordpress.org/support/users/robwent/)
 * Last activity: [7 years, 10 months ago](https://wordpress.org/support/topic/database-error-cant-create-map/#post-10538038)
 * Status: not resolved