Journal is a privacy first, self hosted digital log book. It is designed to be accessible anywhere you go, allowing you to organize your thoughts, feelings and opinions in one place.
License: GNU General Public License v3.0
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
When i try to migrate, database migration tool can't find DB_HOST and other variables
root@e975db9c0f67:/var/www/html# vendor/bin/doctrine-migrations migrate --no-interaction
Notice: Undefined index: DB_HOST in /var/www/html/private/lib/Database/Database.php on line 24
Notice: Undefined index: DB_USERNAME in /var/www/html/private/lib/Database/Database.php on line 25
Notice: Undefined index: DB_PASSWORD in /var/www/html/private/lib/Database/Database.php on line 26
Notice: Undefined index: DB_SCHEMA in /var/www/html/private/lib/Database/Database.php on line 27
<h2>Error establishing a database connection</h2><pre>An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory</pre>
Output of .env file:
root@e975db9c0f67:/var/www/html# cat .env
DEBUG_MODE = "true"
USE_SSL = "false"
BASE_URL = "/"
DB_HOST = "mariadb"
DB_SCHEMA = "test"
DB_USERNAME = "test"
DB_PASSWORD = "test"
SITE_TITLE = "Journal"
ADMIN_EMAIL_ADDRESS = "[email protected]"
Output of echo $DB_HOST
root@e975db9c0f67:/var/www/html# echo $DB_HOST
mariadb
When i change
journal/private/lib/Database/Database.php
Lines 24 to 27 in 5f55ee2
'host' => mariadb, it works
BTW i can successfully connect to web page even without any change.
When visiting an update entry page, if the entry does not exist then you will receive an internal error. There was a nice error message before, I need to look into what happened there.
Error: Call to a member function getEntryId() on null in /journal/private/cache/templates/e5de10e1590620b058206dae2056122b5ea74ace.php:8
Stack trace:
#0 /journal/vendor/illuminate/filesystem/Filesystem.php(107): require()
#1 /journal/vendor/illuminate/filesystem/Filesystem.php(108): Illuminate\Filesystem\Filesystem::Illuminate\Filesystem\{closure}()
#2 /journal/vendor/illuminate/view/Engines/PhpEngine.php(58): Illuminate\Filesystem\Filesystem->getRequire()
#3 /journal/vendor/illuminate/view/Engines/CompilerEngine.php(61): Illuminate\View\Engines\PhpEngine->evaluatePath()
#4 /journal/vendor/illuminate/view/View.php(139): Illuminate\View\Engines\CompilerEngine->get()
#5 /journal/vendor/illuminate/view/View.php(122): Illuminate\View\View->getContents()
#6 /journal/vendor/illuminate/view/View.php(91): Illuminate\View\View->renderContents()
#7 /journal/vendor/jenssegers/blade/src/Blade.php(47): Illuminate\View\View->render()
#8 /journal/private/lib/Utility/Template.php(88): Jenssegers\Blade\Blade->render()
#9 /journal/private/lib/Controller/Entry.php(229): App\Utility\Template->render()
#10 /journal/private/lib/Router.php(76): App\Controller\Entry->updateView()
#11 /journal/public/index.php(5): App\Router::route()
#12 {main}
Next Illuminate\View\ViewException: Call to a member function getEntryId() on null (View: /journal/private/templates/entry/update.blade.php) in /journal/private/cache/templates/e5de10e1590620b058206dae2056122b5ea74ace.php:8
Stack trace:
#0 /journal/vendor/illuminate/view/Engines/PhpEngine.php(60): Illuminate\View\Engines\CompilerEngine->handleViewException()
#1 /journal/vendor/illuminate/view/Engines/CompilerEngine.php(61): Illuminate\View\Engines\PhpEngine->evaluatePath()
#2 /journal/vendor/illuminate/view/View.php(139): Illuminate\View\Engines\CompilerEngine->get()
#3 /journal/vendor/illuminate/view/View.php(122): Illuminate\View\View->getContents()
#4 /journal/vendor/illuminate/view/View.php(91): Illuminate\View\View->renderContents()
#5 /journal/vendor/jenssegers/blade/src/Blade.php(47): Illuminate\View\View->render()
#6 /journal/private/lib/Utility/Template.php(88): Jenssegers\Blade\Blade->render()
#7 /journal/private/lib/Controller/Entry.php(229): App\Utility\Template->render()
#8 /journal/private/lib/Router.php(76): App\Controller\Entry->updateView()
#9 /journal/public/index.php(5): App\Router::route()
#10 {main}
It is also best to check whether all pages redirect properly when incorrect id is given in the url.
Hello!
Thanks a lot for creating this project. I have been running this locally and have found that a lot of time, I am signed out automatically.
I write lengthy posts and when I press save, it would have logged out, losing the post.
Is there any configuration to set to prevent this from happening or increase the sign-out period?
Thanks for all your help!
It would be nice if you could load in entry templates to the entry creation page. This would greatly help with daily entries, if you are keeping track of food, as an example.
Originally posted by EXCIDIVM July 24, 2022
Just one feature is missing for me to actually use it as my daily driver: Support for images. I am very much used to add images to my journal entries. I also like having the first image to be visible in the article overview.
entry updated time is UTC-0, not current country local time. it would be great if it automatically choose the timezone or change from settings.
After a build up of 20-30 entries in the system, when filtering on a category you will find that the entries page in-fact does not display 25 entries for the chosen category.
I am seeing the following error when trying to go to the /entry/create and /template URLs.
Fatal error: require(): Failed opening required '/var/www/private/cache/database/proxy/__CG__AppDatabaseModelCategory.php'
(include_path='.:/usr/share/php') in /var/www/vendor/doctrine/common/lib/Doctrine/Common/Proxy/AbstractProxyFactory.php on line 187
I can create categories and users. I checked and that directory is empty. I am not sure what is supposed to create that file. I even deleted everything and did the full reinstall again. Same error.
On the first start:
journal | wait-for-it.sh: waiting 30 seconds for my-db-server.com:3306
journal | wait-for-it.sh: my-db-server.com:3306 is available after 0 seconds
journal | db is up or timeout reached, continuing
journal |
journal | In ExceptionConverter.php line 67:
journal |
journal | An exception occurred while executing a query: SQLSTATE[42S22]: Column not
journal | found: 1054 Unknown column 't0.timezone' in 'field list'
journal |
journal |
journal | In Exception.php line 28:
journal |
journal | SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.timezone' in 'fi
journal | eld list'
journal |
journal |
journal | In Connection.php line 69:
journal |
journal | SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.timezone' in 'fi
journal | eld list'
journal |
journal |
journal | migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [ --configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
On the second docker-compose up i got
journal | wait-for-it.sh: waiting 30 seconds for my-db-server.com:3306
journal | wait-for-it.sh: my-db-server.com:3306 is available after 0 seconds
journal | db is up or timeout reached, continuing
journal |
journal | In ExceptionConverter.php line 72:
journal |
journal | An exception occurred while executing a query: SQLSTATE[42S21]: Column alre
journal | ady exists: 1060 Duplicate column name 'sortOrder'
journal |
journal |
journal | In Exception.php line 28:
journal |
journal | SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'sortOrd
journal | er'
journal |
journal |
journal | In Connection.php line 69:
journal |
journal | SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'sortOrd
journal | er'
journal |
journal |
journal | migrations:migrate [--write-sql [WRITE-SQL]] [--dry-run] [--query-time] [--allow-no-migration] [--all-or-nothing [ALL-OR-NOTHING]] [ --configuration CONFIGURATION] [--em EM] [--conn CONN] [--] [<version>]
journal |
journal exited with code 0
After the first start the database journal with the tables categories, entries, migrations, templates, users, widgets are created.
The table migrations contains 3 entries
version executed_at execution_time
App\Database\Migration\Version20210307220104 2023-12-12 08:34:15 58
App\Database\Migration\Version20210519195946 2023-12-12 08:34:15 12
App\Database\Migration\Version20210609111114 2023-12-12 08:34:15 27
All other tables are empty, but structure exists.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.