[2.0.21] Country Flags MOD

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
26
57%
Very Good
8
17%
Good
5
11%
Fair
2
4%
Poor
5
11%
 
Total votes: 46

ycl6
Translator
Posts: 5696
Joined: Sat Feb 15, 2003 10:35 am
Location: Taiwan
Contact:

Post by ycl6 » Thu Aug 31, 2006 12:44 pm

FORDification wrote:
Could not obtain post/user information.

DEBUG MODE

SQL Error : 1054 Unknown column 'u.user_from_flag' in 'field list'

SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 13551 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 0, 15

Line : 399
File : viewtopic.php


I went into myAdmin and could see that all flag tables appear to be there, including the 'user_from_flag' table in the phpbb_users. Here's what I can see in myAdmin:

In the phpbb_flags I see:
- flag_ID
- flag_name
- flag_image

...and under the phpbb_users, I see:

- user_from_flag

So what's going on? Why am I being told that the 'user_from_flag' column is 'unknown'?

Hmm... that's interesting! I can't answer your question as the field is there as you've described, I don't see why you are receving the column unknown error 8O

So, you are looking at the correct database right? Or is your new forum running on a new database without you realising it?

~Mac

User avatar
FORDification
Registered User
Posts: 112
Joined: Fri Jul 23, 2004 4:12 am
Location: Nebraska
Contact:

Post by FORDification » Thu Aug 31, 2006 9:19 pm

I've only got one database, so that's not an issue. However, I did just realize something....don't know if it would be a possible source of the problem or not, but...

After I used the script to clean the tables off my database and began to reinstall the Flag MOD, I noticed that the flag tables were already/still there. Apparently even though I'd checked the appropriate boxes in the script to remove the tables, they didn't get removed. (Good thing I checked before installing the Flag MOD.) Anyway, I'm wondering if even though the flag tables are there, if maybe the script did something to them to disable them? Is that even possible?

Would you suggest I just manually remove the tables in phpMyAdmin and attempt to reinsert them?

User avatar
eddywatson
Registered User
Posts: 220
Joined: Wed Aug 30, 2006 8:35 pm
Location: England
Contact:

Post by eddywatson » Mon Sep 04, 2006 7:21 pm

guys, in the final install step when i use easmod for this... it says...

"Copy root/install/db_update_en.php"

wen i put the correct directory into my explorer i get this...

Image

and even when i add the public_html into that address to, it dont work, any ideas?

cheers

User avatar
eddywatson
Registered User
Posts: 220
Joined: Wed Aug 30, 2006 8:35 pm
Location: England
Contact:

Post by eddywatson » Wed Sep 06, 2006 12:08 am

Warning

FIND FAILED: In file [templates/Cobalt/profile_add_body.tpl] could not find:

<input type="text" class="post" style="width: 200px" name="location" size="25" maxlength="100" value="{LOCATION}" />
</td>
</tr>


what do i need to do, to fix this? cheers, i want the flag MOD to work on the Cobalt template... but i can still finish the install, just when i go to profile on the Cobalt template i cant pic a flag, nothing is there, but when i switch back to subsilver its fine. WTF :\

User avatar
eddywatson
Registered User
Posts: 220
Joined: Wed Aug 30, 2006 8:35 pm
Location: England
Contact:

Post by eddywatson » Wed Sep 06, 2006 8:02 pm

3rd time lucky... hope i get a response...

