NotePage, Inc. Forum Index

3075 Syntax Error After Upgrading from V8 to V10

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support
View previous topic :: View next topic  
Author Message
nemback



Joined: 14 Oct 2023
Posts: 3

PostPosted: Sat Oct 14, 2023 2:15 pm    Post subject: 3075 Syntax Error After Upgrading from V8 to V10 Reply with quote

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
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4370

PostPosted: Mon Oct 16, 2023 7:34 am    Post subject: Reply with quote

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)?



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
nemback



Joined: 14 Oct 2023
Posts: 3

PostPosted: Mon Oct 16, 2023 10:21 am    Post subject: Reply with quote

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
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4370

PostPosted: Mon Oct 16, 2023 10:23 am    Post subject: Reply with quote

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?



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
nemback



Joined: 14 Oct 2023
Posts: 3

PostPosted: Tue Oct 17, 2023 9:02 am    Post subject: Reply with quote

The new version worked. Thanks for making that quick and painless.


Back to top
View user's profile
timothyferriss



Joined: 04 Nov 2024
Posts: 2
Location: USA

PostPosted: Mon Nov 04, 2024 8:37 pm    Post subject: Reply with quote

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
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin