I tried to upgrade my forum from 2.6x to v2.7.2.
Because I use a view of my user's table, the upgrade didn't go so well (alter table + views = fatal errors). With some hacking of the upgrade script, I was able to get it to skip the queries on my users table which I then ran manually and everything looks like it completed successfully.
However, now if I try to reindex the DB I get this error
Warning: pg_query() [function.pg-query]: Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block in /usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/db.inc on line 244
(/usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/db.inc:226
/usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/isearch.inc:116
/usr/home/cstdenis/www/fanart/anime-vidcaps/forums/adm/indexdb.php:75
) : ERROR: current transaction is aborted, commands ignored until end of transaction block
Query: INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 1 FROM fud26_search WHERE word IN('Anime','Vidcaps','has','new','forum')
_POST: array ( 'conf' => 'Yes', 'SQ' => 'ec4e5de98de427ccf9e07e2bc8a7dfbd', )
Server Version:
And, if I try to do a consistency check, I get this error:
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "fud26_attach_up" does not exist in /usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/db.inc on line 102
(/usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/db.inc:102
/usr/home/cstdenis/anime_vidcaps_forums/include/theme/default/db.inc:63
/usr/home/cstdenis/www/fanart/anime-vidcaps/forums/adm/consist.php:152
) : ERROR: relation "fud26_attach_up" does not exist
Query: LOCK TABLE fud26_action_log, fud26_ann_forums, fud26_announce, fud26_attach_up, fud26_avatar, fud26_blocked_logins, fud26_buddy, fud26_cat, fud26_custom_tags, fud26_email_block, fud26_ext_block, fud26_fc_view, fud26_forum, fud26_fl_1, fud26_forum_notify, fud26_forum_read, fud26_group_cache, fud26_group_members, fud26_group_resources, fud26_groups, fud26_index, fud26_ip_block, fud26_level, fud26_mime, fud26_mlist, fud26_mod, fud26_mod_que, fud26_msg, fud26_msg_report, fud26_nntp, fud26_ses, fud26_pmsg, fud26_fl_pm, fud26_poll, fud26_poll_opt, fud26_poll_opt_track, fud26_read, fud26_replace, fud26_stats_cache, fud26_search, fud26_search_cache, fud26_smiley, fud26_themes, fud26_thr_exchange, fud26_thread, fud26_thread_notify, fud26_thread_rate_track, fud26_title_index, fud26_user_ignore, fud26_fl_2, fud26_fl_3, fud26_fl_4, fud26_fl_5, fud26_fl_14, fud26_fl_6, fud26_fl_7, fud26_fl_8, fud26_fl_9, fud26_fl_10, fud26_fl_11, fud26_fl_12, fud26_fl_13, fud26_tv_14, fud26_tv_5, fud26_tv_8, fud26_tv_7, fud26_tv_9, fud26_tv_3, fud26_tv_10, fud26_tv_6, fud26_tv_2, fud26_tv_12, fud26_tv_1, fud26_tv_11, fud26_tv_4, fud26_tv_13,fud26_users,fud26_forum,fud26_thread,fud26_poll,fud26_poll_opt,fud26_poll_opt_track,fud26_msg,fud26_pmsg,fud26_mod,fud26_thread_rate_track,fud26_msg_report,fud26_cat,fud26_forum_notify,fud26_thread_notify,fud26_buddy,fud26_user_ignore,fud26_msg,fud26_msg,fud26_users,fud26_users,fud26_attach,fud26_thr_exchange,fud26_read,fud26_mime,fud26_group_members,fud26_group_resources,fud26_groups,fud26_group_members,fud26_group_members,fud26_themes IN ACCESS EXCLUSIVE MODE
_POST: array ( 'conf' => 'Yes', 'SQ' => 'ec4e5de98de427ccf9e07e2bc8a7dfbd', )
Server Version:
After digging through the code and upgrade script, I can't find any references to fud26_attach_up.
Also, I just accidentally closed the window and its no longer accepting my admin login. It doesn't reject it, but it does go back to the "Undergoing maintenance, please come back later." screen after I type it in.
|
Calendar
Search
Help
Members
Register
Login
Home
]