Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-4133 now.

General Error during conversion (fix completed in vcs)

On the last step

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Unknown column 'p.forum_id' in 'field list' [1054]

SQL

SELECT p.forum_id, SUM(topic_replies + 1) AS forum_posts FROM phpbb_topics t WHERE t.forum_id IN (32, 33, 34, 35, 36, 37, 1, 2, 3, 21, 6, 5, 26, 25, 8, 17, 23, 30, 9, 10, 29, 31, 12, 27, 24, 13, 22) AND t.topic_approved = 1 GROUP BY p.forum_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 1507
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 1691
CALL: sync()

FILE: install/install_convert.php
LINE: 790
CALL: install_convert->jump()

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()

Comments / History

Posted by oddfish on May 6th 2007, 05:39

have the same error introduced in 5th May CVS.

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Unknown column 'p.forum_id' in 'field list' [1054]

SQL

SELECT p.forum_id, SUM(topic_replies + 1) AS forum_posts FROM phpbb3_topics t WHERE t.forum_id IN (204, 205, 206, 207, 208, 27, 153, 3, 126, 1, 8, 20, 18, 29, 68, 86, 130, 163, 164, 165, 149, 199, 38, 178, 194, 162, 200, 43, 6, 5, 22, 13, 150, 198, 201, 39, 2, 192, 191, 10, 4, 188, 31, 128, 145, 127, 7, 73, 179, 187, 40, 180, 181, 41, 111, 80, 79, 185, 190, 78, 138, 109, 139, 144, 124, 140, 141, 113, 93, 115, 120, 133, 122, 134, 132, 137, 147, 183, 197, 117, 184, 136, 186, 189, 142, 151, 155, 156, 157, 158, 159, 160, 170, 161, 166, 167, 168, 172, 173, 182, 202, 203) AND t.topic_approved = 1 GROUP BY p.forum_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: includes/functions_admin.php
LINE: 1507
CALL: dbal_mysql->sql_query()

FILE: install/install_convert.php
LINE: 1691
CALL: sync()

FILE: install/install_convert.php
LINE: 790
CALL: install_convert->jump()

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()

Assigned ticket to user "Kellanved"

Action performed by Kellanved (Former Team Member) on May 6th 2007, 09:37

Posted by Nenad on May 6th 2007, 11:25

I get the same thing.

Assigned ticket to user "Acyd Burn"

Action performed by Acyd Burn (Server Manager) on May 6th 2007, 12:12

Changed ticket status from "New" to "Fix in progress"

Action performed by Acyd Burn (Server Manager) on May 6th 2007, 12:12

Linked ticket with changeset: r7485

Action performed by Anonymous (I am too lazy to register) on May 6th 2007, 15:31

Changed ticket status from "Fix in progress" to "Fix completed in CVS"

Action performed by Acyd Burn (Server Manager) on May 6th 2007, 18:08

Ticket details

Related SVN changesets