How do i get Flag MOD to work on Cobalt Template? in profile theres no option to pic a flag? and in mini profile no flags either... PLEASE HELP ME :(

User avatar
Toho_NL
Registered User
Posts: 206
Joined: Fri Jun 16, 2006 2:31 pm
Location: The Netherlands

Post by Toho_NL » Fri Sep 08, 2006 7:19 am

I don't know whether this is discussed already, but is it possible to show the flags in the usergroups-pages as well? Now they do not show up there...

Best regards and thanks for this great MOD,

Toho_NL.

User avatar
markismx
Registered User
Posts: 39
Joined: Mon May 15, 2006 9:22 am

Post by markismx » Mon Sep 11, 2006 6:43 am

Does anybody knows how to make this mod work with Easyucp mod?

ChUzZ
Registered User
Posts: 3
Joined: Fri Sep 15, 2006 10:03 am
Contact:

Problems

Post by ChUzZ » Sat Sep 16, 2006 12:18 am

hey I installed it now when I click on profile it comes up with this:

Couldn't obtain flags information.

DEBUG MODE

SQL Error : 1146 Table 'xanguild_phpb1.phpbb_flags' doesn't exist

SELECT * FROM phpbb_flags ORDER BY flag_name

Line : 943
File : usercp_register.php


Any idea?

ycl6
Translator
Posts: 5696
Joined: Sat Feb 15, 2003 10:35 am
Location: Taiwan
Contact:

Post by ycl6 » Sat Sep 16, 2006 2:04 am

Have you executed this step:

Code: Select all

#
#-----[ DIY INSTRUCTIONS ]------------------------------------------ 
#
Method 1: Copy root/install/db_update_en.php to install/db_update_en.php. Execute and delete after it has been run
Method 2: Use EasyMOD to run contrib/install/db_update_en.txt
Method 3: Copy the SQL query from contrib/install/db_update_en.txt and execute it manually
If you have, in your config.php, what is your setting for this variable:

Code: Select all

$table_prefix = 'phpbb_';
Because if you aren't using the default prefix 'phpbb_' and if you are using Method 2 or Method 3, you need to change the table prefix yourself, as mentioned inside the MOD file

Code: Select all

# 
#-----[ SQL ]------------------------------------------ 
#
# Remember to change the table prefix used on your database
~Mac

ChUzZ
Registered User
Posts: 3
Joined: Fri Sep 15, 2006 10:03 am
Contact:

Post by ChUzZ » Sat Sep 16, 2006 2:07 am

I used easyMOD

ycl6
Translator
Posts: 5696
Joined: Sat Feb 15, 2003 10:35 am
Location: Taiwan
Contact:

Post by ycl6 » Sat Sep 16, 2006 2:59 am

ChUzZ wrote: I used easyMOD

So, how about your answers for the rest of my comments?

~Mac

Kimba09
Registered User
Posts: 16
Joined: Fri Aug 18, 2006 11:18 pm

Post by Kimba09 » Thu Sep 21, 2006 6:22 am

Help! I've just installed the mod but when I try to delete a flag, I get this message:

Template->make_filename(): Error - file admin/confirm_body.tpl does not exist

Problem is the admin/confirm_body.tpl was never in the zip file i uplaodd. Where can I get it? :?

ycl6
Translator
Posts: 5696
Joined: Sat Feb 15, 2003 10:35 am
Location: Taiwan
Contact:

Post by ycl6 » Thu Sep 21, 2006 12:27 pm

Are you using the latest phpBB 2.0.21?

If I remember correctly, that file was added in one of the recent phpBB updates. My suggestion for you is to update your board :wink:

~Mac

Kimba09
Registered User
Posts: 16
Joined: Fri Aug 18, 2006 11:18 pm

Post by Kimba09 » Thu Sep 21, 2006 10:38 pm

Yes, I am. I only uploaded the board a few weeks ago. Although I uploaded the zip file again and found it. Thanks. :)

User avatar
Toho_NL
Registered User
Posts: 206
Joined: Fri Jun 16, 2006 2:31 pm
Location: The Netherlands

Post by Toho_NL » Fri Sep 22, 2006 10:12 am

Is it possible to show the flags in the usergroups-pages as well? Now they do not show up there...

Maybe this can be done with a 'simple' addition to the code, I don't know.

Best regards,

Toho_NL.

Post Reply

Return to “[2.0.x] MOD Database Releases”