Link Checker Error after executing linkbot.php

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Thaitanium
Registered User
Posts: 14
Joined: Tue Oct 14, 2008 5:14 pm

Link Checker Error after executing linkbot.php

Post by Thaitanium » Thu Oct 16, 2008 3:51 am

Code: Select all

UPDATE rs_links SET last_checked = 1224126092, status='0' WHERE id=2147483647
[phpBB Debug] PHP Notice: in file /linkbot.php on line 293: Division by zero
Return to index page
General Error
SQL ERROR [ mysql4 ]

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 [1064]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I've taken a look at line 293 and it is this

Code: Select all

$percent=round($topicdead / $topiclinks * 100,2);
			$checked=date('F jS, Y, g:i a', time());
			$sql = "UPDATE " . POSTS_TABLE . " 
			SET bot = '<b>[" .$linkbot_name. " Checked These Links " . $checked ." and " . $percent ."% Are Dead]</b>'
			WHERE post_id = $postid";
			$db->sql_query($sql);
First line is 293, any help would be beneficial

User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10344
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: Link Checker Error after executing linkbot.php

Post by Noxwizard » Thu Oct 16, 2008 4:03 am

You will need to ask for support wherever you obtained that MOD.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.

User avatar
John P
Registered User
Posts: 1237
Joined: Mon Jan 21, 2008 3:55 pm
Location: Netherlands
Name: John
Contact:

Re: Link Checker Error after executing linkbot.php

Post by John P » Thu Oct 16, 2008 4:07 am

It says $topiclinks is zero so where is $topiclinks defined?
Image
Webhosting, Custom MODs, Technical management, MOD installation and Webdesign

Thaitanium
Registered User
Posts: 14
Joined: Tue Oct 14, 2008 5:14 pm

Re: Link Checker Error after executing linkbot.php

Post by Thaitanium » Thu Oct 16, 2008 11:02 am

it is not defined in any php file, is meant to be in php admin? its not in the mysql either this is the mysql we were meant to enter

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_topic_title', 'Dead Links Found');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_pm_title', 'Found Dead Links In Your Post');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_name', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_userid', '1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_percent', '75');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_binid', '3');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_topic', 'I have detected that more than {BOT_PERCENT}% of your links were dead So I have moved the thread to this forum.\n\nIf you edit your links or they become alive again please notify a member of staff so they can restore it\n\nLink Detective');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('bot_pm', 'I have detected that more than {BOT_PERCENT}% of your links were dead So I have moved the thread to the Bin. \n\nIf you edit your links or they become alive again please notify a member of staff so they can restore it. \n\n{EDIT_URL}\n\nLink Detective');
ALTER TABLE phpbb_users ADD `linkbot_pm` tinyint( 1 ) NOT NULL default '1';
CREATE TABLE `rs_checker` (`id` int(25) NOT NULL,`link` varchar(255) collate latin1_general_ci NOT NULL,`postid` varchar(255) collate latin1_general_ci NOT NULL,`topicid` varchar(255) collate latin1_general_ci NOT NULL);
CREATE TABLE `rs_links` (`id` int(255) NOT NULL,`last_checked` varchar(255) collate latin1_general_ci NOT NULL,`status` varchar(255) collate latin1_general_ci NOT NULL,`postid` varchar(255) collate latin1_general_ci NOT NULL default '0',`topicid` varchar(255) collate latin1_general_ci NOT NULL default '0');
ALTER TABLE phpbb_posts ADD `bot` varchar(255) NOT NULL default '.';

Thaitanium
Registered User
Posts: 14
Joined: Tue Oct 14, 2008 5:14 pm

Re: Link Checker Error after executing linkbot.php

Post by Thaitanium » Thu Oct 16, 2008 11:09 am

$topiclinks = $row['count']; //Total Amount of Links for Topic - Hawke

Is the only other one i can find and it is inside linkbot.php

User avatar
thecoalman
Community Team Member
Community Team Member
Posts: 3299
Joined: Wed Dec 22, 2004 3:52 am
Location: Pennsylvania, U.S.A.
Contact:

Re: Link Checker Error after executing linkbot.php

Post by thecoalman » Thu Oct 16, 2008 11:15 am

As suggested by Noxwizard.
Noxwizard wrote:You will need to ask for support wherever you obtained that MOD.
This forum is not for support of mod related issues, seek support in the mods topic.

Closing.
“Results! Why, man, I have gotten a lot of results! I have found several thousand things that won’t work.”

Attributed - Thomas Edison

Locked

Return to “[3.0.x] Support Forum”