| View previous topic :: View next topic |
| Author |
Message |
nemback
Joined: 14 Oct 2023
Posts: 3
|
 Posted: Sat Oct 14, 2023 2:15 pm Post subject: 3075 Syntax Error After Upgrading from V8 to V10 |
 |
|
After upgrading from v8 to v10, my pages do not automatically send. The following error comes up in the GetAscii log.
Program Halted. Database Error: 3075 Syntax error in string in query expression ''From:(User ID)-(PC name)'. in Procedure: check_for_messages
If I open the asc file, delete and retype a character, then save the file, it will send the page.
Any suggestions?
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4370
|
| Posted: Mon Oct 16, 2023 7:34 am Post subject: |
|
|
There are a few things we'll need to check.
1) Go into the properties of c:\Program Files (x86)\NotePage\PageGate\pggascii.exe, go under the 'Details' tab and let us know what 'File Version' it say you're using.
2) In PG Admin, do you have any settings configured under Interfaces - Settings - Advanced Polling?
If so, what are your parsing parameters for each section (symbols, record, recipient, sender, message)? |
|
| Back to top |
|
nemback
Joined: 14 Oct 2023
Posts: 3
|
| Posted: Mon Oct 16, 2023 10:21 am Post subject: |
|
|
1. Version 10.0.0.10
2. Symbols: Single Character wild card = ?
Multiple Char wild card = *
End of Record Symbol = ~
Ascii Value Delimiter = \
Record: Start Pattern = ??/??/??
Start Offset = 0
End Pattern = \013
End Offset = 0
Recipient = Dynamic
Start Pattern = *
Start Offset = 0
End Pattern = ~
End Offset = 0
Use lookup table is unchecked.
Sender and Message are the same as recipient.
I appreciate the quick reply.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4370
|
| Posted: Mon Oct 16, 2023 10:23 am Post subject: |
|
|
1) Let's update to 10.2.1:
https://www.notepage.net/download/pgsetup.exe
1a) Shut down the PageGate service and close all PageGate related applications on all profiles of the PG server.
1b) Use 'Run as Administrator' to launch the installer and select 'Install PageGate Server'
1c) Click 'Next' until it finishes the installation, then click 'Finish'
2) Do you have any entries in GetAscii - Settings - Advanced Polling - Files? |
|
| Back to top |
|
nemback
Joined: 14 Oct 2023
Posts: 3
|
| Posted: Tue Oct 17, 2023 9:02 am Post subject: |
|
|
| The new version worked. Thanks for making that quick and painless.
|
|
| Back to top |
|
timothyferriss
Joined: 04 Nov 2024
Posts: 2
Location: USA
|
| Posted: Mon Nov 04, 2024 8:37 pm Post subject: |
|
|
| The error you're seeing, 3075 Syntax error in string in query expression, typically points to an issue with how a query is structured, specifically with the string being used for the query. |
|
| Back to top |
|
|
