Repository navigation
Fix duplicate table definitions in schema.ts causing 127 TypeScript compilation errors #509
Description
Bug Description
The database schema file src/database/schema.ts has duplicate table definitions for four tables, plus a duplicate column definition in the users table. This causes the TypeScript compiler to fail with 127 errors, making the project completely uncompilable.
Affected Tables
The following tables are defined twice in src/database/schema.ts:
- announcements - Lines ~357-378 AND ~595-614
- courseShares - Lines ~131-157 AND ~617-641
- courseReviews - Lines ~298-327 AND ~644-667
- notifications - Lines ~331-353 AND ~670-689
Additionally, the users table (lines ~25-64) defines bannedAt twice:
- Line 43:
bannedAt: timestamp("banned_at", { withTimezone: true }) - Line 61:
bannedAt: timestamp("banned_at", { withTimezone: true })
Impact
- TypeScript compilation fails with 127 errors
- Cannot run
npm run typecheck,npm run build, ornpm test - The project is completely broken for development
Steps to Reproduce
- Run
npm install - Run
npx tsc --noEmit -p tsconfig.test.json - Observe 127 compilation errors
Expected Behavior
All tables should be defined exactly once in the schema file. The project should compile without errors.
Acceptance Criteria
- Remove duplicate table definitions (keep the first/most complete version of each)
- Remove duplicate
bannedAtcolumn from users table - Verify
npm run typecheckpasses with zero errors - Verify all imports across the codebase still resolve correctly
Severity
critical - The project cannot be compiled or tested in its current state.
Activity
damilare0813 commentedon Sep 30, 2026
@damilare0813 has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @damilare0813 to this issue.
Duyicoda commentedon Sep 30, 2026
@Duyicoda has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Duyicoda to this issue.
osasfaith commentedon Sep 30, 2026
@osasfaith has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @osasfaith to this issue.
CryptoverseOG commentedon Sep 30, 2026
@CryptoverseOG has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @CryptoverseOG to this issue.
Baytizz commentedon Sep 30, 2026
@Baytizz has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Baytizz to this issue.
leadgenexpert454 commentedon Sep 30, 2026
@leadgenexpert454 has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @leadgenexpert454 to this issue.
Vivianndev commentedon Sep 30, 2026
@Vivianndev has applied to work on this issue as part of the Stellar Wave Program's 9th wave.
ℹ️ Repo Maintainers: To accept this application, review their application or assign @Vivianndev to this issue.
drips-wave commentedon Sep 30, 2026
Congratulations, @osasfaith! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on September 30, 2026.
🧑💻 @osasfaith: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.
Warning
When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.
🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.
🌊 Happy Wave 🌊
grantfox-oss commentedon Oct 1, 2026
🎉 This issue has been marked as completed on GrantFox!
@osasfaith's PR #545 was approved and merged by @DeFiVC.
🏆 @osasfaith: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (732 total points). Track your full progress on GrantFox.
👏 Great work, @osasfaith! Keep contributing to ChainLearnOfficial.