FAQ FAQ   Search Search   Memberlist Memberlist   Usergroups Usergroups   Register Register 
PhpBB- & WordPress- antispam.com
Home of the Antispam for all fields mod ! 
  Profile Profile   Log in to check your private messages Log in to check your private messages  Log inLog in 

 PhpBB- & WordPress- antispam.com Forum Index » [PhpBB2] Support - Antispam for all fields » Error lang and others problems
 Goto page 1, 2  Next The time now is Sat May 26, 2018 4:50 pm 

 Post new topic   Reply to topic View previous topic :: View next topic  
Author Message
PostPosted: Tue Dec 09, 2008 8:33 pm    Post subject: Error lang and others problems  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

http://www.phpbb.com/community/viewtopic.php?f=16&t=393606&start=570

Hi Ramon Fincken!

Please help me!

Quote:
Critical Error!
message_die() was called multiple times.
Error #1
Problem: File missing.
Could not load the Antispam MOD language file, please check your installation.


Where I have error?
Thanks you!

Quote:
P.S.
lang_antispam.php is upload on my forums


Last edited by Owen on Tue Dec 09, 2008 10:53 pm; edited 1 time in total

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:13 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

what is your forums language and in which folders are the lang_antispam.php?
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 10:19 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

ramon fincken wrote:
what is your forums language and in which folders are the lang_antispam.php?


lang_slovak
Surprised

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:21 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

Owen wrote:
ramon fincken wrote:
what is your forums language and in which folders are the lang_antispam.php?


lang_slovak
Surprised


hmm interesting ... did you also put the file in the lang_english folder? ( because there is no translation available yet ... )
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 10:24 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

ramon fincken wrote:
Owen wrote:
ramon fincken wrote:
what is your forums language and in which folders are the lang_antispam.php?


lang_slovak
Surprised


hmm interesting ... did you also put the file in the lang_english folder? ( because there is no translation available yet ... )


Oh yes, go it, but next error :
[code]Array ( [message] => 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 'AND g.group_type <> 2 AND ug.user_pending = 0 ORDER BY u.user_id ASC' at line 1 [code] => 1064 )[/code]

login.php

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:26 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

did you run the sql updater ?
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 10:28 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

No,..
I canīt login on my forum because jump error.. Sad

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:29 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

whats your forums url?
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 10:30 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

Code:
www.warcomunity.com


more more bots.. but they donīt register

_
Array ( [message] => 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 'AND g.group_type <> 2 AND ug.user_pending = 0 ORDER BY u.user_id ASC' at line 1 [code] => 1064 )

over login..


Last edited by Owen on Tue Dec 09, 2008 10:36 pm; edited 1 time in total

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:33 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

My server donīt keep under so many bots 2000 anonymous bots Rolling Eyes

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 10:43 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

Code:
Could not retrieve antispam registration info

DEBUG MODE

>>>> SQL Error : 1146 Table 'do1341300db.phpbb_antispamdb' doesn't exist <<<<<

SELECT id, ip, count(ip) as ip_count from phpbb_antispamdb WHERE ip = '85.148.252.141' group by ip HAVING ( ip_count >2) order by ip_count DESC

Line : 939
File : functions_antispam.php



so ... ok special treatment for this one ....

EDIT sql_update.php
so ...

OPEN sql_update.php

FIND
if (!$userdata['session_logged_in']) {

REPLACE WITH
if(false) {


FIND
if ($userdata['user_level'] != ADMIN) {

REPLACE WITH
if(false) {


RUN
sql_update.php
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 10:50 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

Thanks,

1errors:
Code:
CREATE TABLE `phpbb_antispamdb` ( `Id` int(6) unsigned NOT NULL auto_increment, `user_id` mediumint(8) default NULL, `ip` varchar(25) default NULL, `ip_forwarded` varchar(25) default NULL, `time` int(11) NOT NULL default '0', `type` varchar(40) default 'word', `status` varchar(8) default 'false', `word_triggerid` smallint(5) default NULL, PRIMARY KEY (`Id`) KEY `ip` (`ip`), KEY `ip_forwarded` (`ip_forwarded`), KEY `user_id` (`user_id`), KEY `type` (`type`) )
+++ 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 'KEY `ip` (`ip`), KEY `ip_forwarded` (`ip_forwarded`), KEY `user_id` (`' at line 11


never mind??

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 11:16 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

crap...
sorry !!

FIND
// Override ? Please only change this value if you want to manually override an installation
// $mod_spamcheck_version = '0';

REPLACE WITH
// Override ? Please only change this value if you want to manually override an installation
// $mod_spamcheck_version = '1.3.0';

FIND
Code:
   $sql[] = "CREATE TABLE `" . ANTISPAMDB_TABLE . "` (
              `Id` int(6) unsigned NOT NULL auto_increment,
              `user_id` mediumint(8) default NULL,
              `ip` varchar(25) default NULL,
              `ip_forwarded` varchar(25) default NULL,
              `time` int(11) NOT NULL default '0',
              `type` varchar(40) default 'word',
              `status` varchar(8) default 'false',
              `word_triggerid` smallint(5) default NULL,
              PRIMARY KEY  (`Id`),
             KEY `ip` (`ip`),
             KEY `ip_forwarded` (`ip_forwarded`),
             KEY `user_id` (`user_id`),
             KEY `type` (`type`)                    
            )";



REPLACE WITH

Code:
   $sql[] = "CREATE TABLE `" . ANTISPAMDB_TABLE . "` (
              `Id` int(6) unsigned NOT NULL auto_increment,
              `user_id` mediumint(8) default NULL,
              `ip` varchar(25) default NULL,
              `ip_forwarded` varchar(25) default NULL,
              `time` int(11) NOT NULL default '0',
              `type` varchar(40) default 'word',
              `status` varchar(8) default 'false',
              `word_triggerid` smallint(5) default NULL,
              PRIMARY KEY  (`Id`),
             KEY `ip` (`ip`),
             KEY `ip_forwarded` (`ip_forwarded`),
             KEY `user_id` (`user_id`),
             KEY `type` (`type`)                    
            )";

_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Tue Dec 09, 2008 11:22 pm    Post subject:  Reply with quote  

Owen



Joined: 09 Dec 2008
Posts: 11

Thanks Smile

Array ( [message] => 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 'AND g.group_type <> 2 AND ug.user_pending = 0 ORDER BY u.user_id ASC' at line 1 [code] => 1064 )

Over login Sad
impossible of achievement login

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Dec 09, 2008 11:24 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

please copy the whole message. I cannot tell whats wrong by this line
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
 Post new topic   Reply to topic All times are GMT + 1 Hour

Display posts from previous:    Goto page 1, 2  Next
 PhpBB- & WordPress- antispam.com Forum Index » [PhpBB2] Support - Antispam for all fields » Error lang and others problems
 
 Page 1 of 2
 
 
 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Jump to:  


     Powered by phpBB © 2001, 2005 phpBB Group | Template Neon | Snelle Managed WordPress webhosting