Page 1 of 1

error after install

Posted: Mon Aug 29, 2005 1:06 pm
by Dov3
This error shows up:

Query failed:
SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email

, e.body, e.extended

FROM
serendipity_entries AS e
LEFT JOIN serendipity_authors a
ON e.authorid = a.authorid
LEFT JOIN serendipity_entrycat ec
ON e.id = ec.entryid
LEFT JOIN serendipity_category c
ON ec.categoryid = c.categoryid

WHERE isdraft = 'false' AND e.timestamp <= '1125305960'
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'dagove_serendipity.serendipity_entries' doesn't exist


And if i try to log on as an admin it says my username and password are incorrect.. although they are correct..
Any ideas?

whats the url to the admin client? just to see that im not trying something wrong...

Dove

Re: error after install

Posted: Mon Aug 29, 2005 1:58 pm
by garvinhicking
The query says that your table "serendipity_entries" does not exist. That is the central database table for storing your entries, it seems it is no more.

Check with phpMyAdmin if the table really is no more! Also check if your serendipity_authors table does not exist, this may cause the login problem you're getting. Maybe you accidently deleted your DB tables, or your server crashed, or someone hacked your webspace?

Regards,
Garvin

Posted: Tue Oct 18, 2005 5:23 pm
by Guest
I got the same Problem...
Got it right after installing... the tables weren't created.

Posted: Tue Oct 18, 2005 9:10 pm
by garvinhicking
If the tables were not created, you may have entered wrong user information .

Which database and version did you configure? Do you have any other PHP+MySQL applications running well?

Regards,
Garvin