vb.org Archive

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 02-18-2006 03:15 AM

If you have PHPMyAdmin, you can do it there.

Select your database, then find the table 'toplist_sites', then find the fields 'name' and 'description', you would need to change their type to text or something and leave the length field blank.

biagrin 02-18-2006 08:49 AM

how do i add more file extensions for it to accept such as .bmp etc

Frank Butcher 02-18-2006 10:08 AM

Stupid question but when it says upload the UPLOAD folder in the install instructions does that mean upload it in its entirety in one block and call the folder Upload or upload individual files to the already existing VBB directories ??

Frank Butcher 02-18-2006 10:41 AM

Whats happened here ? anyone ?

Frank Butcher 02-18-2006 10:54 AM

Ok ignore that part lol I have it sorted now but MAJOR stress time now

Every time I try and add a site it just comes up with



http://grandprixforum.com/forums/add_site.php
"This page cannot be displayed"

Anyone who has this program PLEASE tell me what I messed up

Delazar 02-18-2006 10:57 AM

Quote:

Originally Posted by derekivey
If you have PHPMyAdmin, you can do it there.

Select your database, then find the table 'toplist_sites', then find the fields 'name' and 'description', you would need to change their type to text or something and leave the length field blank.


Thanks derekivey

Frank Butcher 02-18-2006 11:05 AM

