FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Problem while running "Consistency Check"
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Problem while running "Consistency Check" [message #30078] Thu, 02 February 2006 04:14 Go to next message
Mathieu is currently offline  Mathieu   France
Messages: 47
Registered: December 2004
Karma: 0
Member
I've run a "Consistency Check" and here is what I get:

Disabling the forum for the duration of maintenance run
Locking the database for checking
(/home/www/htdocs/nolwenn/forumdata/include/theme/default/db.inc:73
/home/www/htdocs/nolwenn/forumdata/include/theme/default/db.inc:40
/home/www/htdocs/nolwenn/public_html/forum/adm/consist.php:152
) 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 '-new WRITE, fud23_avatar WRITE, fud23_blocked_logins WRITE, fud
Query: LOCK TABLES fud23_action_log WRITE, fud23_ann_forums WRITE, fud23_announce WRITE, fud23_attach WRITE, fud23_avatar-new WRITE, fud23_avatar WRITE, fud23_blocked_logins WRITE, fud23_buddy WRITE, fud23_cat WRITE, fud23_custom_tags WRITE, fud23_email_block WRITE, fud23_ext_block WRITE, fud23_fc_view WRITE, fud23_fl_1 WRITE, fud23_fl_10 WRITE, fud23_fl_11 WRITE, fud23_fl_12 WRITE, fud23_fl_13 WRITE, fud23_fl_14 WRITE, fud23_fl_15 WRITE, fud23_fl_16 WRITE, fud23_fl_2 WRITE, fud23_fl_3 WRITE, fud23_fl_4 WRITE, fud23_fl_5 WRITE, fud23_fl_6 WRITE, fud23_fl_7 WRITE, fud23_fl_8 WRITE, fud23_fl_9 WRITE, fud23_fl_pm WRITE, fud23_forum WRITE, fud23_forum_notify WRITE, fud23_forum_read WRITE, fud23_group_cache WRITE, fud23_group_members WRITE, fud23_group_resources WRITE, fud23_groups WRITE, fud23_index WRITE, fud23_ip_block WRITE, fud23_level WRITE, fud23_mime WRITE, fud23_mlist WRITE, fud23_mod WRITE, fud23_mod_que WRITE, fud23_msg WRITE, fud23_msg_report WRITE, fud23_nntp WRITE, fud23_pmsg WRITE, fud23_poll WRITE, fud23_poll_opt WRITE, fud23_poll_opt_track WRITE, fud23_read WRITE, fud23_replace WRITE, fud23_search WRITE, fud23_search_cache WRITE, fud23_ses WRITE, fud23_smiley WRITE, fud23_stats_cache WRITE, fud23_themes WRITE, fud23_thr_exchange WRITE, fud23_thread WRITE, fud23_thread_notify WRITE, fud23_thread_rate_track WRITE, fud23_title_index WRITE, fud23_tmp_consist WRITE, fud23_tv_1 WRITE, fud23_tv_10 WRITE, fud23_tv_11 WRITE, fud23_tv_12 WRITE, fud23_tv_13 WRITE, fud23_tv_14 WRITE, fud23_tv_15 WRITE, fud23_tv_16 WRITE, fud23_tv_2 WRITE, fud23_tv_3 WRITE, fud23_tv_4 WRITE, fud23_tv_5 WRITE, fud23_tv_6 WRITE, fud23_tv_7 WRITE, fud23_tv_8 WRITE, fud23_tv_9 WRITE, fud23_user_ignore WRITE, fud23_users WRITE, fud23_users u WRITE, fud23_forum f WRITE, fud23_thread t WRITE, fud23_poll p WRITE, fud23_poll_opt po WRITE, fud23_poll_opt_track pot WRITE, fud23_msg m WRITE, fud23_pmsg pm WRITE, fud23_mod mm WRITE, fud23_thread_rate_track trt WRITE, fud23_msg_report mr WRITE, fud23_cat c WRITE, fud23_forum_notify fn WRITE, fud23_thread_notify tn WRITE, fud23_buddy b WRITE, fud23_user_ignore i WRITE, fud23_msg m1 WRITE, fud23_msg m2 WRITE, fud23_users u1 WRITE, fud23_users u2 WRITE, fud23_attach a WRITE, fud23_thr_exchange te WRITE, fud23_read r WRITE, fud23_mime mi WRITE, fud23_group_members gm WRITE, fud23_group_resources gr WRITE, fud23_groups g WRITE, fud23_group_members gm1 WRITE, fud23_group_members gm2 WRITE, fud23_themes thm WRITE
_POST: array ( 'conf' => 'Yes', 'S' => '7ffcc1a9c1912ed8940ab1f03ab39822', 'SQ' => '4c29c2722f1b0bd3c918f08ad35cabe6', )
Server Version: 4.0.24_Debian-10-log
[Referring Page] http://forum.nolwenn.org/adm/consist.php?rid=2664&S=7ffcc1a9c1912ed8940ab1f03ab39822&SQ=4c29c2722f1b0bd3c918f08ad35cabe6


What should I do?

I now have parts of the forum which are not available anymore. I'm using FUDforum 2.7.2.

[Updated on: Thu, 02 February 2006 04:19]

Report message to a moderator

Re: Problem while running "Consistency Check" [message #30079 is a reply to message #30078] Thu, 02 February 2006 04:44 Go to previous message
Mathieu is currently offline  Mathieu   France
Messages: 47
Registered: December 2004
Karma: 0
Member
I've solved the problem. I had created a new table "fud23_avatar-new" which prevented the Consistency Check from running properly.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: How to grant restricted access to admin-menu?
Next Topic: errors in the error log
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 04 00:32:28 GMT 2024

Total time taken to generate the page: 0.04229 seconds