# \[paid\] Need some minor help with my DB

**URL:** <https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892>\
**Category:** Marketplace\
**Created:** [2015年三月2日 13:12 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892 "2015-03-02T13:12:47Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![timothyplank](https://avatars.discourse-cdn.com/v4/letter/t/c89c15/32.png) [@timothyplank](https://meta.discourse.org/u/timothyplank)\
**Post date:** [2015年三月2日 13:12 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/1 "2015-03-02T13:12:47Z")

</div>

Hi,

Happy to pay someone to correct an error I’ve caused. I changed the name of the meta category and slug, and it’s now causing an invalid page error when trying to access the category.

It probably just requires that the category name and slug be returned to ‘meta’ but I’d rather not mess around in the shell trying to run queries in postgres - really not familiar with it.

If you can help, please ping me.

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2015年三月2日 20:02 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/2 "2015-03-02T20:02:54Z")

</div>

I don’t think meta has anything special about it, it is just another category.

However: I noticed you changed the slug to `/chat` – can you try changing it to `general-chat` instead?

---

<div class="post-metadata">

**Author:** ![timothyplank](https://avatars.discourse-cdn.com/v4/letter/t/c89c15/32.png) [@timothyplank](https://meta.discourse.org/u/timothyplank)\
**Post date:** [2015年三月2日 21:34 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/3 "2015-03-02T21:34:56Z")

</div>

Hi Jeff,

Thanks for the reply. The problem I have is that I can’t get onto the category page in order to change the slug back, as it throws the error. As the only place to edit it is on the page, this makes it a little tricky.

I guess I’d need to run an update query on the DB to do this but I’m not familiar with running sql queries from the command line, so if you could tell me how, that’d be awesome.

I have tried creating a new DB user and logging into the DB but got a response saying the DB wouldn’t allow the connection. Didn’t want to mess around too much without knowing how.

Thanks for your help.

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [2015年三月2日 22:20 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/4 "2015-03-02T22:20:01Z")

</div>

@techapj has some walkthroughs here under howto on getting to the rails console and issuing SQL commands.

---

<div class="post-metadata">

**Author:** ![timothyplank](https://avatars.discourse-cdn.com/v4/letter/t/c89c15/32.png) [@timothyplank](https://meta.discourse.org/u/timothyplank)\
**Post date:** [2015年三月3日 00:46 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/5 "2015-03-03T00:46:29Z")

</div>

Excellent, it’s done, thanks for the help.

---

<div class="post-metadata">

**Author:** ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)\
**Post date:** [2015年三月6日 00:46 UTC](https://meta.discourse.org/t/paid-need-some-minor-help-with-my-db/25892/6 "2015-03-06T00:46:33Z")

</div>

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.