Hi,

I'm unable to use the admin to delete large categories and their subs as it keeps timing-out so the Monitor is now my option to delete them.

GT support cant help unless I pay them for the right mysql command, so I have managed to cobble together this command to use but need confirmation that it's correct...

DELETE FROM CatLinks WHERE CategoryID = 'idnumber';

Is that right?

Hopefully someone here can help else I'm completely stuck

Thanks.

SamX.

I don't know about this SQL-command (in fact, I don't know anything about sql... ;-) but I would install a copy of LinksSQL on my local system (yes, it runs on WinXX) and test it out. Use Mysqlman to up-/download the tables you need. Works pretty well. You can also delete the categories on your local system and then upload the new tables - since Mysqlman is very fast your server timeout should't be a problem.

Good luck

Andy

You will also need to delete the Category from the Category Table...

Run the following SQL commands in the SQLMonitor:

1)



2)



Then you will have to delete the CATEGORY folder in your links/pages folder....

Regards,

Eliot Lee

Thanks a lot Eliot :)

SamX

You're welcome...

Regards,

Eliot Lee

Hi,

You should now run Repair Tables to delete any orphaned links you might have (links that are not in any category).

Cheers,

Alex

--
Gossamer Threads Inc.

Ok, I got the categories deleted now I need to move lots of links from 1 category to another.
I search the forums but didn't see a way to do that from the monitor..

.. again any help very appreciated.

Thanks :)

Just tried the above to delete some large categories I have, however I'm not sure it completly worked. What I did was;

In SQL Monitor type;

Code:

DELETE FROM Links_CatLinks WHERE CategoryID = 'number';

Then;

Code:

DELETE FROM Links_Category WHERE ID = 'number';

Then I did a repair table, and it brought up a load of orphan links, which I deleted. However, the count now is completly wrong. Do I just need to run a SQL command again to update the number? If so, is this correct (I'm still a SQL newbie );

SELECT FROM Links_Links COUNT(*)

Thanks

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Also, to delete multiple categories in one go, could I use something like;

DELETE FROM Links_CatLinks WHERE CategoryID = 29199,28626,12345;

or

DELETE FROM Links_CatLinks WHERE CategoryID = (29199,28626,12345);

As I said earlier, I'm still quite a newbie with the more advanced codes...just getting the hang of UPDATE, INSERT, MODIFY etc

Thanks

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Anyone?

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

*bump* Anyone?

Thanks

Andy

You'd really need to do a "join" to get the category number/name for each link.

You'd have to be careful if a link is in more than 1 category, since there is only one copy of the link, but potentially several CatLink entries.

Probably easier and safer to write a short script that would do the selects, and keep track of the results.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

I decided it is wiser to give up . I tried downloading a dump to my computer, and doing it from there, but I only have 256Mb RAM and a crappy 28.8k connection , so the download of the file alone took 3 hours. Oh well, I'll try again some other time.

Thanks

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!