Help Help

[Jackinert]

Help, my blog is out

please to help me

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 OUTER JOIN serendipity_entryproperties ep_access_groups
                                                  ON (e.id = ep_access_groups.entryid AND ep_access_groups.property = 'ep_access_groups')
 LEFT OUTER JOIN serendipity_entryproperties ep_access_users
                                                  ON (e.id = ep_access_users.entryid AND ep_access_users.property = 'ep_access_users')
 LEFT JOIN serendipity_entryproperties ep_sticky
                                            ON (e.id = ep_sticky.entryid AND ep_sticky.property = 'ep_is_sticky')
                    WHERE isdraft = 'false' AND e.timestamp <= '1127223416' AND  (ep_access.property IS NULL OR ep_access.value = 'member' OR ep_access.value = 'public' OR (ep_access.value = 'private' AND e.authorid = 1))  AND  (ep_access_groups.property IS NULL OR (ep_access.value = 'member' AND (ep_access_groups.value LIKE '%;3;%'))) AND  (ep_access_users.property IS NULL OR (ep_access.value = 'member' AND (ep_access_users.value LIKE '%;1;%' OR e.authorid = 1)))  AND  (ep_no_frontpage.property IS NULL OR ep_no_frontpage.value != 'true')  
                    GROUP BY e.id
                    ORDER BY orderkey DESC, timestamp DESC
                     LIMIT 3

/ Reçu l'erreur 28 du handler de la table

thanks a lot
Jack

[garvinhicking]

If you search for "mysql table error 28" in google you get this result:

http://dev.mysql.com/doc/mysql/en/cannot-create.html

That means, your server is out of disk space.

Regards,
Garvin

[Jackinert]

If you search for "mysql table error 28" in google you get this result:

http://dev.mysql.com/doc/mysql/en/cannot-create.html

That means, your server is out of disk space.

Regards,
Garvin

it's strange Garvin but my disk in not out of space.
doesn't something else can make an error ?

thanks for help

Jack

[Jackinert]

I can acces s9y admin but it says no categories exist ! and in got the same error when trying to edit entries.

is it possible to be a sql table corruption or something else ?

thanks for your help

Jack

[garvinhicking]

Did you read the link I gave you? The MySQL Error #28 can only say that the server is out of disk space. Did you contact your server administrator? It may also be that the MySQL data files are corrupted and thus not read/writable...

Regards,
Garvin

[Jackinert]

Did you read the link I gave you? The MySQL Error #28 can only say that the server is out of disk space. Did you contact your server administrator? It may also be that the MySQL data files are corrupted and thus not read/writable...

Regards,
Garvin

I did Garvin, i read it but now i'm affraid with it.
looks like my tmpdir full and unable to contact provider admin (
got a problem with serendipity config table, unable to repair it.
is it possible to stop and restart sql server using phpmyadmin ?

thanks a lot for help

Jack

[garvinhicking]

Jack, sadly this will not help you at all. You need to delete files on the server to free up disk space. Usually only the admin can do that. Restarting and stopping the server sadly helps you nothing...

So kick your friendly sysadmin, since even phpMyAdmin should be causing trouble anytime soon when your tmp storage is out of space

Regards,
Garvin

[Jackinert]

Here is the error message when i try to repair table:

Table Op Msg_type Msg_text
serendipity_config repair error 28 when fixing table
serendipity_config repair error Can't copy datafile-header to tempfile, error 9
serendipity_config repair status Operation failed

Jack

[garvinhicking]

Yes, of course, as MySQL cannot write anything to the disk because it's FULL. )

Really, honestly and the last word: Only your sysadmin or people with root privileges will be able to fix this.

Regards,
Garvin

[Jackinert]

Yes, of course, as MySQL cannot write anything to the disk because it's FULL. )

Really, honestly and the last word: Only your sysadmin or people with root privileges will be able to fix this.

Regards,
Garvin

Sorry to disturb you one more time Garvin but serendipity_config table is not the largest one, so why this error only appears when i attempt to repair this table and not the largest one ?

Thanks (should be my last question )

Jackinert

[garvinhicking]

Sorry to disturb you one more time Garvin but serendipity_config table is not the largest one, so why this error only appears when i attempt to repair this table and not the largest one ?

The largest tables usually have less fragmentation that the serendipity_config table, which is more oftne frequented when touching/reinstalling plugins. Thus the server may not need any diskspace to repair/defragment the large, unfragmented table, but it can require additional space if the serendipity_config table needs to be altered.

If more diskspace is available and/or your sysadmin looks after the file permissions/corruption, the problem should be dealt with.

Thanks (should be my last question )

No problem! I wish I could help you. )

Regards,
Garvin