News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Deleting posts

Started by blunted, December 10, 2016, 12:35:35 AM

Previous topic - Next topic

blunted

get the following error

Unknown column 'm.id_member_started' in 'field list'

Kindred

Is that the full error? Usually errors indicate a file and line

Also, please provide the basic information for posts that ask for help?
Smf version?
URL?
Mods installed?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

blunted

2.0.12


Quote1.   Sorted Package Manager Listing   1.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
2.   SMFPacks Super Quotes   1.0.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
3.   SMF Articles   3.0.2a  package_installed   [ Uninstall ][ List Files ][ Delete ]
4.   SMF Mobile Theme Selector   1.0.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
5.   SMF Advanced Invitations System   1.1.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
6.   Encrypt Personal Messages by NIBOGO   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
7.   SMFPacks Mentions   1.4.4  package_installed   [ Uninstall ][ List Files ][ Delete ]
8.   Invitations Contest   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
9.   Popular Topics   1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
10.   Join Reason   1.5  package_installed   [ Uninstall ][ List Files ][ Delete ]
11.   'Read the Rules' Link Above Post Button   2.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
12.   Newsletter Pro   3.1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
13.   Post Karma   0.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
14.   Topic & PM Notifications Privacy   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
15.   SMFPacks: SEO Pro Mod   2.1.5  package_installed   [ Uninstall ][ List Files ][ Delete ]
16.   SMFPacks Social Profile Pro   1.0.4  package_installed   [ Uninstall ][ List Files ][ Delete ]
17.   SMFPacks Multimedia Gallery   1.3.5  package_installed   [ Uninstall ][ List Files ][ Delete ]
18.   PM Attachments   1.6  package_installed   [ Uninstall ][ List Files ][ Delete ]
19.   Post Anonymously In Topic   2.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
20.   Karma Buttons   1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
21.   AdsToppost   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
22.   Expire Attachments mod   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
23.   Welcome Topic Mod   2.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
24.   PM Informer   4.0.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
25.   SMFPacks Likes Pro Mod   2.0.7  package_installed   [ Uninstall ][ List Files ][ Delete ]
26.   SMF Trader System   1.6  package_installed   [ Uninstall ][ List Files ][ Delete ]
27.   Separate the sticky topics   1.0.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
28.   Show Unread Private Messages   1.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
29.   Highslide 4 SMF   0.8.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
30.   Tapatalk SMF 2.0 Plugin   4.4.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
31.   Scrolling Buttons   0.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
32.   Most Popular Topic Today   2.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
33.   SMFPacks Two Factor Authentication   1.0.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
34.   Contact Page   3.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
35.   Avatar Rounded Corners   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
36.   Ohara YouTube Embed   1.2.8  package_installed   [ Uninstall ][ List Files ][ Delete ]
37.   Integration Hooks Report   1.5.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
38.   Fake Online Time   2.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
39.   New Board Stat Style   1.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
40.   Notify of posts and replys by default   1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
41.   SMF Arcade   2.5  package_installed   [ Uninstall ][ List Files ][ Delete ]
42.   Semasa - Surfer's Live Local Time   1.0.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
43.   SMF Downloads Directory   1.2.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
44.   SimpleDesk - Integrated Helpdesk for Simple Machines Forum   2.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
45.   SMF Social Groups   2.4.10  package_installed   [ Uninstall ][ List Files ][ Delete ]
46.   NiceTooltips   1.8  package_installed   [ Uninstall ][ List Files ][ Delete ]
47.   Member NotePad   2.0.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
48.   ICAP: Info Center Access Permission   1.0.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
49.   Advanced Login Form   1.2.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
50.   SMF Activity Stream PRO   2.0.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
51.   Post History   1.03  package_installed   [ Uninstall ][ List Files ][ Delete ]
52.   Default Avatar   2.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
53.   SimplePortal   2.3.6  package_installed   [ Uninstall ][ List Files ][ Delete ]
54.   Dynamic_Memberlist   3.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
55.   Bookmarks   2.5  package_installed   [ Uninstall ][ List Files ][ Delete ]
56.   SMF Classifieds   4.0.9  package_installed   [ Uninstall ][ List Files ][ Delete ]
57.   Activity Bar   1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
58.   Paragrapher   1.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
59.   Post Notifier   1.0.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
60.   Smush.it! For SMF   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
61.   IUMQ - Install & Uninstall Mods Quickly   1.5.1  package_installed   [ Uninstall ][ List Files ][ Delete ]
62.   Reply Button In Every Post   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
63.   SMFPacks WYSIWYG Editor   2.1.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
64.   CometChat   1.0.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
65.   Login Security   1.0.3  package_installed   [ Uninstall ][ List Files ][ Delete ]
66.   Menu Editor Pro   1.0.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
67.   Redirect on Login and/or Logout mod   0.4  package_installed   [ Uninstall ][ List Files ][ Delete ]
68.   Space Between Posts   2.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
69.   SMF 2.0.12 Update   1.0  package_installed   [ Uninstall ][ List Files ][ Delete ]
70.   SMF Links Directory   2.4.2  package_installed   [ Uninstall ][ List Files ][ Delete ]
71.   Board Notes   1.0.8  package_installed   


