UBB.Dev
Posted By: Hal9000 canubbthreadsPosts.MYI - 05/13/2003 6:53 PM
I tried to make a post and suddently I get this message

SQL ERROR: Unable to do_query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t3.B_AnonName FROM ubbthreadsBoards AS t1 LEFT JOIN ubbthreadsUsers AS t2 ON t1.Bo_Posterid = t2.U_Number LEFT JOIN ubbthreadsPosts AS t3 ON t1.Bo_LastNumber = t3.B_Number WHERE t1.Bo_Cat = 1 AND (t1.Bo_Posterid = t2.U_Number OR t1.Bo_Posterid = '0') AND (t1.Bo_LastNumber = t3.B_Number OR t1.Bo_LastNumber ='0') AND (t1.Bo_Read_Perm LIKE '%-3-%' OR t1.Bo_Read_Perm LIKE '%-1-%') ORDER BY t1.Bo_Sorter
Can't open file: 'ubbthreadsPosts.MYI'. (errno: 145)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/public_html/ubbthreads/mysql.inc.php on line 130

At line 130 of mysql.inc.php there is

// ----------------------
// Start the session here
if ($config['tracking'] == "sessions") {
session_save_path($config['sessionpath']);
session_start();
}
else {
$HTTP_SESSION_VARS="";
}

// Get magic quote setting
$magic = get_magic_quotes_gpc();

$tempstyle = "default";

// ---------------------------
// Turn off the magic quoting
set_magic_quotes_runtime(0);

if (!isset(${$config['cookieprefix']."w3t_language"})) {
${$config['cookieprefix']."w3t_language"} = $config['language'];
}
include("$thispath/languages/${$config['cookieprefix']."w3t_language"}/generic.php");$dbh = new sql;
$dbh -> connect();

Thank you in advance
Posted By: Dave_L_dup1 Re: canubbthreadsPosts.MYI - 05/13/2003 6:55 PM
https://www.ubbdev.com/forum/showthreaded.php?Board=php&Number=79916
Posted By: Hal9000 Re: canubbthreadsPosts.MYI - 05/13/2003 7:15 PM
Thanks Dave. Fixed. Thought it was something more serious :-)
Posted By: Hal9000 Re: canubbthreadsPosts.MYI - 05/14/2003 7:00 PM
There is a problem after the repair table

One member was deleted with all his posts . I can't find him in the database. He was the last member who made a post just before the crash. Is there any way to recover this member?

Thanks
Posted By: Astaran Re: canubbthreadsPosts.MYI - 05/14/2003 11:11 PM
Only if you made backups on a regular basis. You could try to restore is entries then.
© UBB.Developers