TinyPortal

Adding or editing an article gives the following message:

Can't create/write to file '/tmp/#sql_44d6_0.MYI' (Errcode: 13)
File: /var/www/vhosts/persbureaualmere.nl/httpdocs/Sources/TPortalAdmin.php
Line: 1335

The file shows:

   if($tpsub=='settings' || substr($tpsub,0,11)=='editarticle'){
       // get all themes for selection in themebox
                $context['TPthemes'] = array();
            $request = db_query("
                        SELECT th.value AS name, th.ID_THEME, tb.value AS path
                        FROM {$db_prefix}themes AS th
                        LEFT JOIN {$db_prefix}themes AS tb ON th.ID_THEME = tb.ID_THEME
                        WHERE th.variable = 'name'
                        AND tb.variable = 'images_url'
                        AND th.ID_MEMBER = 0
line 1335 ---->              ORDER BY th.value ASC", __FILE__, __LINE__);

Running SMF 1.1.5 / TP v0.9.8
URL www.persbureaualmere.nl

Problem is solved by copying a similar file from another website running the same versions.
Bummer I can't pinpoint what created the error. :(

Try repairing the table, if that doesn't works, you need to ask your host.

After being able to work all afternoon, suddenly the error returns.
No changes have been made to either software or DB.

Message again:

Can't create/write to file '/tmp/#sql_44d6_0.MYI' (Errcode: 13)
Bestand: /var/www/vhosts/persbureaualmere.nl/httpdocs/Sources/TPortalAdmin.php
Regel: 1335

I definitly need help guys....

Henk, it looks like database corruption to me. I do believev Errcode: 13 is something about file permissions. You should ask your host to look into this problem.

OK IchBin, wil contact them tomorrow, thanx