Uninstall time I guess :( it was a great idea but simply didn't work for me

Even if I manually try and add a site through another link it will not take me to the site

I guess my VBB is corrupted :(

Frank Butcher 02-18-2006 11:35 AM

This is the most stressful bloody day of my life !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


What does this mean ?


Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE `toplist_sites` ADD `status` VARCHAR( 20 ) DEFAULT 'active' NOT NULL AFTER `out`;;

MySQL Error : Duplicate column name 'status'
Error Number : 1060
Date : Saturday, February 18th 2006 @ 02:34:09 PM
Script : http://www.
Referrer :
IP Address : 80.3.32.7
Username : Administrator
Classname : vb_database

Frank Butcher 02-18-2006 11:39 AM

Does everyone hate me or something ????

Why is no one offering me any help :(

Jeez I am in such a state right now I would bloody pay for help !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Frank Butcher 02-18-2006 12:21 PM

I really want to get this program working, someone out there somewhere must know what is causing the errors and what I can do about them, I have had 11 attempts now at doing this, one of you people must know, please save me from despair and tell me why it is not installing properly and what is causing those database errors

KevinL 02-18-2006 12:46 PM

Quote:

Originally Posted by loonytune15
Umm like a box at the bottom of the page in which the admin can add through the admincp any images that the other sites can use for us.

eg this thread has all my buttons in it.
http://www.monster-designs.com/forum...ead.php?t=1048

So i'd like it to be shown in the toplist area...

On another note has the same error about the rankings been fixed in the toplist random site on the vbacmps been fixed?

Has this been added yet?

Ive read through the thread and didnt see any more about it.

Thanks

Frank Butcher 02-18-2006 02:35 PM

Anyone ?

Am still majorly struggling

derekivey 02-18-2006 02:44 PM

Hello Frank,

That error just means that it was trying to add a field to the database, and it already existed, you can ignore that error. If you want me to install this hack for you, PM me admin and ftp info to your site and I will be more than happy to install it for you.

Sorry I didn't respond earlier, I was still sleeping.

Derek

derekivey 02-18-2006 02:47 PM

Quote:

Originally Posted by KevinL
Has this been added yet?

Ive read through the thread and didnt see any more about it.

Thanks

Yes, I have added it, it shows when users add and edit sites.

Derek

Frank Butcher 02-18-2006 03:12 PM

Quote:

Originally Posted by derekivey
Hello Frank,

That error just means that it was trying to add a field to the database, and it already existed, you can ignore that error. If you want me to install this hack for you, PM me admin and ftp info to your site and I will be more than happy to install it for you.

Sorry I didn't respond earlier, I was still sleeping.

Derek

Hi Derek, thanks, PM on its way :)

derekivey 02-18-2006 04:33 PM

Hi Frank,

I have installed it for you. Let me know if you have any problems with it.

Thanks,
Derek

pbw 02-19-2006 03:10 PM

I recieved the same mysql errors as posted above. Even when i dropped the tables and fields the hack installed.

Now i recieve a division by zero error when attempting to view the toplist. I searched this thread and see similar was mentioned some time ago, https://vborg.vbsupport.ru/showthrea...vision+by+zero but i didnt find any duplicate entry in the xml.

Quote:

Warning: Division by zero in /toplist.php on line 190
Warning: Division by zero in /includes/functions.php on line 1827

Database error in vBulletin 3.5.1:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status='active' ORDER BY `in` DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064

-- pbw

derekivey 02-19-2006 09:05 PM

Quote:

Originally Posted by pbw
I recieved the same mysql errors as posted above. Even when i dropped the tables and fields the hack installed.

Now i recieve a division by zero error when attempting to view the toplist. I searched this thread and see similar was mentioned some time ago, https://vborg.vbsupport.ru/showthrea...vision+by+zero but i didnt find any duplicate entry in the xml.




-- pbw

Doesn't look like your settings got inserted. Can you PM me Admin info to your forum so I can take a look?

Thanks,
Derek

pbw 02-20-2006 03:17 AM

Sure, done.

derekivey 02-21-2006 01:58 AM

Did you send the info? I didn't get any PMs from you.

Derek

pbw 02-21-2006 09:55 AM

i sent a pm, and just now an email.. if for some reason you didnt recieve it let me know

thanks,

-- pbw

derekivey 02-21-2006 10:02 AM

Hey,

I got the email. I'll take a look at your site when I get home from school.

Thanks,
Derek

quanvo81 02-21-2006 12:03 PM

Hi there, can someone help me?
If a members add a site without uploading an images, then the button row show a red cross X, is it supposed to show "None" ?
How do I fix that problem?

derekivey 02-22-2006 03:17 AM

Hi,

It should say None. Can you please PM me a URL to your forum and admin details so that I can take a look?

Thanks,
Derek

quanvo81 02-22-2006 12:16 PM

Quote:

Originally Posted by derekivey
Hi,

It should say None. Can you please PM me a URL to your forum and admin details so that I can take a look?

Thanks,
Derek

I just did, please check your PM, thanks alot.

derekivey 02-22-2006 07:32 PM

Replied to your PM.

Derek

DementedMindz 02-26-2006 05:00 AM

having a few issues on getting the dynamic image to show up its showing up as this link for the image /images/toplist/buttons/dynamic/image.png?id=1 shouldnt it be /images/toplist/buttons/dynamic/image.png this way it shows the image? and if so where is this so i can fix it?

derekivey 02-26-2006 02:03 PM

No that is correct, it adds the id of the site to the url because it shows stats for that site such as their in and out hits, as well as their rank and rating.

Derek

DementedMindz 02-28-2006 11:27 PM

hmmm i can get the image to show at all how do i do that i have installed it all as it was told but it dont show any thoughts?

derekivey 03-01-2006 01:04 AM

Did you read this post? https://vborg.vbsupport.ru/showpost....&postcount=450

DementedMindz 03-02-2006 04:12 AM

no i didnt cause i havent been on here in a bit sorry, but maybe you should put then on install instructions too

derekivey 03-02-2006 11:43 AM

No Problem. I will put it on the install instructions also when I get home from school.

Derek

Sean James 03-02-2006 01:07 PM

i have just updated this script to the latest version, but when i edit the usergroup pemissions i get this error:

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`profileviewpermissions` = '15',
`forumpermissions` = '1044991',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions` = '203953795',
`genericoptions` = '30',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '150000',
`vbspacecomments` = '0',
`toplistpermissions` = '3'
WHERE usergroupid=2;

MySQL Error : Unknown column 'vbspacecomments' in 'field list'
Error Number : 1054
Date : Thursday, March 2nd 2006 @ 08:45:34 AM
Script : http://www.bluepearl-design.com/foru.../usergroup.php
Referrer : http://www.bluepearl-design.com/foru...&usergroupid=2
IP Address : xxx.xx.201.159
Username : Sean
Classname : vb_database
Thanks

yinyang 03-02-2006 04:13 PM

is there anyway to use this along with vbadvanced links directory? that'd pretty much make this thing complete!

DementedMindz 03-02-2006 05:44 PM

Quote:

Originally Posted by derekivey


i did as followed and when the images are shown after they add there site i still cant get it to show that image... any word what might cause this?

derekivey 03-02-2006 06:48 PM

Quote:

Originally Posted by Griffin80
i have just updated this script to the latest version, but when i edit the usergroup pemissions i get this error:



Thanks

Not sure why that is happening. Looks like the vbspace hack did something to your table or something.

Quote:

Originally Posted by yinyang
is there anyway to use this along with vbadvanced links directory? that'd pretty much make this thing complete!

Not sure how that works, so not currently. Maybe in the future I can implement something to work with it. I don't have money to buy a license of it so I can't try it out and make something. Sorry.

Quote:

Originally Posted by DementedMindz
i did as followed and when the images are shown after they add there site i still cant get it to show that image... any word what might cause this?

PM me the url to your forum, admin details, and FTP details so I can take a look at the image file.

Derek

Ramsesx 03-06-2006 09:12 AM

Upgraded from 1.02 to 1.06. uploaded files and imported product (overwrite on).
Get a lot of database errors had to do with buttons, was to quick for saving the errors exactly.
Now if I want to access the toplist I get the same error as on this post#524 and in the acp the buttons are red crossed.
I think need some help with it, thanks.

derekivey 03-06-2006 10:07 AM

For the error you say you get in Port 524, you have to go to the usergroup manager in vB's AdminCP and set the different toplist permissions for each of your groups. PM me admin info to your board, and I'll take a look at the 2nd problem you have.

Derek

Ramsesx 03-06-2006 12:06 PM

Thanks Derek. So far it is now ok, I reuploaded the images. But now if I want to add a new site get the error:
Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG
etc.
If adding the site through the acp it's working fine.

derekivey 03-06-2006 06:59 PM

What format image were you trying to add to the site?


All times are GMT. The time now is 09:34 AM.

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.01884 seconds
  • Memory Usage 1,831KB
  • 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
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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