Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Do not display transactions for January 31 #1156

Closed
Nik-vr opened this issue Jan 31, 2018 · 18 comments
Closed

Do not display transactions for January 31 #1156

Nik-vr opened this issue Jan 31, 2018 · 18 comments
Labels
fixed Bugs that are fixed (in a coming release).
Milestone
4.7.1

Comments

@Nik-vr
Copy link

Nik-vr commented Jan 31, 2018

I am running Firefly III version 4.6.13

Transactions (income), made on January 31, will not be displayed anywhere. But the amount on the account is displayed taking into account these "invisible" transactions. A bug?
@JC5
Copy link
Member

JC5 commented Jan 31, 2018

Where are the transactions not shown exactly? I've created some on the demo site and I see them just fine.

@Nik-vr
Copy link
Author

Nik-vr commented Feb 1, 2018

I do not see the transaction on the "My deposit" page. I do not see the transaction in the report. I do not see the transaction on the main page.
But after creating these transactions, the amount on the chart was recounted correctly.

main-page
transactions-list

On the page of accounts, the amount of the invoice is also not correct, transactions for January 31 are not taken into account.

access-list

@Nik-vr
Copy link
Author

Nik-vr commented Feb 1, 2018

111

@JC5
Copy link
Member

JC5 commented Feb 1, 2018

Could you clear your cache and share the content of /debug with me?

@Nik-vr
Copy link
Author

Nik-vr commented Feb 1, 2018

I use FireFly on a virtual hosting. The cache was cleaned by deleting the folders.
How can I help with debugging?

@JC5
Copy link
Member

JC5 commented Feb 1, 2018

Click the version number in the bottom right corner. It should lead to a page with url yourfirefly.com/debug.

The content of the first box, could you share that here?

@JC5 JC5 added the question label Feb 2, 2018
@Nik-vr
Copy link
Author

Nik-vr commented Feb 2, 2018

Debug information generated at 2018-02-02 05:16:19 UTC for Firefly III version 4.6.13.

Variable Content
FF version 4.6.13
App environment production
App debug mode false
App cache driver file
App logging debug, daily
PHP version 7.1.13
Display errors Off
Error reporting ALL errors
Host FreeBSD s36.ihead.ru 11.1-RELEASE-p4 FreeBSD 11.1-RELEASE-p4 # 1 r325968: Sat Nov 18 20:58:40 MSK 2017 root@freebsd11.build.ihead.ru:/usr/obj/usr/src/sys/IHEAD11 amd64
Interface apache2handler
UserID 1
DB drivers mysql, sqlite
Current driver sqlite
Using Sandstorm? no
Is Sandstorm (.env) 'unknown'
Is Docker (.env) 'unknown'
Trusted proxies (.env) (none)
User agent Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 YaBrowser/17.11.1.988 Yowser/2.5 Safari/537.36
Loaded extensions Core, date, libxml, pcre, Reflection, SPL, hash, session, apache2handler, calendar, ctype, SimpleXML, dom, filter, gd, gettext, standard, iconv, imap, json, mysqlnd, openssl, PDO, pdo_sqlite, pdo_mysql, mysqli, soap, sockets, tokenizer, xml, xmlreader, xmlwriter, zlib, curl, mbstring, xsl, ftp, fileinfo, mcrypt, bcmath, zip, exif, intl, Zend OPcache
Installed packages bacon/bacon-qr-code@1.0.3, davejamesmiller/laravel-breadcrumbs@4.2.0, doctrine/annotations@v1.6.0, doctrine/cache@v1.7.1, doctrine/collections@v1.5.0, doctrine/common@v2.8.1, doctrine/dbal@v2.6.3, doctrine/inflector@v1.2.0, doctrine/lexer@v1.0.1, egulias/email-validator@2.1.3, erusev/parsedown@1.6.4, fideloper/proxy@3.3.4, laravel/framework@v5.5.28, laravelcollective/html@v5.5.1, league/commonmark@0.17.0, league/csv@9.1.1, league/flysystem@1.0.41, monolog/monolog@1.23.0, mtdowling/cron-expression@v1.2.1, nesbot/carbon@1.22.1, paragonie/constant_time_encoding@v2.2.0, paragonie/random_compat@v2.0.11, pragmarx/google2fa@v2.0.7, pragmarx/google2fa-laravel@v0.1.4, psr/container@1.0.0, psr/log@1.0.2, psr/simple-cache@1.0.0, ramsey/uuid@3.7.1, rcrowe/twigbridge@v0.9.5, rmccue/requests@v1.7.0, swiftmailer/swiftmailer@v6.0.2, symfony/console@v3.4.3, symfony/css-selector@v3.4.3, symfony/debug@v3.4.3, symfony/event-dispatcher@v4.0.3, symfony/finder@v3.4.3, symfony/http-foundation@v3.4.3, symfony/http-kernel@v3.4.3, symfony/polyfill-mbstring@v1.6.0, symfony/polyfill-php56@v1.6.0, symfony/polyfill-php70@v1.6.0, symfony/polyfill-util@v1.6.0, symfony/process@v3.4.3, symfony/routing@v3.4.3, symfony/translation@v3.4.3, symfony/var-dumper@v3.4.3, tijsverkoyen/css-to-inline-styles@2.2.0, twig/twig@v1.35.0, vlucas/phpdotenv@v2.4.0, watson/validating@3.1.2,

@Nik-vr
Copy link
Author

Nik-vr commented Feb 2, 2018 

