Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-9329

conversion from MySQLi to PostgreSQL fails on phpbb_users

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 3.0.x
    • Fix Version/s: None
    • Component/s: phpBB 2.0 convertor
    • Labels:
      None
    • Environment:
      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

        Attachments

          Activity

            People

            Assignee:
            Kellanved Kellanved [X] (Inactive)
            Reporter:
            tchyo tchyo
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: