Database error in vBulletin 4.0.0:
Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;
MySQL 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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Thursday, December 24th 2009 @ 05:08:50 AM
Error Date : Thursday, December 24th 2009 @ 05:08:51 AM
Script : http://localhost/support.php?do=replyticket&ticketid=
Referrer : http://localhost/support.php
IP Address : 192.168.1.100
Username : valendono
Classname : vB_Database
MySQL Version : 5.1.37
when ticket already closed and admin wanna see again in Techmenu >> Tickets ToDo >> Closed Filter and click on Title ticket and that happen...
Was able to duplicate this bug. Hopefully we can find a way to fix it.
I also had to uninstall. I got database errors when I tried to add FAQs and there just seems to be too many issues at this time to have it on my live site.
Once this comes out of Beta I'll be interested. Until then it's just too many headaches.
This message hasn't any meaning of complaining for anything, neighter that I'm apologizing, but I want to make clear some things, that I thought to be self explained.
I know how sad is for anybody, to uninstall a module that he found usefull due to bugs. But believe me, I'm feeling also sad, as it means that I lost my attention somewhere and I brought-up a bug.
If you click on the word "Coder" beside my nickname, you'll see that in a duration of just 10 days since the Gold release of vB4, I've released 2 full mods, 1 addon and 6 ...toys (widgets), while other (commercial) coders have disappeared.
Since Oct 2006, when I released my first free mod, I've released more than 20. For all this work, I got from here just 2 donation at a total of $45. What it means? Simple that I've my own job, for which I need to take care if I want to have the money to live. And because my job is not a 9am-5pm job (I've a Travel Agency office), sometimes I need to spend more than 10 hours a day for it.
Coding is my hobby. I was working for my mods, even on Christmas day (to release microMEMBERS) and I met the new year's eye infront of my PC to release microAUCTIONS.
What I was expecting in exchange? Something very simple, something that everybody expects when is giving a gift. A simple thank you and understanding if my gift dosen't meets your expectations.
Don't know how you use to do in your countries, but in Greece we use to thank for the gift, and later if we find it usefull we use it, otherwise we let it at the back without to use it, but always feeling good for the person who gave us it. We don't drop it on his face, saying: "What bulshit is this...". This is humanity, this is civilazation.
I'm really sorry if this post makes some of you to feel uncomfortable, but I had to blow-out what was pressing my mind and my heart.
My warmest wishes to follow you and your beloved, for a happy, healthly and prosperous new year.