Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-14-2012, 08:31 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

For a start you need to post this in the mod for support 2nd a link to your forums will help 3rd the problem could be the version you are using is not the same version as your forums and could be causing some of the problems
Reply With Quote
  #3  
Old 12-15-2012, 02:10 PM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

As mentioned above, questions/problem with mods must be addressed in the mod thread and not in the general discussion forums.

I've responded to your question here: https://vborg.vbsupport.ru/showpost....&postcount=125
Reply With Quote
  #4  
Old 12-17-2012, 07:00 PM
Chris8's Avatar
Chris8 Chris8 is offline
 
Join Date: Nov 2009
Posts: 188
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by ForceHSS View Post
For a start you need to post this in the mod for support 2nd a link to your forums will help 3rd the problem could be the version you are using is not the same version as your forums and could be causing some of the problems
Thank you for your suggestions.


Quote:
Originally Posted by kh99 View Post
As mentioned above, questions/problem with mods must be addressed in the mod thread and not in the general discussion forums.

I've responded to your question here: https://vborg.vbsupport.ru/showpost....&postcount=125
Thank you. Your solution works like a charm!

I'm sorry I have not posted it in the original thread. I've just though it would be quicker to get some help this way as some mod developers do not show here very often anymore. Nonetheless next time I will try post in a mod thread first.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:24 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05542 seconds
  • Memory Usage 2,188KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (4)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete