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

[smartayush007]

Dear Sir,
Please help me to fix this error. Please guide me step by step.

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

Thanks

[margarett]

What are you trying to do when that error shows up?

Check this: How do I ask support questions the smart way?

[smartayush007]

I was trying to post reply or add new topic

[margarett]

Error log?
Installed MODs?
Anything you did/installed that could trigger this?

I think that neither boards or topics/messages would work if that field is missing from the tables... This reminds me of the missing/not missing "members_ip2" problem another user recently had...

[smartayush007]

I have installed a mod and uninstalled it. After that I am having such problems.

I need a solution to this

[margarett]

And what mod was that?

I'm trying to help you, but my crystal ball got damaged recently, so I need you to give me details

[smartayush007]

Dear Sir,

I tried to install the mod post rating http://custom.simplemachines.org/mods/index.php?mod=2234   on my smf version 2.0.4

But the result was not good. So i uninstalled it. SMF shows that the mod was uninstalled correctly but I can even see the posts make my the mod.

Now when I have deleted all the files there is an error while posting or replying to the post or adding new topic.

The error is :  The database value you're trying to insert does not exist: id_board

Please provide me solution to this



   

[margarett]

I see... You say you deleted files, maybe you deleted something you shouldn't...

You should have something in your error log. Can you check it? We need to check what file is affected...

[smartayush007]

my insert post code looks like this


// Insert the post.
   $smcFunc['db_insert']('',
      '{db_prefix}messages',
      array(
         'id_board' => 'int', 'id_topic' => 'int', 'id_member' => 'int', 'subject' => 'string-255', 'body' => (!empty($modSettings['max_messageLength']) && $modSettings['max_messageLength'] > 65534 ? 'string-' . $modSettings['max_messageLength'] : 'string-65534'),
         'poster_name' => 'string-255', 'poster_email' => 'string-255', 'poster_time' => 'int', 'poster_ip' => 'string-255',
         'smileys_enabled' => 'int', 'ratings_enabled' => 'int', 'ratings_enabled' => 'int', 'modified_name' => 'string', 'icon' => 'string-16', 'approved' => 'int',
      ),
      array(
         $topicOptions['board'], $topicOptions['id'], $posterOptions['id'], $msgOptions['subject'], $msgOptions['body'],
         $posterOptions['name'], $posterOptions['email'], time(), $posterOptions['ip'],
         $msgOptions['smileys_enabled'] ? 1 : 0, $msgOptions['ratings_enabled'] ? 1 : 0, $msgOptions['ratings_enabled'] ? 1 : 0, '', $msgOptions['icon'], $msgOptions['approved'],
      ),
      array('id_msg')
   );
   $msgOptions['id'] = $smcFunc['db_insert_id']('{db_prefix}messages', 'id_msg');

[smartayush007]

Plz find the attached image of error log

[smartayush007]

i took this code from line 1839 in subs-post.php

[margarett]

Yup, some code was not removed. That MOD does a LOT of modifications to several files.
Anyway, that error is strange.
Now, did you backup your forum before you installed the MOD? If you didn't do it now and try this:
http://www.simplemachines.org/community/index.php?topic=400356.0

Maybe we're lucky and that will correct things. If not, let us know

[Kindred]

when you install or uninstall a mod, you need to pay attention when there are errors noted for the installation or uninstallation.  Continuing without handling those errors will indeed lead to issues like this.