Comments (6)
Can you post what headlines seem to be causing the problem? I've also never tested this on mac; I know there are a few problems in windows.
from org-sql.
Sure. Here it is:
- TODO Task 1
- Inserted task
- TODO Task 2
** TODO Another task - [#B] One more
Interesting to note is also that update in general doesn't work second time. For example:
- reset => OK
- update (4 records) => OK
- delete one heading
- update (3 records) => says OK but nothing changes in db
from org-sql.
I can't reproduce this on my system but I'm using linux and I don't have a Mac to test this. It sounds like the SQL buffer is getting hung on a command that isn't completing. Two things:
- Try deleting the *SQL: Org* buffer (and killing the process) after the hang and repeating the commands in the OP. Since you probably won't be able to do anything when org-sql is hung, Ctrl-G should kill the command and allow you to kill the buffer.
- If 1 succeeds, go into the source code and run
edebug-eval-top-level-form
on the functionorg-sql-user-update
right before running the command that hangs (this will run the debugger wheneverorg-sql-user-update
is called). Run the hanging command and step through the function (press space repeatedly) and you will see output in the minibuffer as you evaluate each sexp. Post the output that shows up after stepping through(org-sql-update-db)
(if it is normal it should be(nil nil nil)
but I'm guessing it will have some error message in the place of one of the nils.)
from org-sql.
To make 2 easier above, I just pushed a commit that will print the errors you are supposed to see if they exist and you follow the edebug steps. 58a2482 adds a debug option which can be enabled by running (setq org-sql-debug t)
. If necessary, please activate this and run your command sequence again instead of 2, and post the output here if it says anything besides "Run successfully" or "Not run".
from org-sql.
Consider running .trace
and .log
statements in the SQL: Org buffer before executing org-sql-user-reset
and org-sql-user-update
. The .help
command will give you more info on it.
That's what helped me to diagnose my issue
from org-sql.
Awesome! Plan to give it a try asap when I get some time. Will report.
from org-sql.
Related Issues (18)
- Will this package provide a simple web interface? HOT 4
- Symbol’s function definition is void: org-ml-headline-get-logbook HOT 2
- f-write used, but f not "require"d HOT 1
- Effort not showing up in headlines table HOT 2
- swapped calls of 'org-sql-user-push' and 'org-sql-user-pull'
- `s-matches-p`: Wrong type argument HOT 3
- Error: in prepare, no such table HOT 2
- parse custom link types and add them to the links table HOT 1
- Add abbreviation column to the table links HOT 3
- postgres process not closed
- No prompt found or ‘comint-prompt-regexp’ not set properly HOT 3
- can't see a file's #+title nor #+category HOT 2
- Plans? HOT 4
- Documentation error - "org-sqlite-db-path" should be "org-sql-sqlite-path" HOT 1
- Doesn't work on my system - solved with help of sqlite3 ".log" and ".trace" commands HOT 10
- clocking is empty HOT 26
- Hard-coded path to sqlite3 - No such a file or directory, /usr/bin/sqlite3 HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 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.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
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.
from org-sql.