| Author |
|
onhiatus
Senior Member
Joined: May 12 2004
Location: United States
Online Status: Offline
Posts: 279
|
| Posted: April 04 2007 at 22:04 | IP Logged
|
|
|
Thanks. Already a couple problems.
1- When I try to create the first table by running the SQL script for "analogio" I get the following error:
Invalid Direct SQL Code -275
SQLSTATE = S1000
[Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Triggers and procedures not supported in runtime server
2 - I don't remember what I used for a registration key. Can you please send me a key for the username "onhiatus"
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: April 05 2007 at 08:02 | IP Logged
|
|
|
Tony,
Im sorry, I knew there was an extra step I forgot to mention  .
After opening the each SQL file in the multi-editor, at the top of the listing, is the create table statement. You need to highlight and delete this statement (everything from the beginning to just before the first "INSERT" statement). Once the create table statement is deleted, then execute the SQL. This should get rid of the SQL error.
Let me know,
Dave.
|
| Back to Top |
|
| |
bmwragtop
Newbie
Joined: March 30 2008
Location: United States
Online Status: Offline
Posts: 27
|
| Posted: October 13 2013 at 07:04 | IP Logged
|
|
|
Hi Dave,
I just ran into this exact same issue. I am running Powerhome v2.1.4, db version 2.1.2.
I can execute the delet from weblog command just fine.
When I run the delete from eventlog command, I get the following error:
SQLSTATE = S1000
[Sybase][ODBC Driver][Adaptive Server Anywhere]General error: Internal database error *** ERROR *** Assertion failed: 201010 (7.0.3.2054)
Expecting page read to be a leaf index page (table 185, page 7480) -- transaction rolled back
Are there any changes to the database export procedures highligheted earlier in this thread for my version?
Thanks!
Tom
|
| Back to Top |
|
| |
dhoward
Admin Group
Joined: June 29 2001
Location: United States
Online Status: Offline
Posts: 4447
|
| Posted: October 13 2013 at 11:32 | IP Logged
|
|
|
Tom,
Based upon your error, it would appear that your database
may have some corruption or the eventlog has grown to an
unmanageable size.
The first thing I would do is rebuild/compress your
database using the new version of phupg.exe available on
the 7th post on this page: http://www.power-
home.com/forum/forum_posts.asp?TID=2714
I would use it this utility to clear the eventlog so that
your database will fully compact. Once you've done this,
you should have no problems exporting.
Dave.
|
| Back to Top |
|
| |
bmwragtop
Newbie
Joined: March 30 2008
Location: United States
Online Status: Offline
Posts: 27
|
| Posted: October 17 2013 at 18:29 | IP Logged
|
|
|
Thanks Dave! worked like a charm!
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Trouble migrating PH to new computer
