MyBB Central

Full Version: Forum Trashcan [labrocca please help]
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Greetings,

Labrocca I know you are the only one who can help me out. Its useless to ask for help at myBB community.

I am getting this error when activating the plugin

Code:
MySQL error: 1146
Table 'esoundsc_ccforum.settinggroups' doesn't exist
Query: DELETE FROM settinggroups WHERE name = 'trashcan'

Please help me out.

God bless you. Thx
Ugh...seems like you are trying to deactivate the plugin. I have to assume the plugin has an error in it as you are really trying to activate it. The DELETE FROM query is wrong obviously. You are trying to INSERT instead. I would need to see the plugin file.

Goodluck.
Sure no problem brother here are the files.

Source URL

http://community.mybboard.net/thread-837...#pid236097

Note:
I am using myBB 1.2.14
Jeez....how did this get by him?

Edit your trash.php to just remove this part on the top:

PHP Code:
    // Delete all settings to avoid duplicates
    
$db->query("DELETE FROM ".TABLE_PREFIX."settings WHERE name IN(
        'enabletrash', 
        'trashcanfid',
        'trash_closetopics'
    )"
);
    
$db->delete_query("settinggroups""name = 'trashcan'"); 

Those DELETE queries should be checking if exists first. Sad
Thx bro. I'll check it right now.
well now I get

Code:
MySQL error: 1146
Table 'esoundsc_ccforum.settinggroups' doesn't exist
Query: SELECT COUNT(*) as rows FROM settinggroups
$query = $db->simple_select("settinggroups", "COUNT(*) as rows");

Delete that line too. It's wrong.

btw..did you change your table prefix? And are you on 1.4x?
No I am on 1.2.14
Isn't this for 1.2.14?
No it's not.
damn.....I am so foolish.

Thank you brother. BTW do you happen to have TrashCan for 1.2?
I don't but I bet you can get it at mybboard.