Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Need help! Details »»
Need help!
Version: , by Dan Dan is offline
Developer Last Online: May 2020 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 06-08-2003 Last Update: Never Installs: 0
 
No support by the author.

I was informed by one of my members friends can't register at my site and I get this in the mail.

Quote:
Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,yahoo,signature,admin email,showemail,invisible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotification,receivepm,emailo npm,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,starlevel,stari mg) VALUES
NULL,'FewynTest','74c358ae3c5a35e6322fd9ae96360d95 ','fewyn@halodex.com','1','','0','http://','','','','','1','1','0','Gamer','1055034878','1' ,'-1','1055034878','1055034878','3','0','1','1','0',' 15','0','-1','1','69.47.35.154','0','0','1','33')
mysql error: You have an error in your SQL syntax near 'NULL,'FewynTest','74c358ae3c5a35e6322fd9ae96360d9 5','fewyn@halodex.com','1','','' at line 2

mysql error number: 1064

Date: Saturday 07th of June 2003 09:14:38 PM
Script: http://www.eternalgamers.com/forums/forums/register.php
Referer: http://www.eternalgamers.com/forums/register.php

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-08-2003, 12:26 AM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Note the line break at the end of the first line of the query where "yahoo" is broken.
Reply With Quote
  #3  
Old 06-08-2003, 01:03 AM
Rufus69's Avatar
Rufus69 Rufus69 is offline
 
Join Date: Oct 2002
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Meh, I would try to fix it, but either I don't have have db access or I forgot how get in. :P
Reply With Quote
  #4  
Old 06-08-2003, 01:29 AM
filburt1 filburt1 is offline
 
Join Date: Feb 2002
Location: Maryland, US
Posts: 6,144
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Look in register.php for the query, it's probably broken there (unless your e-mail client is just adding a linebreak).
Reply With Quote
  #5  
Old 06-08-2003, 02:01 AM
Rufus69's Avatar
Rufus69 Rufus69 is offline
 
Join Date: Oct 2002
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I forgot the ftp password. :P I'll look for the txt that has it later, if dan doesn't fix it first.
Reply With Quote
  #6  
Old 06-08-2003, 01:19 PM
Rufus69's Avatar
Rufus69 Rufus69 is offline
 
Join Date: Oct 2002
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hmm..I'm thinking it just put a line break in, becaus eI looked at it, but no break.
Reply With Quote
  #7  
Old 06-08-2003, 01:53 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, that's the 50chars setting to break a line in VB.
Your query is wrong because you are missing a bracket. A query should have the shape:
[sql]$DB_site->query( "INSERT INTO table ( column1 , column2 ) VALUES ( 'data1' , 'data2' )" );[/sql]
Reply With Quote
  #8  
Old 06-08-2003, 03:43 PM
Rufus69's Avatar
Rufus69 Rufus69 is offline
 
Join Date: Oct 2002
Posts: 307
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

hm ok, thanks.
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 05:22 AM.


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.04538 seconds
  • Memory Usage 2,266KB
  • Queries Executed 21 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (7)postbit
  • (8)postbit_onlinestatus
  • (8)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