error after install

Having trouble installing serendipity?
Post Reply
Dov3
Posts: 1
Joined: Mon Aug 29, 2005 1:03 pm
Contact:

error after install

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: error after install

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Guest

Post by Guest »

I got the same Problem...
Got it right after installing... the tables weren't created.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply