Picture of the author
Topic :
Thread Created at Invalid date | Started by
Number of Post in this thread: 5Please Sign In to comment on this Thread
Brent_Allsop replied 2 years ago (Sep 10th 2021, 10:20:01 pm)

Message from Ashutosh:

--------------------------------------------

Quick fix is:


https://github.com/the-canonizer/canonizer.2.0/tree/development-50/database

1. canonizer2.sql

2. c_threads.sql

3. replies.sql


Then copy the rest of the migrations to a folder then apply it (Other than problematic one)

----------------------------------------------------------------------------------------------------

Ashutosh indicated "Schema is already in the migrations. But some files are unordered I believe"

and: "I think we need to delete user_id (migrations) to the user migration table then it'll fix the issue. But need to test that. I am travelling tomorrow. Will try to look into this today "


TheSmokingPeanut replied 2 years ago (Sep 10th 2021, 1:49:58 pm)
Developer: Sandeep N
  • Blockers/Needs:
    • Backup database file missing required tables. 
    • Alternative is to understand the existing application thoroughly and rebuild the same.
    • with the existing application cannot build database schema on assumption - it will lead to data loss and inconsistency at later stages
    • Cannot setup in local without correct database. 
  • Today's Work:
    • Tried to fix database migrations in database/migrations - without understanding the application logic it will be very hard and time consuming to fix issues with respect to missing tables
TheSmokingPeanut replied 2 years ago (Sep 10th 2021, 1:49:44 pm)
Developer: Sandeep N
  • Blockers/Needs:
    • Backup database file missing required tables. 
    • Alternative is to understand the existing application thoroughly and rebuild the same.
    • with the existing application cannot build database schema on assumption - it will lead to data loss and inconsistency at later stages
    • Cannot setup in local without correct database. 
  • Today's Work:
    • Tried to fix database migrations in database/migrations - without understanding the application logic it will be very hard and time consuming to fix issues with respect to missing tables
TheSmokingPeanut replied 2 years ago (Sep 10th 2021, 1:49:29 pm)
Developer: Sandeep N
  • Blockers/Needs:
    • Backup database file missing required tables. 
    • Alternative is to understand the existing application thoroughly and rebuild the same.
    • with the existing application cannot build database schema on assumption - it will lead to data loss and inconsistency at later stages
    • Cannot setup in local without correct database. 
  • Today's Work:
    • Tried to fix database migrations in database/migrations - without understanding the application logic it will be very hard and time consuming to fix issues with respect to missing tables
TheSmokingPeanut replied 2 years ago (Sep 9th 2021, 5:24:03 pm)
Hi

Developer: Sandeep N

Tickets: N/A
  • Blockers/Needs:
  • Migrations are incorrect. not able to run the migrations, need a proper schema to fix the issues.
  • backup database file incorrect.
  • Today's Work:
  • Working on setting up the project locally.
  • upgraded the composer packages to the latest.
  • Added missing .env file.
  • Database backup file not working.

Regards