Page 1 of 2

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 3:30 pm
by Ish
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.

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 3:34 pm
by cisco007
can i get a link to the site you are using this on!?

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 3:58 pm
by Ish
Yes buddy... It's http://www.indra.mu.

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:00 pm
by cisco007
do you have the edit i posted on there now!?

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:17 pm
by Ish
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...

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:21 pm
by Ish
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?

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:30 pm
by cisco007
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!

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:36 pm
by Ish
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?

Re: putting shout box on the portal page

Posted: Mon Apr 26, 2010 4:42 pm
by cisco007
i really don't know, i don't remember what version this mchat needs, but i am glad you got it working!