6 Antworten zu diesem Thema

[derek]

Hi all, I've done a huge error. I was updating my website using my iPad, and I deleted my account, which is the admin account. is there anyway of fixing it? Or do I hve to rebuild the store again. If I do will I lose my products ets from a reinstall?


Thank you

[Wolfgang Schmerge]

Hi,

 

no problem.

If you are able to view the database table
dbo.customer
you can directly edit the row of your users - eg find the 'deleted' admin@yourstore (its still in the database)
and look for the column 'Deleted'
change this to 'false'

 

Regards

 

Wolfgang

[derek]

Hi Wolfgang

 

Thank you for your reply, but I cant fine the DBO.customer file anywhere on my computer, I used the standard install from the website, and im running the software on a Windows Home Server 2011.  I have team viewer setup on that server, if you can help, or are you able to get me more detailed instructions on where to look.

 

Once again, thank you for you help.

Regards

Derek

[Marcus Gesing]

You need a database administration tool named "Microsoft SQL Server Management Studio" to edit the database directly

if you cannot access the backend. Once you have this tool installed, open the database and then the table "Customer".

Search for your account record and change the value in column "Deleted" from "True" to "False". Then you are able to login again.

[derek]

Hi Marcus

Thank you for your response. I've downloaded ms Sao server management studio. But I'm having problems finding the data base that has customers? Are you able to tell me where I would gin the?

Once again the you for your help.

[Marcus Gesing]

You have to connect Management Studio with your SQL-Server and expand "Databases". Then expand <your database name> and then "Tables".

(You can find the name of your database in the connection string in App_Data/Settings.txt after "Initial Catalog=".)

Finally right click dbo.Customer and then "Edit all rows" or "Edit Top x Rows".

[derek]

Amazing, thank you all for your help, I now have access again   I owe you both a beer, if you ever get to Australia.

 

Regards

 

 

Derek