WordPress.org

Ready to get started?Download WordPress

Forums

How to fix my host's database error? (12 posts)

  1. airdisplays
    Member
    Posted 9 months ago #

    [Please do not post in all caps - it's considered yelling - topic decapped. Title fixed to be useful.]

    So my last thread was closed down because I offered to pay someone....now I need to learn.... but this is my expertise http://www.airdisplays.com anyway, would someone be so kind as to point me in the correct direction causing the error saying this....is there an easy fix?

    .php'), do_action('init'), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query UPDATE <code>wp_options</code> SET <code>option_value</code> = 'a:2:{i:1373664970;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}s:7:\"version\";i:2;}' WHERE <code>option_name</code> = 'cron' made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-load.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-config.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-settings.php'), do_action('init'), call_user_func_array, wp_schedule_update_checks, wp_schedule_event, _set_cron_array, update_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'theme_switched' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-load.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-config.php'), require_once('D:\hshome\markj\world-air-masters.com\wp-settings.php'), do_action('init'), call_user_func_array, check_theme_switched, get_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'rewrite_rules' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->parse_request, WP_Rewrite->wp_rewrite_rules, get_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'html_type' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->send_headers, get_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'show_on_front' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, WP_Query->parse_query, get_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'posts_per_page' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'comments_per_page' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option
    WordPress database error Table 'markj_wam.wp_posts' doesn't exist for query SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')  ORDER BY wp_posts.post_date DESC LIMIT 0, 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts
    WordPress database error Table 'markj_wam.wp_options' doesn't exist for query SELECT option_value FROM wp_options WHERE option_name = 'sticky_posts' LIMIT 1 made by require('D:\hshome\markj\world-air-masters.com\wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, get_option
  2. airdisplays
    Member
    Posted 9 months ago #

    apart from making a data base and the config file with the same data its obvious there is something else to do but what is it?

  3. SKTThemes
    Member
    Posted 9 months ago #

    @airdisplays:

    Understand your frustration. I am also new to this forum and learning the basics to help someone.

    Here is a link i found which might help you

    This is basically an old topic with similar problems.

    Please contact your host as a first option to check whether your hosting meets the min requirements criteria of wordpress as posted here.

    Hope this helps.

  4. airdisplays
    Member
    Posted 9 months ago #

    thanks SKT, beats me. going to take a look at http://www.joomla.org/ never know, maybe thats self installing, wait and see ! :)

  5. Spanka
    Member
    Posted 9 months ago #

    Hey Airdisplays,

    Having worked with Joomla for about 6 years now and wordpress for about 1 year, I can promise you: nearly everything (except very fine URL control) is easier with WordPress.

    On to your question - database isn't setup correctly. If you read the error message in plain english:

    1. "WordPress database error"
    2. "Table 'markj_wam.wp_options' doesn't exist....

    I've never seen this before. I cannot imagine what caused it. Every WP install for me has been seamless and less than about 2mins.

    If you're working on a local machine (ie: the file paths in your errors indicate this), wipe out the folder, delete the db. Create a new DB and reinstall fresh - could be just an unzip mangle or something.

    If that didn't work, do a google search on the exact repeated error (include the quotes for exact matching):

    "doesn't exist for query SELECT option_value FROM wp_options"

    From glancing through some of the pages, my best guess is that your environment is odd (doing something "cool" with CGI/FastCGI), or your environment does NOT meet WP's requirements, which I presume you've fully checked :)

    On your follow up post - unzip files to dir. Run config setup, which populates wp-config.php & the DB - there's nothing actually ELSE to WP. It's childishly straight forward. There are no other steps unless you want multi-site ability.

    If it goes wrong, it's always: your environment is unsuited, you put in an incorrect DB or similar, files got mangled or permissions for db/files are off. There's not much else to WP.

    Good luck with it.

  6. airdisplays
    Member
    Posted 9 months ago #

    thank you for your words spanka. so, ive tried deleting all files on the server and it advises me i cant do that... tried via FTP and also the servers own file manager, same error message Cant "delete files " Seams that WP is some sore of roaming thing thats looking for a host and then wont let go... so i tried deleting the domain from the host. that didn't work either as when i re-added the domain to host files were still there...so, ive given up, hope ive found someone who can do it for me and i take them flying, fair swap i guess.

    Linux OS is free of charge if you don't value your own time, ive found the same with WP !

    thanks for trying to help.

  7. esmi
    Theme Diva & Forum Moderator
    Posted 9 months ago #

    same error message Cant "delete files " Seams that WP is some sore of roaming thing thats looking for a host and then wont let go

    This is a server issue - not a WordPress one. You need to contact your hosts about it.

  8. alexmalexm
    Member
    Posted 8 months ago #

    I have 100% the same problem. How did you solve it?

  9. airdisplays
    Member
    Posted 8 months ago #

    well bit of a story as it beat the hosting peeps for a while. they had to delete it, I could not. Now im paying someone to set it all up for me. My host peeps are "historic" and don't do one button installing which is a shame. I've got another WP site which is perfect http://www.markjefferiesairdisplays.com hence liking WP but this "pain" setting up is not necessary.....

  10. alexmalexm
    Member
    Posted 8 months ago #

    ok thank you, I`ll try joomla I think)

  11. Spanka
    Member
    Posted 8 months ago #

    Sounds like your hosting environment doesn't have FTP permissions set up well, so that once you ran the install script, you no longer had write permissions on the file.

    This stuff can be messy if the hosting company isn't good with CMS systems.

    esmi is correct - this is a hosting issue.

    @alexmalexm: I can promise you a LOT MORE pain if you tried to run Joomla in the same environment :) Believe me - I've been there. Joomla is a nightmare if the hosting isn't good for it. If the hosting is good, it's great, but not as simple/easy as WP.

  12. alexmalexm
    Member
    Posted 8 months ago #

    Success! Ive made it). I dont know what was the problem, but when I unzipped one worpress theme before instalation of the whole wordpress shell everything was ok!))))))))))))))))))

Reply

You must log in to post.

About this Topic