Replacing Database give Authentication Error

[shahid_hazoor]

Hello Everyone,

I have replaced my old database with new one.
When I login the system says to change password. When I change the password the system redirects to the login page.
Then I try to login the system neither the system get login nor giving any message it just accept and then redirecting to the login page.

Plz help me out of this problem

_________________
Thanks for your support
Shahid Hazoor

[Naveed]

I have replaced my old database with new one.

Not clear about what you mean by replacing your database??? Did you mean a re-install?

Please explain..

[shahid_hazoor]

I have made a database with Name ECommerce Insert data of some products.
Then i need to reinstall AbleCommerce 7.0 I save the database in a temp folder. and delete the database and reinstall AbleCommerce with the database naming ECommerce. When the insatllation completes i replace the current database with Temp folder database.
and see the problem
When I try to login, System says to change password. When I change the password the system redirects to the login page.
Then I try to login the system neither the system get login nor giving any message it just accept and then redirecting to the login page.

_________________
Thanks
Shahid Hazoor

[mazhar]

You are not doing the things properly. If you are doing a reinstall then why you are replacing the database with the old one. The reinstall process makes certain entries in the database and certainly there will be problems if you remove this database with some other.

The proper way for reinstall may be something like this

1)- Take a proper SQL Server backup of your database so that if something goes wrong during the fresh install you will be able to restore your data.
2)- Export the store data that you want to import after reinstall or export complete store using DataPort utility
3)- Now create a new database and perform a fresh AbleCommerce install.
4)- Import the the exported data using DataPort utility.

[shahid_hazoor]

Thanks Dear for replying,
The problem is still there,
Is the conflict may because of the reason that the first created database was using demo version while now the database created is using Licenced Version.

Error like this appear when Importing the Exported data
Insert statement conflicted with COLUMN FOREIGN KEY constraint 'ac_user_ac_Addresses_FK1'. The Conflict occured in database 'E-Commerce', table 'ac_Users', column 'UserId'.

Please suggest or give me the solution such that my all my efford of entering data should not lost.

Note1: I have tried by making the scripts and then run them the details of product and other data apppear but when i tried for preview or making new Categary then same foreign key constraints error are seen.
Note2: First Created Database and Store Name was with name Able while Secondly created database and Store Name was using name E-Commerce.
Also keep remember that my licenced version settings should not be disturbed.


Regards
Shahid Hazoor

[mazhar]

Please make sure that you are running the latest version of the DataPort utility. The latest version is 1.0.0.19. You can found the version information by Clicking the About->About Data Port Menu

Secondly how many time you got this error entry in your import log?
If this happens a few times then go ahead and do the manual remedy by putting the data yourself, because it may be due to some inconsistency in your data

[shahid_hazoor]

The error comes in more then 34 tables and i am sure the error is not from my side.
Secondly the option you tell about the latest version of DataPort utility.By going About->About Data Port Menu I am using Sql Server 2000 and I have not find such option any where plz explain a bit about DataPort utility because this term is new for me.

Best Regards
Shahid Hazoor

[Naveed]

It seems that you are unaware of DataPort tool.

AbleCommerce DataPort utility tool is designed for such tasks. You can export / import your complete or partial store data using this tool in XML or CSV formats. Using DataPort you can transfer your store data to any other AC7 store without caring for database dependencies.

You can learn more about DataPort at:
http://wiki.ablecommerce.com/index.php/ ... rt_Utility
viewtopic.php?f=42&t=5707

Please use DataPort to download (Export) your store data from 1st store, and then upload(import) that data to the new store.

I hope version for both the demo and licensed stores is 7.0 final.