Serendipity Forums

Hello Bros
I installed serendipity and received green all successful and click here for the first time....but below is what I get , can you help me ???
Thank you

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
LEFT JOIN serendipity_authorgroups AS acl_a
ON acl_a.authorid = 0
LEFT JOIN serendipity_access AS acl_acc
ON ( acl_acc.artifact_mode = 'read'
AND acl_acc.artifact_type = 'category'
AND acl_acc.artifact_id = c.categoryid
)
WHERE isdraft = 'false' AND e.timestamp <= 1162418828 AND (
c.categoryid IS NULL
OR ( acl_acc.groupid = 0)
OR ( acl_acc.artifact_id IS NULL

)
)
GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 15
/ Table 'chucknet_serendipity.serendipity_entries' doesn't exist

Hi!

This query says that the 'serendipity_entries' table does not exist! Can you check with phpMyAdmin to see if any tables were created? You did not get any error messages when s9y was created? And you got the error message immediately after that, without doing anything else?

Regards,
Garvin

Hi Garvin
yes I checked with the php myadmin and it shows 0 tables, but I did not have any errors all green.
Plus it said in green Click here to use your serendipidy for the first time.
what should I do?

thanks
Mike

Hi!

That's pretty strange; serendipity should not tell you it installed successfully if all tables were not created.

Maybe you can try to install s9y again? Just delete the 'serendipity_config_local.inc.php' file and you can re-start the install process. Make sure you enter a valid prefix like "serendipity_" in the DB setup, and you enter the same username+data you use for phpMyAdmin?

Best regards,
Garvin

garvinhicking wrote:Hi!

That's pretty strange; serendipity should not tell you it installed successfully if all tables were not created.

Maybe you can try to install s9y again? Just delete the 'serendipity_config_local.inc.php' file and you can re-start the install process. Make sure you enter a valid prefix like "serendipity_" in the DB setup, and you enter the same username+data you use for phpMyAdmin?

Best regards,
Garvin

hello Garvin
I reinstalled and now have a fully funcional weblog (the problem was in the config file) but one thing is driving me nuts is where do new users register and log in, or it does not have that future??,

thank you for helping me out

Hi!

For users to register themselves, you need the "User Self-Registration" plugin. This is available via Spartacus ("Plugins / Templates" link on this site in the header)

HTH,
Garvin

Thank you for all your help and patience...