Welcome to Geeklog Saturday, December 04 2021 @ 03:04 am EST

Geeklog Forums

changing username length from 16


Status: offline

kyah

Forum User
Newbie
Registered: 18/11/06
Posts: 1
Hello forum.

I am new to geeklog. I am in the process of moving away from SMF forum to geeklog forum.
I would like to change the username length from default 'varchar(16)' to 'varchar(20)'. What other areas in geeklog need changing aside from the database?
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 04/08/03
Posts: 1298
Just a quick answer for username 40 signs:

The sql command:
ALTER TABLE gl_users CHANGE username username VARCHAR(40) NOT NULL

The thtml to alter:
admin/user/edituser.thtml #19 16 -> 40
users/getpasswordform.thtml #13 16 -> 40
users/registrationform.thtml #13 16 -> 40

I did this with GL 1.4.0 successfully. Of course back up the db before you try!
 Quote

All times are EST. The time is now 03:04 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content