Table 's9yauthors' doesn't exist

[hyperorbiter]

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

[garvinhicking]

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

[hyperorbiter]

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

[garvinhicking]

You're welcome Good luck!

Regards,
Garvin

[hyperorbiter]

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

[garvinhicking]

Hi!

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

REgards,
Garvin

[hyperorbiter]

thanks mate. all better...

your patience astounds me!

stu

[garvinhicking]

You're welcome, have fun! )

Best regards,
Garvin