[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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

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

Post by ycl6 »

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 »

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 »

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 »

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 »

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”