Quote:
Originally Posted by zentz
users cant add site to the toplist, i get these errors:
Database error in vBulletin 3.6.4:
Invalid SQL:
SELECT `email` FROM user WHERE `userid` IN(my@email.com);
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 '@email.com)' at line 1
Error Number : 1064
Date : Friday, February 9th 2007 @ 09:39:31 AM
Script : http://www.site.com/add_site.php
Referrer : http://www.site.com/add_site.php
IP Address : 89.172.69.96
Username : Admin
Classname : vB_Database
Any ideas?
Also how do i check what toplist version do i currently run?
|
It sounds to me that you entered an email address in for the setting that lets you set who receives an email when a site needs verified. You need to enter a
user ID (not username or email).
Quote:
Originally Posted by DementedMindz
|
Sorry, I've been too busy to take a look. I will get to it ASAP.
Quote:
Originally Posted by Spike Saunders
#1 - Is there anyway that this can be edited to include TWO fields to be filled out for the url, instead of one? The first one being the location of the page that the CODE will appear on. And the second one, being the actaul website's url? I know too many sites that have a Affiliate page, and link to their homepage instead. I would like to fix this so that the code is found on one page while the site themselves in the Toplist will link to the URL specified.
|
That is currently not a feature, but thanks for the suggestion. I will add it to my todo list for the next version.
Quote:
Originally Posted by Spike Saunders
#2 - My forum seems to have an issue with the Redirect from another Site. Basically if you go to one of the sites that have the link back, it goes into a redirect loop while trying to access my site. This repeats indefinitely. However, it does still count the IN link, if you stop or hit back or something to escape the loop. Is there a fix for this? My forum is the most recent version. You can see th is for yourself at ( http://www.community.edubn.com/toplist.php) - I understand if the url is removed by a moderator, and if that is the case, that is fine. But I don't mind people checkin it out, you do not have to register, as guest are allowed to view the sites.
|
You probably did not set the In URL setting. Please edit the settings for the script and enter the URL where you want them to be redirected to when they click an In link. Usually people enter the URL to their homepage or the URL to their forums, it's up to you.
Quote:
Originally Posted by Spike Saunders
#3 - In Firefox ther eseems to be issues with the SITES showing on the main forum page. Sometimes they will be split in half and only the top part of the images will show. Kind of wierd. But Firefox issue as IE does not do it.
|
I'll take a look and see if it can be fixed.
Thanks,
Derek