Title: Static hyperlink
Last modified: January 17, 2022

---

# Static hyperlink

 *  Resolved [Andrzej Klasén](https://wordpress.org/support/users/bibeldans/)
 * (@bibeldans)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/static-hyperlink/)
 * I have two problems.
    1. Changing Column Type to Hyperlink wipes out data in 
   that column. 2. “ERROR: Saving changes to database failed” while saving Hyperlink.
   PS. I’m not using Dynamic hyperlinks: [https://wpdataaccess.com/pricing/](https://wpdataaccess.com/pricing/)
   WP Data Access Free Version 5.1.1
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fstatic-hyperlink%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/static-hyperlink/#post-15261979)
 * Hi Andrzej,
 * Welcome to WP Data Access! 😊 Let’s try to fix these issues…
 * >>> 1. Changing Column Type to Hyperlink wipes out data in that column.
 * This is usually the result of incorrect table settings. The plugin supports two
   different formats for hyperlinks: JSON and plain text. The JSON format is the
   default. It is meant to support additional hyperlink tag attributes. When your
   hyperlink is stored as plain text, you just need to change the hyperlink format
   in table settings so the plugin knows it has to handle these hyperlinks differently.
   To change this settings:
    – Start the Data Explorer – Click on the “Manage” link
   of your table – Open tab “Settings” – Click “Table Settings” – Set “Process hyperlink
   columns as” to Plain text – Save your settings
 * >>> 2. “ERROR: Saving changes to database failed” while saving Hyperlink.
 * When you change the settings mentioned above (1.) this error will most probably
   disappear as well.
 * Can you please try this and let me know if it works?
 * Thanks,
    Peter
 *  Thread Starter [Andrzej Klasén](https://wordpress.org/support/users/bibeldans/)
 * (@bibeldans)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/static-hyperlink/#post-15272636)
 * Yes, it did the trick!
 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 4 months ago](https://wordpress.org/support/topic/static-hyperlink/#post-15272777)
 * Great! 😊

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

The topic ‘Static hyperlink’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [hyperlink](https://wordpress.org/support/topic-tag/hyperlink/)

 * 3 replies
 * 2 participants
 * Last reply from: [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * Last activity: [4 years, 4 months ago](https://wordpress.org/support/topic/static-hyperlink/#post-15272777)
 * Status: resolved