Author Topic: old chats  (Read 2496 times)

0 Members and 1 Guest are viewing this topic.

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
old chats
« on: 22 06 2023, 09:39:58 »
hi,

where are my chats from last year? i can only see the last 30 days.
 

Offline dartraiden

Re: old chats
« Reply #1 on: 22 06 2023, 13:39:04 »
What protocol are you talking about?
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #2 on: 22 06 2023, 14:50:45 »
jabber xmpp
 

Offline dartraiden

Re: old chats
« Reply #3 on: 22 06 2023, 15:48:25 »
Please post version info report here
 

Offline ghazan

Re: old chats
« Reply #4 on: 22 06 2023, 15:49:58 »
rotefantas2,
1. which history plugin do you use?
2. if you could download any SQLITE Browser for Windows, you'd be able to open this profile and execute a query like

SELECT * FROM events WHERE contact_id = XXX;

where XXX is the contact id, you can find it in dbeditor++ in the list of Contacts
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #5 on: 22 06 2023, 18:17:20 »
Please post version info report here
VersionInfo
Quote
CPU: Intel(R) Pentium(R) CPU G4560 @ 3.50GHz [Intel64 Family 6 Model 158 Stepping 9] [DEP Enabled] [4 CPUs]
Installed RAM: 16235 MBytes
Microsoft Windows 10 Professional Edition, 64-bit (build 19045)
Internet Explorer: 9.11.19041.0 (build 919041)
Administrator privileges: No
OS Languages: (UI | Locale (User/System)) : German/German | German/German
Free disk space on Miranda partition: 232365 MBytes

Miranda NG Version: 0.96.3 build #25684 (e313c689e1) x64
Build time: 13 Jun 2023 18:24:12
Profile: C:\Users\Nutzer\AppData\Roaming\Miranda NG\Arbeitsplatz\Arbeitsplatz.dat
Database driver: SQLite database driver
Profile size: 548864 Bytes
Profile creation date: 15 Sep 2021 11:01:54
Language pack: German (DE) [0407]
Service Mode: No
SRMM Log Viewer: built-in

Active Plugins (19):
¤ AVS.dll v.0.98.1.6 [13 Jun 2023 18:24:20] - Avatar service
¤ Clist_modern.dll v.0.9.1.12 [13 Jun 2023 18:25:16] - Modern contact list
¤ CrashDumper.dll v.0.2.0.1 [13 Jun 2023 18:25:22] - Crash dumper
¤ Db_autobackups.dll v.0.1.0.7 [13 Jun 2023 18:24:30] - Db autobackuper
¤ DbChecker.dll v.0.96.3.1 [13 Jun 2023 18:27:08] - Database checker
¤ Dbx_sqlite.dll v.0.96.2.4 [13 Jun 2023 18:27:02] - Miranda NG SQLite database driver
¤ Dummy.dll v.0.2.0.1 [13 Jun 2023 18:26:26] - Dummy protocol
¤ Facebook.dll v.0.1.0.11 [13 Jun 2023 18:27:08] - Facebook
¤ GG.dll v.0.96.3.1 [13 Jun 2023 18:24:42] - Gadu-Gadu protocol
¤ ICQ.dll v.0.96.3.3 [13 Jun 2023 18:27:06] - ICQ-WIM protocol
¤ Import.dll v.0.96.3.1 [13 Jun 2023 18:24:58] - Import contacts and messages
¤ IRC.dll v.0.96.1.4 [13 Jun 2023 18:24:22] - IRC protocol
¤ Jabber.dll v.0.95.11.1 [13 Jun 2023 18:25:16] - Jabber protocol
¤ NewEventNotify.dll v.0.2.2.7 [13 Jun 2023 18:25:18] - NewEventNotify
¤ PluginUpdater.dll v.0.2.1.5 [13 Jun 2023 18:25:30] - Plugin updater
¤ StatusManager.dll v.1.2.0.6 [13 Jun 2023 18:26:48] - Status manager
¤ TabSRMM.dll v.3.6.2.6 [13 Jun 2023 18:24:36] - TabSRMM
¤ TopToolBar.dll v.0.8.0.5 [13 Jun 2023 18:25:04] - TopToolBar
¤ VoiceService.dll v.0.1.3.1 [13 Jun 2023 18:27:14] - Voice Service

Protocols and Accounts:
-------------------------------------------------------------------------------
JABBER                   1 - Enabled 0 - Disabled  Loaded

