possibly currupted database

somethings fishy.... my modules page is showing
Optionwidgets (missing)
Taxonomy_manager (missing)

also, views is warning that fields that existed this morning "don't exist"

also, CCK is warning: "This content type has inactive fields. Inactive fields are not included in lists of available fields until their modules are enabled."

i'm still investigating what might have gone wrong but looks like a module may have got currupted somehow....

Content Taxonomy Options seems to be currupted in that the modules page is showing Optionwidgets as missing eventhough it should be part of CCK. I tried re-uploading a clean version of Content Taxonomy to the site, but i'm still having the same issue. I am wondering if i have to uninstall Content Taxonomy, and then re-enable it? I've used Content Taxonomy on quite a few content types.

Alternativly, i suppose i can revert to a 20 hour old backup of the database :(

I'm not sure of the best plan of attach here....

It appears what initially caused the problem was my FTP program. Files within CCK ended up missing (or possibly currupted) on the way up to the server.

Still getting some errors.. Now i'm trying to clean up.

# user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC, node_created DESC LIMIT 0, 3' at line 14 query: SELECT DISTINCT(node.nid) AS nid, node_data_field_embedded_video_upload.field_embedded_video_upload_embed AS node_data_field_embedded_video_upload_field_embedded_video_upload_embed, node_data_field_embedded_video_upload.field_embedded_video_upload_value AS node_data_field_embedded_video_upload_field_embedded_video_upload_value, node_data_field_embedded_video_upload.field_embedded_video_upload_provider AS node_data_field_embedded_video_upload_field_embedded_video_upload_provider, node_data_field_embedded_video_upload.field_embedded_video_upload_data AS node_data_field_embedded_video_upload_field_embedded_video_upload_data, node_data_field_embedded_video_upload.nid AS node_data_field_embedded_video_upload_nid, node.type AS node_type, filesize, node.created AS node_created FROM node node INNER JOIN content_field_featured_video_embedded node_data_field_featured_video_embedded ON node.vid = node_data_field_featured_video_embedded.vid LEFT JOIN content_type_embedded_video node_data_field_embedded_video_upload ON node.vid = node_data_field_embedded_video_upload.vid WHERE node_data_field_featured_video_embedded.field_featured_video_embedded_value = 'Featured' ORDER BY node_data_field_embedded_video_upload_field_embedded_video_upload_embed DESC, DESC, node_created DESC LIMIT 0, 3 in /home/xxxxx/public_html/sites/all/modules/views/includes/view.inc on line 723.
# user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IS NOT NULL) AND (node_data_field_featured_image.field_featured_image_value = 'F' at line 5 query: SELECT DISTINCT(node.nid) AS nid, node.created AS node_created FROM node node INNER JOIN content_type_image_post node_data_field_featured_image ON node.vid = node_data_field_featured_image.vid WHERE (.filesize IS NOT NULL) AND (node_data_field_featured_image.field_featured_image_value = 'Featured') ORDER BY node_created DESC LIMIT 0, 3 in /home/xxxxxxx/public_html/sites/all/modules/views/includes

Update:

the missing / currupted files caused some modules to be automatically deselected.

re-selecting those, with proper files uploaded fixed the problem.