timw4mail
/
HummingBirdAnimeClient
1
1
Fork 1
Code Issues 5 Pull Requests Projects 1 Releases Wiki Activity

Collection Database issues #20

New Issue
Closed
opened 2019-01-03 21:11:14 -05:00 by colwellkr · 4 comments
colwellkr commented 2019-01-03 21:11:14 -05:00
Contributor
Copy Link

Ongoing issues with the collection database.

Observed issues so far:

  • Phinx.yml already exists in repo and doesn't need to be initialized (update docs)
  • Phinx.yml requires migrations location to be in single quotes (' ')
  • PHP throws error when trying to view collection if database does not exist (perhaps have a check to make sure the db has been generated before navigating to collection or on collection page)
  • Phinx migrates database to incorrect location (named anime_collection.sqlite.sqlite3)
  • Even once database has been moved to correct location, adding items to it fails with a "read only database" error.
Ongoing issues with the collection database. Observed issues so far: * Phinx.yml already exists in repo and doesn't need to be initialized (update docs) * Phinx.yml requires migrations location to be in single quotes (' ') * PHP throws error when trying to view collection if database does not exist (perhaps have a check to make sure the db has been generated before navigating to collection or on collection page) * Phinx migrates database to incorrect location (named anime_collection.sqlite.sqlite3) * Even once database has been moved to correct location, adding items to it fails with a "read only database" error.
colwellkr commented 2019-01-03 21:12:16 -05:00
Author
Contributor
Copy Link

Errors regarding initializing phinx.yml and trying to migrate database without putting migrations locations in single quotes:

Errors regarding initializing phinx.yml and trying to migrate database without putting migrations locations in single quotes:
unknown.png
34 KiB
unknown.png
colwellkr commented 2019-01-03 21:14:28 -05:00
Author
Contributor
Copy Link

Phinx generating database with the wrong filename (anime_collection.sqlite.sqlite3)

Phinx generating database with the wrong filename (anime_collection.sqlite.sqlite3)
unknown (1).png
17 KiB
unknown (1).png
colwellkr commented 2019-01-03 21:16:27 -05:00
Author
Contributor
Copy Link

Error regarding writing to a read-only database occurs when trying to add items to the collection. Seems to happen both with a newly generated database and one ported over from a previous installation.

Error regarding writing to a read-only database occurs when trying to add items to the collection. Seems to happen both with a newly generated database and one ported over from a previous installation.
unknown (2).png
123 KiB
unknown (2).png
timw4mail added this to the v4.1 milestone 2019-01-07 14:31:51 -05:00
timw4mail added the
Bug
 label 2019-01-07 14:31:57 -05:00
timw4mail commented 2019-01-08 16:09:09 -05:00
Owner
Copy Link
  • Phinx.yml already exists in repo and doesn't need to be initialized (update docs)
  • Phinx.yml requires migrations location to be in single quotes (' ')
  • PHP throws error when trying to view collection if database does not exist (perhaps have a check to make sure the db has been generated before navigating to collection or on collection page)
  • Phinx migrates database to incorrect location (named anime_collection.sqlite.sqlite3)
  • Even once database has been moved to correct location, adding items to it fails with a "read only database" error.

The last issue seems to be an environment-specific problem, so I'm closing this.

* <s>Phinx.yml already exists in repo and doesn't need to be initialized (update docs)</s> * <s>Phinx.yml requires migrations location to be in single quotes (' ')</s> * <s>PHP throws error when trying to view collection if database does not exist (perhaps have a check to make sure the db has been generated before navigating to collection or on collection page)</s> * <s>Phinx migrates database to incorrect location (named anime_collection.sqlite.sqlite3)</s> * Even once database has been moved to correct location, adding items to it fails with a "read only database" error. The last issue seems to be an environment-specific problem, so I'm closing this.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
master
develop
v5.2.0
v5.1.0
v4.2.0
v4.1.0
v4.0.0
v3.0
v2.2.1
v2.2
v2.1
v2
Labels
Clear labels   
Bug

   
Feature Request

   
Other

   
Planned Feature

   
Planning
No Label
Bug
Feature Request
Other
Planned Feature
Planning
Milestone
Clear milestone
No items
No Milestone
v4.1
Projects
Clear projects
No project
Assignees
Clear assignees
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: timw4mail/HummingBirdAnimeClient#20
No description provided.
Delete Branch "%!s(<nil>)"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?