Inhalte aufrufen

Profilbild

Deleted admin user in error


  • Bitte melden Sie sich an, um eine Antwort zu verfassen.
6 Antworten zu diesem Thema

#1 derek

derek

    Member

  • Members
  • 11 Beiträge

Geschrieben: 28 October 2014 - 12:35

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

#2 Wolfgang Schmerge

Wolfgang Schmerge

    SmartStore AG

  • Administrators
  • 1996 Beiträge

Geschrieben: 28 October 2014 - 12:43

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


Viele zusätzliche Smartstore.NET Plugins gibt es im MARKETPLACE:
http://community.sma...dex.php?/files/

 

Hier geht es zu den Smartstore.NET Videos:
Smartstore.NET Youtube-Channel
 

Die deutsche Smartstore.NET Online-Dokumentation gibt es hier:
http://docs.smartsto...display/smnetde

In dem folgenden BLOG findet man interessante Tipps & Tricks zum Thema "Smartstore.NET":

http://community.sma...t-tipps-tricks/

 


#3 derek

derek

    Member

  • Members
  • 11 Beiträge

Geschrieben: 28 October 2014 - 21:46

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



#4 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3424 Beiträge

Geschrieben: 28 October 2014 - 22:15

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.

Schöne Grüße aus Düsseldorf,
Marcus Gesing


#5 derek

derek

    Member

  • Members
  • 11 Beiträge

Geschrieben: 29 October 2014 - 12:27

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.

#6 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3424 Beiträge

Geschrieben: 29 October 2014 - 13:43

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".

Schöne Grüße aus Düsseldorf,
Marcus Gesing


#7 derek

derek

    Member

  • Members
  • 11 Beiträge

Geschrieben: 30 October 2014 - 04:09

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