|
|
Rank: Advanced Member
Joined: 7/16/2008
Posts: 30
Location: California
|
Hi Roger, I am still stuck on sync errors and want to start over with a clean database.
How do I do this?
thanks, John
|
|
Rank: Administration
Joined: 8/3/2007
Posts: 734
Location: Fort Atkinson, WI
|
User Management Studio to find the GalleryServerPro database. Delete it, then create a new one.
Roger Martin
Lead Developer for Gallery Server Pro
|
|
Rank: Advanced Member
Joined: 7/16/2008
Posts: 30
Location: California
|
Is that pretty intuitive for me to do or for the expert.
P.S. I submitted an app to istockphoto. wish me luck.
Thanks,
|
|
Rank: Administration
Joined: 8/3/2007
Posts: 734
Location: Fort Atkinson, WI
|
It is easy. You should have no trouble finding information on the internet for deleting and then creating an empty database using SQL Management Studio. My guess is that you can figure it out intuitively just by poking around a bit.
Roger Martin
Lead Developer for Gallery Server Pro
|
|
Rank: Advanced Member
Joined: 7/16/2008
Posts: 30
Location: California
|
With SQL lite, is there an easy way to do this?
thanks,John
|
|
Rank: Administration
Joined: 8/3/2007
Posts: 734
Location: Fort Atkinson, WI
|
With SQLite, you can just replace the file galleryserverpro_data.sqlite with the one from the download ZIP file (it is in the App_Data directory).
This effectively deletes all your data, including your user accounts. If you do this, you'll want to run the installer again so that a new Admin account is created.
Roger Martin
Lead Developer for Gallery Server Pro
|
|
Rank: Member
Joined: 8/14/2008
Posts: 11
Location: Spokane,WA
|
I'm pretty new to sql myself and had no problem creating and deleting databases in sql manager when I first started installing Gallery Server Pro, My only real problems were setting roles and permissions. For a while I couldn't even get the installer to run because of my database and Ajax not being installed.
Just open Microsoft SQL management studio express and connect under windows authentication, expand databases, right click on "databases" and "create new database".
then set users and roles. its pretty simple even for a newbie.
|
|
Rank: Advanced Member
Joined: 7/16/2008
Posts: 30
Location: California
|
Hi, I cant seem to find the galleryserverpro_data.sqlite file you mentioned. Its not in the download either. maybe in the beta download?
thanks, John
|
|
Rank: Administration
Joined: 8/3/2007
Posts: 734
Location: Fort Atkinson, WI
|
Yes, it is in 2.1, which is only available as a beta at the moment.
Roger Martin Lead Developer for Gallery Server Pro
|
|
|
Guest |