View Single Post
  #1  
Old 12-14-2012, 07:10 PM
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Help me please with fixing this mod

I need some help fixing this small problem.

Here is the mod I'm testing -> https://vborg.vbsupport.ru/showthread.php?t=124907

Here is an additional modification of the mod -> https://vborg.vbsupport.ru/showpost....0&postcount=87 and here is the problem. It works well when typing existing username and wrong password but there is an issue when typing non-existing username.


Code:
Database error in vBulletin 3.8.111:

Invalid SQL:
INSERT INTO vb_logins (userid, username, ipaddress, phpdate, logintype) VALUES (, '', '11.111.11.1', 1355514465, 'FAILED ATTEMPT');

MySQL 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 ' '', '11.111.11.1', 1355514465, 'FAILED ATTEMPT')' at line 1
Error Number  : 1064
Request Date  : Friday, December 14th 2012 @ 02:47:45 PM
Error Date    : Friday, December 14th 2012 @ 02:47:45 PM
Script        : http://www.xxx.xxx/forums/login.php?do=login
Referrer      : http://www.xxx.xxx/forums/index.php
IP Address    : 11.111.11.1
Username      : 
Classname     : vB_Database
MySQL Version : 
-->

Is it because of the lack userid or username? What is the best way to fix it? I was thinking about some user related conditionals, I'm not sure though which one would work here and if it's best way to do it anyway. Any help will be greatly appreciated.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01075 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete