no access to serendipity blog

[pierreva]

I'm using serendipity since 2 years. Suddently I can't access to :
http://www.vaudrey.org/weblog/
Is there a process to diagnose the problem ?

Pierre

[garvinhicking]

Hi!

This could be a problem of your webserver. Can you contact your hosting and ask them if they changed anything recently?

Maybe the upgraded PHP, and the new version throws an error message, but your hoster disables error messages and thus you can see nothing.

Best regards,
Garvin

[pierreva]

My provider is in the process of introducing a new version of MySQL. The database name and the user name are changed. In which file can I change these names ?

[garvinhicking]

Hi!

You can change those in the "serendipity_config_local.inc.php" file.

best regards,
GArvin

[pierreva]

The provider also changed php to 4.4.6-1
My serendipity version is 0.8-beta5
I don't think there is a problem with Mysql

Thanks for your help.

Pierre

[garvinhicking]

Hi!

Your serendpity version is very much outdated, you should consider upgrading.

Check your error log to see what can cause the error, the provider should have access to it.

Best regards,
Garvin

[pierreva]

With the current version I don't have access to the start page and I don't know the error. Do you think I will go to the start page during the upgrading process with version 1.1.2 ?
Another solution is to install a fresh Serendipity in another directory and populate the database with the dump of the database made with PhpMyadmin
What do you recommand ?

Pierre

[garvinhicking]

Hi!

The current start page could be blocked because of a 0.8 problem with recent PHP versions. So uploading the 1.1.2 files *might* help in this.

But there's no way to definitely tell this without your provider having a look into the PHP error logs!

Your other idea of parallel installing another s9y version is also a good idea, I'd definitely pursue that. Make a SQL dump backup before proceeding!!!

HTH,
Garvin

[pierreva]

Inbetween I installed the database on another server and populate it with the export of phpmyadmin. The installation runs well, but the following error when I go to my blog :

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.username AS loginname,
                    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 <= 1175837100 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 'blog.serendipity_authorgroups' doesn't exist

I don't have such a table in my current database.
Is there some conversion to do ?
Could you please help me to understand what is wrong ?

Pierre

[garvinhicking]

Hi!

In your original database, there must have been this "serendipity_authorgroups" table, so you must restore it from your backup. This table is important, as it holds author configuration.

Or did you also upgrade your s9y installation while moving? In that case you didn't properly run the upgrade process as outlined in the FAQ on www.s9y.org - you always first need to get s9y running on the new server and THEN perform the update, because only then serendipity can create newly introduced tables. You can force the recreation of that by using the methods outlined in the FAQ in the "My upgrade failed" section.

HTH,
Garvin

[pierreva]

In my current database I don't have a "serendipity_authorgroups" table.
I don't have a backup with this table. Can you help me to recreate this table with PhpMyAdmin ?

Thanks for your help.

Pierre

PS : Perhaps this is why I have the following error in admin panel with the link "Editer les billets" :

Query failed:

SELECT


e.id,
e.title,
e.timestamp,
e.comments,
e.exflag,
e.author,
e.authorid,
e.trackbacks,
e.isdraft,
e.allow_comments,
e.last_modified,

a.realname AS author,
a.email



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


GROUP BY e.id
ORDER BY timestamp DESC
LIMIT 0, 12

/ Can't find record in ''

[garvinhicking]

Hi!

If you are missing this table, you might be very likely missing many more tables!!

Check out the 'sql/db.sql' file of serendipity and see if every mentionied database table exists in your installation. You can also use this file as a guide on how to create the missing tables.

The CONTENT of these tables is harder to recreated. You need to manually add a reference of every author to the usergroup he belongs to into that table.

The other error of your admin more sounds like a crashed MySQL! Search google for "can't find record mysql" to see how this can happen...

Best regards,
Garvin