 | [Solved] Help with installing Country Flags MOD |  |
 Posted: 04/09/2007 4:16 AM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 8:31 AM
Location: Birmingham, UK.
|
|
|
|
|
 |
| Code:
|
Proposed Database Alterations for your mysql Database Allow
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Unexpected or unknown attribute "AFTER USER_FROM", in "user_from_flag varchar(25) NULL AFTER user_from", statement: 1, table: "phpbb_users"
SQL:
ALTER TABLE phpbb_users ADD user_from_flag varchar(25) NULL AFTER user_from
|
What is it I need to do? |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 4:33 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:31 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Hmm, I had to do it this way
copy and paste of all the sql queries above into http://www.phpbbstyles.com/sql.php then run it, then remove the sql section from the install file and reupload it back onto the host... the mod processed fine after had doing the sql queries manually.
Not sure whether I did this the easy way or but it installed! Woohoo  |
|
|
|
|
| Back to Top |
|
|
| Re: Help with installing Country Flags MOD | |
| Posted: 04/09/2007 4:41 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 11:31 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
I think the MOD was already installed earlier and removed and SQL queries were run before and you tried to install it again in which you don't need to run SQL queries again for the second time and skip that step and it will install properly  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 4:46 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:31 AM
Location: Birmingham, UK.
|
|
|
|
|
|
It couldn't have been that because it was the first time I installed the mod (I think) 
Anyway, I want to know how Nightrider managed to get the flags to move. My flags are boring 
I tried to add Nightrider’s flag too but it was to big  |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 6:11 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 11:31 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| Ohk. Let's see what NightRider replies. |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 8:21 AM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:31 AM
Location: Birmingham, UK.
|
|
|
|
|
|
Thanks anyway abdulbasit 
NIGHTRIDER ... |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 8:23 AM |
|
|
|
|
|
| Citation |
| Posts |
1017 |
| Word Cnt. |
64,643 |
| BDay |
Apr 18 |
| Sign |
Aries |
| Sex |
|
|
|
|
Joined: Apr 01, 2007
Local time: 11:31 AM
Location: UNITED ARAB EMIRATES
|
|
|
|
|
|
| You are always welcome. Whatever I have learnt is because of NightRider. I was nothing. He have helped me in every matter. He is genius |
|
|
|
|
| Back to Top |
|
|
| Re: Help with installing Country Flags MOD | |
| Posted: 04/09/2007 12:50 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:31 AM
Location: St Pete, FL
|
|
|
|
|
|
| Chris Powell wrote:
|
| Code:
|
Proposed Database Alterations for your mysql Database Allow
SQL PROCESSING ERROR:
No SQL alterations will be performed. However, you may skip SQL processing, continue installing the MOD, and deal with the SQL manually
The following error occured:
Error:
Unexpected or unknown attribute "AFTER USER_FROM", in "user_from_flag varchar(25) NULL AFTER user_from", statement: 1, table: "phpbb_users"
SQL:
ALTER TABLE phpbb_users ADD user_from_flag varchar(25) NULL AFTER user_from
|
What is it I need to do?
|
This error is caused by the AFTER option in the SQL query. EM doesn't recognize that option. But since it is not necessary in the query, you could always modify queries that contain the AFTER fieldname by removing that part. The placement of the new field is not important, so the AFTER part is totally unnecessary...
This query could be rewritten to this:
| Code:
|
|
ALTER TABLE phpbb_users ADD user_from_flag varchar(25) NULL;
|
The animated flags installed here come from two different sites:
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] Help with installing Country Flags MOD | |
| Posted: 04/09/2007 1:15 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 8:31 AM
Location: Birmingham, UK.
|
|
|
|
|
|
So the AFTER fieldname is not needed. Got it.
As to the Flags isn't there a pack with all of them in there already... it would take me forever and a day getting them all one by one. It will take me long enough setting up the location/names for all the flags in ACP
Is there any change of you sending me RCF's images/flags pack?  you can pm the link if you don't want to post them openly on here…
Btw welcome back dude |
|
|
|
|
| Back to Top |
|
|
| Re: Help with installing Country Flags MOD | |
| Posted: 04/09/2007 1:27 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 3:31 AM
Location: St Pete, FL
|
|
|
|
|
|
The way I have worked the Animated flags is this. When someone registers with a new location that I haven't gotten an animated flag, I donwload it from one of those links I provided, then I correct it. I haven't replaced all of the flags because as you say, that would take forever. But it doesn't take me very long to fix them one at a time when a new one is needed...
All of our animated flags are mixed with the non-animated flags on our server, so it would be nearly impossible for me to find and separate them so that I could create an animated flag pak for everyone...
 |
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
![[ Hidden ]](templates/Helius_blue/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
