raworth

Big Bagel: I appreciate your message. And I didn’t quite give up as it irritates me not to be able to do something. This is what I’ve done so far. As I have all the WP files, and the sql backup, I dropped all the data entries via phpMyAdmin. I then made a new WP installation changing the folder name to NOTES. This installed perfectly and I was able to both access it as http://tomraworth.com/notes and make blog entries in the normal way. I read “Restoring from Backup” but when I used phyMyAdmin there was no “import” tag. I followed other threads and found one that seemed to imply I could cut and paste from a Text Editor the contents of the sql file and paste it into the SQL “Query” window (after dropping all the new data entries made by the fresh installation). This took some time, but seemed to work eventually as new data appeared in the base. But then http://tomraworth.com/notes just presented a blank page. Clicking “themes” in dashboard gave a “theme broken” message, so I reverted to default. Now I seem to have all the old entries working, but must work out how to re-do my own theme, re-do any plugins, etc. At least, clumsily and in almost dark, I seem to have blundered on a method. Thanks again to you all. TR

A new day. I have FTPd everything from the server, and have sql data files via phpMyAdmin, all on my hard-drive. It seems to make most sense to me to delete all the data files on the server, make a fresh install of 3.2.1 (using the same blog name) and then (as esmi suggested yesterday “eminently do-able”) import the old posts to the new blog. I’d be grateful for any advice as to whether this is reasonable, and
(a) how to delete the data from the server using phpMyAdmin
(b) how to import the old posts/information from the files on my hard-drive
(c) if, by doing this, I would possibly import the same problem (causing DDOS attacks on my server) to the new blog.
I apologize if this should be a new thread. TIA. TR

O.K. I’ll give Hostway a chance to help out, as they’ve been prompt with assistance for a few other site problems over the years. I’ll let you know anything they suggest (as I’m interested in the problem itself, and not just getting the blog up again)… but should I need to start a fresh installation I’ll return for advice on that. Thanks. TR

I’ve written to them explaining about the impossibility of accessing the NOTES installation, but I don’t expect anything to come of it… they seem to have reached the limits of assistance by supplying the log. There’s certainly no way, in my seventies, I’m going to quickly learn code, so I imagine several years of work will just vanish. Many thanks for your attempts to help. TR

Thanks, esmi. It is installed at 13560/public_html/notes (i.e. within the folder “notes”). Server is and has been Hostway.com for many years. There are two screenshots that might help, and a PDF of the log they sent on:
ss1.png

ss2.png
pdf

Thanks, Moshu and Jacques: I’ll get to this when I’ve a little more free time.
Jacques: you can reach me on raworth@gmail.com and we’ll catch up.
Excuse off topic.

TR

Thanks. Sorry for the delay, offline for a while. Here’s the

categories.php

<?php
require_once(‘admin.php’);

$title = __(‘Categories’);
$parent_file = ‘edit.php’;

$wpvarstoreset = array(‘action’,’cat’);
for ($i=0; $i<count($wpvarstoreset); $i += 1) {
$wpvar = $wpvarstoreset[$i];
if (!isset($$wpvar)) {
if (empty($_POST[“$wpvar”])) {
if (empty($_GET[“$wpvar”])) {
$$wpvar = ”;
} else {
$$wpvar = $_GET[“$wpvar”];
}
} else {
$$wpvar = $_POST[“$wpvar”];
}
}
}

