Mayhem is having problems

New Members Section
Post Reply
User avatar
Buzzed
Posts: 1261
Joined: Fri Apr 23, 2004 6:40 pm

Mayhem is having problems

Post 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
A good plan, violently executed now, is better than a perfect plan next week. A pint of sweat, saves a gallon of blood. No poor bastard ever won a war by dying for his country. He won it by making other bastards die for their country.
George Patton
Image
User avatar
Baron[CotC]
Caesar
Posts: 1711
Joined: Wed Feb 26, 2003 1:29 am
Xfire Username: redbaroncotc
Location: Alberta, Canada
Contact:

Post 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?
Caesar - Clan of the Camper - http://www.clanofthecamper.com
Image
User avatar
Akira
Eagle / Forum Admin
Posts: 1509
Joined: Tue Feb 25, 2003 12:52 pm
Location: Ontario, Canada
Contact:

Post by Akira »

Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
Neophyte
Posts: 1433
Joined: Tue Feb 25, 2003 2:44 pm
Location: San Diego, CA.

Post 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!
Neophyte[CotC]
Member since 1996

Image
User avatar
Baron[CotC]
Caesar
Posts: 1711
Joined: Wed Feb 26, 2003 1:29 am
Xfire Username: redbaroncotc
Location: Alberta, Canada
Contact:

Post by Baron[CotC] »

now THAT is hilarious :lol:




Thanks for the quick fix Akira, you're the best!
Caesar - Clan of the Camper - http://www.clanofthecamper.com
Image
User avatar
Akira
Eagle / Forum Admin
Posts: 1509
Joined: Tue Feb 25, 2003 12:52 pm
Location: Ontario, Canada
Contact:

Post 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. :D
User avatar
Buzzed
Posts: 1261
Joined: Fri Apr 23, 2004 6:40 pm

Post by Buzzed »

Mayhem, try to re-register now.

Edit
doh! Should have read the other post first
A good plan, violently executed now, is better than a perfect plan next week. A pint of sweat, saves a gallon of blood. No poor bastard ever won a war by dying for his country. He won it by making other bastards die for their country.
George Patton
Image
User avatar
Akira
Eagle / Forum Admin
Posts: 1509
Joined: Tue Feb 25, 2003 12:52 pm
Location: Ontario, Canada
Contact:

Post by Akira »

Buzzed wrote:Mayhem, try to re-register now.

Edit
doh! Should have read the other post first
Testing quotes having been fixed.
User avatar
Baron[CotC]
Caesar
Posts: 1711
Joined: Wed Feb 26, 2003 1:29 am
Xfire Username: redbaroncotc
Location: Alberta, Canada
Contact:

Post 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!
Caesar - Clan of the Camper - http://www.clanofthecamper.com
Image
Serpent
Posts: 1002
Joined: Sun Mar 16, 2003 3:57 pm
Location: Over here
Contact:

Post 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... ;)
Image
User avatar
Akira
Eagle / Forum Admin
Posts: 1509
Joined: Tue Feb 25, 2003 12:52 pm
Location: Ontario, Canada
Contact:

Post 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. :)
Post Reply