| Re: Time to up grade [message #22274 is a reply to message #22271] |
Tue, 25 January 2005 17:49   |
|
|
I can run the test.php script and see
Server API CGI
Could not get into the admin cp at my_forum/www/adm tried adminlogin.php and index.php.
The rest of my site is working fine.
Thanks for the great fast help
Update, I spent quite a while on the phone with my hosting service and from what they say the upgrade script is stopping at the begining of the consist.php file....hope that helps getting me back up.
Update 2, so much for my hosting service helping out. I went back to my forum and was able to get in. The update took however I can not view any postings, only the first page comes up. This is what I get when trying to view a post.
(/usr/home/web/users/123456/html/fforum/www/index.php:125
/usr/home/web/users/123456/html/fforum/www/index.php:221
/usr/home/web/users/123456/html/fforum/www/theme/default/tree.php:684
/usr/home/web/users/123456/html/fforum/www/index.php:1174
) 1064: 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 'AND tr.user_id=294 LEFT JOIN fud_read r ON r.thread_id=t.id AND r.user_id=' at line 17
Query: SELECT c.id AS cat_id, f.name, m.subject, t.id, t.forum_id, t.replies, t.rating, t.n_rating, t.root_msg_id, t.moved_to, t.thread_opt, t.root_msg_id, t.last_post_date, tn.thread_id AS subscribed, mo.forum_id AS md, tr.thread_id AS cant_rate, r.last_view, r2.last_view AS last_forum_view, tv.pos AS th_pos, tv.page AS th_page, m2.thread_id AS last_thread, (CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) AS group_cache_opt FROM fud_thread t INNER JOIN fud_msg m ON m.id=t.root_msg_id INNER JOIN fud_forum f ON f.id=t.forum_id INNER JOIN fud_cat c ON f.cat_id=c.id INNER JOIN fud_thread_view tv ON tv.forum_id=t.forum_id AND tv.thread_id=t.id INNER JOIN fud_msg m2 ON f.last_post_id=m2.id LEFT JOIN fud_thread_notify tn ON tn.user_id=294 AND tn.thread_id=1317 LEFT JOIN fud_mod mo ON mo.user_id=294 AND mo.forum_id=t.forum_id LEFT JOIN fud_thread_rate_track tr ON tr.thread_id= AND tr.user_id=294 LEFT JOIN fud_read r ON r.thread_id=t.id AND r.user_id=294 LEFT JOIN fud_forum_read r2 ON r2.forum_id=t.forum_id AND r2.user_id=294 INNER JOIN fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud_group_cache g2 ON g2.user_id=294 AND g2.resource_id=f.id WHERE t.id=1317
_GET: t=tree&goto=4156&rid=294&
Server Version: 4.1.8a-ProHosting-SMP
[Referring Page] http://www.scoutswest.com/fforum/www/index.php?t=threadt&frm_id=18& rid=294
Update 3, it seems that I only get the above mess. when in Flat View??. When I go to Tree View I don't see any problems!
Update 4, now that all the dust has settled. It looks like all is well! Could it be that it just takes some time for the upgrade code to trickle down thur the system before one should start checking for any errors?
Got Torque?
[Updated on: Tue, 25 January 2005 21:01] Report message to a moderator |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]