My upgrade went bad
Posted: Sun Jan 31, 2010 8:54 pm
What i did was copy all the files from the update dowload file and over wrote the old ones and all php files then my MCP panel stoped working as well as the PM so this is the error I get from MCP when I click on it
Code: Select all
SQL ERROR [ mysql4 ]
Unknown column 'r.pm_id' in 'where clause' [1054]
SQL
SELECT COUNT(r.report_id) AS total FROM phpbb_reports r, phpbb_posts p WHERE r.post_id = p.post_id AND r.pm_id = 0 AND r.report_closed = 0 AND p.forum_id IN (0, 3, 4, 5, 22, 8, 87, 108, 105, 24, 65, 21, 6, 7, 103, 113, 9, 10, 32, 11, 86, 88, 89, 90, 102, 107, 12, 13, 14, 15, 79, 80, 81, 82, 83, 84, 85, 20, 29, 27, 28, 30, 31, 17, 33, 34, 35, 40, 36, 38, 37, 39, 91, 18, 55, 41, 42, 109, 43, 53, 54, 44, 45, 46, 47, 48, 49, 50, 51, 52, 110, 56, 57, 58, 92, 93, 94, 95, 96, 97, 98, 112, 19, 59, 60, 61, 62, 63, 64, 23, 68, 69, 70, 72, 71, 77, 78, 25, 66, 67, 26, 74, 104, 76, 73, 106, 101, 99, 75, 100)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/mcp/mcp_front.php
LINE: 163
CALL: dbal_mysql->sql_query()
FILE: includes/mcp/mcp_main.php
LINE: 143
CALL: mcp_front_view()
FILE: includes/functions_module.php
LINE: 507
CALL: mcp_main->main()
FILE: mcp.php
LINE: 244
CALL: p_master->load_active()