@Poremsky.com

Tips & Tricks for Windows, Office, and Whatever

  • Home
  • Windows
  • Office
  • BlackBerry
  • Web Design
  • WordPress
  • Internet Explorer

Yourls: Can't add new urls to database (endless spinner)

Published on April 27, 2012

Yourls url shortening service I've been using an older version of Yourls for a few years. I tried to upgrade to v1.5 a few times but always hit a problem with adding new URLs to the database: it acts like it's adding the URLs but really doesn't Sometimes the 'thinking' icon spins forever, other times it says it completed but the URL does not work and refreshing the screen erases the new entry.

I was able to edit existing records and I could add records directly, using MySQL GUI. I just couldn't add new URLs using the interface.

I found various hacks around the Internet that was supposed to fix it but nothing worked. I'm not using a cheap host, the site is self-hosted on a Windows 2008 server I'm an admin on.

When I tried to add more URLs tonight, using a newer MySQL GUI, it wouldn't let me paste all the rows at once. 🙁 In fact, it wouldn't let me insert any records as it had the database marked read only, due to the lack of a primary key. I tried making the keyword column the primary key but the site stopped working. Oops.

That got me to thinking… was the primary key the problem and would it work correctly if I made a new data base? I had the data in a CSV file, so rebuilding the database wasn't an issue. The answer: I can now add new records. Adding URLs is slower than with the older version of Yourls… but the URL is added and it works, I don't add new URLs to this database all that often anyway.

** It's slower because it has a title field and goes out to the long URLs page to get the title. It looks nice… I might upgrade my other 2 Yourls sites.

Share this:

  • Facebook
  • LinkedIn
  • Twitter
  • Print
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments

Recent Posts

  • Server drafts location is not valid error message
  • What is the Brown File Box Icon on Files in Windows 11?
  • Remove Office Licenses from Windows
  • Add the Recent Items Folder to Windows 10 Quick Access
  • A New Scam? Cashing in on Kohl's Cash

Recent Comments

  • FUAD on Remove Office Licenses from Windows
  • Brian DuBridge on Add the Recent Items Folder to Windows 10 Quick Access
  • Renee Moodie on Remove Office Licenses from Windows
  • John P on Remove Office Licenses from Windows
  • Puja on Remove Office Licenses from Windows
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

© 2023 · @Poremsky.com

wpDiscuz
Go to mobile version
You are going to send email to

Move Comment