Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-4657

Convertor error

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • None
    • 3.0.x
    • Installation system
    • None
    • PHP Environment:
      Database:

      Just tried to convert an old phpBB board to a latest CVS version of RC1.

      Install goes stright forward and converting at begining to. But when I come to "Conversion in progress" step and click on "Continue conversion" button I get following sql-error:

      (Observe that funny sql-string)

      SQL ERROR [ mysql ]
       
      You have an error in your SQL syntax near 'AS poster_id, attachments_desc.physical_filename, attachments_desc.real_filename' at line 4 [1064]
       
      SQL
       
      SELECT attachments.attach_id, attachments.post_id, posts.topic_id, attachments.user_id_1 AS poster_id, attachments_desc.physical_filename, attachments_desc.real_filename, attachments_desc.download_count, attachments_desc.comment, attachments_desc.extension, attachments_desc.mimetype, attachments_desc.filesize, attachments_desc.filetime, attachments_desc.thumbnail FROM phpbb_attachments attachments, phpbb_posts posts, phpbb_attachments_desc attachments_desc WHERE (attachments_desc.attach_id = attachments.attach_id AND attachments.privmsgs_id = 0 AND posts.post_id = attachments.post_id) GROUP BY attachments.attach_id, attachments.post_id, posts.topic_id, attachments.user_id_1 AS poster_id, attachments_desc.physical_filename, attachments_desc.real_filename, attachments_desc.download_count, attachments_desc.comment, attachments_desc.extension, attachments_desc.mimetype, attachments_desc.filesize, attachments_desc.filetime, attachments_desc.thumbnail ORDER BY attachments.attach_id LIMIT 2000
       
      BACKTRACE
       
      FILE: includes/db/mysql.php
      LINE: 133
      CALL: dbal_mysql->sql_error()
       
      FILE: includes/db/mysql.php
      LINE: 180
      CALL: dbal_mysql->sql_query()
       
      FILE: includes/db/dbal.php
      LINE: 135
      CALL: dbal_mysql->_sql_query_limit()
       
      FILE: install/install_convert.php
      LINE: 1215
      CALL: dbal_mysql->sql_query_limit()
       
      FILE: install/install_convert.php
      LINE: 203
      CALL: install_convert->convert_data()
       
      FILE: install/index.php
      LINE: 336
      CALL: install_convert->main()
       
      FILE: install/index.php
      LINE: 208
      CALL: module->load()

      The official RC1 candidate conversion worked as it should.

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

              Created:
              Updated:
              Resolved: