HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media


Welcome to TinyPortal. Please login or sign up.

April 19, 2024, 08:01:12 PM

Login with username, password and session length
  • Total Members: 3,885
  • Latest: Growner
  • Total Posts: 195,164
  • Total Topics: 21,219
  • Online today: 266
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 1
  • Guests: 147
  • Total: 148
  • @rjen

Help needed: Database error? *SOLVED*

Started by Henk, June 14, 2008, 01:14:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


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/
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

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/
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