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)

chriszep 04-25-2006 08:38 AM

hello when I upload product-toplist.xml

i have this
Quote:

atabase 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 : Tuesday, April 25th 2006 @ 11:36:24 AM
Script : http://www.xxxxxxxxxxxxxx.com/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums...?do=productadd
IP Address : xxxxxxxxxxxxxxxxxxx
Username : xxxxxxxxxxxxxxxxxxxxxxxx
Classname : vb_database
Thanks

derekivey 04-25-2006 09:49 AM

Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

Ramsesx 04-25-2006 11:36 AM

Quote:

Originally Posted by derekivey
Are you running the latest version (1.0.7) of my hack? It looks like you are missing the views field. If you are not upgraded yet, please upgrade, but if you did, just execute this query in vB's admincp or PHPMyAdmin.
[sql]ALTER TABLE `vb3_toplist_sites` ADD `views` INT( 25 ) UNSIGNED NOT NULL;[/sql]

Derek

Sorry, you're right I don't have the latest version.
One wish for a next version, could you make an option for disabling the rating system because I have some user rating the concurrent sites bad.
Thank you

derekivey 04-25-2006 06:49 PM

Sure, I will add that option. I might also add a banning option.

Derek

cat4m 04-26-2006 01:14 AM

I keep getting this error when I try to add an image to the site :
Warning: getimagesize(/home/lovespir/public_html/loveforum/images/toplist/buttons/sites/trcv75d4FUtp179je4ne): failed to open stream: No such file or directory in /admincp/toplist_admin.php on line 393
Can anyone help at all. I have been looking through the thread but cant find anything that works. Thanks in advance.

derekivey 04-26-2006 09:53 AM

Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).

chriszep 04-27-2006 09:08 AM

Quote:

Originally Posted by derekivey
Try removing that query from the install code in the XML file and try reimporting it again, or if there are no sites on your toplist yet, you can drop all of the toplist_* tables and reimport.

Derek

ok I made it but another error with duplicate
Quote:

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 : Thursday, April 27th 2006 @ 12:07:11 PM
Script : http://xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://xxxxxxxxxxxxxxxxxxxx/forums/a...?do=productadd
IP Address : xxxxx
Username : Cxxxx
Classname : vb_database
how to uninstall everything in the data base ?

derekivey 04-27-2006 10:05 AM

You have to use PHPMyAdmin to remove all the toplist_* tables, and there is a field in the usergrouppermissions table.

Derek

cat4m 04-28-2006 04:48 PM

Quote:

Originally Posted by derekivey
Make sure the /images/toplist/buttons/sites folder exists and is writable (chmod 777).


How do I make it writable ? And what is chmod 777 ? Sorry I dont know much about this. Everything else is working but the image picture.

derekivey 04-28-2006 06:41 PM

There should be a feature in your FTP program to let you give it write permissions. If you can't find it talk to your webhosting provider. They should be able to help you out.

Derek


All times are GMT. The time now is 05:06 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.01803 seconds
  • Memory Usage 1,745KB
  • 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