Page 1 of 1
Mayhem is having problems
Posted: Mon Apr 17, 2006 10:33 pm
by Buzzed
He is trying to register in and when he brings up campquake.net, he clicks on register, the agreement terms come up and when he agrees he gets a general error could not inset new confirmed code information, then it goes into a debug mode and he cant do anything further.
One line says sql error etc etc.
Any solutions? He needs help
Posted: Tue Apr 18, 2006 6:44 pm
by Baron[CotC]
Could not insert new confirm code information
DEBUG MODE
SQL Error : 1406 Data too long for column 'code' at row 1
INSERT INTO phpbb_confirm (confirm_id, session_id, code) VALUES ('1937ac906df1ffffe407227f3bf17d38', '167c29bb492b3878e5d666240b35e4a5', '333COC719D')
Line : 1002
File : usercp_register.php
Thats the error, I confirmed it by trying to register on my computer.
Any ideas Akira? Perhaps this is linked to the quote code being silly?
Posted: Tue Apr 18, 2006 7:24 pm
by Akira
Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
Posted: Tue Apr 18, 2006 7:36 pm
by Neophyte
Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
Does that fix the quote problem?
edit: hehehe! Nevermind!
Posted: Tue Apr 18, 2006 7:39 pm
by Baron[CotC]
now THAT is hilarious
Thanks for the quick fix Akira, you're the best!
Posted: Tue Apr 18, 2006 9:00 pm
by Akira
Neophyte wrote:Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
Does that fix the quote problem?
edit: hehehe! Nevermind!
Darn phpBB, if it didn't, I'll track that fix tomorrow.
Posted: Wed Apr 19, 2006 7:04 am
by Buzzed
Mayhem, try to re-register now.
Edit
doh! Should have read the other post first
Posted: Wed Apr 19, 2006 9:21 am
by Akira
Buzzed wrote:Mayhem, try to re-register now.
Edit
doh! Should have read the other post first
Testing quotes having been fixed.
Posted: Wed Apr 19, 2006 7:53 pm
by Baron[CotC]
Akira wrote:Buzzed wrote:Mayhem, try to re-register now.
Edit
doh! Should have read the other post first
Testing quotes having been fixed.
Huzzah! Akira strikes again!
Posted: Wed Apr 19, 2006 8:37 pm
by Serpent
Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
just wondering.....sa to another sa..... why use mysql 5? i use 4.1 on most... why go to 5? i heard 5 handles stored procedures better....but not sure what reasons there were here...
Posted: Wed Apr 19, 2006 9:01 pm
by Akira
Serpent wrote:Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
just wondering.....sa to another sa..... why use mysql 5? i use 4.1 on most... why go to 5? i heard 5 handles stored procedures better....but not sure what reasons there were here...
Just keeping with the latest. Especially when setting up this web server from scratch, everything is latest version.
