News: When asking for support, it helps us and you, if you read the Posting Guidelines

Login  |  Register
HTML5 Icon HTML5 Icon
TP on Social Media
Welcome, Guest. Please login or register.
Did you miss your activation email?

July 16, 2019, 02:20:40 AM

Login with username, password and session length

Recent

Members
Stats
  • Total Posts: 188512
  • Total Topics: 20736
  • Online Today: 26
  • Online Ever: 629
  • (November 08, 2018, 01:36:54 PM)
Users Online
Users: 0
Guests: 21
Total: 21

Author Topic: Help needed: Database error? *SOLVED*  (Read 6657 times)

0 Members and 1 Guest are viewing this topic.

Henk

  • Guest
Help needed: Database error? *SOLVED*
« on: June 14, 2008, 06:14:05 AM »
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. :(
« Last Edit: June 14, 2008, 06:48:59 AM by G6 »

Offline Dragooon

  • Hero Member
  • *****
  • Posts: 994
Re: Help needed: Database error?
« Reply #1 on: June 14, 2008, 06:18:38 AM »
Try repairing the table, if that doesn't works, you need to ask your host.

Henk

  • Guest
Re: Help needed: Database error? Error re-occur
« Reply #2 on: June 14, 2008, 06:36:09 PM »
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....

Offline IchBin™

  • Developer
  • *
  • Posts: 16228
    • My Website
Re: Help needed: Database error? *SOLVED*
« Reply #3 on: June 14, 2008, 10:56:18 PM »
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

  • Guest
Re: Help needed: Database error? *SOLVED*
« Reply #4 on: June 15, 2008, 08:22:41 AM »
OK IchBin, wil contact them tomorrow, thanx