putting shout box on the portal page

Post any general problems, information or issues on ModphpBB3 in here.
User avatar
cisco007
Staff
Staff
Posts: 501
Joined: Tue Oct 07, 2008 3:44 am

Re: putting shout box on the portal page

Post by cisco007 » Mon Apr 26, 2010 3:17 pm

Latest post of the previous page:

i might of forgotten the lang files,

try this open portal.php

find:

Code: Select all

$user->setup('mods/lang_portal');
replace with:

Code: Select all

$user->setup('mods/lang_portal', 'mods/mchat_lang');
see if that works!

User avatar
Ish
Forum Member
Forum Member
Posts: 14
Joined: Fri Apr 23, 2010 10:19 am

Re: putting shout box on the portal page

Post by Ish » Mon Apr 26, 2010 3:30 pm

I tried but getting the following msg:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'mods' in 'where clause' [1054]

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

User avatar
cisco007
Staff
Staff
Posts: 501
Joined: Tue Oct 07, 2008 3:44 am

Re: putting shout box on the portal page

Post by cisco007 » Mon Apr 26, 2010 3:34 pm

can i get a link to the site you are using this on!?

User avatar
Ish
Forum Member
Forum Member
Posts: 14
Joined: Fri Apr 23, 2010 10:19 am

Re: putting shout box on the portal page

Post by Ish » Mon Apr 26, 2010 3:58 pm

Yes buddy... It's http://www.indra.mu.

User avatar
cisco007
Staff
Staff
Posts: 501
Joined: Tue Oct 07, 2008 3:44 am

Re: putting shout box on the portal page

Post by cisco007 » Mon Apr 26, 2010 4:00 pm

do you have the edit i posted on there now!?

User avatar
Ish
Forum Member
Forum Member
Posts: 14
Joined: Fri Apr 23, 2010 10:19 am

Re: putting shout box on the portal page

Post by Ish » Mon Apr 26, 2010 4:17 pm

Nah... The last edit u've suggested, I've removed... Because it doesn't load the portal.php page, it only shows the SQL error...

Wait... I'll put it there again for a while...

User avatar
Ish
Forum Member
Forum Member
Posts: 14
Joined: Fri Apr 23, 2010 10:19 am

Re: putting shout box on the portal page

Post by Ish » Mon Apr 26, 2010 4:21 pm

This is displayed:
General Error
SQL ERROR [ mysql4 ]

Unknown column 'mods' in 'where clause' [1054]

SQL

SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_styles s, phpbb_styles_template t, phpbb_styles_theme c, phpbb_styles_imageset i WHERE s.style_id = mods/mchat_lang AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

BACKTRACE

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

FILE: includes/session.php
LINE: 1615
CALL: dbal_mysql->sql_query()

FILE: portal.php
LINE: 29
CALL: user->setup()
Any idea wat went wrong?

User avatar
cisco007
Staff
Staff
Posts: 501
Joined: Tue Oct 07, 2008 3:44 am

Re: putting shout box on the portal page

Post by cisco007 » Mon Apr 26, 2010 4:30 pm

undo the edit i told you to do and add this:

Code: Select all

$user->setup('mods/mchat_lang');
on a new line after this:

Code: Select all

$user->setup('mods/lang_portal');
see if you still get the error, i don't understand why you are getting that error, I have done that edit many times on many sites, and have never gotten that error!

User avatar
Ish
Forum Member
Forum Member
Posts: 14
Joined: Fri Apr 23, 2010 10:19 am

Re: putting shout box on the portal page

Post by Ish » Mon Apr 26, 2010 4:36 pm

Cool!!

:yahoo:

It works fine now!! Thanks loads buddy...

I'm hosting my files on bluehost, do u think it could b the mysql version they hve?

User avatar
cisco007
Staff
Staff
Posts: 501
Joined: Tue Oct 07, 2008 3:44 am

Re: putting shout box on the portal page

Post by cisco007 » Mon Apr 26, 2010 4:42 pm

i really don't know, i don't remember what version this mchat needs, but i am glad you got it working!

Post Reply