Serendipity Forums

Posted: **Mon May 29, 2006 10:56 am**

eeek! what do i do? i've just got a blank and disabled blog! all the other tables are there in phpadmin, so i was wondering if i should just recreate the table? if so, what are the fields i need to create?

thanks

Posted: **Mon May 29, 2006 11:00 am**

Hi!

Is the whole table gone and removed? How could that happen, did you contact your provider?

Serendipity doesn't drop this table anywhere in code!

You'll need to recreate the table with a structure like this:

Code: Select all

CREATE TABLE `serendipity_authors` (
  `realname` varchar(255) NOT NULL default '',
  `username` varchar(20) default NULL,
  `password` varchar(32) default NULL,
  `authorid` int(11) NOT NULL,
  `mail_comments` int(1) default '1',
  `mail_trackbacks` int(1) default '1',
  `email` varchar(128) NOT NULL default '',
  `userlevel` int(4) unsigned NOT NULL default '0',
  `right_publish` int(1) default '1',
  PRIMARY KEY  (`authorid`)
) TYPE=MyISAM AUTO_INCREMENT=167 ;

-- 
-- Dumping data for table `serendipity_authors`
-- 

INSERT INTO `serendipity_authors` (`realname`, `username`, `password`, `authorid`, `mail_comments`, `mail_trackbacks`, `email`, `userlevel`, `right_publish`) VALUES 
('John Doe', 'John Doe', '674f33841e2309ffdd24c85dc3b999de', 1, 1, 1, 'john@example.com', 255, 1);

Of course you'll need to recreate each author you previously had. But it should also be important for you to find out how this happened!

Regards,
Garvin

Posted: **Mon May 29, 2006 11:55 am**

i was mucking around with mambo and deleted some tables in phpadmin...i must have clicked on it accidentally. operator error.
thanks for the info, i'll let you know how it goes.

thanks, you really are fantastic support.

stu

Posted: **Mon May 29, 2006 12:13 pm**

You're welcome

Good luck!

Regards,
Garvin

Posted: **Mon May 29, 2006 12:13 pm**

hi garvin,

the blog is up now (whew!), but i can't log in.
i've tried a number of different ideas in the fields : 'username' and 'password' but to no avail...any ideas how to get in as administrator again?

stu

Posted: **Mon May 29, 2006 1:27 pm**

Hi!

You must store the password in serendipity_authors MD5() encoded!

REgards,
Garvin

Posted: **Mon May 29, 2006 11:33 pm**

thanks mate. all better...

your patience astounds me!

stu

Posted: **Tue May 30, 2006 10:20 am**

You're welcome, have fun!

)

Best regards,
Garvin

Serendipity Forums

Table 's9yauthors' doesn't exist

Table 's9yauthors' doesn't exist

Re: Table 's9yauthors' doesn't exist

how it happened:

Re: how it happened:

blog up, but i'm locked out

Re: blog up, but i'm locked out

all better now

Re: all better now