CountryFlags

[Matthew K.]

Hello carloscuev! Thank you for stopping by and posting your solution, we definitely appreciate it.

I actually believe it's a bug in this modification, as I've seen it before. I'll put it on my list of things to fix. Thanks for reminding me

[Arantor]

It's not a bug in this modification. As stated and as demonstrated, it's a bug in the Are You Human modification.

[Diego Andrés]

How to show the country in text and no with images ?

[Dracopaion]

I'm hoping you can help me out with this every time you try to log into the site I get this error

Database Error: Field 'country' doesn't have a default value
File: C:/inetpub/root/Sources/Subs.php
Line: 2760

[Matthew K.]

@Dracopaion - Try running the Country Flags install file again. You can extract the .zip archive on your computer and then upload the install.php file to your server and then run it in your browser.

[Dracopaion]

no Joy it still errors out ive attached some more information that may help i hope and attached is the subs.php file itself.

I also noticed that when you log out there is another error that says Database Error Please try again. If you come back to this error screen, report the error to an administrator.

The Mods installed

1.   Add Social Media Icons To Profiles
2.   Add Stars To Profile
3.   Adk Custom Block
4.   Adk Gallery
5.   Adk Highlight Php
6.   Admin Toolbox
7.   Aeva Media
8.   Auto Refresh Who Index
9.   Autor In Display
10.   AvatarSelect
11.   Avatar Verification
12.   BBCode with style
13.   Country Flags
14.   Curve mobile mod
15.   Custom Action Mod
16.   Custom Form Mod
17.   Custom Permissions
18.   ENotify
19.   Event Registration Mod
20.   Hide Info Center From Guests
21.   Login Logger
22.   Membergroup ID with Group Name
23.   Menu Editor Lite
24.   NChat
25.   newstaffblock
26.   Notify of posts and replys by default
27.   Order Custom Profile Fields
28.   nneonneo's AJAX ShoutBox
29.   Separate the sticky topics
30.   SimplePortal
31.   Staff Permissions For Simple Portal
32.   Topic Rating Bar

the top and bottem 5 of the error location

Code Select Expand

$smcFunc['db_insert']($do_delete ? 'ignore' : 'replace',
'{db_prefix}log_online',
array('session' => 'string', 'id_member' => 'int', 'id_spider' => 'int', 'log_time' => 'int', 'ip' => 'raw', 'url' => 'string'),
array($session_id, $user_info['id'], empty($_SESSION['id_robot']) ? 0 : $_SESSION['id_robot'], time(), 'IFNULL(INET_ATON(\'' . $user_info['ip'] . '\'), 0)', $serialized),
array('session')
);
}

// Mark your session as being logged.
$_SESSION['log_time'] = time();


[Diego Andrés]

How to show the country in text and no with images ?

[Matthew K.]

I am currently working on a new version of Country Flags that will contain quite a few enhancements.

How to show the country in text and no with images ?

I'll throw this option in for you.

[Diego Andrés]

Thank you !!

[Matthew K.]

There's a sneak peak on our Facebook page if you want to see it. (SMFHacks)

[vbgamer45]

Link to FB account for the preview http://www.facebook.com/smfhacks
Link us if you enjoy the work we do!

[Dracopaion]

Hi guys

Any more possible fixes for this found yet?

Database Error: Field 'country' doesn't have a default value
File: C:/inetpub/root/Sources/Subs.php
Line: 2760

[Matthew K.]

I am currently working on a new version of Country Flags that will contain quite a few enhancements.

How to show the country in text and no with images ?

I'll throw this option in for you.

[Dracopaion]

Unfortunately I can't wait until you release your next version of this mod to see if it may fix the problem so I tried to uninstall the mod instead. The pre check for uninstall was all good to go and it seemed to uninstall without a problem however I'm still getting the same error. Is this a problem of the mod or of SMF? Do I need to elevate this to a different forum? I ask this because this almost looks more like a database error then an error in the coding for subs.php

[Matthew K.]

It's not going to be long for the update to be released...furthermore, it's an issue with the modification not installing properly. Any bugs in this modification (not seen many fatal bugs) will be fixed in the next patch.

[vbgamer45]

Unfortunately I can't wait until you release your next version of this mod to see if it may fix the problem so I tried to uninstall the mod instead. The pre check for uninstall was all good to go and it seemed to uninstall without a problem however I'm still getting the same error. Is this a problem of the mod or of SMF? Do I need to elevate this to a different forum? I ask this because this almost looks more like a database error then an error in the coding for subs.php

alter table smf_members change country country varchar(255) default '';

[Diego Andrés]

Link to FB account for the preview http://www.facebook.com/smfhacks
Link us if you enjoy the work we do!

Liked!

[vbgamer45]

Thanks!! Appreciate the support

[Dracopaion]

Unfortunately I can't wait until you release your next version of this mod to see if it may fix the problem so I tried to uninstall the mod instead. The pre check for uninstall was all good to go and it seemed to uninstall without a problem however I'm still getting the same error. Is this a problem of the mod or of SMF? Do I need to elevate this to a different forum? I ask this because this almost looks more like a database error then an error in the coding for subs.php



alter table smf_members change country country varchar(255) default '';

Ran this and it returned an error #1054 - Unknown column 'country' in 'smf_members' (my site hates me) not sure what to do next

It's not going to be long for the update to be released...furthermore, it's an issue with the modification not installing properly. Any bugs in this modification (not seen many fatal bugs) will be fixed in the next patch.

First let me mention after going over my post I haven't mentioned how much I appreciate the work that you guys have put into your mods, and SMF for making the base to do all this. What should have taken months to create for me I've been able to do in days. I'm also still questioning if it is indeed an actual bug in your mod because of what I just attempted above. I have also just found out that the server had crashed just as this all started and it may have indeed caused a corruption in the database. And if that is the case then the database needs to be repaired not your mod.

This site is a guild site for an mmo and having the country flags for all the different people around the world that are playing is a very nice touch. Unfortunately that also comes with a bunch of crabby people when the site isn't working during an in game server move (they have a tendency to get a bit cranky with the person operating the site). With that said that is the reason for my "urgency" to get this resolved. I have read your posts on the upcoming changes to your mod and am looking forward to them. However if I can't get the current problem resolved I'm worried that even upgrading your mod won't solve the problem if it is indeed actually your mod that is causing this.

[vbgamer45]

Try this
alter table smf_members add column country varchar(255) default '';


We renamed the field to country_flag might be some code that still uses the old name.