Previous Thread
Next Thread
Print Thread
Hop To
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Due to a member merge
I now have a user that has 29,000 pm's.
So it is blocked now.
Needless to say it would take forever deleting one page at a time.

If I were to delete all rows for a specific user id in the three mysql pm tables would that corrupt anything?
What happens to the other parties involved with the pm's?
Would you suggest running the Prune Orphaned Private Messages in the re builder afterwards?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,063
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,063
Likes: 69
You'll need to be careful when playing in the database, there are items linking all participants in a PT to that message and when removing the only user from a PT you'll end up with abandoned messages.

The participants involved in a PT are located in the "ubbt_PRIVATE_MESSAGE_USERS" table, wheras "ubbt_PRIVATE_MESSAGE_TOPICS" contains the topic data such as last reply, title, etc. and "ubbt_PRIVATE_MESSAGE_POSTS" contains the individual messages.

I am unsure however if UBB.threads would simply read you deleting the users entries in the "ubbt_PRIVATE_MESSAGE_USERS" table as removing PTs since their entries would still be in the "ubbt_PRIVATE_MESSAGE_POSTS" table (and if you remove posts from that table users in other private topics will see missing messages).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
That is why I asked the question.
There are three tables for PM's.
If I deleted all rows for a specific user ID in all three tables.
Will it corrupt the PM's
Even if I run the rebuilder for orphaned pm's.

Most of the pm's are like years old.
Oldest being 2006

It just sucks to only be able to delete 10 at a time from the user tool.
Let's see 29000/10 = 2900 pages.
Of which need to be refreshed and selected again.

So you have no idea what could happen and if it could be recovered from.
Except for a database restore?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,063
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,063
Likes: 69
I have never done it, or heard of anyone doing it, and managing the database directly is not supported by the vendor of UBB.threads (as it is not using the built in tools for managing PMs). What you choose to do to your own database is entirely your choice.

If the users entries in the "ubbt_PRIVATE_MESSAGE_USERS" table are purged and a orphaned PT tool is run it should catch any messages which no longer are linked to any users.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Okay,
I guess if I resort to this measure I will close the board make a backup , attempt to delete and run the orphaned PM's
Then if something looks amiss reload the database.
But it will be difficult to check all the recipients on how it looks for them.
Other that pick one or two and become member to see.

Would it not just show the user removed themself from the topic?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Giving considerations to the age of most of them I would suspect that all participants would not care.
I am not going to worry about current topics sent.
He can just recreate them.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Alright I finally approached this slightly different.
Due to concerns of just database diving.

I edited the forum/scripts/changedisplay.inc.php and set 99 to 1000
Code
if (($PostsPer < 1) || ($PostsPer > 99))

Then edited forum/templates/default/editdisplay.tpl and added a option for Max Threads Per Page
Code
<option value="1000" {if $PostsPer eq 1000}selected="selected"{/if}>{$lang.SHOW} 1000 {$lang.MAX_POSTS}</option>

Then became member and deleted PM's 1000 at a wack.
No issues.

Then I decided to run the rebuilders for PM's
Rebuild Private Messages----- No issues

Prune Orphaned Private Messages---- Invalid mode specified

HUMM!!!

Every thing seems okay so far and I restored the two files back to virgin stock code

But what does Invalid mode specified mean?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
It appears that I have a item in the config.inc.php file called DATABASE_BIG_LIMITS
According to the changelog it only appears on legacy servers in the cp database section..
Which is not the case on this site.
I am on php7.x and database is utf8mb4.
The file is blankl for a entry and there is not a option to enter a value in the cp.

I just checked two other sites and it does not have an entry line for DATABASE_BIG_LIMITS at all in the file nor a option to do so in the cp.
Should I delete that entry line in the config file on the site in question?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,063
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,063
Likes: 69
You should create different posts for different items; it makes it easier to find and keep things on track in the future.

Big Limits was introduced in v7.7.5 and allows pre-PHP7 installs to process larger chunk values for MySQL Limits in the rebuilder tools.

The setting, when shown (only PHP5 users will see this setting, as PHP7 already uses the larger chunk sizes) will be called "Force the use of larger MySQL data chunks in legacy environments (older PHP versions) when pruning or rebuilding content."

When you update your configuration it will populate a new key to your config file; there is no need to remove it as blank and 0 mean the same thing.

PHP7+/Big Limits:
Code
	$limits = array(
		"posts" => 2000,
		"posts_utf8" => 2000,
		"forums" => 200,
		"prunepostorphans" => 100,
		"pruneptorphans" => 100,
		"signatures" => 2000,
		"topics" => 2000,
		"private_messages" => 2000,
		"postcounts" => 2000,
		"likecounts" => 2000,
		"prunedupelikes" => 1,
		"updatescheme" => 1,
	);

Otherwise:
Code
	$limits = array(
		"posts" => 1000,
		"posts_utf8" => 1000,
		"forums" => 200,
		"prunepostorphans" => 100,
		"pruneptorphans" => 100,
		"signatures" => 1000,
		"topics" => 1000,
		"private_messages" => 1000,
		"postcounts" => 1000,
		"likecounts" => 1000,
		"prunedupelikes" => 1,
		"updatescheme" => 1,
	);


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Looking at dorebuildcontent.php
Starting at line 63

I need to edit the config.inc.php file and delete that line entry DATABASE_BIG_LIMITS
Or enter a value of one or something else besides nothing or a null value.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,063
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,063
Likes: 69
Its a new key in UBB.threads 7.7.5, why do you need to delete it? Your other installs will have it too when the config is updated (at least db settings); 0 is the same as blank which is the same as not existing. See my earlier post.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
As I said I have now visited two sites using UBB7.7.5 and the line item does not exist in the config.inc.php file.
Nor does the item exist as a item to edit in the cp.
But this site has
'DATABASE_BIG_LIMITS' => '', in the config file and when I run Prune Orphaned Private Messages i get Invalid mode specified

I am on php7.4 .

The only way for me to add a value to Prune Orphaned Private Messages is by editing the config.inc.php file


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,063
Likes: 69
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,063
Likes: 69
You should only see the item as a configuration if your install is running on PHP5; all PHP7 installs should use the default big limits (as the check in the rebuilder is there).


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,353
Likes: 51
Ruben Offline OP
OP Offline
Joined: Dec 2003
Posts: 6,353
Likes: 51
Never mind.
I figured it out.
I had to delete the entry via a file edit then open cp-database tab resave to create the file entry again and run the re builder that finally completed.
Something I missed must have been corrupted in the config file.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
7.7.5 become member issue
by Ruben - 04/15/2021 10:06 AM
Gobal announcement replies.
by Ruben - 04/09/2021 1:46 PM
Strange parse error in faq.php
by Baldeagle - 04/06/2021 1:12 AM
Upgrading to 7.7.5: Error:
by BB - 04/02/2021 10:48 AM
Does UBB 7.7.5 support webp images
by Ruben - 03/27/2021 12:00 PM
Who's Online Now
1 members (1 invisible), 45 guests, and 78 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5