phpMyAdmin Help

[David]

Hey,

Nathan told me before, but I seemed to have forgotten. How do you run a query via phpMyAdmin?

I'm trying to run this script:

UPDATE phpbb_forums SET forum_flags = (forum_flags | 64) WHERE forum_type = 1

Thanks.

 

[Dasher]

Go into phpMyAdmin.
Click on your db that your told to run the query in.
Click the query tab.
Go to the big box and paste it and hit run or submit.

 

[David]

Nope, it isn't working at all. Do I have to purge the cache etc?

 

[Dean]

Did you get any error? because phpMyAdmin will throw out an error if you done something wrong.

Make sure you are doing the following:
cPanel > phpMyAdmin > DB > SQL Tab(second one right after Structure) > Put your SQL query (UPDATE phpbb_forums SET forum_flags = (forum_flags | 64) WHERE forum_type = 1) in the big box > GO

 

[John1]

To run a SQL query, click on "SQL" on the navigation bar.
Enter your SQL in the box provided.
Click 'Go'.

Hopefully that worked 😉

 

[David]

Hm. I can run it without error, but no result. (the query is for auto enable quick reply).

 

[Expired Account]

Is your table prefix phpbb_ ?

 

[posey]

Is your table prefix phpbb_ ?

If it was not, it would result into an error (if the database wouldn't exist). But if you have two database's, you will have to make sure to select the correct one with the correct prefix.

 

[David]

Yes Tayne, it is. I haven't received any errors, but I haven't received a result :shrug:

 

[posey]

Well, Quick Reply has two settings. Global Settings which has to be enabled and a forum-based settings. This SQL did all forum based settings, so you do not have to edit each forum. However, in "Post Settings" in the General tab of your ACP you will find the Global Setting: "Allow Quick Reply" which you will have to set to Yes.

Cheers,

 

[David]

No, I'm guessing you don't know that query. Its for the quick reply to show up automatically. Right now its a show/hide button and that is quite annoying. 🙂

 

[Expired Account]

No, I'm guessing you don't know that query. Its for the quick reply to show up automatically. Right now its a show/hide button and that is quite annoying. 🙂

I've sent you a PM about installing a different quick reply 😉

 

[Unknown Bliss]

If I were you just use Prime Quick Reply or Evil Quick Reply...

 

[Expired Account]

If I were you just use Prime Quick Reply or Evil Quick Reply...

Evil Quick Reply is the same, you click on a bottom to see the quick reply. Prime Quick Reply is good though.

 

[Unknown Bliss]

Yeah, the phpbb quick reply is based on evils, but there is an option to make evil quick reply to auto show.