TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

March 29, 2024, 05:16:17 AM

Login with username, password and session length
Members
Stats
  • Total Posts: 195,105
  • Total Topics: 21,213
  • Online today: 310
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 266
  • Total: 266

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.

Henk

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. :(

Dragooon

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

Henk

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

IchBin

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.

Henk

OK IchBin, wil contact them tomorrow, thanx