Welcome, Guest. Please Login or Register.
November 27, 2024, 07:52:37 AM
Home Help Search Log in Register
News: SMF is the next generation in forum software, almost completely re-written from the ground up, make sure you don't fall for cheap imitations that suffer from feature bloat!

YaBB SE Community  |  English User Help  |  English Help  |  can't delete post « previous next »
Pages: [1] Reply Ignore Print
Author Topic: can't delete post  (Read 320 times)
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
can't delete post
« on: May 26, 2003, 05:35:42 AM »
Reply with quote

I need to delete a post and I get this error:
QuoteCan't open file: 'yabbse_polls.MYI'. (error: 145)
File: /home/anguz/public_html/foros/Sources/ModifyMessage.php
Line: 297

that line says:
         $request = mysql_query("DELETE FROM {$db_prefix}polls WHERE ID_POLL='$row[ID_POLL]' LIMIT 1;") or database_error(__FILE__, __LINE__);

what should I do or change to fix this? thx in advance
Logged

My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:can't delete post
« Reply #1 on: May 26, 2003, 05:41:25 AM »
Reply with quote

REPAIR TABLE yabbse_polls;

-[Unknown]
Logged
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:can't delete post
« Reply #2 on: May 26, 2003, 06:24:21 AM »
Reply with quote

thank you very much again  :)
Logged

My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:can't delete post
« Reply #3 on: May 29, 2003, 03:49:53 PM »
Reply with quote

now I get this message when trying to remove a thread:
QuoteError en la Base de Datos

Can't open file: 'yabbse_polls.MYI'. (errno: 145)
Archivo: /home/anguz/public_html/foros/Sources/RemoveThread.php
LĂ­nea: 49
line 49 says:
   $request = mysql_query("DELETE FROM {$db_prefix}polls WHERE ID_POLL='$row[ID_POLL]' LIMIT 1;") or database_error(__FILE__, __LINE__);

I'm guessing the query would too be:
REPAIR TABLE yabbse_polls;

would this be correct? :P

also, if there's nothing wrong with a table, would it do it any harm to run that query?

another question:  in the forum's index, there's two forums that don't show the last post data, instead it says "N/A"... why is this?

thx in advance :)
Logged

My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:can't delete post
« Reply #4 on: May 29, 2003, 04:56:22 PM »
Reply with quote

well, I tried it and workde :)


but I still have the problem with the last reply not showing in the forum index, you can see it here
http://12.96.162.208/~anguz/foros/index.php
half way down, more or less

any idea why this is?
Logged

My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:can't delete post
« Reply #5 on: May 30, 2003, 02:39:45 AM »
Reply with quote

Recount All Board Totals.

-[Unknown]
Logged
Anguz
YaBB God
*****
Posts: 641


llama me?!

WWW
Re:can't delete post
« Reply #6 on: May 30, 2003, 02:53:41 AM »
Reply with quote

thank you very much once more :)
Logged

My Mods: Avatar & Sig Size Control, No Show Msg Subject, Msg URL Composer, Built-in Avatar Rand, Built-in Sig Rand, Remove New-lines Excess, Show All Stars, Search Bar, Smart URLs
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  can't delete post « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.080 seconds with 21 queries.