Unknown column 'm.id_member_started' in 'field list'
File: /home/domains/public_html/Sources/RemoveTopic.php
Line: 115

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.12, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.




Illori

can you attach that file to your next post?

Kindred

right... so, that code does not actually appear in the default RemoveTopic file...


// Remove just a single post.
function DeleteMessage()
{
global $user_info, $topic, $board, $modSettings, $smcFunc;

checkSession('get');

$_REQUEST['msg'] = (int) $_REQUEST['msg'];

// Is $topic set?
if (empty($topic) && isset($_REQUEST['topic']))
$topic = (int) $_REQUEST['topic'];

$request = $smcFunc['db_query']('', '
SELECT t.id_member_started, m.id_member, m.subject, m.poster_time, m.approved
FROM {db_prefix}topics AS t
INNER JOIN {db_prefix}messages AS m ON (m.id_msg = {int:id_msg} AND m.id_topic = {int:current_topic})
WHERE t.id_topic = {int:current_topic}
LIMIT 1',
array(
'current_topic' => $topic,
'id_msg' => $_REQUEST['msg'],
)
);
list ($starter, $poster, $subject, $post_time, $approved) = $smcFunc['db_fetch_row']($request);
$smcFunc['db_free_result']($request);

// Verify they can see this!
if ($modSettings['postmod_active'] && !$approved && !empty($poster) && $poster != $user_info['id'])
isAllowedTo('approve_posts');

if ($poster == $user_info['id'])
{
if (!allowedTo('delete_own'))
{
if ($starter == $user_info['id'] && !allowedTo('delete_any'))
isAllowedTo('delete_replies');
elseif (!allowedTo('delete_any'))
isAllowedTo('delete_own');
}
elseif (!allowedTo('delete_any') && ($starter != $user_info['id'] || !allowedTo('delete_replies')) && !empty($modSettings['edit_disable_time']) && $post_time + $modSettings['edit_disable_time'] * 60 < time())
fatal_lang_error('modify_post_time_passed', false);
}
elseif ($starter == $user_info['id'] && !allowedTo('delete_any'))
isAllowedTo('delete_replies');
else
isAllowedTo('delete_any');

// If the full topic was removed go back to the board.
$full_topic = removeMessage($_REQUEST['msg']);

if (allowedTo('delete_any') && (!allowedTo('delete_own') || $poster != $user_info['id']))
logAction('delete', array('topic' => $topic, 'subject' => $subject, 'member' => $poster, 'board' => $board));

// We want to redirect back to recent action.
if (isset($_REQUEST['recent']))
redirectexit('action=recent');
elseif (isset($_REQUEST['profile'], $_REQUEST['start'], $_REQUEST['u']))
redirectexit('action=profile;u=' . $_REQUEST['u'] . ';area=showposts;start=' . $_REQUEST['start']);
elseif ($full_topic)
redirectexit('board=' . $board . '.0');
else
redirectexit('topic=' . $topic . '.' . $_REQUEST['start']);
}


as a matter of fact, in mine, member_started is defined on t (t being smf_topics)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

blunted

#5
here and ty


blunted


Kindred

Fix the mod that broke the code? ;)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

blunted


blunted


Kindred

Yup, that looks like the culprit
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

blunted


dougiefresh

I've fixed the mod for version 2.2.....

Advertisement: