Soft Delete

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
User avatar
umarizal
Registered User
Posts: 177
Joined: Mon Mar 17, 2008 2:03 am
Location: São Paulo - SP - Brasil
Name: Leandro dos Santos
Contact:

Re: Soft Delete

Post by umarizal »

problem when accessing "install.php" to alter the database:
SQL ERROR [ mysqli ]

Duplicate column name 'post_deleted' [1060]

SQL

ALTER TABLE `phpbb_posts` ADD COLUMN `post_deleted` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/db/db_tools.php
LINE: 618
CALL: dbal_mysqli->sql_query()

FILE: includes/db/db_tools.php
LINE: 910
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install.php
LINE: 33
CALL: phpbb_db_tools->sql_column_add()
What to do for that to solve?
EN: Do to others what you would want them to do to you.
ES: Haz a los demás todo lo que quieras que te hagan a ti.
PT: Faça aos outros o que você gostaria que fizessem a você.
User avatar
Bruno36
Registered User
Posts: 287
Joined: Fri Mar 02, 2007 2:16 pm
Location: france
Name: bruno astie
Contact:

Re: Soft Delete

Post by Bruno36 »

Hello!

This may mark in viewtopic
'This post was soft deleted by %1$s on %2$s. Click %3$shere%4$s to un-delete this post'
1.JPG
1.JPG (99.48 KiB) Viewed 1215 times
as in the photo?
Excuse me for my poor English, I speak french
Bruno36
User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: Soft Delete

Post by muggins »

EXreaction wrote:I haven't used this mod in many months and the mod itself is a mess TBH (soft delete does not work very well as a mod).

I don't think I'll be updating it unless a security fix is required.
I ran into a problem yesterday related to this mod, I'm afraid. I turned off the default "Create Shadow Topic" months ago, so I didn't realize the issue until then.

One of my mods was moving topics, and she checked 'yes' to leaving a shadow. I deleted the shadows this morning, and it deleted the moved topic. I didn't realize it, and hard-deleted the shadow, as well as the parent.

I can't figure out how to remove the shadow topics from the original forum... Any help is appreciated! :(
Muggins
User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan

Re: Soft Delete

Post by EXreaction »

That same thing happens when you delete a shadow topic even without this mod installed. To remove the shadow topic you have to go into the MCP and view the forum. There is a link for shadow topics to remove that shadow topic.
User avatar
muggins
Registered User
Posts: 1183
Joined: Fri Feb 22, 2008 5:12 pm
Location: Texas
Name: Donovan
Contact:

Re: Soft Delete

Post by muggins »

<smacks myself in the head repeatedly>

Thanks! I never had to know that, but I'll bet I won't forget again! :oops:
Muggins
Neoxxx
Registered User
Posts: 102
Joined: Wed Mar 18, 2009 12:18 pm

Re: Soft Delete

Post by Neoxxx »

Hello, I uncovered that soft delete mod interferred with sort_topics_alphabetically mod in fact when I click on letter for filter topics appears this error: Call to undefined function soft_delete_update_reply_count() in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\forum\viewforum.php on line 665

I try to comment that function and sort_topics_alphabetically works fine and soft delete would seem work fine
User avatar
Fredrik Idestam
Registered User
Posts: 199
Joined: Sat Apr 18, 2009 7:54 am
Contact:

Re: Soft Delete

Post by Fredrik Idestam »

katierunyon
Registered User
Posts: 56
Joined: Fri Sep 01, 2006 3:55 pm
Location: Pennsylvania
Contact:

Re: Soft Delete

Post by katierunyon »

I just tried to install this mod and I am having the same problem as umarizal when I try to use the install file to alter my database.
General Error
SQL ERROR [ mysql4 ]

Duplicate column name 'post_deleted' [1060]

SQL

ALTER TABLE `phpbb3_posts` ADD COLUMN `post_deleted` mediumint(8) UNSIGNED DEFAULT '0' NOT NULL

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/db/db_tools.php
LINE: 618
CALL: dbal_mysql->sql_query()

FILE: includes/db/db_tools.php
LINE: 910
CALL: phpbb_db_tools->_sql_run_sql()

FILE: install.php
LINE: 33
CALL: phpbb_db_tools->sql_column_add()
Then I also noticed that I'm having another problem. I'm not sure if it's directly related to this mod (I had tried using the Prime Trash Bin mod and did my best to uninstall it). Now whenever I try to go to any of my forums or topics, I get this:
SQL ERROR [ mysql4 ]

Unknown column 'topic_deleted' in 'field list' [1054]

SQL

SELECT topic_deleted, topic_deleted_reply_count FROM phpbb3_topics WHERE topic_id = 95 LIMIT 1

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/db/mysql.php
LINE: 221
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: includes/mods/soft_delete.php
LINE: 27
CALL: dbal_mysql->sql_query_limit()

FILE: viewtopic.php
LINE: 276
CALL: soft_delete_update_reply_count()
I'd really appreciate any help, even an idea of where I might need to look. Thanks.
User avatar
Fredrik Idestam
Registered User
Posts: 199
Joined: Sat Apr 18, 2009 7:54 am
Contact:

Re: Soft Delete

Post by Fredrik Idestam »

hi,
i installed this mod (Soft Delete) successfully, however when a user deletes his post the Topic in forum is not highlighted but the post is highlighted.
also, i am full admin & founder but still not able to hard delete the deleted post or restore it.
please provide more information about it and also what's the problem as i mentioned above.
i am using ProSilver Style & my PhpBB version is v3.0.4.
Please help to resolve these issues.
Thanks
User avatar
EXreaction
Former Team Member
Posts: 5666
Joined: Sun Aug 21, 2005 9:31 pm
Location: Wisconsin, U.S.
Name: Nathan

Re: Soft Delete

Post by EXreaction »

You will need to remove the database changes from the prime trash bin mod before you can use this.
User avatar
Fredrik Idestam
Registered User
Posts: 199
Joined: Sat Apr 18, 2009 7:54 am
Contact:

Re: Soft Delete

Post by Fredrik Idestam »

thanks for the help, but even after adding moderator permissions i am not able to Restore the soft deleted post.
i don't have it's option.
why is this?
User avatar
Fredrik Idestam
Registered User
Posts: 199
Joined: Sat Apr 18, 2009 7:54 am
Contact:

Re: Soft Delete

Post by Fredrik Idestam »

even after adding moderator permissions i am not able to Restore the soft deleted post.
i don't have it's option.
why is this?
platinum_2007
Registered User
Posts: 1101
Joined: Tue Jul 22, 2008 2:47 am
Location: Nova Scotia, Canada

Re: Soft Delete

Post by platinum_2007 »

Can you confirm this is all OK for 3.0.4?
filhakika
Registered User
Posts: 126
Joined: Tue Apr 15, 2008 8:41 am

Re: Soft Delete

Post by filhakika »

Great great mod this is. Congrts.
But i have a question. I'll use this mod for " deprecations of users".

So, i don't want to keep the "soft deleted" posts. For example i could want them hard delete after 7 days after "soft deleted". So, where can i find these all soft deleted posts or topics as a "list". Is this possible? Must i go ACP and review Moderator Logs every time?
User avatar
Fredrik Idestam
Registered User
Posts: 199
Joined: Sat Apr 18, 2009 7:54 am
Contact:

Re: Soft Delete

Post by Fredrik Idestam »

i don't have option to restore soft deleted post, anyone please help....
Locked

Return to “[3.0.x] MOD Database Releases”