My nodes are in reverse order! help!
pj@plainjaingra... - December 7, 2006 - 15:53
The order of all my nodes are in reverse order. The oldest nodes are now at the top of the page and the newest are at the bottom! It is impossible to stick anything to the top of the site, and anything I had stickied previously is not stickied at all (not at top or bottom).
I have never seen or heard of something like this happening! Is there someone out there that can tell me why this is happening and what I can do to correct it?
-Pj
do you mean comments? I
do you mean comments? I don't see how the order of nodes can be reveresed. Comments has a setting in administer -> comments -> configure -> viewing options that allows you to switch comments from newest first to newest last.
no, not the comments...
I mean the nodes themselves, like blog posts and stories... oddly enough the comments are still the way they are supposed to be...
My most recent nodes are going to the bottom of the list, and the the ones I made weeks ago are now at the top! And the stickies are showing up anywhere they want to! lol, if I can't get this fixed I'll just shut down the site, it is not worth this hassle.
http://plainjaingraphics.com
Looks to me like you have a
Looks to me like you have a problem related to this issue http://drupal.org/node/64114
when I open your website as an anon user, I am presented with the drupal welcome page.
without fixing this issue, I can't see any content.
could you also provide (for those willing to help) a list of contributed modules? as well as which version of drupal you are using ?
yes...
I'll provide the requested information in a bit. Thank you for taking in interest in helping me.
edit, here's more info:
I believe I'm using 4.7.0. (It might be 4.7.2 but I don't think so)
I installed Node Access Arbitrator last night. I think this is what borked my site. I enabled NA-Arbitrator in admin/modules. When I went to the settings for the module I saw the message that said "don't submit if you are not sure what you are doing" (paraphrased). I knew at once this is not the module for me so I didn't press any buttons there. I hit my back button and immediately disabled NA-Arbitrator. I think it was already too late.
I plan to follow the instructions at http://drupal.org/node/64114.
If you would be kind enough to tell me how to run a query using phpMyAdmin I would really appreciate it. I looked around in phpMyAdmin but it is over my head.
Modules are:
aggregator Aggregates syndicated content (RSS, RDF, and Atom feeds).
block Controls the boxes that are displayed around the main content. required required
blog Enables keeping an easily and regularly updated web page or a blog.
captcha Adds a Captcha to the registration form.
chatbox An HTML/JavaScript based chat.
codefilter Provides tags for escaping large pieces of code automatically.
comment Allows users to comment on and discuss published content.
comment_closer Schedule automatic closing of comments for selected node types based on the age of the node
contact Enables the use of both personal and site-wide contact forms.
drupal Lets you register your site with a central server and improve ranking of Drupal projects by posting information on your installed modules and themes; also enables users to log in using a Drupal ID.
filter Handles the filtering of content in preparation for display. required required
forum Enables threaded discussions about general topics.
google_pr Allows users to find the Google PageRank of sites choose by them.
help Manages the display of online help.
image Allows uploading of images.
image_gallery Allows sorting and displaying of image galleries based on categories
img_assist Enables users easily upload and insert images into content.
linksdb Maintains a database of links.
manage Use a dedicated theme for admin pages.
menu Allows administrators to customize the site navigation menu.
month
node Allows content to be submitted to the site and displayed on pages. required required
nodewords Allows users to add meta tags, eg keywords or description.
page Enables the creation of pages that can be added to the navigation system.
path Allows users to rename URLs.
ping Alerts other sites when your site has been updated.
profile Supports configurable user profiles.
search Enables site-wide keyword searching.
shoutbox This module enables you to display a shoutbox.
sitemenu site map page and block menu, based on taxonomy
statistics Logs access statistics for your site.
statistics_filter Filter out admin and search engine hits on your site.
story Allows users to submit stories, articles or similar content.
system Handles general site configuration for administrators. required required
taxonomy Enables the categorization of content.
taxonomy_menu Adds links to taxonomy terms to the global navigation menu.
teaser_images Converts images in teasers into thumbnails.
throttle Handles the auto-throttling mechanism, to control site congestion.
required
tracker Enables tracking of recent posts for users.
upload Allows users to upload and attach files to content.
urlfilter Automatically turns web and e-mail addresses into clickable links.
user Manages the user registration and login system. required required
watchdog Logs and records system events. required required
download CHANGELOG.TXT in
download CHANGELOG.TXT in the root and it'll tell you exactly what version you're running.
Are you using Mysql 4.1.21?
There's a bug in that version that causes the behaviour you're describing. Sorry, this is the best link I have handy right now: http://bugs.mysql.com/bug.php?id=21456
The good news is that there's a patch available.
Server version: 4.1.21-standard-log
You got it!
Okay, about that patch... My site is hosted at http://bluehost.com .
Will I be able to patch Mysql myself or is this something Bluehost would have do do?
Most likely you will not be
Most likely you will not be able to do this yourself. You'll have to get with tech support and see if they'll do it.
thank you servantofthebones
I'm running Drupal 4.7.0, 2006-05-01...
Thank you so much for directing me to that page!
Thank you so much for directing me to that page!
I ran this query only
INSERT INTO node_access (nid, gid, realm, grant_view, grant_update, grant_delete) VALUES (0, 0, 'all', 1, 0, 0);and my site seems to be working fine now! (fingers crossed)Thanks again!
-Pj
no problem. good luck!
no problem. good luck!