How do i unbookmark all?

jonnimunki

Hi, imported a mybb forum with thousands of threads and it auto bookmarked all of them. how do I bulk unbookmark all of these?

vrijvlinder

I believe The bookmarks are stored for each user in the database. GDN_UserDiscussion->Bookmarked

You could probably drop the Bookmarked Table and see if that fixes it. Make a backup of the database just in case something goes wrong.

River

to avoid dropping column or table, use update set.

http://www.w3schools.com/sql/sql_update.asp

use sql or phpmyadmin

update UserDiscussion
set Bookmarked = 0

you may need prefix UserDiscussion (e.g. Gdn_UserDiscussion)

you might use a where if you want to restrict to a UserID.

http://www.tutorialspoint.com/sql/sql-update-query.htm

vrijvlinder

I believe The bookmarks are stored for each user in the database. GDN_UserDiscussion->Bookmarked

You could probably drop the Bookmarked Table and see if that fixes it. Make a backup of the database just in case something goes wrong.

River

to avoid dropping column or table, use update set.

http://www.w3schools.com/sql/sql_update.asp

use sql or phpmyadmin

update UserDiscussion
set Bookmarked = 0

you may need prefix UserDiscussion (e.g. Gdn_UserDiscussion)

you might use a where if you want to restrict to a UserID.

http://www.tutorialspoint.com/sql/sql-update-query.htm

jonnimunki

thanks guys, will let you know if it works. May I suggest that the import tool is updated so that discussions aren't automatically bookmarked? where do I suggest this fix?

jonnimunki

Ok sorted, dropped the "bookmarked" column. Website broke after that so made a new column in same spot with same attributes and all bookmarks now reset to 0. tested bookmarking function and its working perfectly.

R_J

@jonnimunki said:
thanks guys, will let you know if it works. May I suggest that the import tool is updated so that discussions aren't automatically bookmarked? where do I suggest this fix?

@Linc should be notified. But if you have a GitHub account, you could also open an issue: https://github.com/vanilla/porter

@jonnimunki said:
Ok sorted, dropped the "bookmarked" column. Website broke after that so made a new column in same spot with same attributes and all bookmarks now reset to 0. tested bookmarking function and its working perfectly.

Better than dropping would be setting it to 0 like @River has suggested. And better than recreating it manually would be using yourforum.com/utility/structure/
You should run it nevertheless - it wouldn't hurt. There are some "false positives", which will prevail eve if you applied the suggested fixes.
But after you've manually "fixed" the table, I really would advise that official comparison.