switch($action) {

case ‘addcat’:
if ($user_level < 3)
die (__(‘Cheatin’ uh?’));

$cat_name= wp_specialchars($_POST[‘cat_name’]);
$id_result = $wpdb->get_row(“SHOW TABLE STATUS LIKE ‘$wpdb->categories'”);
$cat_ID = $id_result->Auto_increment;
$category_nicename = sanitize_title($cat_name, $cat_ID);
$category_description = $_POST[‘category_description’];
$cat = intval($_POST[‘cat’]);

$wpdb->query(“INSERT INTO $wpdb->categories (cat_ID, cat_name, category_nicename, category_description, category_parent) VALUES (‘0’, ‘$cat_name’, ‘$category_nicename’, ‘$category_description’, ‘$cat’)”);

header(‘Location: categories.php?message=1#addcat’);
break;

case ‘delete’:

check_admin_referer();

$cat_ID = (int) $_GET[‘cat_ID’];
$cat_name = get_catname($cat_ID);
$category = $wpdb->get_row(“SELECT * FROM $wpdb->categories WHERE cat_ID = ‘$cat_ID'”);
$cat_parent = $category->category_parent;

if ( 1 == $cat_ID )
die(sprintf(__(“Can’t delete the %s category: this is the default one”), $cat_name));

if ( $user_level < 3 )
die (__(‘Cheatin’ uh?’));

$wpdb->query(“DELETE FROM $wpdb->categories WHERE cat_ID = ‘$cat_ID'”);
$wpdb->query(“UPDATE $wpdb->categories SET category_parent = ‘$cat_parent’ WHERE category_parent = ‘$cat_ID'”);
// TODO: Only set categories to general if they’re not in another category already
$wpdb->query(“UPDATE $wpdb->post2cat SET category_id=’1′ WHERE category_id=’$cat_ID'”);

header(‘Location: categories.php?message=2’);

break;

case ‘edit’:

require_once (‘admin-header.php’);
$cat_ID = (int) $_GET[‘cat_ID’];
$category = $wpdb->get_row(“SELECT * FROM $wpdb->categories WHERE cat_ID = ‘$cat_ID'”);
$cat_name = $category->cat_name;
?>

<div class=”wrap”>
<h2><?php _e(‘Edit Category’) ?></h2>
<form name=”editcat” action=”categories.php” method=”post”>
<table class=”editform” width=”100%” cellspacing=”2″ cellpadding=”5″>
<tr>
<th width=”33%” scope=”row”><?php _e(‘Category name:’) ?></th>
<td width=”67%”><input name=”cat_name” type=”text” value=”<?php echo wp_specialchars($cat_name); ?>” size=”40″ /> <input type=”hidden” name=”action” value=”editedcat” />
<input type=”hidden” name=”cat_ID” value=”<?php echo $cat_ID ?>” /></td>
</tr>
<tr>
<th scope=”row”><?php _e(‘Category slug:’) ?></th>
<td><input name=”category_nicename” type=”text” value=”<?php echo wp_specialchars($category->category_nicename); ?>” size=”40″ /></td>
</tr>
<tr>
<th scope=”row”><?php _e(‘Category parent:’) ?></th>
<td>
<select name=’cat’>
<option value=’0′ <?php if (!$category->category_parent) echo ” selected=’selected'”; ?>><?php _e(‘None’) ?></option>
<?php wp_dropdown_cats($category->cat_ID, $category->category_parent); ?>
</select></td>
</tr>
<tr>
<th scope=”row”><?php _e(‘Description:’) ?></th>
<td><textarea name=”category_description” rows=”5″ cols=”50″ style=”width: 97%;”><?php echo wp_specialchars($category->category_description, 1); ?></textarea></td>
</tr>
</table>
<p class=”submit”><input type=”submit” name=”submit” value=”<?php _e(‘Edit category’) ?> »” />
</form>
<?php _e(‘« Return to category list’); ?>
</div>
<?php

break;

case ‘editedcat’:
if ($user_level < 3)
die (__(‘Cheatin’ uh?’));

$cat_name = wp_specialchars($_POST[‘cat_name’]);
$cat_ID = (int) $_POST[‘cat_ID’];
$category_nicename = sanitize_title($_POST[‘category_nicename’], $cat_ID);
$category_description = $_POST[‘category_description’];

$wpdb->query(“UPDATE $wpdb->categories SET cat_name = ‘$cat_name’, category_nicename = ‘$category_nicename’, category_description = ‘$category_description’, category_parent = ‘$cat’ WHERE cat_ID = ‘$cat_ID'”);

header(‘Location: categories.php?message=3’);
break;

default:

require_once (‘admin-header.php’);

$messages[1] = __(‘Category added.’);
$messages[2] = __(‘Category deleted.’);
$messages[3] = __(‘Category updated.’);
?>

<?php if (isset($_GET[‘message’])) : ?>
<div class=”updated”><?php echo $messages[$_GET[‘message’]]; ?></div>
<?php endif; ?>

<div class=”wrap”>
<?php if ( $user_level > 3 ) : ?>
<h2><?php printf(__(‘Categories (add new)’), ‘#addcat’) ?> </h2>
<?php else : ?>
<h2><?php _e(‘Categories’) ?> </h2>
<?php endif; ?>
<table width=”100%” cellpadding=”3″ cellspacing=”3″>
<tr>
<th scope=”col”><?php _e(‘ID’) ?></th>
<th scope=”col”><?php _e(‘Name’) ?></th>
<th scope=”col”><?php _e(‘Description’) ?></th>
<th scope=”col”><?php _e(‘# Posts’) ?></th>
<th colspan=”2″><?php _e(‘Action’) ?></th>
</tr>
<?php
cat_rows();
?>
</table>

</div>

<?php if ( $user_level > 3 ) : ?>
<div class=”wrap”>
<?php printf(__(‘Note:
Deleting a category does not delete posts from that category, it will just
set them back to the default category %s.’), get_catname(1)) ?>

</div>

<div class=”wrap”>
<h2><?php _e(‘Add New Category’) ?></h2>
<form name=”addcat” id=”addcat” action=”categories.php” method=”post”>

<?php _e(‘Name:’) ?>
<input type=”text” name=”cat_name” value=”” />
<?php _e(‘Category parent:’) ?>
<select name=’cat’ class=’postform’>
<option value=’0′><?php _e(‘None’) ?></option>
<?php wp_dropdown_cats(0); ?>
</select>
<?php _e(‘Description: (optional)’) ?>
<textarea name=”category_description” rows=”5″ cols=”50″ style=”width: 97%;”></textarea>
<p class=”submit”><input type=”hidden” name=”action” value=”addcat” /><input type=”submit” name=”submit” value=”<?php _e(‘Add Category »’) ?>” />
</form>
</div>
<?php endif; ?>

<?php
break;
}

include(‘admin-footer.php’);
?>

and here’s the sidebar.php

<?php
$mode = ‘sidebar’;

$standalone = 1;
require_once(‘admin-header.php’);

get_currentuserinfo();

if ($user_level == 0)
die (“Cheatin’ uh ?”);

if (‘b’ == $_GET[‘a’]) {

?><!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt;
<html xmlns=”http://www.w3.org/1999/xhtml”&gt;
<head>
<title>WordPress › Posted</title>
<meta http-equiv=”Content-Type” content=”<?php bloginfo(‘html_type’); ?>; charset=UTF-8″ />
<link rel=”stylesheet” href=”wp-admin.css” type=”text/css” />
</head>
<body
Posted !
Click here to post again.
</body>
</html><?php

} else {

?><!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt;
<html xmlns=”http://www.w3.org/1999/xhtml”&gt;
<head>
<title>WordPress › Sidebar</title>
<meta http-equiv=”Content-Type” content=”<?php bloginfo(‘html_type’); ?>; charset=<?php bloginfo(‘blog_charset’); ?>” />
<link rel=”stylesheet” href=”wp-admin.css” type=”text/css” />
<style type=”text/css” media=”screen”>
form {
padding: 3px;
}
.sidebar-categories {
display: block;
height: 6.6em;
overflow: auto;
background-color: #f4f4f4;
}
.sidebar-categories label {
font-size: 10px;
display: block;
width: 90%;
}
</style>
</head>
<body id=”sidebar”>
<h1 id=”wphead”>WordPress</h1>
<form name=”post” action=”post.php” method=”POST”>
<div><input type=”hidden” name=”action” value=”post” />
<input type=”hidden” name=”user_ID” value=”<?php echo $user_ID ?>” />
<input type=”hidden” name=”mode” value=”sidebar” />
Title:
<input type=”text” name=”post_title” size=”20″ tabindex=”1″ style=”width: 100%;” />

Categories:
<span class=”sidebar-categories”>
<?php dropdown_categories(); ?>
</span>

Post:
<textarea rows=”8″ cols=”12″ style=”width: 100%” name=”content” tabindex=”2″></textarea>

<input name=”saveasdraft” type=”submit” id=”saveasdraft” tabindex=”9″ value=”Save as Draft” />
<input name=”publish” type=”submit” id=”publish” tabindex=”6″ style=”font-weight: bold;” value=”Publish” />

</div>
</form>

</body>
</html>
<?php
}
?>