No announcement yet.

SQL error

  • Filter
  • Time
  • Show
Clear All
new posts

  • jroy
    tmp space is filled, thats probably why, thanks anyways guys!

    Leave a comment:

  • jroy
    started a topic SQL error

    SQL error

    Hi, I get this error when trying to access my inbox:

    Invalid SQL:
    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.iconpath
    FROM vb3_pm AS pm
    LEFT JOIN vb3_pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN vb3_icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid=1 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50

    mysql error: Got error -1 from table handler

    mysql error number: 1030

    i tried to repair/optimize the tables but they all say they are ok, im running 3.0.7 (going to upgrade asap)

    im not sure why its generating this error, i havnt touched the files in a while
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.