[solved] NEW user can't register after 2.0.19 to 2.0.20

[jrubio]

Can not register new visitors after I updated from 2.0.19 to 2.0.20, I get the following error message:

Code: Select all

Could not insert new confirm code information

DEBUG MODE

SQL Error : 22001 [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

INSERT INTO phpbb2_confirm (confirm_id, session_id, code) VALUES ('de9c237cf61e5eb761b76c18d90c1c50', '05b4cc57b43f804723b4aedd80226e28', 'FCD4F432OD')

Line : 1002
File : usercp_register.php

I am also getting these intermitent error messages, they seem to dissapear whenever I refresh:

Code: Select all

Warning: odbc_exec(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SESSIONS_KEYS_TABLE'., SQL state S0002 in SQLExecDirect in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php on line 171

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 366

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\sessions.php on line 367

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 475

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 477

Warning: Cannot modify header information - headers already sent by (output started at \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\db\mssql-odbc.php:171) in \\NAWINFS03\home\users\web\b1339\rh.tlazaonline1\forums\includes\page_header.php on line 478


URL: http://www.tlazaonline.com/forums/index.php
Template(s) used: subsilver
Any and all MODs: Admin User list, Auto-cookie mod
Do you use a port of phpBB: na
Version of phpBB: 2.0.20
Version of PHP: 4.3.10
Which database server and version: ms sql 2000
Host: readyhosting
Did someone install this for you/who: no
Is this an upgrade/from what to what: 2.0.19 to 2.0.20
Is this a conversion/from what to what: no
Have you searched for your problem: yes
If so, what terms did you try: reinstalled mods
State the nature of your problem: above description
Do you have a test account for us:

[jrubio]

I have temporarily solved my problem, by disabling the Visual confirmation code from Admin Control panel,,,although it is recommended to be activated , I will reactivate after a fix has been posted.

Although I am still getting random Error messages, when viewing my forums,,,I should note, the Errors do not show everytime , I am unsure exactly when they are appearing and they are not interfering with functions of forum, and they usually disappear when page has been refreshed.

[Bill W]

I ran into this problem as well, using PHP 5.1.2 and MySql 5.0.19.

After doing some debugging, I was able to determine that the error is in the substr of the following line in usercp_register.ph:

$code = strtoupper(str_replace('0', 'o', substr($code, 6)));

Changing it to this fixed the problem:
$code = strtoupper(str_replace('0', 'o', substr($code, 0, 6)));

The original substr code was taking a sub string of $code starting at position 7 and going to the end of the string, which resulted in a string that was greater than 6 characters, which is the largest value that can be stored in the confirm table.

The change that I made will take a sub string of $code starting at position 0 and getting 6 characters.

I wouldn't recommend making this change as I don't know what the original coders intent was. I just thought someone might be interested in seeing this.

I haven't checked into this any further to determine if there are any other problems as this is the first time I've set up and used phpbb and I'm just checking it out on a server at home (it isn't live).

Bill

[jrubio]

thank you, we will consider this and post a result later.