Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 12:11 pm EST

Geeklog Forums

Rename GL link categories


eYos

Anonymous
Currently I still use geeklog 1.4.0sr6. How can I rename the link categories without loosing all my entries? I know there's a way to rename it with phpmyadmin, but what's the exact command?

Thanks for your help
 Quote

eYos

Anonymous
No one? Sorry, I am total beginner in SQL.
 Quote

iam

Anonymous
Quote by: eYos

No one? Sorry, I am total beginner in SQL.


I think all Geeklog ExpertAAA they never done this before or may be they so busy to look at your request question. you better to try by your self, if you can't do with phpmyadmin I think you try to do manually.

bye.
 Quote

eYos

Anonymous
Thanks for your reply. Hm, This could be difficult with over 600 entries ;-)
 Quote

Status: offline

1000ideen

Forum User
Full Member
Registered: 08/04/03
Posts: 1298
I wonder if that is possible with GL 1.5.1 and the latest link plugin. At least there the fields ID and name can be changed online.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
In 1.5.1, you can do that directly in the Links plugin (1.5.0 had a few bugs there).

In 1.4.1, this SQL request should do (untested, as I don't have a 1.4.1 site where I could test it right now):
Text Formatted Code
UPDATE gl_links SET category = 'new-category' WHERE category = 'old-category';

When you do that, you need to take care of duplicate categories yourself.

bye, Dirk
 Quote

eYos

Anonymous
@ Dirk

Thank you!!! This is exactly what I was looking for!
 Quote

All times are EST. The time is now 12:11 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content