« Subscribe to Comments | Main | Firefox Network Pipelining 2: more info »

My Visitors List

By maurizio | April 10, 2007

If you are new here, you may want to subscribe to my RSS feed. Feel free to leave comments and questions too.Thanks for visiting!

Today I’ve corrected some idiotic bugs on My Visitors list project. No one is really caring, because no one noticed that the list on my blog didn’t update even if you registered! I even added the possibility to have a 40×40 picture of yourself there. Right now I am not showing it, because mylist.php works only on icon mode.But if you add your picture and do not modify “icons” setting, you’ll see a small 16×16 thumbnail of your bigger picture! :)
I still have to make possible to modify this option AND decide whether to use icons or the small thumbnail pic.

The most boring thing I have to do to this project are the “edit profile” pages. You could modify something right now, but I think it will not save, or if it saves you will screw up your stuff. Better to write me instead :)
I even have to add some email notification for the newly registered users.

Btw.. I have only 2 registered users (apart for my 10 test users), but both of them doesn’t use my widget/plugin yet. Be the first to test it on your page and I will give you a lot of backlinks from my blog posts and from all visitors.nafurai.com pages!

1. MySql tip #1: if you see something like:
   Truncated incorrect DOUBLE value: 'aaa'
   read carefully your code. I wrote something like that:
   UPDATE bla SET x='aaa' AND y='bbb' WHERE x=1;
   If you are a bit distracted like me, it will take a dozen of minutes or more to discover that the problem is simply a grammar error. Sql “UPDATE” command doesn’t use “AND”, but commas
   UPDATE bla SET x='aaa' , y='bbb' WHERE x=1;

2. MySql tip #2: use mysql from a shell if you want some serious tests. The previous error wasn’t visible inside phpMyAdmin.The only thing you see there is a “0 rows affected”, while if you try it on a shell, “0 rows affected, 1 warnings”. Then you just have to write:
   show warnings;
   to discover what is the error.

If you don’t understand a word of what I just said, write me a comment and I’ll start some very easy lessons/posts on databases. When I have to explain something difficult I tend to use some very easy example without using any technical language. Then if you need something more technical, I’m sure you’ll find plenty of example on the net.

Time to sleep now.

Share This

Topics: Content Creation, Programming |

Read other related posts:

Comments