Title: WordPress database errors / apostrophes
Last modified: July 13, 2017

---

# WordPress database errors / apostrophes

 *  Resolved [FriendlyWP](https://wordpress.org/support/users/mmcginnis/)
 * (@mmcginnis)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-errors-apostrophes/)
 * Hi, I have some users that can’t seem to remember not to put apostrophes in the
   PrettyLink shortened-url slug, and PrettyLink itself does not strip them out.
   In my PHP Error log I’m seeing database errors like this, for shortened links
   where an admin manually created a shortlink like this: [http://myurl.com/EasyDIYChildren’sBoookmarks](http://myurl.com/EasyDIYChildren’sBoookmarks)
 * `[13-Jul-2017 04:59:01 UTC] WordPress database error 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 'sBookmarks' LIMIT 1' at line 1 for query SELECT*
   FROM wp_nato_prli_links WHERE slug='EasyDIYChildren'sBookmarks' LIMIT 1 made 
   by require('wp-blog-header.php'), require_once('wp-load.php'), require_once('
   wp-config.php'), require_once('wp-settings.php'), do_action('plugins_loaded'),
   WP_Hook->do_action, WP_Hook->apply_filters, PrliAppController->redirect, PrliAppController-
   >link_redirect_from_slug, PrliUtils->track_link`
 * Can you fix it so that users aren’t allowed to put apostrophes (or anything but
   dashes/letters/numbers I guess) in the slug field?
 * Thanks!

Viewing 1 replies (of 1 total)

 *  Plugin Author [cartpauj](https://wordpress.org/support/users/cartpauj/)
 * (@cartpauj)
 * [8 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-errors-apostrophes/#post-9326792)
 * Thank you for the information. I have added this to our bug tracker to be addressed
   soon.

Viewing 1 replies (of 1 total)

The topic ‘WordPress database errors / apostrophes’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [cartpauj](https://wordpress.org/support/users/cartpauj/)
 * Last activity: [8 years, 10 months ago](https://wordpress.org/support/topic/wordpress-database-errors-apostrophes/#post-9326792)
 * Status: resolved