[ABD] Country Flags 1.0.0

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
User avatar
nexen
Registered User
Posts: 3
Joined: Fri May 04, 2007 2:06 am

Re: [RC] Country Flags 1.0.0

Post by nexen »

Hi i'm using this mod and have the same problem about registration process, I was looking in the code and find this function:

functions_user.php -> used_add

In the line that insert the user in Data Base the value of flag is there:

$sql = 'INSERT INTO ' . USERS_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);
$db->sql_query($sql);
$user_id = $db->sql_nextid();
trigger_error($user_id, E_USER_ERROR);

I put a trigger_error just there (bold text) and look the data base and value is in the table, just the operations after that, in some way put blank value in the table but actually now i'm not able to find exactly where it is...

Any ideas ? :|
Squid_Vicous
Registered User
Posts: 11
Joined: Sun Apr 01, 2007 2:35 pm

Re: [RC] Country Flags 1.0.0

Post by Squid_Vicous »

I installed 0.9.0 , everything ran just right except when new users try to register. This error appears

General Error
SQL ERROR [ mysql4 ]

Field 'user_country_flag' doesn't have a default value [1364]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

__________________________________________________________________________________

I then upgraded to the latest version 1.0 and still get the same error. Is there some way of disabling the flag option in the registration process? The flag mod works just fine except when new users try register :?:
tupeu
Registered User
Posts: 320
Joined: Wed Jul 25, 2007 5:47 pm
Location: roFLmania
Contact:

Re: [RC] Country Flags 1.0.0

Post by tupeu »

This is a great mod but on my board not all users have their flag displayed...
:-s

And I also have the error when trying to remove a group`s member

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 = 201' at line 6 [1064]

SQL

UPDATE phpbb_users SET user_flag = '' WHERE group_id = 7 AND user_flag <> '' AND user_flag = AND user_id = 201

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: 2764
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: 75
CALL: p_master->load_active()
Mandarola
Registered User
Posts: 245
Joined: Tue Sep 25, 2007 3:21 am

Re: [RC] Country Flags 1.0.0

Post by Mandarola »

I´ve this error

Code: Select all

SQL ERROR [ mysql4 ]

Table '162635.FLAGS_TABLE' doesn't exist [1146]

SQL

SELECT * FROM FLAGS_TABLE ORDER BY flag_country

BACKTRACE

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

FILE: includes/acp/acp_groups.php
LINE: 505
CALL: dbal_mysql->sql_query()

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

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
what can I do to resolve this problem?
User avatar
ThunderCrew
Registered User
Posts: 1438
Joined: Sat Jun 30, 2007 6:26 pm
Location: Ill, Usa
Contact:

Re: [RC] Country Flags 1.0.0

Post by ThunderCrew »

says flags table doesnt exist did you do the sql install instructions ?
Ugg im a t0tal newb again ...... 2 years off cant remember jack ... time to get to it
User avatar
ThunderCrew
Registered User
Posts: 1438
Joined: Sat Jun 30, 2007 6:26 pm
Location: Ill, Usa
Contact:

Re: [RC] Country Flags 1.0.0

Post by ThunderCrew »

PS "The requested topic does not exist." also ran through the "mod databse" and country flags was no where to be found. I would like this mod but cant seem to find it.
Ugg im a t0tal newb again ...... 2 years off cant remember jack ... time to get to it
Brogsitter
Registered User
Posts: 58
Joined: Sun Jan 06, 2008 11:25 pm

Re: [RC] Country Flags 1.0.0

Post by Brogsitter »

Alternative download location? it seems that the DL site is offline for 10 days.
saaiberke
Registered User
Posts: 1126
Joined: Wed Jul 20, 2005 8:13 am
Location: Gent/Belgium
Contact:

Re: [RC] Country Flags 1.0.0

Post by saaiberke »

I can provide a temp downloadlocation here.

(Attention: there is a problem with this version when new users register your board and you require them to choose a country flag ==> the choosen flag is not stored in the database at registration.)

Grtz,

Nic
Brogsitter
Registered User
Posts: 58
Joined: Sun Jan 06, 2008 11:25 pm

Re: [RC] Country Flags 1.0.0

Post by Brogsitter »

Thanks, downloaded and installed. Followed the instructions correctly (triple checked everything) and I have a strange issue:

I installed the modules #1 and #2 like it is advised in the installation file. Finally they do not show up in the 'ACP - User and Groups - User' tab.

Any ideas?
User avatar
oddfish
Registered User
Posts: 839
Joined: Mon Mar 19, 2007 8:45 pm
Location: Testing 3.1
Contact:

Re: [RC] Country Flags 1.0.0

Post by oddfish »

... and you have installed #3 and enabled all 3 modules ?
Country Flag User Edition Clickable Post Count Link

... another record broken without breaking any records ...
Testing phpBB3.1 dark style based on prosilver ... http://www.oddmods.net
Brogsitter
Registered User
Posts: 58
Joined: Sun Jan 06, 2008 11:25 pm

Re: [RC] Country Flags 1.0.0

Post by Brogsitter »

yes sir ;) installed all 3 modules and enable all 3 modules, refreshed all templates, themes and imagesets and finally purge the cache
User avatar
oddfish
Registered User
Posts: 839
Joined: Mon Mar 19, 2007 8:45 pm
Location: Testing 3.1
Contact:

Re: [RC] Country Flags 1.0.0

Post by oddfish »

kewl .. and set your permissions to manage flags (admin roles/mod roles..users and groups)?
Country Flag User Edition Clickable Post Count Link

... another record broken without breaking any records ...
Testing phpBB3.1 dark style based on prosilver ... http://www.oddmods.net
Brogsitter
Registered User
Posts: 58
Joined: Sun Jan 06, 2008 11:25 pm

Re: [RC] Country Flags 1.0.0

Post by Brogsitter »

Yep. Did this too. Anyway setting the permission should not effect the possibility to see the acp panel
User avatar
BizimPencere
Registered User
Posts: 396
Joined: Sat Aug 25, 2007 8:31 pm

Re: [RC] Country Flags 1.0.0

Post by BizimPencere »

Nice mod thank you nedka
www.phpbbturkiye.net | Turkish phpBB3 support and development
User avatar
Gremlinn
Registered User
Posts: 2133
Joined: Mon Aug 04, 2003 12:13 am
Location: Rochester, NY
Name: Nathan

Re: [RC] Country Flags 1.0.0

Post by Gremlinn »

I think I figured out where the problem is for why the flag is not saved during registration. It has to do with the group settings. First, the user is added to the users table. Then the group defaults are applied. When that happens, the group flag is over writing the user's flag.

There needs to be a check for the group default flag to NOT override the user's flag.
Locked

Return to “[3.0.x] Abandoned MODs”