After having a nice July4th weekend I just loaded my site and noticed that the all the content is gone. Every area of the site where I added nodes (around 2,300) vanished.
I logged into Admin and noticed this message, over and over again, a few thousand times, with each message less than a second apart from the next:
Can't open file: 'node.MYI' (errno: 145) query: S
When viewing the details of this it says:
Can't open file: 'node.MYI' (errno: 145) query: NSELECT node.nid FROM node INER JOIN term_node ON node.nid = term_node.nid WHERE term_node.tid = 20 ORDER BY rand() LIMIT 3 in /home/mysite/includes/database.mysql.inc on line 66.
Does this statement say that its trying to receive the details of each node but cant find them?
I then went in and viewed the database using the dba module. The node table appears to have no entries. The number "0" is not appearing in the rows column, its just a blank space where a number should be.
Any ideas to remedy this? Do I need to restore a backup of the DB?
Thanks in advance as Im starting to freak out a bit.
-=Vince
Comments
MySQL
This is MySQL complaining that it cannot open the file that holds the table 'node'.
It also gives an error number that can be used with perror (perror 145). That gives the following information:
Either check & attempt to repair (mysql doc or via phpmyadmin) or restore a backup.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.
Problem Solved...restored backup
Thanks for the tips; I truly appreciate them. I quickly notified my hosting provider and they restored a backup of the node table in under 5 minutes.
This is one of the biggest reasons we pay extra for rock solid hosting from RackSpace.
-=Vince
Technology White Papers
IT Executive Blogs
rackspace
What an experience!
glad it was quickly resolved. Is it possible to view your site?
Rackspace sounds like a great host. Could you please comment a bit about how long you've been with them, any problems you've experience before this, cost, etc? Who else did you consider?
Rackspace
You can view the site at this link.
We've been using Rackspace for about 5 months now. They are by far the best hosting service I have ever used. We receive immediate live human support 24/7/365 by calling their 800 number. We have specific people on our customer support team so you dont feel like your talking to someone new every time you call in.
Support comes with our package, and i assume with most of their packages. Rackspace basically setup most of the nitty gritty technical stuff for our site including Clean URLs, cloning sites, domain name setup/dns, email, cron jobs, etc. I just call in, tell them what I need, and they take care of it within 15 minutes, every time.
We opted for an AMD Opteron 2Ghz dedicated rack server (with room for another CPU on the mobo) 2GB RAM, with hardware firewall sitting in front. Unlimited download bandwidth and 1TB (yes terabyte) of upload bandwidth per month. 2 dedicated IPs and a few other bells and whistles.
We're paying about $500+ per month for the hosting and I wouldnt have it any other way. That one time that something goes horribly wrong and they fix it in under 10 minutes is well worth the total investment.
You basically just have to calculate how much your downtime (or uptime) is worth.
We evaluated some other hosts like 1&1, HostDirect, and some others, but none of them could come close to the benefits of RackSpace.
As their slogan states: "Fanatical Support" is right on the money.
-=Vince
Technology White Papers
IT Executive Blogs
thank you
thank you. that was very helpful.
You site looks really good.
I was wondering, is your site supposed to be self-supporting? I couldn't really figure out the business model for it.
(also, there are some strange accent type mark's on Guy Kawasaki's blog.)
Strange Accent Marks
Strange thing....once I restored the backup of the node table, unknown accent marks were put into blocks of text where quotations and other characters should be. This is kind of annoying me. If anyone has any ideas of how to remove this, I'm all ears.
-=Vince
Technology White Papers
IT Executive Blogs
character set
I have a vague memory that the default character set changed between 4.6 and 4.7 or something like that. That might have to do with your problem.
different databse versions?
I had this problem moving data between mysql 4.0 and 4.1. I can avoid problems with flags per: http://drupal.org/node/71289#comment-134187
---
Work: BioRAFT
That seems odd.
They have 'unlimited' download but put a cap on upload?
Site Information
Our website generates revenue by the white paper downloads. Our company's primary business is lead generation for Tech Organizations. You can find a link to our white paper research library in my signature (Technology White Papers).
The goal of this site was to organize executive level blogs from the IT industry in one easy to use website. Hopefully, this will save busy professionals and decision makers time by letting them find the blogs from thought leaders in their industry.
Each blog entry has links to relevant white papers underneath them. We are basically taking aggregator2-items and displaying them as traditional blog entries. Also, the "The Bloggers" tab in the top will show you all the bloggers that we aggregate.
In terms of the upload/download bandwidth for Rackspace, I would assume that putting a cap on upload bandwidth prevents users from uploading full movies or something along those lines. We are far from reaching that limit...right now.
Thanks again for the feedback; its still a work in progress.
-=Vince
Technology White Papers
IT Executive Blogs
interesting
that is very interesting.
what module/s are you using for the pay per click application?
overall, what modules are you using to manage the ecommerce aspect?
ad revenue...
The pay per click ads on the site are from the Google AdSense program and Im using the AdSense module to integrate it.
This module works really well, but to be honest, we dont care much about the revenue generated from adSense. We're basically using it as there are rumors that google ranks sites higher (and indexes them more frequently) if you run AdSense. It does make perfect sense:
Someone searches something on google, they go to a site with AdSense, the user clicks an ad, Google generates revenue.
Whether this is true or not hasnt really been validated, plus it doesnt take up much room on the site.
I suppose the Google SiteMap module (which we also use) auto updates google on new content anyway.
We dont have any eCommerce built into the site, so we're not using any module there. We direct traffic to our white paper library, where users register for white papers and then turn into sales leads. We have another program handling the backend of that for reporting.
Technology White Papers
IT Executive Blogs
backend
Thank you very much. I was wondering about the backend. Could you possibly share what you are using please? Please feel free to private message me. thank you.
Lead collections & Generation
Marium,
The Find White Papers website is NOT running on Drupal. It is based on a proprietary PHP system. We integrate the registration forms/lead capture by using an iFrame and pulling content from a custom app.
In about 3 months we are relaunching the Find White Papers website completely revamping all the functionality, design, workflow, user registration, lead reporting, etc. I'll post the site here when it does launch.
The TechnologyVoices.com site is (hopefully) going to be a great way to drive traffic back to our Find White Papers site.
Best,
-=Vince
Technology White Papers
IT Executive Blogs
I see
No wonder. Thank you. I look forward to seeing the new site.