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

Home » FUDforum Development » Bug Reports » Topics show above Announcements and Stickies + Consistency Check
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Topics show above Announcements and Stickies + Consistency Check [message #29763] Sat, 14 January 2006 16:14 Go to next message
djechelon is currently offline  djechelon   Italy
Messages: 46
Registered: July 2005
Karma: 0
Member
Damn I got another bug... Crying or Very Sad

I noticed that normal topics appear above Announcements and Stickies. I read the how-to and found a topic about this matter.
Unfortunately I can't run Consistency check because of the following error
Disabling the forum for the duration of maintenance run
Locking the database for checking
(/home/xxx/FUDforum/include/theme/default/db.inc:78
/home/xxx/FUDforum/include/theme/default/db.inc:209
/home/xxx/forum/adm/consist.php:135
) 1146: Table 'kamelot.forum_forum' doesn't exist
Query: SELECT id FROM forum_forum
_POST: array ( 'conf' => 'Yes', 'SQ' => '***', )
Server Version: 4.0.26
[Referring Page] http://www.kamelot.webcust.prq.se/forum/adm/consist.php?rid=3&SQ=****


I'm using 2.7.3 I'll try to upgrade to 2.7.4 first...

[follow-up] I did the upgrade, but upgrade's consistency check can't run! Reutrns same error!!!

[Updated on: Sat, 14 January 2006 16:20]

Report message to a moderator

Re: Topics show above Announcements and Stickies + Consistency Check [message #29764 is a reply to message #29763] Sat, 14 January 2006 16:28 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Do you have a table alias or something that would make show tables return "forum_forum" ?

FUDforum Core Developer
Re: Topics show above Announcements and Stickies + Consistency Check [message #29767 is a reply to message #29763] Sat, 14 January 2006 16:30 Go to previous messageGo to next message
djechelon is currently offline  djechelon   Italy
Messages: 46
Registered: July 2005
Karma: 0
Member
OK I've found the reason.

It's just a letter case problem. I chose "Forum" as table prefix, with capital F. The script insists to use lower case prefix. I manually edited that query and got the same error by another query. That part ran fine!

In fact, I have another error:

WRITE, Forum_tv_47 WRITE, Forum_tv_48 WRITE, Forum_tv_49 WRITE, Forum_tv_5 WRITE, Forum_tv_50 WRITE, Forum_tv_51 WRITE, Forum_tv_52 WRITE, Forum_tv_53 WRITE, Forum_tv_54 WRITE, Forum_tv_55 WRITE, Forum_tv_56 WRITE, Forum_tv_57 WRITE, Forum_tv_58 WRITE, Forum_tv_59 WRITE, Forum_tv_6 WRITE, Forum_tv_60 WRITE, Forum_tv_61 WRITE, Forum_tv_62 WRITE, Forum_tv_63 WRITE, Forum_tv_64 WRITE, Forum_tv_65 WRITE, Forum_tv_66 WRITE, Forum_tv_67 WRITE, Forum_tv_68 WRITE, Forum_tv_69 WRITE, Forum_tv_7 WRITE, Forum_tv_70 WRITE, Forum_tv_71 WRITE, Forum_tv_8 WRITE, Forum_tv_9 WRITE, Forum_user_ignore WRITE, Forum_users WRITE, forum_tv_2 WRITE, forum_tv_3 WRITE, forum_tv_4 WRITE, forum_tv_5 WRITE, forum_tv_6 WRITE, forum_tv_7 WRITE, forum_tv_8 WRITE, forum_tv_9 WRITE, forum_tv_10 WRITE, forum_tv_11 WRITE, forum_tv_12 WRITE, forum_tv_13 WRITE, forum_tv_14 WRITE, forum_tv_15 WRITE, forum_tv_16 WRITE, forum_tv_17 WRITE, forum_tv_18 WRITE, forum_tv_19 WRITE, forum_tv_20 WRITE, forum_tv_21 WRITE, forum_tv_22 WRITE, forum_tv_23 WRITE, forum_tv_24 WRITE, forum_tv_25 WRITE, forum_tv_26 WRITE, forum_tv_27 WRITE, forum_tv_28 WRITE, forum_tv_29 WRITE, forum_tv_30 WRITE, forum_tv_31 WRITE, forum_tv_32 WRITE, forum_tv_33 WRITE, forum_tv_34 WRITE, forum_tv_35 WRITE, forum_tv_36 WRITE, forum_tv_37 WRITE, forum_tv_38 WRITE, forum_tv_39 WRITE, forum_tv_40 WRITE, forum_tv_41 WRITE, forum_tv_42 WRITE, forum_tv_43 WRITE, forum_tv_44 WRITE, forum_tv_45 WRITE, forum_tv_46 WRITE, forum_tv_47 WRITE, forum_tv_48 WRITE, forum_tv_49 WRITE, forum_tv_50 WRITE, forum_tv_51 WRITE, forum_tv_52 WRITE, forum_tv_53 WRITE, forum_tv_54 WRITE, forum_tv_55 WRITE, forum_tv_56 WRITE, forum_tv_57 WRITE, forum_tv_58 WRITE, forum_tv_59 WRITE, forum_tv_60 WRITE, forum_tv_61 WRITE, forum_tv_62 WRITE, forum_tv_63 WRITE, forum_tv_64 WRITE, forum_tv_65 WRITE, forum_tv_66 WRITE, forum_tv_67 WRITE, forum_tv_68 WRITE, forum_tv_69 WRITE, forum_tv_70 WRITE, forum_tv_71 WRITE, forum_users u WRITE, forum_forum f WRITE, forum_thread t WRITE, forum_poll p WRITE, forum_poll_opt po WRITE, forum_poll_opt_track pot WRITE, forum_msg m WRITE, forum_pmsg pm WRITE, forum_mod mm WRITE, forum_thread_rate_track trt WRITE, forum_msg_report mr WRITE, forum_cat c WRITE, forum_forum_notify fn WRITE, forum_thread_notify tn WRITE, forum_buddy b WRITE, forum_user_ignore i WRITE, forum_msg m1 WRITE, forum_msg m2 WRITE, forum_users u1 WRITE, forum_users u2 WRITE, forum_attach a WRITE, forum_thr_exchange te WRITE, forum_read r WRITE, forum_mime mi WRITE, forum_group_members gm WRITE, forum_group_resources gr WRITE, forum_groups g WRITE, forum_group_members gm1 WRITE, forum_group_members gm2 WRITE, forum_themes thm WRITE


As you can see, the first tables have Forum as prefix, the last ones have forum.

I'll have to manually edit all the things
Re: Topics show above Announcements and Stickies + Consistency Check [message #29769 is a reply to message #29767] Sat, 14 January 2006 16:33 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Take out this line:
$tbl = strtolower($tbl); // table names on mysql need to be lowercase
inside consist.php and tell me if it does the trick.


FUDforum Core Developer
Re: Topics show above Announcements and Stickies + Consistency Check [message #29771 is a reply to message #29763] Sat, 14 January 2006 17:11 Go to previous messageGo to next message
djechelon is currently offline  djechelon   Italy
Messages: 46
Registered: July 2005
Karma: 0
Member
OK it worked!

I have one last problem that is a bit off-topic.
I messed up with GLOBALS.php file on forum's root directory in order to try to change all the tables' prefixes. Unfortunately when restoring I always get Forum Disabled and I can only access Admin.

On Global Configuration, the forum is enabled but I still can't access it (www.kamelot.webcust.prq.se/forum).

Any suggestion?
Re: Topics show above Announcements and Stickies + Consistency Check [message #29773 is a reply to message #29763] Sat, 14 January 2006 17:28 Go to previous messageGo to next message
djechelon is currently offline  djechelon   Italy
Messages: 46
Registered: July 2005
Karma: 0
Member
OK this is gone too.
I have just edited the FUD_OPTION_1 variable manually to make it odd and it works. Maybe it was only a CHMOD problem. Dunno.

Thank you for your help.

[Follow-up] Now in version 2.7.4 normal topics do not appear over Stickies & Announcements.

But is it OK that Stickies are above Announcements? On normal forums it's the opposite rule!

[Updated on: Sat, 14 January 2006 17:33]

Report message to a moderator

Re: Topics show above Announcements and Stickies + Consistency Check [message #29778 is a reply to message #29773] Sat, 14 January 2006 18:03 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The stickies and announcements are the same thing internally, just a different name. So the order depends on the posting time.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Cannot use forum_login.php and fudapi.inc.php together
Next Topic: Error : Invalid group id when Mass Emailing
Goto Forum:
  

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

Current Time: Sun Nov 24 01:15:13 GMT 2024

Total time taken to generate the page: 0.02490 seconds