vb.org Archive
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Template Modifications (https://vborg.vbsupport.ru/forumdisplay.php?f=139)
-   -   [release] Spambot Protection (https://vborg.vbsupport.ru/showthread.php?t=86544)

jrotunda85 03-09-2003 11:28 PM
Ok, Filburt.

I installed everything and everything is working fine, except for when I try to do things with the users I registered. For some reason, everytime I try to post with that user I get a database error and I got it occassionally with trying to log-in. The interesting thing is I can do everything just fine with the admin account, including posting, logging back in, etc. So I assume it must be something with the database modifications.

Help :confused:

filburt1 03-09-2003 11:31 PM
What's the database error?

jrotunda85 03-09-2003 11:53 PM
It's just giving me the generic "There has been an error in the Senate Sim database." It doesn't give me the report like where it's coming from or anything.

filburt1 03-09-2003 11:54 PM
Right-click the page, click View Source, and copy the error.

jrotunda85 03-10-2003 12:10 AM
This is the one I am getting when trying to log in. It appears, it does have something to do with the hack because it denotes 6 which is the number of posts I set in the Board Options.

Quote:
<html><head><title>Senate Sim Version 3.0 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.3.0:

Invalid SQL: SELECT
IF(COUNT(threadid) >= 6, 6, COUNT(threadid)
FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30
mysql error: You have an error in your SQL syntax near 'FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30' at line 3

mysql error number: 1064

Date: Sunday 09th of March 2003 07:05:58 PM
Script: http://www.senatesim.com/testvb/testvb/index.php?
Referer: http://www.senatesim.com/testvb/index.php?
-->

</table></td></tr></table></form>
<blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the Senate Sim Version 3.0 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:support@senatesim.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>

filburt1 03-10-2003 12:14 AM
Sh**, I forgot a closing paren in PAPI 1.0.8. Uploading new version, stand by.

filburt1 03-10-2003 12:17 AM
Try upgrading to PAPI 1.0.9 and see if it helps.

jrotunda85 03-10-2003 12:26 AM
Still getting it:

Quote:
<html><head><title>Senate Sim Version 3.0 Database Error</title><style>P,BODY{FONT-FAMILY:tahoma,arial,sans-serif;FONT-SIZE:11px;}</style><body>

<!-- Database error in vBulletin 2.3.0:

Invalid SQL: SELECT
IF(COUNT(threadid) >= 6, 6, COUNT(threadid)
FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30
mysql error: You have an error in your SQL syntax near 'FROM thread WHERE postuserid = 12
AND dateline > UNIX_TIMESTAMP() - 30' at line 3

mysql error number: 1064

Date: Sunday 09th of March 2003 07:22:58 PM
Script: http://www.senatesim.com/testvb/testvb/index.php?
Referer: http://www.senatesim.com/testvb/index.php?
-->

</table></td></tr></table></form>
<blockquote><p>&nbsp;</p><p><b>There seems to have been a slight problem with the Senate Sim Version 3.0 database.</b><br>
Please try again by pressing the <a href="javascript:window.location=window.location;" >refresh</a> button in your browser.</p>An E-Mail has been dispatched to our <a href="mailto:support@senatesim.com">Technical Staff</a>, who you can also contact if the problem persists.</p><p>We apologise for any inconvenience.</p></blockquote></body></head></html>

filburt1 03-10-2003 12:51 AM
What are the contents of the floodcheck() function for the version of PAPI that you have?

jrotunda85 03-10-2003 01:27 AM
Quote:
Originally Posted by filburt1
What are the contents of the floodcheck() function for the version of PAPI that you have?
It has been attached.


All times are GMT. The time now is 06:40 AM.
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

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.01173 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (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