how to update "plugins" column in "mybb_datacache"

[Cleopatra]

how can i update "plugins" column in "mybb_datacache"


this is where i am now
what should i do next

[dragonexpert]

Realistically you shouldn't do this. You have to know what serialized data looks like. I must ask, why do you need to manually edit the cache instead of letting MyBB do the work for you?

[Cleopatra]

after i upgrade to 1.8.1
even i deactivate all the plugins
but it appeared that i should have uninstalled them too
cause there are still traces of plugins
that are not fully removed
which causes me a lot of errors
so i want to deactivate and ininstall all the plugins
before i remove them from FTp

[un4saken]

you can use this to deactivate all plugins 

a:1:{s:6:"active";a:0:{}}

[Cleopatra]

how to use this exactly
and will this remove every change the plugins made
also is there is a way i can remove a specific plugin

[dragonexpert]

If you will post the contents of cache for plugins and state which plugin you don't want active, I can give you the proper code.

[Cleopatra]

where i can find the contents of cache for plugins
i want to deactivate the achivments plugin

[dragonexpert]

Go into PHPMyAdmin like you were before and run this query:

SELECT cache FROM mybb_datacache WHERE title='plugins'

You could also click edit on the line that starts with plugins.

[Cleopatra]

what will happen if i run this query....will it affect my forum

---

this is what appear in a box when i clicked on edit

a:1:{s:6:"active";a:27:{s:12:"AddNewTheard";s:12:"AddNewTheard";s:8:"AJAXChat";s:8:"AJAXChat";s:10:"rememberus";s:10:"rememberus";s:3:"aui";s:3:"aui";s:4:"jloc";s:4:"jloc";s:12:"lastvisitors";s:12:"lastvisitors";s:13:"register_time";s:13:"register_time";s:13:"profilealbums";s:13:"profilealbums";s:17:"kestatlastthreads";s:17:"kestatlastthreads";s:10:"teamonline";s:10:"teamonline";s:14:"styleUsernames";s:14:"styleUsernames";s:12:"dvz_shoutbox";s:12:"dvz_shoutbox";s:9:"newpoints";s:9:"newpoints";s:7:"country";s:7:"country";s:11:"moodmanager";s:11:"moodmanager";s:3:"thx";s:3:"thx";s:9:"myprofile";s:9:"myprofile";s:10:"imgprofile";s:10:"imgprofile";s:18:"quickadveditorplus";s:18:"quickadveditorplus";s:9:"someimage";s:9:"someimage";s:14:"profilmuzigiek";s:14:"profilmuzigiek";s:13:"custom_status";s:13:"custom_status";s:8:"prostats";s:8:"prostats";s:11:"onlinetoday";s:11:"onlinetoday";s:11:"grouplegend";s:11:"grouplegend";s:10:"portalannc";s:10:"portalannc";s:8:"avatarep";s:8:"avatarep";}}

[dragonexpert]

From seeing that,I can't identify which one is for achievements. I'm thinking its the aui, but not sure. Do you know what the file name the plugin file was for that one?