heyrsmith

Hey drmike, thanks for responding – no, not a silly question at all. Yes, my solutions were ahead of the gun a bit – This particular install is one that is tightly controlled by our admin folks and I do not have direct access to the DB – there is a (slight) institutional reluctance to service this install, so I always feel like it is important to be able to understand what might be going on and suggest ways of fixing it.

What our support person was able to tell me this morning is that

…one of the tables apparently had more data in it than was set in the database structure… for example, the structure was set to allow no more than 100 characters and ….it had well more than that…I have upped that to 255 characters and the site “looks” OK….

…also the DB was completely screwed up though and several tables are barking at me that they need repaired and re-indexing…

So that seems to have fixed it for now. We also had a particular page throwing the following error:

database error: [Data too long for column ‘useragent’ at row 1]
INSERT INTO wp_useronline VALUES (‘1173176402’, ‘Guest’, ‘Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322)’, ‘131.204.119.146’, ‘auSofA ? Graduate Program in Community Planning’, ‘%2Fsoa%2Findex.php%2Fprograms%2Fmcp%2F’)

Which seems to be the place where there is “too much data” The upping of the character limit has fixed that error too. My support person followed up with:

Yep that’s the problem right there….so there was too much in the database in that field..and it “probably” caused the indexing to screw all up.

That particular error looks like it may be caused by the wp_useronline plugin, which has never caused any problems before… Our support is unable to offer any observations as to how this happened or possible ways to keep it from re-occurring in the future.

So I guess I am left with the following questions:

1. How does this happen and is it normal?
2. Does the fix make sense?
3. Is there a way to avoid this in the future?

Thanks in advance for any observations…

OK, I finally have a little more information. On a slower computer, a brief series of error messages pops up in the frame when I hit “upload” they go away in a flash and then the “browse” window comes back, albeit without the newly uploaded images:
—-

WordPress Database error: [Field ‘post_content_filtered’ doesn’t have a default value]
INSERT INTO wp_post (post_author, post_date, post_date gmt, post_parent, menu order, post_mime_type, guid) VALUES (‘6′, 2007-01-18 02:08:42’, ‘2007-01-17 20;08;42’, ‘ ‘,ppt5.jpg, ‘ ‘, ‘attachement’, ‘open’, ‘open’, ‘ ‘, ‘ppt5jpg’, ‘ ‘, ‘ ‘, ‘2007-01-18 02:08:42’, ‘2007-01-17 20:08:42’, ‘-1169063304’, ‘0’ ‘image/jpeg’,

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQ server version for the right syntax to use near ” at line 3]
SELECT category_id FROM wp_post2cat WHERE post_id =

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQ server version for the right syntax to use near ‘ 1)’ at line 2]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 1)

WordPress database error: [Out of range value adjusted for column ‘post_id’ at row 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES (‘ ‘, ‘_wp_attached_file’ , ‘W:\www\cadc.auburn.edu\soa\rural-studio\outreach2007/wp-content/uploads/2007/01/ppt5.jpg’)

WordPress database error: [Out of range value adjusted for column ‘post_id’ at row 1]
INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES
(‘ ‘ , ‘__wp_attachment_metadata’ , ‘a:4:{s:5:\”width\”;i:99;s:6\”height\”;i:101;s:14:\”hwstring_small\”;s:22:\height=\’96\’
width=\’94\’\”;s:4:\”file\”;s:88:\W:\\www\\cadc.auburn.edu\\soa\\rural-studio\\outreach2007/wp-content/uploads/2007/01/ppt5.jpg\”;}’)

—-
Again, the images actually upload fine (I can access them via ftp) but they do not show up in the “browse” window. All files that were uploaded before the server upgrade are visible in the “browse” window, just not anything that I upload now after the server upgrade. This is affecting all of the WordPress sites on this server.

Any help or observations as to what might be causing this and a possible fix is extremely welcome. And sorry if there are any typos in the above error code – It appears and disappears so quickly I hade to do a screen capture and type it in by hand….

You may want to give the Event Calendar Plugin a look-see, too: https://wpcal.firetree.net/

hey ruckerz – I can confirm that this does indeed seem to fix the problem. all looks like it is working as it should.

Thanks for that!

I fixed a similar problem with my IIS install.
I noticed there was a slight difference in the way the auto-generated link to the profile subpage was different from the way it was written when I clicked on the tab in the profile section of the dashboard. One was written with a backslash, while the other was written with a forward slash. I tracked it down to around line 64. I had to change:

$this->use_profile = "" . __('You may manage your subscription options from your ', 'subscribe2') . "<a href="" . get_settings('siteurl') . "/wp-admin/profile.php?page=subscribe2/subscribe2.php">profile</a>.
"

to:

$this->use_profile = "" . __('You may manage your subscription options from your ', 'subscribe2') . "<a href="" . get_settings('siteurl') . "/wp-admin/profile.php?page=subscribe2subscribe2.php">profile</a>.
"

EDIT:
huh – there should be a backslash between between “subscribe2” and “subscribe2.php” in the last edited code, but for some reason the forum is stripping it out…

That seemed to do it for me in Subscribe2 v2.2.8

Hey bcreighton – care to share exactly how/where in the code exactly you fixed this?

Hi Moshu – for one, you can style pages using custom templates which you cannot do for posts. You can also make lists of pages into menus, and custom organize them in a variety of ways just by using the built-in WP parameters, not to mention the various page plugins out there. For one of my sites I am using WP as a simple content manager (The site has a blog front-end but lots of pages as well). The ability to have pages with multiple parents (or be categorized) would allow me to call the same page in a variety of menu configurations. Depending on what page was active. Say I have a page that is called “Home” and I want the page “Child” to show up as a menu item. I simply make a menu that shows the children of “Home”, right? But suppose that I want the page “Child” to also show up in a menu for a page called “Work”. It would be great if “Child” were a child of “Work” as well. Then I could use the same syntax to construct all of my menus. Page Categorization would work the same. I suppose that I COULD use individual posts and categories to do the same thing, but then my blogging categories would get full and confusing to other users that simply blog (this is also a multi-author site). By keeping posts and pages separate (although similar) I think it makes it easier for users.

Sean:
Thanks for the offer – I would greatly appreciate it. As I stated above, I am happy to pay for your work in any manner that you wish ( I see that you have paypal). You can contact me at:
rusty dot smith at auburn dot edu.

Thanks a lot!

A captcha will not keep the trackback spam out; You need Akismet and Bad Behavior for that. Once you have those installed, you won’t need a captcha.

Skippy this is fantastic! Just what I was looking for. Once I see it, it makes perfect sense. I just never can think right about these things…

Kingforaday:
Try the code:

<?php wp_list_pages('title_li=&depth=1'); ?>

in your sidebar and see if that does what you want it to do. Setting the depth to “1” Restricts the list to only top-level parent pages. You may want to also check out the codex entry on pages to learn about all of the parameters that you can use.

datasta:
Can’t really tell what you mean by “the video does not show on my blog” as you did not provide a link, but it may be that you are using the rich text editor to insert the code? Try it with the rich text editor turned off. If that does not work you can try to ask VaamYob (the developer) directly by clicking on the FAQ link at the top of his site and asking your question there directly. Finally, if you still cannot get it to work you could try the ExtremeVideo plugin instead? I think it has the same rich text editor “problem” though. Good luck!

you could always just hardcode it like:

<h2>Pages</h2>
<ul class="pages">
<?php wp_list_pages('sort_column=menu_order&title_li=' ); ?>
</ul>

the ul class=”pages” is of course not needed, I just use it style the list via css.

I had trouble with many of the links as well. I finally got it from the link on this page: https://rane.hasitsown.com/blog/index.php

The direct link to the zipped file is: https://rane.hasitsown.com/blog/wp-content/shared/faq.zip

Hi all -thanks for the observation. Yes I too was working under the assumption that the faq plugin was 1.5 worthy. I have a couple of 2.0 installs that are very similar to the 1.5.2 that I am having trouble with. I will give it a try on one of them and report back as soon as I can.

Hi Vaam Yob – just installed the plugin in a 1.5.2 install and get this error in several places:

WordPress database error: [Unknown column 'u.display_name' in 'field list']
SELECT a.answer, a.rating_avg, a.id a_id, q.views, q.id q_id, q.question, question_approved, question_author, question_author_email, question_author_url, question_author_ip, c.cat_name, c.cat_id, u.display_name answer_author FROM wp_faq_questions q LEFT JOIN wp_faq_answers a ON q.id = a.q_id LEFT JOIN wp_faq_questions2cat q2c ON q.id = q2c.q_id LEFT JOIN wp_categories c ON q2c.cat_id = c.cat_id LEFT JOIN wp_users u ON a.answer_author_user_id = u.id WHERE q.question_approved = 0 ORDER BY c.cat_id, question_date desc

It shows up on the Faq Manage page, the moderate page, and at the top of the page where the <!–faq–> tag is entered. you can see it here.

Also, if I can get it working, two things that may be nice additions to this great plugin: a numbering system (so that I might say as an answer “see question #12”) and a way to have more than one faq per blog, although I can only imagine how difficult THAT might be…