View previous topic :: View next topic |
Author |
Message |
dpellerin
Joined: 14 Jan 2004 Posts: 22
|
Posted: Fri Dec 19, 2014 4:56 pm Post subject: PageGate 7 with SQL Server |
|
|
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 |
|
OzCom
Joined: 22 Oct 2003 Posts: 1122 Location: US
|
Posted: Fri Dec 19, 2014 10:27 pm Post subject: |
|
|
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 |
|
dpellerin
Joined: 14 Jan 2004 Posts: 22
|
Posted: Mon Dec 22, 2014 10:01 am Post subject: |
|
|
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 |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Mon Dec 22, 2014 11:35 am Post subject: |
|
|
Can you post the structure of your 'users' table in your SQL database, including all field names, types, etc.? |
|
Back to top |
|
dpellerin
Joined: 14 Jan 2004 Posts: 22
|
Posted: Mon Dec 22, 2014 11:44 am Post subject: |
|
|
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 |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Mon Dec 22, 2014 2:51 pm Post subject: |
|
|
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). |
|
Back to top |
|
dpellerin
Joined: 14 Jan 2004 Posts: 22
|
Posted: Mon Dec 22, 2014 3:16 pm Post subject: |
|
|
[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 |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Mon Dec 22, 2014 3:36 pm Post subject: |
|
|
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. |
|
Back to top |
|
dpellerin
Joined: 14 Jan 2004 Posts: 22
|
Posted: Mon Dec 22, 2014 4:13 pm Post subject: |
|
|
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 |
|
Tech Support
Joined: 25 Aug 2003 Posts: 4370
|
Posted: Mon Dec 22, 2014 6:00 pm Post subject: |
|
|
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. |
|
Back to top |
|
|