Data truncation error after board upgrade

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
deep64blue
Registered User
Posts: 10
Joined: Fri Jun 26, 2009 5:17 pm

Data truncation error after board upgrade

Post by deep64blue »

What version of phpBB are you using? phpBB 3.2
What is your board's URL? http://forum.gameplan.org.uk
Who do you host your board with? 1&1
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
What version of phpBB3 did you update from? phpBB 3.0.10
What styles do you currently have installed? Prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
When did your problem begin? My problems began after I completed upgrade from 3.0.10 to 3.2 using instructions found at viewtopic.php?f=556&t=2402101
Please describe your problem:

After uploading the new 3.2 code I navigated to /install and chose "upgrade database only", this failed with the following error:-

General Error:SQL ERROR [ mysql4 ]Data truncated for column 'user_newpasswd' at row 12 [1265]
SQL
ALTER TABLE `bb_users` CHANGE `user_newpasswd` `user_newpasswd` varchar(255) DEFAULT '' NOT NULL
in file /*removedforsecuritybeforeposting*/phpbb/db/driver/driver.php on line 999BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 999CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/mysql.phpLINE: 191CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1061CALL: phpbb\db\driver\mysql->sql_query()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1776CALL: phpbb\db\tools\tools->_sql_run_sql()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 507CALL: phpbb\db\tools\tools->sql_column_change()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\db\tools\tools->perform_schema_changes()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 711CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 658CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 400CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 288CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 241CALL: phpbb\db\migrator->update_do()FILE: [ROOT]/phpbb/install/module/update_database/task/update.phpLINE: 160CALL: phpbb\db\migrator->update()FILE: [ROOT]/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: [ROOT]/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: [ROOT]/phpbb/install/controller/update.phpLINE: 133CALL: phpbb\install\installer->run()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 113CALL: call_user_func()FILE: [ROOT]/vendor/symfony/http-foundation/Response.phpLINE: 374CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: [ROOT]/install/app.phpLINE: 57CALL: Symfony\Component\HttpFoundation\Response->send()
Post Reply

Return to “[3.2.x] Support Forum”