I didn't me that in a bad way. I was jusy saying that adding too many queries might not be a good idea to some poeple. Sorry if you took that wrong. ;)

np .....

i wish there was another way ..... but none i can think of without the extra
queries .......

How can I clear #1060 - Duplicate column name 'showthanks'
to run
ALTER TABLE `forum` ADD `showthanks` INT(1) DEFAULT '0' NOT NULL;

again, because anytime I run it give me error as the message below.
Thanks tnguy3n

Error

SQL-query :

ALTER TABLE `forum` ADD `showthanks` INT( 1 ) DEFAULT '0' NOT NULL

MySQL said:


#1060 - Duplicate column name 'showthanks'

That error means that column is already there. You do not need to run that query again. ;)

I don't know what the heck exactly wrong with my database. It keeps give me a message that:

you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


I HAVE READ THIS INTRUCTION FOR MANY TIMES EVEN I got sucessful when Run SQL query/queries on database.
From tnguy3n told me for his help, but it is still not working..
What is exactly wrong about it.

Run this query:

I run this query already, but the problem is the same.

I tested this on my localhost and it seemed to work fine. I think I got that "No Permission Message" too, but then I updated that "thank you" option for forums (by running that query) and i got it to work.
(hey, i noticed you got the same last name as mine ;) )

How do I add a counter to show the total number of members who made the "Thanks"??

Thanks

I'll do it Vitrox ;)