![]() |
If you just transfered everything, you shouldn't have to reinstall the Toplist itself. If you want to do a fresh install, just delete the product, and delete any Toplist_ tables that vB's product manager left, and import the XML file again to install.
Derek |
The hack was actually uninstalled during the move, it's just those tables stuck around...
How do I remove the tables? |
After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column. I have set the toplist up on our test site which works flawlessy . Any ideas whats going wrong? the database error I get is Database error in vBulletin 3.5.4: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Administrators', `description` = '', `usertitle` = 'Administrator', `opentag` = '<span style=\"color: red;\">', `closetag` = '</span>', `passwordexpires` = '0', `passwordhistory` = '0', `forumpermissions` = '1048575', `attachlimit` = '5000000', `pmquota` = '500', `pmpermissions` = '3', `pmsendmax` = '5', `calendarpermissions` = '63', `wolpermissions` = '31', `adminpermissions` = '3', `genericpermissions` = '205520831', `genericoptions` = '31', `profilepicmaxwidth` = '120', `profilepicmaxheight` = '150', `profilepicmaxsize` = '200000', `avatarmaxwidth` = '120', `avatarmaxheight` = '150', `avatarmaxsize` = '200000', `toplistpermissions` = '1' WHERE usergroupid=6; MySQL Error : Unknown column 'toplistpermissions' in 'field list' Error Number : 1054 Date : Sunday, July 23rd 2006 @ 08:48:09 PM Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php Referrer : http://www.iz-grafix.co.uk/forums/ad...&usergroupid=6 IP Address : ******** Username : ******** Classname : vb_database |
Quote:
[sql]DELETE TABLE IF EXISTS toplist_categories; DELETE TABLE IF EXISTS toplist_clicks; DELETE TABLE IF EXISTS toplist_ratings; DELETE TABLE IF EXISTS toplist_reports; DELETE TABLE IF EXISTS toplist_sites;[/sql] If you have a table prefix, don't forget to add that to each of the lines above. After that has been done, reinstall the Toplist hack and let me know if you have anymore problems. Quote:
Execute the following SQL in PHPMyAdmin. [sql]ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;[/sql] Be sure to add your table prefix to that if you have one. Derek |
Thanks for the quick reply though it didn't fix my problem.
After running the query I got this error Error SQL query: ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ; MySQL said: #1060 - Duplicate column name 'arcadepermissions' |
Hmm, thats weird. Can you open PHPMyAdmin, and see if there are two columns called arcadepermissions, and see if the toplistpermissions column is there at all?
Thanks, Derek |
I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.
What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not. https://vborg.vbsupport.ru/ |
Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record
we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ?? |
Quote:
Quote:
Derek |
Quote:
I would like to ask how is views ranking method counted - is it summary of in out and views ?? thanks again for such fantastic support |
How do I change the look of the list? I want to remove the in and the out column?
|
why are the words "Delete Site ]" showing up in my description? I am not logged in and unregistered users can't delete listings
|
It works but I get this error at the top of the forum:
Quote:
|
Quote:
Quote:
Quote:
Quote:
|
Quote:
|
Quote:
|
derek i just thought of something that might be nice... say you dont allow buttons or banners on your toplist via admincp maybe have it where when you shut that setting off and it will shut it off on addsite cause if you shut it off right now it still shows on addsite... also whats the biggest banner size you would recommend?
|
I will add that to the next version. I recommend small banner sizes because if you did big ones, you would probably have to modify the templates so they would fit better, but the size is entirely up to you.
Derek |
Quick question. I have the marquee at the bottom of the forum right now and I have two questions. Is there a way to make it when someone clicks on one of the banner's at the bottom that it'll open the link in a new window instead of the same one and is there a way to change the text right above the marquee that says "Toplist Sites:" to something unique?
Thank you again, it's working great for me. |
1) Yes, edit the Toplist_Forum_Home template (I think it's called that).
2) Yes, search for that phrase in vB's phrase manager and put something in for the English translation field. Derek |
Hi can you help me?
i get this error: Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/www1/rechner2/wwwneu/vbulletin/toplist.php(555) : eval()'d code on line 54 Line 54 is: <if condition="$sr['votes'] == 1"> it?s the original Temlate vB Ver. = 3.5.3 |
Quote:
|
Quote:
|
Sorry wrong template... The template you need to edit is Toplist_Sites_Code.
Find: PHP Code:
PHP Code:
Derek |
BTW guys, When I release the next version, I will have it for 3.5 and 3.6.
Derek |
Quote:
|
No Problem :).
|
Quote:
*adds it to the list ________ Toyota TF106 history |
You should be able to use the current version on 3.6, I haven't found any problems so far.
Derek |
Quote:
|
Nevermind, fixed.
|
Quote:
|
Quote:
|
I am having problems with images displaying for toplist.All the settings appear to be correct but they wont display,also my avatars are not displaying as well.Any help would be much appreciated.
|
I have a suggestion for the next release..
On the Forumhome where it says "Toplist:" , can we have after that how many sites are in the toplist, and have the word toplist, able to be linked to the toplist? |
Great modification Derek! Works perfectly, and can't wait for the next versions!
|
Quote:
Quote:
Quote:
|
ok here are my problems: I did a fresh install and this is what is happening:
1. View my toplist 2. when a registered user ads a ad.....how do they edit it? (i hve permissions set that they can edit) what do i do? |
What happens when they try to edit? Or is the link not showing?
|
the link is not showing
|
All times are GMT. The time now is 10:06 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|