1 Topic by RuDeDoGg (edited by RuDeDoGg 2005-09-16 05:18)

  • Registered: 2004-12-20
  • Posts: 38

Topic: MySql Help Please

I am trying to add some extra fields in my database, and have a form so users can input data on account creation.  I am getting the "Cannot create user" error.  I think it's a problem with the mySql query.

$db->query('INSERT INTO '.$db->prefix.'users (username, group_id, password, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, picurl, charname, type) VALUES(\''.$db->escape($username).'\', '.$intial_group_id.', \''.$password_hash.'\', \''.$email1.'\', '.$email_setting.', '.$save_pass.', '.$timezone.' , \''.$db->escape($language).'\', \''.$pun_config['o_default_style'].'\', '.$now.', \''.get_remote_address().'\', '.$now.'\', '.$picurl.'\', '.$charname.'\', '.$type.')') or error('Unable to create user', __FILE__, __LINE__, $db->error());

$db->query('INSERT INTO '.$db->prefix.'users (username, group_id, password, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, picurl, charname, type) VALUES(\''.$db->escape($username).'\', '.$intial_group_id.', \''.$password_hash.'\', \''.$email1.'\', '.$email_setting.', '.$save_pass.', '.$timezone.' , \''.$db->escape($language).'\', \''.$pun_config['o_default_style'].'\', '.$now.', \''.get_remote_address().'\', '.$now.'\', '.$picurl.'\', '.$charname.'\', '.$type.')') or error('Unable to create user', __FILE__, __LINE__, $db->error());

Any help would be GREATLY appreciated big_smile

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: MySql Help Please

Well, are picurl, charname, and type numbers or words?

3 Reply by RuDeDoGg (edited by RuDeDoGg 2005-09-16 12:37)

  • Registered: 2004-12-20
  • Posts: 38

Re: MySql Help Please

Heres from my DB:
charname   varchar(15)      
picurl       varchar(255)
type               varchar(5)

I have a forms on my page with the names picurl, type, and charname.  Shouldn't that work?

Thanks in advance big_smile

  • Registered: 2004-04-16
  • Posts: 199

Re: MySql Help Please

Should be

$db->query('INSERT INTO '.$db->prefix.'users (username, group_id, password, email, email_setting, save_pass, timezone, language, style, registered, registration_ip, last_visit, picurl, charname, type) VALUES(\''.$db->escape($username).'\', '.$intial_group_id.', \''.$password_hash.'\', \''.$email1.'\', '.$email_setting.', '.$save_pass.', '.$timezone.' , \''.$db->escape($language).'\', \''.$pun_config['o_default_style'].'\', '.$now.', \''.get_remote_address().'\', '.$now.', \''.$picurl.'\', \''.$charname.'\', \''.$type.'\')') or error('Unable to create user', __FILE__, __LINE__, $db->error());

I didn't see anything else wrong.

I enjoy pie :)
  • Registered: 2004-12-20
  • Posts: 38

Re: MySql Help Please

Thanks a lot Mediator, I'll try it when I get home.  (Currently at school :\)

PS.  Are you still working on RSCN?  I heard you kind of disappeared tongue

  • Registered: 2004-12-20
  • Posts: 38

Re: MySql Help Please

Update:  Worked

Thanks a lot Med big_smile