Warning: The author of this contribution does not provide support for it anymore.

Thanks for posts

Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054] - Thanks for posts

Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by contiw » Sat Aug 14, 2010 10:00 pm

In includes/UCP/ucp_prefs.pcp the following two lines


Code: Select all

 'S_ALLOW_THANKS_PM'    => $data['allowthankspm'],                            
 'user_allow_thanks_pm'    => $data['allowthankspm'],


creates this error when trying to update user profile :

Code: Select all

Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

SQL

UPDATE phpbb_users SET user_allow_pm = 1, S_ALLOW_THANKS_PM = 0, user_allow_thanks_pm = 0, user_allow_viewemail = 1, user_allow_massemail = 1, user_allow_viewonline = 1, user_notify_type = '0', user_notify_pm = 1, user_options = '230271', user_dst = 0, user_dateformat = 'D M d, Y g:i a', user_lang = 'en', user_timezone = 0, user_style = '1' WHERE user_id = 2

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/ucp/ucp_prefs.php
LINE: 106
CALL: dbal_mysqli->sql_query()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_prefs->main()

FILE: ucp.php
LINE: 345
CALL: p_master->load_active()


I have eliminated

Code: Select all

 'S_ALLOW_THANKS_PM'    => $data['allowthankspm'], 


and there are NO ERRORS returned.
But I am kind of fishing in the dark : is it ok what I have done?

Thank You.
contiw
Registered User
Posts: 83
Joined: Tue Jun 01, 2010 4:23 am
Contact:

Re: Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by Палыч » Sat Aug 14, 2010 10:12 pm

You made a mistake when editing the includes/ucp/ucp_prefs.php
See the instructions carefully
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by contiw » Sat Aug 14, 2010 10:19 pm

So it is ok what I have done, I suppose.

Палыч
Don't be sorry about your 'bad' english.
English is a bad language. :lol:
contiw
Registered User
Posts: 83
Joined: Tue Jun 01, 2010 4:23 am
Contact:

Re: Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by Палыч » Sat Aug 14, 2010 10:32 pm

contiw wrote:So it is ok what I have done, I suppose.

No

Code: Select all

find
                  'user_allow_pm'         => $data['allowpm'],
after-add
                  'user_allow_thanks_pm'   => $data['allowthankspm'],
find
            'S_ALLOW_PM'      => $data['allowpm'],
after-add
            'S_ALLOW_THANKS_PM'   => $data['allowthankspm'],


contiw wrote:English is a bad language.

I do not think so
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact:

Re: Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by contiw » Sat Aug 14, 2010 11:13 pm

Thanks Сергей.
In effect, the second variable was missing.
And of course I was joking with the english language being bad.
English is my second first language.
Have a nice weekend.
Does it still smoke in your area?
contiw
Registered User
Posts: 83
Joined: Tue Jun 01, 2010 4:23 am
Contact:

Re: Unknown column 'S_ALLOW_THANKS_PM' in 'field list' [1054]

by Палыч » Thu Nov 04, 2010 10:01 am

close
Sorry for my bad english
User avatar
Палыч
Translator
Posts: 1543
Joined: Sun Jul 01, 2007 7:59 pm
Location: St. Petersburg
Name: Сергей
Contact: