Page 1 of 1

Table 'serendipity.serendipity_entrycat' doesn't exist

Posted: Tue Sep 26, 2006 12:17 am
by neko
I have installed version serendipity-1.0.1.tar.gz (new installation).
I configured it in my apache, got index.php (fixed some permissions...),
clicked Default installation.

I got lots of Messages, but no ERROR:

Code: Select all

User 'XXX' has exceeded the 'max_updates' resource (current value: 20)
called /<path>/ again and got this error.

I looked into my database (mysql) there is no table entrycat - I have 7 tables in database serendipity in my mysql.
0 Entries have been made.

Any help???

complete errormsg:

Code: Select all

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 <= 1159219668 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 'serendipity.serendipity_entrycat' doesn't exist

Posted: Tue Sep 26, 2006 3:48 am
by judebert
That table (and a bunch of others) should all be made during installation. The warning you got sounds like you're not allowed to make any more modifications to your database, at least temporarily.

If you remove the serendipity_config_local.inc.php, then visiting your index.php should try to reinstall Serendipity. Alternatively, you could try to execute the sql/db.sql file with phpMyAdmin (or similar database tool) to create the database tables.

Definitely a problem with the database during installation. It wouldn't allow you to make that table, or 7 others (should be a total of 14 on a clean installation).

Posted: Tue Sep 26, 2006 11:53 pm
by neko
Thank you for your help.
I set the limit to 200 (and later 2000) and got a complete installation.

I think it would be helpful if the installer script recognizes these limits and marks them as error during installation (the blog is not usable without a proper databse).

neko, now with testblog.... :-)

Posted: Wed Sep 27, 2006 3:30 am
by judebert
I'll pass the suggestion on to Garvn.

Hey, Garvin! Here's a good suggestion!

Posted: Sun Oct 01, 2006 10:27 pm
by garvinhicking
Hi!

Checking the mysql option of that value would take up some detection logic, and then...I think anyone who changes this setting to a value as low as 20 must surely know what he is restricting. I've never heard that happen in a web application, so I'm afraid that adding such a check would help one user in 10.000 and only obfuscates/bloats up the code...

Just $0.02 :)

Best regards,
GArvin