Icon Packs:
-------------------------------------------------------------------------------
 Proto_Dummy.dll [13 Jun 2023 18:31:00]
 Proto_Facebook.dll [13 Jun 2023 18:31:00]
 Proto_GG.dll [13 Jun 2023 18:30:58]
 Proto_ICQ.dll [13 Jun 2023 18:31:00]
 Proto_IRC.dll [13 Jun 2023 18:30:58]
 Proto_Jabber.dll [13 Jun 2023 18:30:58]
 Proto_MetaContacts.dll [13 Jun 2023 18:31:00]
 Proto_MRA.dll [13 Jun 2023 18:31:00]
 TabSRMM_icons.dll [13 Jun 2023 18:30:58]
 Toolbar_icons.dll [13 Jun 2023 18:30:58]
 xStatus_Jabber.dll [13 Jun 2023 18:30:58]
[close]
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #6 on: 22 06 2023, 18:19:20 »
rotefantas2,
1. which history plugin do you use?
2. if you could download any SQLITE Browser for Windows, you'd be able to open this profile and execute a query like

SELECT * FROM events WHERE contact_id = XXX;

where XXX is the contact id, you can find it in dbeditor++ in the list of Contacts
1. none
2. where is the path of the profile? which browser do you recommend ? this  one?
https://sqlitebrowser.org/dl/
 

Offline ghazan

Re: old chats
« Reply #7 on: 22 06 2023, 20:43:08 »
rotefantas2,
1. by default = Profiles subfolder of your Miranda NG installation path, or ProfilePath variable in your mirandaboot.ini
2. yes, why not
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #8 on: 23 06 2023, 14:19:32 »
i have no idea where to search. do i have to look for .db-files or .sqlite-files?
 

Offline dartraiden

Re: old chats
« Reply #9 on: 23 06 2023, 17:41:22 »
mirandaboot.ini -> ProfileDir=<profile path>

<profile path>/<profile name>/<profile name>.dat = it is your database
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #10 on: 23 06 2023, 20:03:31 »
browser says no. miranda ng still opened.
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #11 on: 23 06 2023, 20:04:52 »
ok this looks good (after closing miranda ng)
 

Offline rotefantas2

  • Newbie
  • *
  • Posts: 29
Re: old chats
« Reply #12 on: 23 06 2023, 20:08:54 »
i have no idea how to start a query and use dbeditor++ in the list of Contacts.
..
 

Offline dartraiden

Re: old chats
« Reply #13 on: 24 06 2023, 06:51:57 »
SELECT * FROM events WHERE contact_id = XXX;

where XXX is the contact id, you can find it in dbeditor++ in the list of Contacts
1. Install the DbEditorPP plugin
2. Right-click on contact -> Open in Database Editor -> See contact ID (dec value)
In my case, it is 447
3. Open db in SQLite Browser (always use a copy, do not experiment on your real db)
4. Switch to Execute SQL
5. Execute SELECT * FROM events WHERE contact_id = 447; command
6. See SQL Log

-- EXECUTING ALL IN 'SQL 1'
--
-- At line 1:
SELECT * FROM events WHERE contact_id = 447;
-- Result: 325 rows returned in 149ms

325 events in history for this contact

7. See timestamp for event 1 (1 is the oldest event in contact history)
1634160132
8. Convert this UNIX timestamp to date with https://www.unixtimestamp.com
GMT    Wed Oct 13 2021 21:22:12 GMT+0000

Result: the history of conversations with this contact in my database starts with Oct 13 2021 21:22:12 GMT
This is in complete agreement with what the history viewer plugin History++ shows me in Miranda (Oct 13 21:22:12 GMT = Oct 14 0:22:12 GMT+3)

This way you will find out if there is a history older than 30 days in the database or not.
« Last Edit: 24 06 2023, 07:06:39 by dartraiden »
 
The following users thanked this post: rotefantas2

Offline dartraiden

Re: old chats
« Reply #14 on: 24 06 2023, 07:08:02 »
If there is no history older than 30 days in the database... well, for some reason it is erased. I have no idea why.

If there is a history older than 30 days in the database, perhaps this is some kind of bug in the history viewer, and it simply cannot show it. Try another history viewer (HistoryPP plugin or Basic History). Or create new database and import all contacts and history from old database to the new one.
« Last Edit: 24 06 2023, 07:10:58 by dartraiden »
 
The following users thanked this post: ghazan