Catagory order issue

[Scubasteve]

SMF Version: SMF 1.1 RC2
With Tiny Portal 0.86 (thnx bloc!!)

This problem never existed before, and has made its first appearence today. I have tried all the maintence options, checked that files are writeable, etc. Need some insight from the community.

One of the forums i admin has a problem with catagory order on the forum index. For example if i create a new catagory, move an old catagory, etc it doesnt reflect the changes on the index. I loaded the forum this morning and say the "Tools" catagory and its boards was below "General". This is strange because it wasnt last night, no admins have been on, and when i go into admin -- boards it shows it as it should be not how it is. So i tried moving it, i tried making a new catagory, etc and it shows fine under admin but not on the index.

Any ideas on wtf is going on? I tried running repair settings also but everything is as it should be.

[Scubasteve]

just noticed that if i make a new board it goes to the end of the catagory no matter where i place it or where it shows in the admin panel.....

what the fudge lol

[jerm]

anything in the error log?

[Scubasteve]

just a few failed login attempts, nothing relevant

[jerm]

hmm oddish
are the changes in the admin panel still correct, or does it go back to the orginal after you hit save?

also after you make the changes then go to see if the boards are displaying properly, try hitting ctl F5.

[Scubasteve]

admin panel is 100% correct like it should be and saves all changes. CTRL+F5 does nothing for it. I'm completely at a loss on this one, i really am.

[Scubasteve]

no one?

[Scubasteve]

Hard to believe this has never happened to anyone before lol. I'm trying to avoid redoing the forum because i would loose so much data if we didnt restore the database it wouldnt be worth it.

[Scubasteve]

up we go

[jerm]

if you dont mind, pm me a username/password with admin privilages and i'll take a look into it (and a link to your site)

[jerm]

i have a feeling that this might be a theme related issue. i was unable to select the defaul theme though

[Scubasteve]

it was working fine before and i did a clean install of the theme. I'll tweak it so you can change your theme real fast, i have my guys locked into this one. Thanks again for helping out.

[Fizzy]

Have you tried uninstalling the modded theme completely and then testing Admin Panel in Default Theme?

[Scubasteve]

Yes. me and electrohome have been trying alot of stuff. Last night, to update everyone, i did a FULL re-install. With and without TP and regardless of theme it works fine until i restore the database ie bring back my forums information. Then the problem comes back. I've checked the catagories table and the boards table and they are currect. electrohome has posted information in the support staff only forum on the problem, its a real humdinger

[Fizzy]

Could the MySQL table structures be corrupt?

[Scubasteve]

everything appears to be correct and intact. i'm basing it on experience and properly working installs : /

[Fizzy]

Can you check something for me.

The Category Order should be stored in `smf_categories` table in your database.
The structure should be as follows:

Code Select Expand


`smf_categories` (
  `ID_CAT` tinyint(4) unsigned NOT NULL auto_increment,
  `catOrder` tinyint(4) NOT NULL default '0',
  `name` tinytext NOT NULL,
  `canCollapse` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`ID_CAT`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;


The data in the table should include `catOrder` starting at zero. Can you make sure that you have a category assigned to zero.

Experiment.
Open up the table in phpmyadmin.
Browse the table data and make a note of the cats and their `catOrder` numbers
Change the order of one of the categories in your SMF admin panel
Refresh the Browse of the MySQL table. - Has the `catOrder` changed for the cat you just tweaked?

[Scubasteve]

structure is exactly as it should be, but when i modified the admin panel they did not change in the database itsself. So now what =]
 
 
 

[Fizzy]

Try forcing a change by editing it in the database and test it.
We need to ascertain if the problem is MySQL or PHP based.

[Scubasteve]

changing it in phpmyadmin made no difference on the index