Welcome to Geeklog, Anonymous Thursday, June 20 2024 @ 02:41 am EDT

Geeklog Forums

changing username length from 16

Status: offline


Forum User
Registered: 11/18/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?

Status: offline


Forum User
Full Member
Registered: 08/04/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!

All times are EDT. The time is now 02:41 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