The database does not exist: is_approved ?

[xyxis_fahim]

Hello,
When I try to merge a Topic in SMF 2 , and error reporting
"The database value you're trying to insert does not exist: is_approved"  comes on.

What may be the cause?

Thank you.

[ONLiNEZONE]

Hello,
When I try to merge a Topic in SMF 2 , and error reporting
"The database value you're trying to insert does not exist: is_approved"  comes on.

What may be the cause?

Thank you.

I think it might be an error in the database
If you use cPanel for WebServer Administration then tell me.

[xyxis_fahim]

Yes it is Cpanel.

[H]

Are you running beta3?

Have you tried running Admin area > Forum Maintenance > Find and Repair errors?

[Dragooon]

OK Just looking at the code, I think it is a bug
See this query

Code Select Expand

$request = $smcFunc['db_query']('', '
SELECT t.id_topic, m.subject, m.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
WHERE t.id_board = {int:id_board}
AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
AND t.approved = {int:is_approved}' : '') . '
ORDER BY {raw:sort}
LIMIT {int:offset}, {int:limit}',
array(
'id_board' => $_REQUEST['targetboard'],
'id_topic' => $_GET['from'],
'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
'offset' => $_REQUEST['start'],
'limit' => $modSettings['defaultMaxTopics'],
)
);
(Around line 898-915 in SplitTopics.php in the function MergeIndex)
There is AND t.approved = {int:is_approved} But no is_approved in the values array.

[niko]

This is fixed already.

adding 'is_aproved' => 1 to array should fix this.

[ONLiNEZONE]

Yes it is Cpanel.

Okay, login as the Administrator for cPanel.
Goto MySQL Databases. Find, Repair database's and then click your database for your forum.
then click repair.

[metallica48423]

did that do it for you, xyxis_fahim?

[xyxis_fahim]

Okay, login as the Administrator for cPanel.
Goto MySQL Databases. Find, Repair database's and then click your database for your forum.
then click repair.

That didn't work ,Sorry.

[Dragooon]

The DB is fine.

Find

Code Select Expand

   $request = $smcFunc['db_query']('', '
      SELECT t.id_topic, m.subject, m.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
         LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
      WHERE t.id_board = {int:id_board}
         AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
         AND t.approved = {int:is_approved}' : '') . '
      ORDER BY {raw:sort}
      LIMIT {int:offset}, {int:limit}',
      array(
         'id_board' => $_REQUEST['targetboard'],
         'id_topic' => $_GET['from'],
         'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
         'offset' => $_REQUEST['start'],
         'limit' => $modSettings['defaultMaxTopics'],
      )
   );
And replace it with

Code Select Expand

   $request = $smcFunc['db_query']('', '
      SELECT t.id_topic, m.subject, m.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
         LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
      WHERE t.id_board = {int:id_board}
         AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
         AND t.approved = {int:is_approved}' : '') . '
      ORDER BY {raw:sort}
      LIMIT {int:offset}, {int:limit}',
      array(
         'id_board' => $_REQUEST['targetboard'],
         'id_topic' => $_GET['from'],
         'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
         'offset' => $_REQUEST['start'],
         'limit' => $modSettings['defaultMaxTopics'],
         'is_approved' => 1,
      )
   );

[Rocks-HD]

The DB is fine.

Find

Code Select Expand

   $request = $smcFunc['db_query']('', '
      SELECT t.id_topic, m.subject, m.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
         LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
      WHERE t.id_board = {int:id_board}
         AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
         AND t.approved = {int:is_approved}' : '') . '
      ORDER BY {raw:sort}
      LIMIT {int:offset}, {int:limit}',
      array(
         'id_board' => $_REQUEST['targetboard'],
         'id_topic' => $_GET['from'],
         'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
         'offset' => $_REQUEST['start'],
         'limit' => $modSettings['defaultMaxTopics'],
      )
   );
And replace it with

Code Select Expand

   $request = $smcFunc['db_query']('', '
      SELECT t.id_topic, m.subject, m.id_member, IFNULL(mem.real_name, m.poster_name) AS poster_name
      FROM {db_prefix}topics AS t
         INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
         LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
      WHERE t.id_board = {int:id_board}
         AND t.id_topic != {int:id_topic}' . ($onlyApproved ? '
         AND t.approved = {int:is_approved}' : '') . '
      ORDER BY {raw:sort}
      LIMIT {int:offset}, {int:limit}',
      array(
         'id_board' => $_REQUEST['targetboard'],
         'id_topic' => $_GET['from'],
         'sort' => (!empty($modSettings['enableStickyTopics']) ? 't.is_sticky DESC, ' : '') . 't.id_last_msg DESC',
         'offset' => $_REQUEST['start'],
         'limit' => $modSettings['defaultMaxTopics'],
         'is_approved' => 1,
      )
   );

thanks man

My smf 2.0 beta 3.1 public had the same problem and with you help I can make work very well.

it's problem probably is because I had smf 1.1.4 and upgrade for smf 2.0

Thanks

[Dragon41673]

Hey guys, this thread is very old, but I'm having the same issue. If I need to start a new thread...that's fine.

I wasn't sure if I should use the same "fix" as listed above, or if it would even apply to me...here's my scenario...

I was hosted on GoDaddy, just last week, I switched over to SiteGround. Ever since, I've had this issue. I'm running 2.0.10. I did not have cpanel while on GoDaddy but I do in SiteGround.

Any help would be appreciated.

Thank you!

[Steve]

Yea, please start a new thread considering the age of this one and that it's marked solved.

[Dragon41673]

Yea, please start a new thread considering the age of this one and that it's marked solved.

Will do!

[Shambles]

Yea, please start a new thread considering the age of this one and that it's marked solved.

Not actually necessary these days - there's a precedent...

http://www.simplemachines.org/community/index.php?topic=532800.msg3802654#msg3802654

[Dragon41673]

It's alright Shambles...new thread was started. Clicking unnotify for this one.

[margarett]

Not actually necessary these days - there's a precedent...

http://www.simplemachines.org/community/index.php?topic=532800.msg3802654#msg3802654

It's not exactly the same thing, 'ya now? This is a topic from 2008