[BETA] Country Flags 1.0.0

Modules for the User Control Panel
Forum rules
Image Please feel free to download any MOD's here, support for each MOD is located it's own thread.

To post your own MOD, please first read the MOD Guidelines

Re: [BETA] Country Flags 1.0.0

Postby littlebags » 05 Jan 2008, 17:42

Okay thanks. :good:
User avatar
littlebags    
Crewman
Crewman
 
Posts: 5
Joined: 05 Jan 2008, 04:52
Location: Vermont
Favorite Team: 49er's
Gender: Male




phpBB Academy at StarTrekGuide
Support STG
Using PayPal Donate

Re: [BETA] Country Flags 1.0.0

Postby appa » 09 Mar 2008, 13:01

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    
Supporter
Supporter
 
Posts: 47
Joined: 09 Mar 2008, 12:22
Favorite Team: MU
Gender: Male
phpBB Knowledge: 4

Re: [BETA] Country Flags 1.0.0

Postby appa » 10 Mar 2008, 04:42

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    
Supporter
Supporter
 
Posts: 47
Joined: 09 Mar 2008, 12:22
Favorite Team: MU
Gender: Male
phpBB Knowledge: 4

Re: [BETA] Country Flags 1.0.0

Postby appa » 10 Mar 2008, 11:24

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...
appa    
Supporter
Supporter
 
Posts: 47
Joined: 09 Mar 2008, 12:22
Favorite Team: MU
Gender: Male
phpBB Knowledge: 4

Re: [BETA] Country Flags 1.0.0

Postby NoLimit » 19 Mar 2008, 11:26

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

Dont make no darn sense!! :scratch:

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.
NoLimit
Cadet I
Cadet I
 
Posts: 13
Joined: 17 Feb 2008, 15:04
Gender: Male

Re: [BETA] Country Flags 1.0.0

Postby fakan » 25 Mar 2008, 15:07

I Got the same above error and solved the problem after commented the code in functions_user.php as appa post
fakan
Crewman
Crewman
 
Posts: 4
Joined: 20 Dec 2007, 12:13
Gender: Male

Re: [BETA] Country Flags 1.0.0

Postby Hearthrobz » 31 Mar 2008, 19:16

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
Hearthrobz
Crewman
Crewman
 
Posts: 4
Joined: 14 Mar 2008, 09:00
Gender: Male
phpBB Knowledge: 4

Re: [BETA] Country Flags 1.0.0

Postby shanto » 15 Apr 2008, 09:03

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()
shanto    
Crewman
Crewman
 
Posts: 8
Joined: 11 Apr 2008, 06:48
Gender: Male
phpBB Knowledge: 7

Re: [BETA] Country Flags 1.0.0

Postby Mandarim » 13 May 2008, 14:09

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!?
Mandarim
Crewman
Crewman
 
Posts: 1
Joined: 13 May 2008, 13:50
Gender: Male

Re: [BETA] Country Flags 1.0.0

Postby DimazzzZ » 03 Jun 2008, 15:10

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 :(
DimazzzZ
Crewman
Crewman
 
Posts: 1
Joined: 03 Jun 2008, 14:44
Gender: Male
phpBB Knowledge: 7

PreviousNext

Return to UCP

Who is online

Users browsing this forum: No registered users and 2 guests