Welcome to Geeklog, Anonymous Friday, November 08 2024 @ 08:10 pm EST
Geeklog Forums
changing username length from 16
Status: offline
kyah
Forum User
Newbie
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?
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?
9
13
Quote
Status: offline
1000ideen
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!
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!
13
9
Quote
All times are EST. The time is now 08:10 pm.
- 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