query failed serendipity.serendipity_authorgroups doesn't

[periferral]

I did an upgrade and now I get this. Any clues

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 <= '1132045989' 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_authorgroups' doesn't exist

[garvinhicking]

It seems you made the upgrade wrong.

Read http://www.s9y.org/11.html#A12 and http://www.s9y.org/11.html#A13 please.

Regards,
Garvin

[periferral]

thanks. I did the fixperm thing and reran the script and it worked fine.
thanks

[Alphonse]

I just did my first clean installation of Serependity 0.9.1 for a test drive -- no upgrade, and I received essentially the same message as the author of this thread, after I tried to access my homepage:

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
                    s9y-1_entries AS e
                    LEFT JOIN s9y-1_authors a
                        ON e.authorid = a.authorid
                    LEFT JOIN s9y-1_entrycat ec
                        ON e.id = ec.entryid
                    LEFT JOIN s9y-1_category c
                        ON ec.categoryid = c.categoryid
                     LEFT JOIN s9y-1_authorgroups AS acl_a
                                   ON acl_a.authorid = 0
                            LEFT JOIN s9y-1_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 <= '1132986200' 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

/You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-1_entries AS e LEFT JOIN s9y-1_authors a

His error was that a certain table didn't exist. Mine is supposedly a syntax error. I have checked my hosts server info, and the MySQL version installed is 4.0.25-standard-log. I have followed the steps supplied through the links above by garvinhicking, but all I get after is a 404 error message.

Any further help would be greatly appreciated, as at this point -- with my lacking knowledge of SQL -- I have no clear idea what to do.

Thanks in advance.

[garvinhicking]

Hi Alphonse!

You chose to use "s9y-1" as your DB prefix. That is an invalid name in SQL terms. Reinstall and name the prefix "s9y_1".

Serendipity does not encode invalid special characters, because that is not portable through oterh DB systems we support like postgresql. I'm sorry for not stating clearly that only [a-z0-9_] should be used for dbPrefixes.

Regards,
Garvin

[Alphonse]

Ah ... such a trivial thing! Thank you for saving me from my ignorance.

Now, if Imay require your assistance again: I am having a problem with themes. After the installation a "blank" theme showed up, and it seems to be impossible to change. I've tried changing the access permissions of the templates folder but not one of the settings works -- I've set it back to the 0775 default.

I don't know if the problem is with the cache -- and If it is, I really don't know to set it up.

[garvinhicking]

Glad to could help you with that.

Can you tell me what exactly you mean with 'blank' template? can you make a screenshot? And are you using serendipity 0.9.1 with the spartacus plugin?

Regards,
Garvin

[Alphonse]

I couldn't find to way upload attachments here so, here's a link to a screenshot: scr1

Or better yet, you may feel free to visit the homepage.

I can access the style management section through the backend, but no matter which style I attempt to install, no effect at all appears at the frontend.

And yes, I am using the latest 0.9.1 release -- not so sure about the spartacus plugin. I do know that I'm using the default installation though -- nothing downloaded and nothing hacked yet.

[garvinhicking]

Did you read http://www.s9y.org/11.html#A21 ? Check your setting for the 'Embed' mode in s9y configuration.

Regards,
Garvin

[Hathor]

I upgraded from a nightly version of 9 to the stable 9.1 and was getting the same error message as the original poster. I tried several things recommended in the FAQ - no luck. Then I decided to try random changes to my blog configuration, and immediately stumbled on the solution:

I just had to turn Autodetect used HTTP-Host to "no". Now it's fine.

Just posting this in case anyone else ever has the problem.

[Trench]

I've tried all the above fixes and still no luck. I upgraded from 0.85 to 0.91 and I still get this...

Code: Select all

Query failed: 
SELECT 
                    ep_sticky.value AS orderkey,

                    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 OUTER JOIN serendipity_entryproperties ep_no_frontpage
                                                  ON (e.id = ep_no_frontpage.entryid AND ep_no_frontpage.property = 'ep_no_frontpage')
 LEFT OUTER JOIN serendipity_entryproperties ep_access
                                              ON (e.id = ep_access.entryid AND ep_access.property = 'ep_access')
 LEFT JOIN serendipity_entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky') 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 <= '1134073644' AND  (ep_access.property IS NULL OR ep_access.value = 'public') AND  (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')   AND     (
                                 c.categoryid IS NULL 
                                 OR ( acl_acc.groupid = 0)
                                 OR ( acl_acc.artifact_id IS NULL 
                                      
                                    )
                               )
                    GROUP BY e.id
                    ORDER BY orderkey DESC, timestamp DESC
                     LIMIT 15
/ Table 'trench_blog.serendipity_authorgroups' doesn't exist

[garvinhicking]

Trench: It seems you did not properly upgrade. Please read http://www.s9y.org/11.html#A17 + the follow-up item.

Regards,
Garvin