Database error in vBulletin Control Panel: Invalid SQL: ALTER TABLE user ADD
country VARCHAR (50) NOT NULL

mysql error: Duplicate column name 'country'
mysql error number: 1060
Date: Friday 21st of September 2001 02:24:11 PM
Script: /forums/admin/flag.php?
Referer:

You only need to run flag.php ONCE! This will create the field for country in the user table. After that you DON'T run flag.php again! Delete flag.php!

Make sure you have followed the rest of the instructions in the .txt file. All the php files that were edited need to be uploaded and everything should be working!

i tried replacing all the files with default and the same problem persist.

First of all, you need to get ONE hack working before you start another. You seem to be simultaneously working on 2 hacks (Country Flag and Astrological Sign) and getting errors from one, the other, or both!!!

What do you mean by this?? ?? ?? ?? ?? There are NO files to replace. You need to go to the first post in this thread and download the actual hack. Then you need to read and follow the .txt file as it guides you through editing the .php files it needs to work. Then, after EVERYTHING is followed in the .txt file, if you still have problems, let me know. You are posting in both this and the Astrological Sign hack at the same time which you can't be working on both at the same time... get one working first! Then move on to the next hack!

meaning i uploaded the default .php files example member.php and register.php and ran flag.php again but did not work. :(

Like I said, if you already ran flag.php, DON'T run it again! The first time you ran it, it added the country field to the user table. Every time you try to run it now, it sees that the country field already exists and will ALWAYS give you an error because it exists. If you made all the changes to the .php files and uploaded them, go to your forum homepage, log in as you, click on the 'User CP' and click on 'Edit Profile'. Look for 'Select your Country' and choose your country from the dropdown list. Submit the modifications and look for one of your posts in the forum. You should see the flag next to your name! Click on your profile and you should see the flag next to your name!

ok i get the options for selecting country, but it is blank! nothing to choose! i think below is what i dont understand, if possible pls explain.

this is from the readme:

*** The 'modifyprofile_country' template needs to be changed
to a default original templatesetid of -1 (changed templates
have the templatesetid set to 2) or else the Admin CP addon
will not show the country select list (Any ideas why?). To do
this, use phpMyAdmin and run this query:
UPDATE template SET templatesetid="-1" where title="modifyprofile_country"
This will move the template from the custom to default templates
and will be found in the 'User Option Templates' group.

hope to hear from u soon.

If you have access to phpMyAdmin, go to it and use the following query:

UPDATE template SET templatesetid="-1" where title="modifyprofile_country"

Otherwise, upload the attached tempchange.php file to your admin directory and execute it like you did with flag.php. Then try going to your Edit Profile and see if the list is there.

nope....sighz...ok

and a problem i cant seem to add the template modifyprofile_country anymore, i tried adding 2 times but its never there, help~

You can't add a 'modifyprofile_country' template anymore because one already exists! By running the tempchange.php, it changed the template from a "custom" to a "default original" template (-1). You will now find the template in the 'User Option Templates' group. Click on expand and you should see the 'modifyprofile_country' template.