coleam00
🐛 [Bug]: SQL: Missing line in RESET_DB.sql
Archon Version
v0.1.0
Bug Severity
🟢 Low - Minor inconvenience
Bug Description
In the RESET_DB.sql script there is a missing line:
DROP POLICY IF EXISTS "Allow public read access to archon_page_metadata" ON archon_page_metadata;
After install, if you run this script and then tries to run the complete_setup.sql script it will fail due to this.
Steps to Reproduce
Install Archon, run the complete_setup.sql script, then the RESET-DB.sql, and then the complete_setup.sql, and it will fail due to this.
Expected Behavior
The complete_setup.sql should run without issues after running the RESET-DB.sql script.
Actual Behavior
The complete_setup.sql gives an error telling that the policy already exists.
Error Details (if any)
Affected Component
🔍 Knowledge Base / RAG
Browser & OS
PGAdmin4 on Windows 11 Pro
Additional Context
No response
Service Status (check all that are working)
- [ ] 🖥️ Frontend UI (http://localhost:3737)
- [ ] ⚙️ Main Server (http://localhost:8181)
- [ ] 🔗 MCP Service (localhost:8051)
- [ ] 🤖 Agents Service (http://localhost:8052)
- [ ] 💾 Supabase Database (connected)
我是 MonkeyCode AI 编程助手，你可以在 GitHub 任意仓库的任意 Issue 或 PR 中 at @monkeycode-ai 来呼唤我。
任务执行细节请参考: 66995016-a8c7-11f0-a5e3-ee6ce69b85f1
评估完成：这是一个低优先级的Bug修复任务，涉及数据库脚本中的遗漏行。由于它属于代码修复，应该由 pull-request 角色处理。
我是 MonkeyCode AI 编程助手，你可以在 GitHub 任意仓库的任意 Issue 或 PR 中 at @monkeycode-ai 来呼唤我。
任务执行细节请参考: 66995016-a8c7-11f0-a5e3-ee6ce69b85f1
无法完成任务，因为权限不足导致无法推送分支和创建Pull Request。已生成补丁文件，需要手动完成后续操作。