pixellated

I saw that the wp-db.php file is an altered version of Justin Vincent’s (https://php.justinvincent.com) EZ_SQL, which I use at work to connect to an Oracle database. EZ_SQL is a db abstraction script that connect to just about any DB out there. I’m wondering if Justin’s Oracle script (or any of the others, for that matter) could be modded to work with WordPress…

Nevermind.
Found out that, for whatever reason, it has something to do with changing the post content fieldtype from TEXT to LONGTEXT (as someone in another thread suggested doing for extra-long posts)… apparently, while it works for some people, it caused MySQL on our host to go completely berzerk and give the errors above.
After we were able to log back into PHPMyAdmin and change the content fieldtype back to “TEXT” and the host ran a repair on MySQL, everything worked fine. We actually tried doing this several times, and each time, the host had to run a repair on MySQL… so we’re not touching the field types anymore, and the site owner will just have to be less verbose in the future! ??

No, that’s already taken care of. It’s the same domain, etc., just a new server. While I was in PHPMyAdmin, I changed all the necessary paths, etc. that I could find. However, it’s still not letting anyone (there are several users) log in.

We’re having a similar problem. After exporting the old db, and uploading everything to the new server, and importing the old db into the new db, login is failing. We don’t dare risk a new install because we’ve modified WP so extensively with hacks, plugins, and custom coding (w/o documenting any of it, silly rabbits…) that to do a fresh install would equal disaster.
Tried resetting the password as suggested above but that didn’t work either. Any other ideas?

Excellent! Thanks for the link.

Reviving this thread…
Currently performing a search brings up the full article, rather than the title/exerpt (as noted above, back on Aug 28 2003). I would like to change this so that not only do the search results appear on a new page (this is easy enough to do) but it only lists titles/exerpts at most, titles only at the least.
Can this be done easily? Has anyone produced a “better search” for WP?

Hmm… I suppose you could modify the dropdown menu to default to a different user each time. You’d have to hard-code it in, though:

<select name="post_author">
<!-- hard-coded default -->
<option value="X" selected="selected">Default User Name</option>
<!-- end default -->
<?php
$authq = "select * from wp_users order by ID";
$authr = mysql_query($authq) or die(mysql_error());
while ($auth = mysql_fetch_array($authr)) {
echo '<option value="' . $auth['ID'] . '">' . $auth['user_nickname'] . '</option>';
}
?>
</select>

See if that helps.

Well, seeing as it’s been two weeks and nobody’s even responded with so much as a “feh” I decided to muddle my way through and add it in myself. This is a total hack, and isn’t pretty by WP standards, but it works.
In /wp-admin/post.php, scroll down to case ‘edit’ and add the following after $post_title = addslashes($_POST[‘post_title’]);:
$post_author = $_POST['post_author'];
Scroll a little farther down to the UPDATE $tableposts query and add the following after post_status = ‘$post_status’,:
post_author = '$post_author',
Save and close.
Open /wp-admin/edit-form-advanced.php and scroll down to the postpassworddiv fieldset, and add this in immediately following it:

<fieldset id="postauthordiv">
<legend><?php _e('Post Author') ?></legend>
<div>
<select name="post_author">
<?php
$authq = "select * from wp_users order by ID";
$authr = mysql_query($authq) or die(mysql_error());
while ($auth = mysql_fetch_array($authr)) {
echo '<option value="' . $auth['ID'] . '">' . $auth['user_nickname'] . '</option>';
}
?>
</select>
</div>
</fieldset>

Save and close.
Done.

Similar problems here, except I’m unable to login via the admin login. All the user data for admin is still in the db; password hasn’t changed; etc. but when I try to login, it keeps returning me to the login page.
It’s not just me–several other people have tried as well.

I’m unable to get it to work as well, although I think it may be the version of MySQL running on the server. I’m getting a big ol’ SQL error right around the ‘WHERE’ in ‘SELECT ID, post_date, post_title, category_id FROM $wpdb->posts, $wpdb->post2cat WHERE $wpdb->post2cat.category_id = $cat AND $wpdb->post2cat.post_id = $wpdb->posts.ID’ (etc.)
Any thoughts?

Ooooo…K. Guess no answer is my answer.

Thanks, David. After I posted my query, I worked with it a little longer, and eventually abandoned the idea. But, I appreciate your response. ??

Whoops, that second line in the blockquotes should read:

the_content(‘more’, ‘0’, ‘the_category()’)