The MU forums have moved to WordPress.org

WordPress database error on install (35 posts)

  1. UsmanLaw
    Member
    Posted 17 years ago #

    What does all this mean? How can I fix it? Sorry if this has been asked.

    WordPress database error: [Table 'usmanlaw_BlogsByTopic.wp_1_options' doesn't exist]
    SELECT option_name FROM wp_1_options WHERE option_name = 'wp_hashcash_rand'

    WordPress database error: [Table 'usmanlaw_BlogsByTopic.wp_1_options' doesn't exist]
    SELECT option_name FROM wp_1_options WHERE option_name = 'wp_hashcash_rand'

    WordPress database error: [Table 'usmanlaw_BlogsByTopic.wp_1_options' doesn't exist]
    INSERT INTO wp_1_options (option_name, option_value, option_description, autoload) VALUES ('wp_hashcash_rand', '', '', 'yes')

    WordPress database error: [Table 'usmanlaw_BlogsByTopic.wp_1_options' doesn't exist]
    UPDATE wp_1_options SET option_value = '10521082' WHERE option_name = 'wp_hashcash_rand'

    Could Not Find Blog!
    Searched for blogsbytopic.com/wpmu/ in usmanlaw_BlogsByTopic::wp_blogs table. Is that right?
    Please check that your database contains the following tables:
    wp_blogs
    wp_users
    wp_usermeta
    wp_site
    wp_sitemeta
    wp_sitecategories

  2. dronamraju
    Member
    Posted 17 years ago #

    I have been stuck at this same level for the past day. I investigated into the code. Here's what i understand.
    On august 17th, a new plug in was added "wp-hashcash.php". This is adding options BEFORE the tables were created.
    So if you got the version prior to august 17th you are doing well.
    I think this has to do with how the initia blog is created. It used to be done through function calls and seems like it was moved into a plug in.
    I just wish the developer did some basic testing before releasing this change into nightly build. I dont' want to sound critical, this person seems to be doing a great job with the whole software, but this just seems like basic testing is missing.
    Does any one have a prior version of build to download?

  3. UsmanLaw
    Member
    Posted 17 years ago #

    guess not?

  4. VicenteBalvanera
    Inactive
    Posted 17 years ago #

    I do have the 8-14 version; but suppose things will get fixed soon. How can I get it to you?

  5. UsmanLaw
    Member
    Posted 17 years ago #

    Eiter host it and we can download it or email it.
    UsmanLaw@gmail.com

    Thanks a lot!

  6. lucid1
    Inactive
    Posted 17 years ago #

    I put the download from 8-16 here http://anyonesblog.com/lucid1/wpmu-unstable-8-16.tar.gz

    if anyone official has a problem with me putting that there, please let me know....
    thanks

  7. dronamraju
    Member
    Posted 17 years ago #

    Thank you!!
    Downloaded this version and got past the errors! thank you very much!

    However, I am able to go through the installation process and it redirects me to the main page (www.mysite.com) and when i go there, it is asking me to go through the install again.

    lucid1, can you help me?

    thank you in advance

  8. UsmanLaw
    Member
    Posted 17 years ago #

    We must be doing something wrong

  9. lucid1
    Inactive
    Posted 17 years ago #

    sorry, that is not an error I am familier with... I am not a developer, just a tinkerer... perhaps after the weekend one of them will come on and help you. Maybe sooner even... good luck!

  10. dronamraju
    Member
    Posted 17 years ago #

    This is a problem with my apache directives. I had to set
    "AllowOverride All" in my apache conf file and now everything works fine

  11. UsmanLaw
    Member
    Posted 17 years ago #

    How do you do that? is that like the 777 thing?

  12. dronamraju
    Member
    Posted 17 years ago #

    Hmm, can you edit the virtualhost configuration for your apache server? This has to be a line with in your apache server configuration file.

  13. UsmanLaw
    Member
    Posted 17 years ago #

    This is probaly something my Host is suppose to do. I will email them.

  14. Farms
    Member
    Posted 17 years ago #

    Good plan, I just ask mine to, ahem:

    " Hiya,

    Please can you create a dns wildcard alias and an apache wildcard virtual hosts for ladedadeda.com

    Cheers, James "

    And it works... programming for dogs :D

  15. SEbasic
    Inactive
    Posted 17 years ago #

    I've downloaded the version you provided - I just can't get past the

    "Please check that your database contains the following tables:
    wp_blogs
    wp_users
    wp_usermeta
    wp_site
    wp_sitemeta
    wp_sitecategories"

    bit...

    I'm going nuts here - Tried on 3 different servers and keep getting errors...

    It's got to be something I'm doing, I just can't see where I'm going wrong at all.

    I've tried changing the table prefix from wp_ to mu_

    I've tried the latest rebuilds - the old one provided above - everything I can think of...

    Any ideas anyone?

  16. UsmanLaw
    Member
    Posted 17 years ago #

    Im still stuck there to

  17. SEbasic
    Inactive
    Posted 17 years ago #

    I posted in another thread too...

    Doesn't look like support reaches this far yet...

    It's a shame - such a great bit of software, and I just can't use it yet...

  18. donncha
    Key Master
    Posted 17 years ago #

    There is support, but it's limited and not infinite. Did you install into the root of your server or into a directory? Try the root, might work better!

  19. UsmanLaw
    Member
    Posted 17 years ago #

    I thought you have to put it in the wpmu folder?

  20. hpatoio
    Member
    Posted 17 years ago #

    Hej, I had the same problem.

    The point is that the installation wizard creat a line in wp_blogs with the field "path" with a "/" less.

    For example for me was "/wp" instead od "/wp/" ... once I changed this the BLOG appeared.

    Hope this help

    Simone

  21. UsmanLaw
    Member
    Posted 17 years ago #

    This is what I see in wp_blogs/path

    * If field type is "enum" or "set", please enter the values using this format: 'a','b','c'...
    If you ever need to put a backslash ("\") or a single quote ("'") amongst those values, backslash it (for example '\\xyz' or 'a\'b').
    ** For default values, please enter just a single value, without backslash escaping or quotes, using this format: a

    What do I do with that?

  22. hpatoio
    Member
    Posted 17 years ago #

    Actually in my DB the field "path" in the table "wp_blog" is a varchar(100) ... so.

    I've installed the last version of WordpressMU, the one is on download now.

    Simone

  23. UsmanLaw
    Member
    Posted 17 years ago #

    Reinstalled the latest version, Its varchar 100, still getting the same thing, dont see where i would add the \, still gettin the same error

    things are looking bleak

  24. SEbasic
    Inactive
    Posted 17 years ago #

    There is support, but it's limited and not infinite. Did you install into the root of your server or into a directory? Try the root, might work better!

    I understand that - It wasn't a dig... :)

    I have installed it in the root (Well, example.com/wpmu/)

    That is the directory the site has to sit in right?

    The DB tables are *certianly* there, so I just don't see why it's not seeing them. :)

    Cheers

  25. hpatoio
    Member
    Posted 17 years ago #

    To UsmanLaw,

    can you please tell me how many lines you have in the table "wp_blog" (should be one) and the content of them/it ?

  26. UsmanLaw
    Member
    Posted 17 years ago #

    I have 7 fields. 3 lines in the path field. Did I answer that right?

  27. hpatoio
    Member
    Posted 17 years ago #

    you forgot the values of them ... ;-D

  28. deadlyromio
    Member
    Posted 17 years ago #

    I get this with newest build...

    Fatal Error
    Could Not Find Blog!
    Searched for xxxxxxx.info/wpmu/ in xxxx_blogs::wp_blogs table. Is that right?
    Please check that your database contains the following tables:
    wp_blogs
    wp_users
    wp_usermeta
    wp_site
    wp_sitemeta
    wp_sitecategories
    If you suspect a problem please report it to support forums!

    I checked it but to no success. Any help or quick fix...also didn't look like it created a subdomain as you can see by url? Is this how the url is suppose be for install?

  29. UsmanLaw
    Member
    Posted 17 years ago #

    Not sure what you mean by value.
    Maybe this is what it is.
    Statements Value
    Format dynamic
    Rows 1
    Row length ø 52
    Row size ø 5,172 Bytes
    Next Autoindex 2
    Creation Aug 24, 2005 at 05:51 PM
    Last update Aug 24, 2005 at 05:51 PM

  30. donncha
    Key Master
    Posted 17 years ago #

    Install WPMU into the root of your webserver, not /wpmu/ - it's a pain but it's buggy otherwise. If you can fix the bug and mail me a patch it'd be great though!

About this Topic

  • Started 17 years ago by UsmanLaw
  • Latest reply from UsmanLaw