Truncated from this point <----|05:16:17] production.DEBUG: viewRange is 1M  
[2018-02-02 05:16:17] production.DEBUG: isCustom is false  
[2018-02-02 05:16:17] production.DEBUG: subtractPeriod: date is 2018-02-01  
[2018-02-02 05:16:17] production.DEBUG: 1M is in function map, execute subMonths with argument 1  
[2018-02-02 05:16:17] production.DEBUG: subtractPeriod: resulting date is 2018-01-01  
[2018-02-02 05:16:17] production.DEBUG: Default set is  [3,1,10,12,14,20,18,6,8,16] 
[2018-02-02 05:16:17] production.DEBUG: Frontpage preference set is  [3,1,12,14,8] 
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: JournalCollector range is now 2018-02-01 - 2018-02-28 (inclusive)  
[2018-02-02 05:16:17] production.DEBUG: Journal collector will filter for budgets [2] 
[2018-02-02 05:16:17] production.DEBUG: setAccounts: 3, 1, 10, 12, 14, 20, 18, 6, 8, 16  
[2018-02-02 05:16:17] production.DEBUG: Enabled filter FireflyIII\Helpers\Filter\TransferFilter  
[2018-02-02 05:16:17] production.DEBUG: Will run 2 filters on the set.  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\TransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\TransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: JournalCollector range is now 2018-02-01 - 2018-02-28 (inclusive)  
[2018-02-02 05:16:17] production.DEBUG: Journal collector will filter for budgets [1] 
[2018-02-02 05:16:17] production.DEBUG: setAccounts: 3, 1, 10, 12, 14, 20, 18, 6, 8, 16  
[2018-02-02 05:16:17] production.DEBUG: Enabled filter FireflyIII\Helpers\Filter\TransferFilter  
[2018-02-02 05:16:17] production.DEBUG: Will run 2 filters on the set.  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\TransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\TransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: Journal collector now collecting for user #1  
[2018-02-02 05:16:17] production.DEBUG: journalCollector::startQuery  
[2018-02-02 05:16:17] production.DEBUG: JournalCollector range is now 2018-02-01 - 2018-02-28 (inclusive)  
[2018-02-02 05:16:17] production.DEBUG: Journal collector will filter for budgets [3] 
[2018-02-02 05:16:17] production.DEBUG: setAccounts: 3, 1, 10, 12, 14, 20, 18, 6, 8, 16  
[2018-02-02 05:16:17] production.DEBUG: Enabled filter FireflyIII\Helpers\Filter\TransferFilter  
[2018-02-02 05:16:17] production.DEBUG: Will run 2 filters on the set.  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\InternalTransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: Before filter FireflyIII\Helpers\Filter\TransferFilter: 0  
[2018-02-02 05:16:17] production.DEBUG: After filter FireflyIII\Helpers\Filter\TransferFilter: 0

@Nik-vr
Copy link
Author

Nik-vr commented Feb 2, 2018

When statistics for February are displayed on the main page, the amount on the account is displayed correctly. But on the transaction transactions page for January 31 there is neither in January, nor in February.

@JC5
Copy link
Member

JC5 commented Feb 2, 2018

OK, so somehow the range for January is incorrect, leaving you with just 30 days.

Can you compare the following:

  • Date range is 1-Jan to 31-Jan
  • Date range changed to 1-Jan to 30-Jan. (use the date range picker, "custom" option)

I am curious if these two views are the same or if the view with 30 January is missing transactions as well.

I see that you use SQLite and I shall debug accordingly. I was using MySQL.

@Nik-vr
Copy link
Author

Nik-vr commented Feb 2, 2018

I formed a list of transactions for January 1-30, then January 1-31. In the list for January 1-30 the transaction for January 30 disappeared!
-1 day? :)

1-30-jan
1-31-jan

@JC5
Copy link
Member

JC5 commented Feb 2, 2018

I think so, yes.

Could you browse to your-firefly.com/flush? It will send you back to the index. Does it help?

@Nik-vr
Copy link
Author

Nik-vr commented Feb 4, 2018

Could you browse to your-firefly.com/flush? It will send you back to the index. Does it help?

After this command nothing has changed.

@JC5
Copy link
Member

JC5 commented Feb 4, 2018

I've found the problem, and it will be fixed in the next release. The transactions are not gone just invisible. It has to do with the way dates are stored. 2018-01-31 is not the same as 2018-01-31 00:00:00 for SQLite.

I apologize for this issue, and thank you for helping me find the issue!

@JC5 JC5 added bug fixed Bugs that are fixed (in a coming release). and removed question labels Feb 4, 2018
@JC5 JC5 added this to the 4.7.1 milestone Feb 4, 2018
@Nik-vr
Copy link
Author

Nik-vr commented Feb 5, 2018

OK! I will wait.

@JC5
Copy link
Member

JC5 commented Feb 10, 2018

Closed to clear the list.

@JC5 JC5 closed this as completed Feb 10, 2018
@Nik-vr
Copy link
Author

Nik-vr commented Feb 28, 2018

Transactions (any), made on Feb 28, will not be displayed anywhere in 4.7.0 :)

@JC5
Copy link
Member

JC5 commented Feb 28, 2018

It is the same issue, I'm afraid. I hope to release 4.7.1 this weekend.

@scottsousa scottsousa mentioned this issue Mar 28, 2019
Closed
@lock lock bot locked as resolved and limited conversation to collaborators Jan 24, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees
No one assigned
Labels
fixed Bugs that are fixed (in a coming release).
Projects
None yet
Milestone
4.7.1
Development

No branches or pull requests
2 participants
@Nik-vr @JC5