Warning: The author of this contribution does not provide support for it anymore.

Forum sort order

How to unistall? - Forum sort order

How to unistall?

by aoi_azzura » Tue Oct 12, 2010 10:22 am

please tell me how to uninstall this mod.
it's in conflict with the ones in http://www.phpbb.com/customise/db/mod/f ... or-t_86350

so if you're kind enough to tell me how wo uninstall this mod, it will be greatly appreciated.
i'm not very good with reverse engineering, i'm affraid

:?:
aoi_azzura
Registered User
Posts: 5
Joined: Tue Oct 12, 2010 8:50 am
Contact:

Re: How to unistall?

by aoi_azzura » Wed Oct 13, 2010 3:43 pm

i'm sorry for this earlier post. this mod works well. my mistake in uploading files. once i reuploaded them all, it works just fine.
aoi_azzura
Registered User
Posts: 5
Joined: Tue Oct 12, 2010 8:50 am
Contact:

Re: How to unistall?

by tumba25 » Wed Oct 13, 2010 4:01 pm

Someone else might want that info.
To remove this MOD you first remove all file edits. Just look in the install file and do the edits backwards.

Then open phpMyAdmin and run these SQL queries.

Code: Select all

ALTER TABLE phpbb_forums DROP topic_list_order, DROP topic_list_dir, DROP user_sort_override;

Code: Select all

ALTER TABLE phpbb_users CHANGE user_topic_sortby_type user_topic_sortby_type varchar(1) character set utf8 collate utf8_bin NOT NULL DEFAULT 't', CHANGE user_topic_sortby_dir user_topic_sortby_dir varchar(1) character set utf8 collate utf8_bin NOT NULL DEFAULT 'a';

Code: Select all

UPDATE phpbb_users SET user_topic_sortby_dir = 'd' WHERE user_topic_sortby_dir = 'b';

Code: Select all

UPDATE phpbb_users SET user_topic_sortby_type = 't' WHERE user_topic_sortby_type = 'b';
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: How to unistall?

by Tabitha2 » Wed Apr 09, 2014 7:33 am

Error:

#1091 - Can't DROP 'topic_list_order'; check that column/key exists
Tabitha2
Registered User
Posts: 35
Joined: Wed Oct 17, 2012 7:09 am
Contact:

Re: How to unistall?

by 5hocK » Wed Apr 09, 2014 8:27 am

Tabitha2 wrote:Error:

#1091 - Can't DROP 'topic_list_order'; check that column/key exists

Did you run the SQL queries when you installed? If not then you don't have to doo this part.
A thread is pretty much a topic. Stop with the pedantics will ya.
User avatar
5hocK
Registered User
Posts: 3011
Joined: Wed Nov 23, 2011 7:00 pm
Location: England