Xabi wrote:Could this module be expanded to show regions for every country with a dependant dropdown menu?
http://www.zonderdank.be/uploads/files/ ... 01.0.0.zipoddfish wrote:IP_Country_Flag_210.rar is not this MOD.
Yes your'e right, I'm confused. te error is on file : Country Flags 1.0.0.zip dowload from this postoddfish wrote:IP_Country_Flag_210.rar is not this MOD.
This link is not working as wellsaaiberke wrote:For those who can't wait for the download to be up again, you can find the latest release here.
I get the same error too.cotp wrote:Hello, I just tried to delete a user from global moderators group and got this error message:Any idea if it is a mod's bug or one I did ?Code: Select all
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 = 1410' at line 6 [1064] 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 = 1410' at line 6 [1064] SQL UPDATE phpbb3_users SET user_flag = '' WHERE group_id = 2172 AND user_flag <> '' AND user_flag = AND user_id = 1410 BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal->sql_error() FILE: includes/functions_user.php LINE: 2865 CALL: dbal_mysql->sql_query() FILE: includes/functions_user.php LINE: 2754 CALL: remove_default_flag() FILE: includes/acp/acp_groups.php LINE: 198 CALL: group_user_del() FILE: includes/functions_module.php LINE: 471 CALL: acp_groups->main() FILE: adm/index.php LINE: 78 CALL: p_master->load_active()
Cotp
PS: the strange thing I could remove a user from a group but not from global moderators...
Code: Select all
remove_default_flag($gid, $uids);
Code: Select all
// remove_default_flag($gid, $uids);
Thanks, that fixed the problem. Another thing that was mentioned a couple of pages back is that when new member register and selects country flag it still shows that no flag was selected and displays "---" instead of a flag in the profile page.oddfish wrote:try this ^talkbasket^ - had problems with it changing a user's default group and it shows in the error you are getting :
OPEN includes/functions_user.php
FINDand comment it out :Code: Select all
remove_default_flag($gid, $uids);
Code: Select all
// remove_default_flag($gid, $uids);
@*Capmaster*: Here you are: http://rapidshare.com/files/81743371/Co ... _1.0.0.zip*Capmaster* wrote:Any chance of actually being able to download this mod?
All the links are bad, and the author's own link to the mods on his fileserver stops at ver. 0.8.0.
Twelve pages of posts and no link to the current version. What a circle-jerk
Code: Select all
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 = 54' at line 6 [1064]
SQL
UPDATE phpbb_users SET user_flag = '' WHERE group_id = 2 AND user_flag <> '' AND user_flag = AND user_id = 54
BACKTRACE
FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()
FILE: includes/functions_user.php
LINE: 2902
CALL: dbal_mysql->sql_query()
FILE: includes/functions_user.php
LINE: 3048
CALL: remove_default_flag()
FILE: includes/acp/acp_users.php
LINE: 1885
CALL: group_user_attributes()
FILE: includes/functions_module.php
LINE: 479
CALL: acp_users->main()
FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
The fix is 4 posts above yours link.komAk wrote: Hello guys i have a problem and i supose it is because of this mod. When i want to make a default groups for any user it tells me this:
The only problem with this is that i can't add mods or admins..please help me..or tell me another way to make mods or admins..even with mysql..Code: Select all
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 = 54' at line 6 [1064] SQL UPDATE phpbb_users SET user_flag = '' WHERE group_id = 2 AND user_flag <> '' AND user_flag = AND user_id = 54 BACKTRACE FILE: includes/db/mysql.php LINE: 158 CALL: dbal_mysql->sql_error() FILE: includes/functions_user.php LINE: 2902 CALL: dbal_mysql->sql_query() FILE: includes/functions_user.php LINE: 3048 CALL: remove_default_flag() FILE: includes/acp/acp_users.php LINE: 1885 CALL: group_user_attributes() FILE: includes/functions_module.php LINE: 479 CALL: acp_users->main() FILE: adm/index.php LINE: 74 CALL: p_master->load_active()