vb.org Archive
Page 97 of 159 « First 47879596 97 9899107147 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Toplist (https://vborg.vbsupport.ru/showthread.php?t=98646)

derekivey 07-23-2006 02:21 PM
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

Lena Starling 07-23-2006 03:19 PM
The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

Izza 07-23-2006 06:52 PM
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

derekivey 07-24-2006 01:26 AM
Quote:
Originally Posted by Lena Starling
The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?
Execute the following code in PHPMyAdmin...

[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:
Originally Posted by Izza
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
Looks like the product installer didn't add the column to the usergroup table.

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

Izza 07-24-2006 07:56 AM
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'

derekivey 07-24-2006 03:20 PM
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

Izza 07-24-2006 06:40 PM
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/

Dj. Gargamel 07-25-2006 06:26 AM
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 ??

derekivey 07-25-2006 01:09 PM
Quote:
Originally Posted by Izza
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.

http://www.iz-grafix.co.uk/mt/arcadepermissions.gif
Don't worry about indexes... Click structure at the top to see if they are there.

Quote:
Originally Posted by Dj. Gargamel
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 ??
Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

Dj. Gargamel 07-25-2006 03:23 PM
Quote:
Originally Posted by derekivey
Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek
It would be perfect -
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


All times are GMT. The time now is 04:28 AM.
Page 97 of 159 « First 47879596 97 9899107147 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02219 seconds
  • Memory Usage 1,758KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete