Title: Can’t create links WordPress Database Error Last modified: February 25, 2020 --- # Can’t create links WordPress Database Error * Resolved [solarblitz77](https://wordpress.org/support/users/solarblitz77/) * (@solarblitz77) * [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/) * We have just tried to add a link to our pretty links control panel, it displayed Link created, when I tried to test the link, it failed, so I looked at the error log * And i notice the below error * > WordPress database error Unknown column ‘sponsored’ in ‘field list’ for query > INSERT INTO `wp_prli_links` (`redirect_type`, `url`, `slug`, `name`, `description`,` > group_id`, `nofollow`, `sponsored`, `param_forwarding`, `track_me`, `link_cpt_id`,` > updated_at`, `created_at`) VALUES (‘307’, ‘[https://www.mackrell.com/’](https://www.mackrell.com/’);,‘ > mackrell-Landlord-laywers-mpu’, ‘Mackrell – 02-20 – MPU’, ”, NULL, ‘0’, ‘0’,‘ > 0’, ‘1’, ‘26643’, ‘2020-02-25 17:07:03’, ‘2020-02-25 17:07:03’) /* From [residentiallandlord. > com/wp-admin/post.php] in [/nas/content/live/rlcom/wp-content/plugins/pretty- > link/app/models/PrliLink.php:68] */ made by edit_post, wp_update_post, wp_insert_post, > do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController- > >save_cpt_link, PrliLink->create, referer: [https://residentiallandlord.com/wp-admin/post-new.php?post_type=pretty-link&wp-post-new-reload=true](https://residentiallandlord.com/wp-admin/post-new.php?post_type=pretty-link&wp-post-new-reload=true) * Can you shed any light on how i fix this, I have tried de-activating and re-activating the plugin. * We are only running th basic version. Viewing 4 replies - 1 through 4 (of 4 total) * Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/) * (@cartpauj) * [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/#post-12479086) * It sound like the database upgrade script didn’t run successfully after the last update. * Do you have access to your database via phpMyAdmin or something similar? * If so, or if your webhost can help, do the following find these rows in `wp_options` table and set them all to `1` * `prli_db_version` `prlipro_db_version` `prli_version` * After they’ve been set to `1` visit your wordpress dashboard and refresh it. * That should force the database upgrade script to run again and hopefully will fix this error. * Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/) * (@cartpauj) * [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/#post-12479089) * If you’re using the free version of Pretty Links, then you won’t have the `prlipro_db_version`. So just the other two will need to be updated. * Thread Starter [solarblitz77](https://wordpress.org/support/users/solarblitz77/) * (@solarblitz77) * [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/#post-12486527) * I have just tried that, and the prli_version change the option_value to 3.1.0 after the refresh how ever, the pri_db_version remained at 1. * Is there another way to force the database to upgrade * As after it displayed the pretty-link-update, I tried to add a new link and got the following error * > [Thu Feb 27 11:11:35.130816 2020] [php7:notice] [pid 21995] [client 86.137.62.130: > 31820] WordPress database error Unknown column ‘sponsored’ in ‘field list’ > for query INSERT INTO `wp_prli_links` (`redirect_type`, `url`, `slug`, `name`,` > description`, `group_id`, `nofollow`, `sponsored`, `param_forwarding`, `track_me`,` > link_cpt_id`, `updated_at`, `created_at`) VALUES (‘307’, ‘[https://www.mackrell.com/’](https://www.mackrell.com/’);,‘ > mackrell-Landlord-laywers-mpu’, ‘Mackrell – 02-20 – MPU’, ”, NULL, ‘1’, ‘0’,‘ > 0’, ‘1’, ‘26655’, ‘2020-02-27 11:11:35’, ‘2020-02-27 11:11:35’) /* From [residentiallandlord. > com/wp-admin/post.php] in [/nas/content/live/rlcom/wp-content/plugins/pretty- > link/app/models/PrliLink.php:68] */ made by edit_post, wp_update_post, wp_insert_post, > do_action(‘save_post’), WP_Hook->do_action, WP_Hook->apply_filters, PrliLinksController- > >save_cpt_link, PrliLink->create, referer: [https://residentiallandlord.com/wp-admin/post-new.php?post_type=pretty-link&wp-post-new-reload=true](https://residentiallandlord.com/wp-admin/post-new.php?post_type=pretty-link&wp-post-new-reload=true) * Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/) * (@cartpauj) * [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/#post-12487821) * Pretty Links runs the database script automatically when the /wp-admin/ is loaded if the prli_db_version is < the current db version. * Since it remained at 1 after you changed it, it sounds like an error is happening when the database script is running (different error than the above). * See if your webhost can check the database error logs for your site concerning pretty links (prli) and see if there’s any other errors. Viewing 4 replies - 1 through 4 (of 4 total) The topic ‘Can’t create links WordPress Database Error’ is closed to new replies. * ![](https://ps.w.org/pretty-link/assets/icon-256x256.png?rev=2503434) * [PrettyLinks - Affiliate Links, Link Branding, Link Tracking, Marketing and Stripe Payments Plugin](https://wordpress.org/plugins/pretty-link/) * [Frequently Asked Questions](https://wordpress.org/plugins/pretty-link/#faq) * [Support Threads](https://wordpress.org/support/plugin/pretty-link/) * [Active Topics](https://wordpress.org/support/plugin/pretty-link/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/pretty-link/unresolved/) * [Reviews](https://wordpress.org/support/plugin/pretty-link/reviews/) * 4 replies * 2 participants * Last reply from: [cartpauj](https://wordpress.org/support/users/cartpauj/) * Last activity: [6 years, 3 months ago](https://wordpress.org/support/topic/cant-create-links-wordpress-database-error/#post-12487821) * Status: resolved