Well, it seems that the version isn't the issue, just the upgrade process could have caused it... here is the MySQL error I get when importing the product (aka it shows this when I click on "Import" and doesn't import the product)
Quote:
Database error in vBulletin 3.5.3:
Invalid SQL:
show tables like ghf_'sl_shout';
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 'ghf_'sl_shout'' at line 1
Error Number : 1064
Date : Tuesday, February 14th 2006 @ 10:00:30 PM
Script : http://forums.xxxxxxxxxxxxx.com/admincp/plugin.php
Referrer : http://forums.xxxxxxxxxxxxx.com/admi...?do=productadd
IP Address : 69.10.160.68
Username : Otikeu
Classname : vb_database
My MySQL version is 4.1.14-standard. It works on a test board of vB 3.5.3, but won't work on my upgraded board of 3.5.3...
And then use $username in the rest of the code instead of $vbulletin->userinfo['username'].
It would be great if you could add a fix similar to this to your codebase. So I (and probably others) won't have to take care for the future. It also enhances your security. Someone might be able to inject SQL by using a malformed username or something. I think it's not trivial or maybe not even possible, but why not going the safes way?!
Otikeu: I had the same. Just change the statement in the xml to: show tables like 'sl_shout'.
But do this with care and only if you're sure the [yourprefix]sl_shout table is not existing already in your db. This is a nasty workaround to get it running, but it works.
Otikeu: I had the same. Just change the statement in the xml to: show tables like 'sl_shout'.
But do this with care and only if you're sure the [yourprefix]sl_shout table is not existing already in your db. This is a nasty workaround to get it running, but it works.
Aw, yes that is what I thought, but wasn't too sure on what to do. However, I was gonna backup my database and then do that, but now that you've confirmed, I'll proceed with it heh. Thank you for the help, I'll post what the results are.
while i try to importing the product it appear to error. this is what the program noticed>>>
Does anybody can tell me what happened with this? and what should i do to install it please..... :ermm:
Same issue as I had, check the posts on this page.
Also, what file do I edit to modify Chatbox templates? Cause, I wanna take out the input text field so it doesn't auto refresh... and just customize it some more. Also, maybe for the next release, a /emote system? I can give you a list of good ones.
It's obvious that this mod is made for a lighter skin, if you have a dark skin then you cannot see the button letter's or the text people put into the box. I like this, a bit better than vbshout to be honest as it's much lighter on the db. If someone could tell me how i could change the font colors of the buttons and box text, i would be most happy.
It's obvious that this mod is made for a lighter skin, if you have a dark skin then you cannot see the button letter's or the text people put into the box. I like this, a bit better than vbshout to be honest as it's much lighter on the db. If someone could tell me how i could change the font colors of the buttons and box text, i would be most happy.
The colors depend on your vBulletin's CSS customizations. It works on my dark layout.
You can check the coding, etc, through the chatbox_lite.php file.
WARNING! Basic PHP knowledge required.
Chatbox Lite Details »»
About Developer
DB Changes 
No support by the author.
02-15-2006, 01:02 AM
It's running fine now in my brandnew vBulletin installation @http://www.celica-community.de
