ElkArte Community

Elk Development => Bug Reports => Exterminated Bugs => Topic started by: heartgraphs on January 04, 2014, 12:08:57 am

Title: Database error
Post by: heartgraphs on January 04, 2014, 12:08:57 am
Hi

I keep getting this below error when sometimes.

"The database value you're trying to insert does not exist: id_profile"

any ideas?
Title: Re: Database error
Post by: emanuele on January 04, 2014, 04:27:00 am
Hello heartgraphs, yes, I think it is that one:
http://www.elkarte.net/community/index.php?topic=774.msg5559#msg5559

There is also another one:
http://www.elkarte.net/community/index.php?topic=776.0

A couple of (big) mistakes slipped in to the beta... :-[
Title: Re: Database error
Post by: heartgraphs on January 04, 2014, 05:38:57 am
Hi @emanuele

I am attaching the screenshot of the error log. All the error's are from Notification.subs.php .

Can you please check that.
Title: Re: Database error
Post by: emanuele on January 04, 2014, 09:11:14 am
Uhhh... that seems another bug indeed!

Try changing Notification.subs.php like that:
Code: (find) [Select]
			ln.sent, mem.id_group, mem.additional_groups, b.member_groups, mem.id_post_group, t.id_member_started, b.name,
ln.id_topic

Code: (replace with) [Select]
			ln.sent, mem.id_group, mem.additional_groups, b.member_groups, mem.id_post_group, t.id_member_started, b.name,
ln.id_topic, b.id_profile
Title: Re: Database error
Post by: emanuele on January 05, 2014, 11:45:45 am
I pushed it anyway. O:-)

https://github.com/emanuele45/Dialogo/commit/df33cf9d9b0c97ee67bef96d355315a7756d5d45