-
Bug
-
Resolution: Duplicate
-
None
-
3.0.x
-
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.

