PDA

View Full Version : Cannot install.....DBISAM Engine Error



mickie
01-15-2008, 10:28 AM
DBISAM Engine Error # 11949 SQL parsing error - Duplicate DHLAtHomeFlag column not allowed in ALTER TABLE SQL statement at line 1, column 25
SQL: ALTER TABLE Account ADD DHLAtHomeFlag INTEGER DEFAULT 0 ;


Trying to "upgrade" usinf RC2-5-7-ShipRush_v5_Endicia.exe and RC2-5-7-ShipRush_v5_FedEx.exe

I have tried the FEDEX upgrade, the ENDICIA upgrade. All give the same error.

Now our business is shut down because we cannot ship. As usual, ShipRush NEVER works on the first try....at least not for us.

I can't ship anything from RMS.

I have been trying this for over an hour.......

It was working. I guess I should have known better. Sigh.

SYSOPS
01-15-2008, 10:31 AM
First step:
Stop all SR
Restore the database from a backup (typically out under documents and settings\username\application data\z-firm llc\shiprush v5\database.v5)

Now launch ShipRush again. See if it is able to upgrade the database without error.

One quick kill option would be to rename the database.v5 folder and let ShipRush create a new one. You would have to re-register your accounts with FedEx and Endicia and all old history would be lost.

SYSOPS

mickie
01-15-2008, 10:33 AM
That is what happened last time...all history is lost.

Will we ever be able to do a Shiprush upgrade where we can actually KEEP our historical data?

mickie
01-15-2008, 10:37 AM
OK I have 4 files in the backup directory.

How do I restore it?

SYSOPS
01-15-2008, 10:38 AM
Just 4? That certainly doesn't sound right.

Let's try and clarify this over the phone. We will contact you directly.

SYSOPS