Details
-
Bug
-
Status: Closed (View Workflow)
-
Resolution: Fixed
-
3.0.x
-
None
-
None
-
PHP Environment:
Database:
Description
Conversion fails with phpBB 2 board from MySQLi to PostgreSQL. The failure occurs on phpbb_users, at line 1329 of install_convert.php
Actual error message :
Error while processing INSERT query.
|
ยป SQL:INSERT INTO phpbb_users (user_id, user_type, group_id, user_regdate, username, username_clean, user_password, user_pass_convert, user_posts, user_email, user_email_hash, user_birthday, user_lastvisit, user_lastmark, user_lang, user_timezone, user_dateformat, user_inactive_reason, user_inactive_time, user_interests, user_occ, user_website, user_jabber, user_msnm, user_yim, user_aim, user_icq, user_from, user_rank, user_permissions, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_notify, user_notify_pm, user_notify_type, user_allow_pm, user_allow_viewonline, user_allow_viewemail, user_actkey, user_newpasswd, user_style, user_options, user_sig_bbcode_uid, user_sig, user_sig_bbcode_bitfield) VALUES (178, 0, 3, '1183582683', 'ewerasupol', 'ewerasupol', '8945b4cb1bfb8cb5c95c137fc60ed9a0', 1, '0', '****@****.info', '43799568521', ' 0- 0- 0', '0', '0', 'en', '1.00', 'D d M Y, G:i', 0, 0, '', '', '', '', '', '', '', '', '', '0', '', '', 0, 0, 0, '0', 0, '0', 0, '1', '0', 0, '1', '1', '', '', '', '1', 831, 'c206f', '', 0)
|
|
|
Array ( [message] => ERROR: invalid input syntax for integer: "" [code] => )
|
Repeat ad nauseum with almost every user.
Conversion of the same board from MySQLi to MySQLi works fine. Filling the PostgreSQL board with the phpbb_users rows from the MySQL board works fine but every posts is then marked as guest.
Doing the same with phpbb_posts, phpbb_topics and phpbb_forums seems to fix all remaining issues.
phpBB 3.0RC5 and 2.0.21
PHP 5.2.4_p20070914-pl2-gentoo with Suhosin-Patch 0.9.6.2
MySQL 5.0.44
PostgreSQL 8.2.4