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?

http://plainjaingraphics.com

-Pj

Comments

vm’s picture

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.

pj@plainjaingraphics.com’s picture

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

vm’s picture

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 ?

pj@plainjaingraphics.com’s picture

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
ravenite@gmail.com’s picture

download CHANGELOG.TXT in the root and it'll tell you exactly what version you're running.

skor’s picture

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.

pj@plainjaingraphics.com’s picture

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?

skor’s picture

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.

pj@plainjaingraphics.com’s picture

I'm running Drupal 4.7.0, 2006-05-01...

pj@plainjaingraphics.com’s picture

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.

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

vm’s picture

no problem. good luck!