NotePage, Inc. Forum Index

PageGate 7 with SQL Server

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> Integration Related Questions
View previous topic :: View next topic  
Author Message
dpellerin



Joined: 14 Jan 2004
Posts: 22

PostPosted: Fri Dec 19, 2014 4:56 pm    Post subject: PageGate 7 with SQL Server Reply with quote

We currently use version 4 of PageGate and I connect the messages and users table to a SQL Server so I can provide a web based front end for managing users.

I'm trying to do the same thing with version 7 but when I run the admin program it crashes when trying to access the settings panel for any user. It's very odd, I can view all the other sections. I can even create users. But when I click settings I get the following error:

Error #383 Invalid operation in Procedure: edit_user load

Has anyone else integrated PageGate with SQL server successfully? Thanks.


Back to top
View user's profile
OzCom



Joined: 22 Oct 2003
Posts: 1087
Location: US

PostPosted: Fri Dec 19, 2014 10:27 pm    Post subject: Reply with quote

There were SIGNIFICANT database structure changes between v4 and v7 - if you are trying to use the same queries it will not work.



_________________
Aaron D. Osgood
Streamline Communications, LLC
* Authorized Notepage, Inc. Development Partner and Re-seller
TEL: 207-518-8455
AOsgood@streamline-solutions.net
Creators of AutoPage Spillman CAD interface for PageGate
Back to top
View user's profile Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger
dpellerin



Joined: 14 Jan 2004
Posts: 22

PostPosted: Mon Dec 22, 2014 10:01 am    Post subject: Reply with quote

Yeah, I realize that, but this error is thrown by PageGate Admin itself when connecting to the SQL database I created from scratch, using the current schema.


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4041

PostPosted: Mon Dec 22, 2014 11:35 am    Post subject: Reply with quote

Can you post the structure of your 'users' table in your SQL database, including all field names, types, etc.?



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



Joined: 14 Jan 2004
Posts: 22

PostPosted: Mon Dec 22, 2014 11:44 am    Post subject: Reply with quote

Certainly, sorry for the formatting.

Name Type AllowNull

[user] varchar(50) Unchecked
full_name varchar(50) Unchecked
id varchar(50) Unchecked
EmailTo varchar(80) Unchecked
carrier varchar(50) Unchecked
maxchars smallint Unchecked
on_call bit Unchecked
reliapage_index smallint Unchecked
forward varchar(80) Unchecked
ascii_service bit Unchecked
gui_service bit Unchecked
mail_service bit Unchecked
serial_service bit Unchecked
tap_service bit Unchecked
web_service bit Unchecked
ad_hoc bit Unchecked
multi_page bit Unchecked
email_only bit Unchecked
[group] bit Unchecked
template varchar(80) Unchecked
text1 varchar(80) Unchecked
text2 varchar(80) Unchecked
text3 varchar(80) Unchecked
text4 varchar(80) Unchecked
text5 varchar(80) Unchecked
text6 varchar(80) Unchecked
text7 varchar(80) Unchecked
text8 varchar(80) Unchecked
text9 varchar(80) Unchecked
text10 varchar(80) Unchecked
image1 varchar(80) Unchecked
image2 varchar(80) Unchecked
image3 varchar(80) Unchecked
image4 varchar(80) Unchecked
image5 varchar(80) Unchecked
custom bit Unchecked
group_list bit Unchecked
GLFullNames bit Unchecked
Failover varchar(50) Unchecked
extra1 varchar(80) Unchecked
extra2 varchar(80) Unchecked
extra3 varchar(80) Unchecked
extra4 varchar(80) Unchecked
hold bit Unchecked
hold_start date Unchecked
hold_stop date Unchecked
display_group bit Unchecked
creator varchar(50) Unchecked
priority int Unchecked


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4041

PostPosted: Mon Dec 22, 2014 2:51 pm    Post subject: Reply with quote

Those look ok.

One thing that can cause the error is if the carrier name in the users record doesn't match a carrier name in the carriers table (capitalization counts).



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



Joined: 14 Jan 2004
Posts: 22

PostPosted: Mon Dec 22, 2014 3:16 pm    Post subject: Reply with quote

[quote="Tech Support"]Those look ok.

One thing that can cause the error is if the carrier name in the users record doesn't match a carrier name in the carriers table (capitalization counts).[/quote]

Well, right now I only have one user in that table, and it was created with the Admin program. I know the carrier is good because I selected it from the list in the UI.

Any other suggestions?


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4041

PostPosted: Mon Dec 22, 2014 3:36 pm    Post subject: Reply with quote

See if you can run the export option on the recipients.

In PG Admin go to Database->Tools->Export->Recipients & Groups

If it runs, please post the export file contents.



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



Joined: 14 Jan 2004
Posts: 22

PostPosted: Mon Dec 22, 2014 4:13 pm    Post subject: Reply with quote

The export completed. Here is the contents... again, sorry for the formatting. You may not be able to see it here, but each field is padded out with spaces. Not sure if that has anything to do with my issue.

"701","dana_pellerin ","Dana Pellerin "," ","ATT-SMTP "," ","160",#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,#FALSE#,"0",#FALSE#,#FALSE#," ",#FALSE#," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",#FALSE#,#FALSE#,"5595551212@txt.att.net ",#FALSE#,#FALSE#," "," "," "," "," ",#FALSE#,"12:00:00 AM","12:00:00 AM"," ","100"


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4041

PostPosted: Mon Dec 22, 2014 6:00 pm    Post subject: Reply with quote

I verified that the extra spaces in all the text fields are indeed causing the problem. In particular the failover field having a space instead of an empty string, is causing the actual error that you are experiencing.

The extra spaces may also cause other odd problems throughout the rest of the program, but I can't really say what.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> Integration Related Questions 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