Skip to main content ↑ ↓
Topic: Missing field in database (Read 6345 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

Missing field in database

I run in error while trying send email to member. Screenshot attached.

Fixed by query:
Code: [Select]
ALTER TABLE [icode]elkarte[/icode].[icode]elkarte_members[/icode] ADD COLUMN [icode]ignore_list[/icode] VARCHAR(255) NOT NULL COLLATE utf8_general_ci;
EDIT:
Attention! Dont run this query, its useless. Here is the fix.
Regards
NetFlag
Last Edit: November 29, 2013, 06:42:57 am by NetFlag

Re: Missing field in database

Reply #1 –

Thanks for the report (and fix) looks like we missed a column in the install file  :'(

Re: Missing field in database

Reply #2 –

I'd be tempted to say we need a test to check for existing tables and columns, but that wouldn't solve the issue because we'd rely on the fact the test has been updated.

This happen when a member is added to the ignore list, right?
Bugs creator.
Features destroyer.
Template killer.

Re: Missing field in database

Reply #3 –

BTW it's my fault... O:-)
In fact, now, I'm not sure what I wanted to do.
I added that piece of code when changing the "do not receive PM from people in my ignore list", to the "do not allow people in my ignore list to contact me" (i.e. not even emails).

So, for the moment, the best fix is to change Members.subs.php from:
Code: [Select]
SELECT receive_from, buddy_list, ignore_list
to:
Code: [Select]
SELECT receive_from, buddy_list, pm_ignore_list
create the column is useless because is not used anywhere else.

I think the original idea was to rename the pm_ignore_list column to ignore_list, in order to make it consistent with everything else.
And probably is the best thing to do...

 emanuele goes do it.

Scratch that, I'm going to fix just Members.subs.php, easier and doesn't require a full change in the database.
Last Edit: November 29, 2013, 06:29:19 am by emanuele
Bugs creator.
Features destroyer.
Template killer.