| Author |
 Topic Search  Topic Options
|
bobrobert 
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 17 September 2007 at 3:39pm |
|
Because I deleted the permissions table I can't log into the forum Can you help a little more please? TIA
Edited by bobrobert - 17 September 2007 at 4:18pm
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2007 at 5:43pm |
|
You deleted the whole table??!!
You were only meant to delete the contents of the table, not the table itself.
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2007 at 6:31pm |
|
I am afraid so I take it I need a database backup? TIA
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2007 at 6:42pm |
|
The other option is run this SQL to recreate the permissions table:-
CREATE TABLE [DBO].[tblPermissions] (
[Group_ID] [int] NOT NULL DEFAULT (0),
[Author_ID] [int] NOT NULL DEFAULT (0),
[Forum_ID] [int] NOT NULL DEFAULT (0),
[View_Forum] [bit] NOT NULL ,
[Post] [bit] NOT NULL ,
[Reply_posts] [bit] NOT NULL ,
[Edit_posts] [bit] NOT NULL ,
[Delete_posts] [bit] NOT NULL ,
[Priority_posts] [bit] NOT NULL ,
[Poll_create] [bit] NOT NULL ,
[Vote] [bit] NOT NULL ,
[Attachments] [bit] NOT NULL ,
[Image_upload] [bit] NOT NULL ,
[Moderate] [bit] NOT NULL,
[Display_post] [bit] NOT NULL,
[Calendar_event] [bit] NOT NULL
) ON [PRIMARY]
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2007 at 6:56pm |
|
Thanks Would you be so kind as to tell me how I know zilch about data bases TIA
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2007 at 7:13pm |
|
I understand the first two parts but where do I enter "not null" and similar commands TIA
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 September 2007 at 9:13am |
|
If 1&1 give you a database tool you should be able to run this as an SQL command on the database.
However, as you need to ask, I think you maybe better off staying away from the database and request a backup from your web host.
Edited by -boRg- - 18 September 2007 at 9:14am
|
|
|
|
bobrobert
Groupie
Joined: 15 February 2007
Status: Offline
Points: 51
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 September 2007 at 1:22pm |
|
Thanks again for your help 1&1 are unable to supply a backup database Am I doomed? Anything else I can do? TIA
Edited by bobrobert - 18 September 2007 at 4:13pm
|
|
