New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

invalid identifier keyword "Version" on oracle #362

Open
omanbuluatie opened this Issue Oct 8, 2017 · 6 comments

Comments

Projects
None yet
2 participants
@omanbuluatie

omanbuluatie commented Oct 8, 2017

continuoing from issue #361 this is my log
Sun 2017/10/08 19:44:00 gammu-smsd: Using SQL service
Sun 2017/10/08 19:44:00 gammu-smsd: Configuring Gammu SMSD...
Sun 2017/10/08 19:44:00 gammu-smsd: PIN code is "1234"
Sun 2017/10/08 19:44:00 gammu-smsd: CommTimeout=30, SendTimeout=30, ReceiveFrequency=15, ResetFrequency=0, HardResetFrequency=0
Sun 2017/10/08 19:44:00 gammu-smsd: checks: CheckSecurity=1, CheckBattery=1, CheckSignal=1, CheckNetwork=1
Sun 2017/10/08 19:44:00 gammu-smsd: mode: Send=1, Receive=1
Sun 2017/10/08 19:44:00 gammu-smsd: deliveryreport = no
Sun 2017/10/08 19:44:00 gammu-smsd: phoneid =
Sun 2017/10/08 19:44:02 gammu-smsd: Connected to driver SQORA32.DLL
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM gammu WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM inbox WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM sentitems WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM outbox WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM outbox_multipart WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT * FROM phones WHERE ROWNUM <= 1
Sun 2017/10/08 19:44:02 gammu-smsd: Execute SQL: SELECT Version FROM gammu
Sun 2017/10/08 19:44:02 gammu-smsd: SQLExecDirect failed, Code = -1, ODBC diagnostics:
Sun 2017/10/08 19:44:02 gammu-smsd: 42S22:1:904:[Oracle][ODBC][Ora]ORA-00904: "VERSION": invalid identifier

Sun 2017/10/08 19:44:02 gammu-smsd: SQL failure: 79
Sun 2017/10/08 19:44:02 gammu-smsd: Initialisation failed, stopping Gammu smsd: Error in executing SQL query. (SQL[79])
Sun 2017/10/08 19:44:02 gammu-smsd: Stopping Gammu smsd: No error. (NONE[1])

fail_sql

@omanbuluatie

This comment has been minimized.

Show comment
Hide comment
@omanbuluatie

omanbuluatie Oct 14, 2017

can you please fix this? thanks 😄

omanbuluatie commented Oct 14, 2017

can you please fix this? thanks 😄

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 16, 2017

Member

Seriously I'm lost - in #361 the problem was that there were quotes around field names, now the problem is that there are no quotes?

Member

nijel commented Oct 16, 2017

Seriously I'm lost - in #361 the problem was that there were quotes around field names, now the problem is that there are no quotes?

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 16, 2017

Member

Also how did you create the table? It seems that Oracle is a bit weird in matching, see https://stackoverflow.com/a/563126/225718

Member

nijel commented Oct 16, 2017

Also how did you create the table? It seems that Oracle is a bit weird in matching, see https://stackoverflow.com/a/563126/225718

@nijel nijel added bug smsd labels Oct 16, 2017

@omanbuluatie

This comment has been minimized.

Show comment
Hide comment
@omanbuluatie

omanbuluatie Oct 19, 2017

after looking for the problem with oracle i finally found how to fix invalid identifier, now the service is success starting but there is another issued with sql time format.

omanbuluatie commented Oct 19, 2017

after looking for the problem with oracle i finally found how to fix invalid identifier, now the service is success starting but there is another issued with sql time format.

@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 24, 2017

Member

Once we solve these issues, can you please provide SQL script to create tables for Gammu? I'd include them together with the ones for other databases.

Member

nijel commented Oct 24, 2017

Once we solve these issues, can you please provide SQL script to create tables for Gammu? I'd include them together with the ones for other databases.

nijel added a commit that referenced this issue Oct 24, 2017

Correct timestamp format for Oracle
Issue #362

Signed-off-by: Michal Čihař <michal@cihar.com>
@nijel

This comment has been minimized.

Show comment
Hide comment
@nijel

nijel Oct 24, 2017

Member

The timestamp format should be fixed in 71c9cd3.

Member

nijel commented Oct 24, 2017

The timestamp format should be fixed in 71c9cd3.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment