Assigned ticket to user "Kellanved"
Action performed by Kellanved (Former Team Member) on May 27th 2007, 10:57
General error
SQL ERROR [ mysql4 ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use 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()