My upgrade went bad

general issues...
Post Reply
User avatar
Rustynail
Registered User
Posts: 6
Joined: Wed Jan 27, 2010 3:29 pm

My upgrade went bad

Post by 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()
Last edited by Rustynail on Tue Feb 26, 2013 10:29 am, edited 1 time in total.

[center]Image[/center]

User avatar
spaceace
Site Owner
Posts: 991
Joined: Wed Dec 16, 2009 8:30 pm
Location: Ontario, Canada
Flag: Canada
Contact:

Re: My upgrade went bad

Post by 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 ;)
Last edited by spaceace on Tue Feb 26, 2013 10:29 am, edited 1 time in total.
if you like my work and would like to contribute to my development of styles, please donate by using the donate button in the header.

Image

Need hosting? Click this text to check out ICDSOFT

Post Reply