My upgrade went bad

[Rustynail]

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

[spaceace]

when updating, the first thing the installer does is update the database. best thing to do would be to upload the original files, and use the update package from phpbb http://www.phpbb.com/downloads/olympus.php?update=1

follow the update instruction, then if there's any errors, post them