Table 'serendipity.serendipity_entrycat' doesn't exist

Having trouble installing serendipity?
Post Reply
neko
Posts: 2
Joined: Mon Sep 25, 2006 11:35 pm
Contact:

Table 'serendipity.serendipity_entrycat' doesn't exist

Post 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
judebert
Regular
Posts: 2478
Joined: Sat Oct 15, 2005 6:57 am
Location: Orlando, FL
Contact:

Post 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).
Judebert
---
Website | Wishlist | PayPal
neko
Posts: 2
Joined: Mon Sep 25, 2006 11:35 pm
Contact:

Post 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.... :-)
judebert
Regular
Posts: 2478
Joined: Sat Oct 15, 2005 6:57 am
Location: Orlando, FL
Contact:

Post by judebert »

I'll pass the suggestion on to Garvn.

Hey, Garvin! Here's a good suggestion!
Judebert
---
Website | Wishlist | PayPal
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post 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
# 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