A Delicious Revenge
December 6th, 2005 • Geeking Out / Goodies / MySQLicious / Software
Believe it or not, there’s actually a new MySQLicious! However, it’s really pretty much identical to the old MySQLicious. All I’ve done is fixed the $this->$newline bug mentioned by Richard and clarified the licensing, as suggested by Walter. Additionally, the FAQ has been updated.
There seems to be an outstanding bug where sometimes MySQLicious erroneously mirrors all bookmarks instead of those for a selected tag. Then on the next mirroring, it corrects itself. I haven’t done any debugging yet to figure out if this is a del.icio.us issue or a MySQLicious bug.
I’ve also had one report of issues with certain characters that I have yet to reproduce, and I haven’t seen the errors caused by a missing notes field either. Any help in tracking these down would be appreciated.
Oh, and the title of this entry? I was looking for synonyms to “delicious,” and “a delicious revenge” was in the definition. It was far too delicious to pass up.
♫ Mylo vs. Black Eyed Peas - Felix Drops The Humps
Follow this discussion
Jukka-Pekka Keisala
February 9th, 2006 at 3:35 am
My hosting just update PHP on the server to version 5 and script stopped to work.
I am getting error on mirror.php:
!/usr/bin/php -q
Fatal error: Cannot access empty property in {path}/MySQLicious.php on line 219
Kr0n
February 22nd, 2006 at 7:09 pm
Hello, and first of all thanks for your time implementing MySQLicious!
I've realized that posts with special characters (those as tildes, aposthrophes, and so on) are not inserted properly in the database.
My solution to this, is:
- In the CREATE statement for the delicious table, I added "DEFAULT CHARSET=utf8" at the end.
- In all the INSERT and UPDATE statements to the delicious table, added "_utf8" preceding the field value, in my case "description" and "extended".
E.g. INSERT INTO
delicious(… ,description, …) VALUES (…, _utf8'', 'some description', …)More info: dev.mysql.com
Thanks again for your time!
Kr0n
BillyG
May 4th, 2006 at 1:43 pm
Hi. I've had this shortcut on my desktop for many weeks and finally got around to installing it yesterday, thx so much.
I probably have something setup wrong but I sure haven't found it yet. I am using the same server address name as another DB that I have setup on the same server (actually thru Y! Hosting) and even though I am looking at the other DB's tables thru phpMyAdmin right now, I keep getting this message when runnng mydomain.com/MySQLicious/mirror.php: Could not connect to MySQL server.
After the first time, I went ahead and manually created the database and ran the script again but still no luck.
For all the config stuff at the top of the mirror file, I used exactly the same info that my phpMyAdmin config file has (which again, I'm looking at those tables inside phpMyAdmin right now so I know that info is correct) with the exception of the DB name. For this, I used a new name and then manually created it also after the first mirror attempt. I also edited in my del.icio.us UID & PW of course. Any ideas? TIA.
Walter Cruz
March 21st, 2007 at 11:01 pm
I have ported the MySQLicious to PostgreSQL (using the PEAR:MDB2). :)