| View previous topic :: View next topic |
| Author |
Message |
mnardi
Joined: 10 Jun 2004
Posts: 8
|
 Posted: Thu Aug 23, 2012 1:32 pm Post subject: Error #3010 Table 'security' already exists. |
 |
|
Error Message appears when trying to start pagegate admin.
"PGAdmin Fatal Error - convert500to501"
Error # 3010 Table 'security' alredy exists.
Please let me know what I need to do to resolve this issue.
Thanks,
Marc
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Thu Aug 23, 2012 1:39 pm Post subject: |
|
|
Marc,
Is this a new setup or an existing setup that has just started to give the error? |
|
| Back to top |
|
mnardi
Joined: 10 Jun 2004
Posts: 8
|
| Posted: Thu Aug 23, 2012 1:43 pm Post subject: |
|
|
Hello,
This is and existing setup. It's been up for over 2 years.
Marc
|
|
| Back to top |
|
mnardi
Joined: 10 Jun 2004
Posts: 8
|
| Posted: Thu Aug 23, 2012 1:47 pm Post subject: |
|
|
| Just started having problems this morning 11am.
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Thu Aug 23, 2012 1:50 pm Post subject: |
|
|
Marc,
That's... really bizarre because the error is referencing a routine that converts an old database style to the new standard. If this is a setup that's been working properly for two years, unless something radical changed like transferring servers and installing a new build of the program, that error means that the Admin is detecting that certain sections of your database aren't there and it's assuming it needs to upgrade the database to the new standard.
If you would, please email a copy of the pagegate.mdb file (typically located in c:\PageGateData\Database\) to support at notepage dot com so I can have a look at the database to see what's going on. |
|
| Back to top |
|
mnardi
Joined: 10 Jun 2004
Posts: 8
|
| Posted: Thu Aug 23, 2012 1:56 pm Post subject: |
|
|
Just emailed it to support at notepage dot com
thank you
Marc
|
|
| Back to top |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Thu Aug 23, 2012 2:04 pm Post subject: |
|
|
The file you sent was the automatic backup of the PageGate Database that the program makes each day at midnight. That backup file is intact, so here's what you're going to want to do:
1) On the PageGate server, shut down ALL PageGate programs and services. We want absolutely no part of PageGate running.
2) Go in to the c:\PageGateData\Database\ directory on your hard drive.
3) Rename the pagegate.mdb file to pagegate.old
4) Rename the pgedbbak.mdb to pagegate.mdb
5) Try to run the Admin.
If the Admin comes up without an error, restart the PageGate Server and you should be back in business. |
|
| Back to top |
|
mnardi
Joined: 10 Jun 2004
Posts: 8
|
| Posted: Thu Aug 23, 2012 2:08 pm Post subject: |
|
|
This Worked!!!
Thank you very much!!!!
This is such a great app.
:)
|
|
| Back to top |
|
NotePage Sales
Site Admin
Joined: 23 Apr 2004
Posts: 265
|
| Posted: Thu Aug 23, 2012 6:21 pm Post subject: |
|
|
| I am glad everything is working again, and glad you like PageGate. If there is ever anything else, please let us know.
_________________
NotePage Sales
|
|
| Back to top |
|
mnardi
Joined: 10 Jun 2004
Posts: 8
|
| Posted: Wed Aug 29, 2012 3:38 pm Post subject: |
|
|
| Will do thank you.
|
|
| Back to top |
|
|
