vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Administrative and Maintenance Tools - vb Linkchecker Bot 1.1 (https://vborg.vbsupport.ru/showthread.php?t=190407)

Vaupell 01-31-2009 12:09 PM

Quote:

Originally Posted by Floris (Post 1617965)
The vB product can run these queries, and takes table prefix into account.

i do admin work on 6 different vb boards, ive seen the query area
but none of them allow me to run query's

agree with poster, i also use phpmyadmin,
dont know why it dosent work, but hay dont need it.:up:

Tuga?? 02-03-2009 07:21 PM

Hi any help with this error ?

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT graveyard, graveyard_id, pmUID, pmUNA, acheck, alast, pmSub, pmMsg FROM dlc_config LIMIT 1;

MySQL Error  : Table 'tugateaf_forum.dlc_config' doesn't exist
Error Number  : 1146


Slugger00001 02-03-2009 08:35 PM

Quote:

Originally Posted by Vaupell (Post 1729869)
i do admin work on 6 different vb boards, ive seen the query area
but none of them allow me to run query's

agree with poster, i also use phpmyadmin,
dont know why it dosent work, but hay dont need it.:up:


in config.php you have to put your user id to allow yourself to run quarys from admincp

Tuga?? 02-03-2009 08:45 PM

Onother error wen try to run query

Quote:

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 'ALTER TABLE `thread` ADD `ignore_check` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER ' at line 2

dxflw 02-06-2009 10:26 PM

db error

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                SELECT
                        userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                       
                FROM user AS user
                LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
                LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
               
                WHERE user.userid = 1797;

MySQL Error  : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, February 16th 2009 @ 10:33:46 AM
Error Date    : Monday, February 16th 2009 @ 10:37:55 AM
Script        : http://******.net/forum/vbbot.php?method=all
Referrer      : http://******.net/forum/vbbot.php
IP Address    : 79.103.214.217
Username      : ^^freakos^^
Classname    : vB_Database
MySQL Version :


IIAnDoII 02-07-2009 12:57 PM

momo2 i have the same problem can any 1 help

http://g.imagehost.org/0219/Untitled-1.png

Jibba Jabbas 02-11-2009 10:54 PM

Great mod and apologies if already asked. But what I am curious about, is it possible to have the bot just make a new post saying that the link is dead rather than move the thread all together? Or better yet, not even make a post but just add at the bottom of the post "link checked [date] deleted" or "link checked [date] alive" ... That sort of thing?

Any help is greatly appreciated, thanks.

Sup101 02-12-2009 10:13 PM

This seems not to work with 3.8.1 it trashes every single thread... Plus tells me cURL is not working right...

putergirl 02-15-2009 08:13 PM

downloaded

Shamil. 02-16-2009 01:11 PM

Ive found a bug. But I cant seem to fix it.

When the bot reports a thread it doesn't set the thread to visible. Ive tried changing the SQL queries but they all seem to be ok.

I dont know what else to do. At the moment only admins can see the reports :(


All times are GMT. The time now is 01:33 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.01372 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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