Mayhem is having problems
Mayhem is having problems
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
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
George Patton
- Baron[CotC]
- Caesar
- Posts: 1711
- Joined: Wed Feb 26, 2003 1:29 am
- Xfire Username: redbaroncotc
- Location: Alberta, Canada
- Contact:
Thats the error, I confirmed it by trying to register on my computer.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
Any ideas Akira? Perhaps this is linked to the quote code being silly?
- Baron[CotC]
- Caesar
- Posts: 1711
- Joined: Wed Feb 26, 2003 1:29 am
- Xfire Username: redbaroncotc
- Location: Alberta, Canada
- Contact:
Mayhem, try to re-register now.
Edit
doh! Should have read the other post first
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
George Patton
- Baron[CotC]
- Caesar
- Posts: 1711
- Joined: Wed Feb 26, 2003 1:29 am
- Xfire Username: redbaroncotc
- Location: Alberta, Canada
- Contact:
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...Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.
- Akira
- Eagle / Forum Admin
- Posts: 1509
- Joined: Tue Feb 25, 2003 12:52 pm
- Location: Ontario, Canada
- Contact:
Just keeping with the latest. Especially when setting up this web server from scratch, everything is latest version.Serpent wrote: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...Akira wrote:Fixed! Searched phpBB forum, issue with those using MySQL 5 (in our case). Had to adjust some code in phpBB.