Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
Okay well all if not lost
I just had this happen to a guy a few days ago.

Do the following. These are sql queries from Threads admin panel.

1.

DROP TABLE w3t_Category

2.

CREATE TABLE `w3t_Category` (
`Cat_Title` varchar(120) NOT NULL default 'General Discussion',
`Cat_Number` int(9) unsigned NOT NULL default '0',
`Cat_Description` text,
`Cat_Type` varchar(10) NOT NULL default 'forum',
KEY `indx1` (`Cat_Title`),
KEY `indx2` (`Cat_Number`),
KEY `type_ndx` (`Cat_Type`)
) TYPE=MyISAM;


3. Then in your admin panel you can recreate your categories.
If you go to EDIT FORUMS you will notice that the category names are listed with forums underneath still. So jot down the categories in order as the forums are displayed in order under the proper cat order in the edit window. Now go to create categories and create them one at a time in the order you wrote them down. All should be well and working for you now.

This is the way to do it if you have no backups. I suggest you do backups from now on to be safe. You never know when your going to lose the user or post tables under something like this.

Sponsored Links
Entire Thread
Subject Posted By Posted
Help with sql error jma 09/20/2003 2:26 PM
Re: Help with sql error omegatron 09/20/2003 2:58 PM
Re: Help with sql error omegatron 09/20/2003 2:59 PM
Re: Help with sql error Dave_L_dup1 09/20/2003 3:41 PM
Re: Help with sql error omegatron 09/20/2003 4:01 PM
Re: Help with sql error jma 09/20/2003 4:48 PM
Re: Help with sql error Dave_L_dup1 09/20/2003 4:51 PM
Re: Help with sql error omegatron 09/20/2003 5:53 PM
Re: Help with sql error jma 09/21/2003 2:36 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)