[BETA] Country Flags 1.0.0

[littlebags Chris]

Okay thanks.

[appa]

when i try to try to Update a users default group settings from User administration :: ravikumar.. after clicking Make group default for member, it give me following error....

Please help me to fix this.. it's on a live forum...

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 1868' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 508 AND user_flag <> '' AND user_flag = AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 3056
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1903
CALL: group_user_attributes()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

and when i try to click Remove member from group it giving me following error..

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in AND user_id = 1868' at line 5 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 514 AND user_flag <> '' AND user_flag = in AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1920
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

When i try to set users default group from Group members :: Moderators, it's giving me following error..

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in AND user_id IN (1812, 1868)' at line 5 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 514 AND user_flag <> '' AND user_flag = in AND user_id IN (1812, 1868)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 3056
CALL: remove_default_flag()

FILE: includes/acp/acp_groups.php
LINE: 141
CALL: group_user_attributes()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_groups->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

and when i try to remove users from Group members :: Moderators, it's giving me following error..

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'in AND user_id = 1868' at line 5 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 514 AND user_flag <> '' AND user_flag = in AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_groups.php
LINE: 197
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_groups->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Please some 1 help me to fix..

it's on live forum....

[appa]

OPEN includes/functions_user.php

FIND

Code: Select all

remove_default_flag($gid, $uids);

and comment it out :

Code: Select all

// remove_default_flag($gid, $uids);

After do the above.. now i can set default group.. but still i can't remove any 1 from group(from User administration :: as well as Group members :: Any Group)

getting following error:: from Group members :: Any Group

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 1868' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 525 AND user_flag <> '' AND user_flag = AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_groups.php
LINE: 197
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_groups->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

And : following from User administration ::

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 1868' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 525 AND user_flag <> '' AND user_flag = AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1920
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

[appa]

OPEN includes/functions_user.php

FIND

Code: Select all

remove_default_flag($gid, $uids);

and comment it out :

Code: Select all

// remove_default_flag($gid, $uids);

After do the above.. now i can set default group.. but still i can't remove any 1 from group(from User administration :: as well as Group members :: Any Group)

getting following error:: from Group members :: Any Group

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 1868' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 525 AND user_flag <> '' AND user_flag = AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_groups.php
LINE: 197
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_groups->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

And : following from User administration ::

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 1868' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 525 AND user_flag <> '' AND user_flag = AND user_id = 1868

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2910
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2800
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1920
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

[/quote]


Actually i think, it's really interesting to find out error by trial and error methods..
So finally i able to fix this...

[quote="appa"]OPEN includes/functions_user.php

FIND

Code: Select all

remove_default_flag($group_id, $sql_where_ary[$gid]);

and comment it out :

Code: Select all

// remove_default_flag($group_id, $sql_where_ary[$gid]);

Cool, now everything works perfect.. and also i don't need to use Group Flag.. until it fixed...

[NoLimit]

Why after a month of being flawless does this error come and bite me today?

Dont make no darn sense!!

I installed this mod early to late feb. Changed my flag in my Admin acct, and been admining the board as usual. Then all the sudden today, I dont have access to any of the things that are guarded by group permissions. I modified my Moderator Control Panel link and Quick Mod drop down and other things so that only GID 2 and 4 can see them. This morning I was in the Mod control panel and everything was fine. Then all the sudden, out of no where the mod ctrl link was gone!! So were two other links guarded by GID permissions. My admin acct was no longer red in my member list, etc. It was though I was a regular user, just with access to the ACP!!

I went to the ACP and tried to change my default group back to Admin, and got the error posted above. I commented out that line and all seems to be back to the norm.

The only think I can think of is that yesterday/last night I installed these 3 board mods.

'Topic Tags MOD' Version 0.1.0
'Prime Trash Bin' Version 0.2.18
'JC Auto-Archiver' Version 0.1.0

Unfortunatly I installed them all back to back and never accessed the Mod Control Panel inbetween the modifications. So I dont know if they have anthing to do with this bug coming out of the woodwork or not.

At anyrate, Thank you Appa for the quick fix.

[fakan]

I Got the same above error and solved the problem after commented the code in functions_user.php as appa post

[Hearthrobz]

Any one plz help me


This mod worked for me since last week.But after that flags are not appearing in the viewtopic and option to change flag is appearing in profile.But when i press change country flag and select my country,it say's changes saved.But after that it returns to the default level without any change in country.

I reinstalled mod and also dropped and re installed sql.what to do,plz help

[shanto Shanto]

When I want to remove a user from the group I get this..


SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 19' at line 6 [1064]

SQL

UPDATE phpbb3_users SET user_flag = '' WHERE group_id = 359 AND user_flag <> '' AND user_flag = AND user_id = 19

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2832
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 2765
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1895
CALL: group_user_del()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

[Mandarim]

Ive the same error

Code: Select all

SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND user_id = 187' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 14 AND user_flag <> '' AND user_flag = AND user_id = 187

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions_user.php
LINE: 2873
CALL: dbal_mysql->sql_query()

FILE: includes/functions_user.php
LINE: 3019
CALL: remove_default_flag()

FILE: includes/acp/acp_users.php
LINE: 1879
CALL: group_user_attributes()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()


how can i resolve it!?

[DimazzzZ]

Hi all. Sorry for disturbing, I have a question I have a bug with this mod, and me or my friends can't find Error: uncaught exception: What The.... On my forum installed Avalon style and in UCP it not show info in drop-down list I write original lines from code and tested to put working code from ACP. In acp it works, but it ucp all codes of this mod didn't work. Could you tell me what can I do with it?
Thanks

PS - I tested to put code on header and many others place of site, but mod works correctly only in ACP