Recent Posts

Pages: [1] 2 3 ... 10
1
News and Updates / Minor update 4.0.896
« Last post by Wilson Logan on June 17, 2019, 08:04:20 AM »

http://www.personalgroupware.com/groupmanager/pg-offline-4-0-896.zip


1.   Move database should move all Attachments, Files, Links and Photos as well as correct references to Attachments in messages.

2.   Correct the MySQL export template and change BLOB to MEDIUMBLOB.

3.   Correct the MySQL export template and add a semicolon to USE `PGO` because it is required.

4.   Add consideration for backslashes that may appear in a Subject and must be escaped.


If you have not been affected by this issue then you do not need this update.
2
I need Help ! / Re: Yahoo d/l limit
« Last post by Wilson Logan on May 23, 2019, 06:52:21 AM »
Hi Jim,

 That is some very interesting information.

 Just as a caveat to that, I have been able to get 120,000+ posts from a single group in a single session.

 The limit seems to be shared across the group. So, if your group is large, you get a large allowance.

 The allowance is consumed by traffic to & from the group.

 If the group is not heavily trafficked, a small number of people can have access to the total allowance.

 TBF that is simply my guess at what is happening but it is based on nearly 20 years experience of downloading Yahoo groups.

Cheers,

 Wilson.



3
I need Help ! / Re: Yahoo d/l limit
« Last post by Techsys on May 22, 2019, 09:06:16 AM »
This may come as a surprise for some people so I'm sharing my experience.

Last evening, I downloaded all 19 years of our group data, which was 91,336 messages with numerous attachments (excluding "winmail.dat"), 330 MB of photos, 36 MB of other files and a handful of links for a total of about 750 MB of data. No hiccups, no lockouts, no invalid anything.

Before I suppose how this could happen under the supposedly-watchful eye of Yahoo staff, there is a backstory that should be known to anyone who hasn't heard.

In a Business Insider report dated January 8, 2019, Verizon CEO, Hans Vestberg, clearly stated that AOL and Yahoo business units must survive on their own merits. It is then curious that, since this report, zero posts in Groups have been indexed whatsoever and are not included in any "Search Conversations" results. Also, no statistics for any group have been updated since January 12 but most groups currently show January 5 as the last activity which, of course, simply isn't true or even possible. Therefore, I am convinced that Yahoo is dying a slow death. This prompted great concern in our group to secure our data.

I can only imagine that I was able to download, uninterrupted, for one of the following reasons: (a) sadly, no one is watching or cares, (b) automated systems are not being maintained and are failing or have completely failed, or (c) non-residential IP addresses aren't flagged for attention.

After hearing all the scary warnings about pulling too many posts at once, I specifically spun up a Windows 10 VM on Azure, thinking I could change the assigned IP address as necessary. So I pulled 6K messages, stopped for dinner (because I wanted to watch it closely) then came back and said "to heck with it" and let her rip. When I went past 16K and then 25K, I was pleasantly surprised. Everything was done about 4 hours later.

Many, many thanks to Mr. Logan for providing this impressive utility. I will absolutely be registering.

The Business Insider report link: https://www.businessinsider.com/verizon-ceo-hans-vestberg-yahoo-aol-business-2019-1
4
I need Help ! / Re: SQLite database cipher
« Last post by Wilson Logan on April 20, 2019, 12:35:54 AM »
I use SQLite Studio to open & browse the database files.

https://sqlitestudio.pl/index.rvt?act=download

5
I need Help ! / Re: Downloading Files
« Last post by Wilson Logan on April 19, 2019, 11:42:56 PM »
Groovy!

Cheers,

 Wilson.
6
I need Help ! / Re: Downloading Files
« Last post by mick on April 19, 2019, 09:27:56 AM »
Wilson,

I must've missed the memo on ver. 4.0.891. I downloaded it and installed it and I am now able to download files and folders.

Thanks!

Mick
7
I need Help ! / Re: Downloading Files
« Last post by mick on April 19, 2019, 08:28:21 AM »
Wilson,

I am currently running 4.0.88

MC
8
I need Help ! / Re: Yahoo d/l limit
« Last post by Wilson Logan on April 19, 2019, 03:20:49 AM »
Actually... Yahoo is pseudo threaded.


Each message has an individual message number.  Messages are atomic.

What joins them is the subject line.

That is, in & of itself, no guarantee of continuity as if you make a reply but change the subject line, the link is lost.


Truly threaded  forums (like Facebook) have separate Post and Comment types.

Comments cannot exist without their parent Post.

 
9
I need Help ! / Re: Downloading Files
« Last post by Wilson Logan on April 19, 2019, 03:14:15 AM »
Mick,

 What version PGO do you have?

 I have a memory of us making a change for TLS1.2 which is a change that was made to the internet generally.

Cheers,

 Wilson.
10
I need Help ! / Re: SQLite database cipher
« Last post by Wilson Logan on April 19, 2019, 03:08:55 AM »
Hi Richard,

 You can open the .db3 database file directly with SQLite Browser.

 You do not need to export as SQL as what this produces is a dump file which is a text file of SQL commands.

 You cannot open a text file with a utility designed to open databases.

 Just open the .db3 file (which is an SQLIte database) using your SQLite browser.

Cheers,

Wilson.
Pages: [1] 2 3 ... 10
SMF spam blocked by CleanTalk