WordPress.org

1. flash87
   Member
   Posted 6 years ago #

   Sorry, but I don't see any posts in the forum that seem to fix this.

   I have all the minimum requirements satsified with my hosting server. I've walked carefully through all the setup steps and believe I have them correct. When I get to step 2, I see the errors below. Some of the tables don't get created and/or populated. Please help, and thanks!

   Second Step

   Now we’re going to create the database tables and fill them with some default data.

   WordPress database error: [Column 'meta_key' is used with UNIQUE or INDEX but is not defined as NOT NULL]
   CREATE TABLE wp_postmeta ( meta_id bigint(20) NOT NULL auto_increment, post_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY post_id (post_id), KEY meta_key (meta_key) )

   WordPress database error: [Column 'meta_key' is used with UNIQUE or INDEX but is not defined as NOT NULL]
   CREATE TABLE wp_usermeta ( umeta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) )

   WordPress database error: [You have an error in your SQL syntax near 'autoload = 'no' WHERE option_name = 'moderation_keys'' at line 1]
   UPDATE wp_options SET autoload = 'no' WHERE option_name = 'moderation_keys'

   WordPress database error: [You have an error in your SQL syntax near 'autoload = 'no' WHERE option_name = 'recently_edited'' at line 1]
   UPDATE wp_options SET autoload = 'no' WHERE option_name = 'recently_edited'

   WordPress database error: [You have an error in your SQL syntax near 'autoload = 'no' WHERE option_name = 'blacklist_keys'' at line 1]
   UPDATE wp_options SET autoload = 'no' WHERE option_name = 'blacklist_keys'

   WordPress database error: [You have an error in your SQL syntax near 'rel_id, post_id, category_id) VALUES (1, 1, 1)' at line 1]
   INSERT INTO wp_post2cat (rel_id, post_id, category_id) VALUES (1, 1, 1)

   WordPress database error: [You have an error in your SQL syntax near '('7669c5'), 'g3000@mac.com', NOW(), 'g3000', 'admin')' at line 1]
   INSERT INTO wp_users (ID, user_login, user_pass, user_email, user_registered, display_name, user_nicename) VALUES ( '1', 'admin', MD5('7669c5'), 'g3000@mac.com', NOW(), 'g3000', 'admin')

   WordPress database error: [Table 'press.wp_usermeta' doesn't exist]
   INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (2, 'wp_user_level', '10');

   WordPress database error: [Table 'press.wp_usermeta' doesn't exist]
   INSERT INTO wp_usermeta (user_id, meta_key, meta_value) VALUES (2, 'wp_capabilities', 'a:1:{s:13:"administrator";b:1;}');

   Finished!

   Now you can log in with the username "admin" and password "xxxxx".

   Note that password carefully! It is a random password that was generated just for you. If you lose it, you will have to delete the tables from the database yourself, and re-install WordPress. So to review:

   Username
   admin
   Password
   ********[password moderated]
   Login address
   wp-login.php

2. Mark (podz)
   Support Maven
   Posted 6 years ago #

   If you try a reinstall with a fresh upload of files does the error repeat?
   Does your host have other WP installs running correctly?

3. flash87
   Member
   Posted 6 years ago #

   Thanks for responding.

   Yep, I've tried three or four repeat installs and get the same errors. Every time I reinstalled I even used a fresh copy of all the files. My host (Verio) shouldn't be running any other installs. (It's a virtual private server account, and it's the first time I've ever tried putting a blog here.)

4. flash87
   Member
   Posted 6 years ago #

   Oh, I forgot to post this info, in case it matters:

   Verio, FreeBSD
   PHP Version 4.3.1
   Zend Extension
   MySQL Ver 12.22 Distrib 4.0.24

   Please help. I'm going mad reinstalling over and over! Thanks.

5. flash87
   Member
   Posted 6 years ago #

   And here's the Zend info:
   20021010
   Zend Engine v1.3.0

6. moshu
   Member
   Posted 6 years ago #

   Search for "zend" in the forum. Maybe it will help.

7. flash87
   Member
   Posted 6 years ago #

   I updated the Zend optimizer per that thread. Unfortunately, it didn't help. Still getting the same errors with a fresh install.

8. flash87
   Member
   Posted 6 years ago #

   Can anyone help? Please? I'm begging. =)

   I've tried everything I've seen referenced in the help forums. Thanks.

9. vkaryl
   Member
   Posted 6 years ago #

   Have you contacted Verio Support about this? If so, what was their response?

10. flash87
    Member
    Posted 6 years ago #

    They just said that they don't provide support for the WordPress application, and confirmed that I did indeed have the hosting requirements met as far as PHP and MySQL goes.

11. Mark (podz)
    Support Maven
    Posted 6 years ago #

    Does the blog work? Can you login?
    The database should have 9 tables at install, which are
    _categories
    _comments
    _linkcategories
    _links
    _options
    _post2cat
    _postmeta
    _posts
    _users
    what are you missing?

    In wp-config.php there are 4 lines of information you filled out. REMOVE YOUR PASSWORD and then post just that informatio here.

12. flash87
    Member
    Posted 6 years ago #

    Thanks for responding.

    Looks like it was unable to create the postmeta table, or populate the other tables. The install technically finishes (after all those syntax and database errors) and even gives me an admin username and password, but it couldn't populate the right table with those values, so I can't login. (When I check the database, the users table is empty.) So it doesn't even recognize the admin username.

    Here's the info from my wp-config.php again:
    define('DB_NAME', 'wordpress'); // The name of the database
    define('DB_USER', 'mbank'); // Your MySQL username
    define('DB_PASSWORD', '******'); // ...and password
    define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

13. Mark (podz)
    Support Maven
    Posted 6 years ago #

    Does your user have 'ALL' priviledges on the database?

14. flash87
    Member
    Posted 6 years ago #

    Yep, I followed these directions from codex in creating the database...

    mysql> GRANT ALL PRIVILEGES ON ''databasename''.* TO "''wordpressusername''"@"''hostname''"
    -> IDENTIFIED BY "''password''";
    Query OK, 0 rows affected (0.00 sec)

    mysql> FLUSH PRIVILEGES;
    Query OK, 0 rows affected (0.01 sec)

    ALTHOUGH, in my shell I notice that I get syntax errors if I do the quote marks exactly as they in the directions. I have to do it like this for it to take:

    mysql> GRANT ALL PRIVILEGES ON wordpress.* TO 'mbank'@'localhost'
    -> IDENTIFIED by '********';
    Query OK, etc. etc.

15. macuser7
    Member
    Posted 6 years ago #

    Can you create the tables that WordPress Dosent manaully and see if that works

16. flash87
    Member
    Posted 6 years ago #

    OK. Should I create them all before installation? Or try it after and it fails?

17. flash87
    Member
    Posted 6 years ago #

    Actually, I think I'm going to give up. There are a whole host of syntax errors to address besides the uncreated tables. It's too much of a hassle.

    Thanks to everyone who tried to help.

18. flash87
    Member
    Posted 6 years ago #

    OK...thought I'd try one more thing. (I'm not sure if the reply form will submit this right, but basically what i'm doing is taking out tickmarks and manually submitting commands and it's working.)

    It turns out MySQL doesn't like the backticks. In some cases, it doesn't like tickmarks at all. With my most recent attempted installation, when I go into the shell and try entering a command that failed, like...

    INSERT INTO wp_post2cat (rel_id, post_id, category_id) VALUES (1, 1, 1)

    ...it chokes. But if I change it to...

    INSERT INTO wp_post2cat (rel_id, post_id, category_id) VALUES (1, 1, 1)

    So, assuming I get it to work with all this manual setup, will it continue to work, or does WordPress code have these marks that will cause syntax errors with my installation of MySQL all the time? I'm confused.

19. flash87
    Member
    Posted 6 years ago #

    Well, that only worked with some of the failed MySQL statements. I have no idea how to manually enter the others and make the syntax work.

    I appreciate any other suggestions anyone might have. The only other thing I've thought of was to check the error log. Might this mean anything?

    [Tue Mar 21 10:26:46 2006] [warn] module php4_module is already loaded, skipping
    [Tue Mar 21 10:26:46 2006] [warn] module php4_module is already loaded, skipping
    [Tue Mar 21 10:26:46 2006] [warn] module php4_module is already loaded, skipping
    [Tue Mar 21 10:26:46 2006] [warn] module php4_module is already loaded, skipping
    [Tue Mar 21 10:26:46 2006] [warn] module php4_module is already loaded, skipping
    PHP Fatal error: Unable to load dynamic library 'mysql.so' - Shared object "mysql.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'msql.so' - Shared object "msql.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'imap.so' - Shared object "imap.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'ftp.so' - Shared object "ftp.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'mcrypt.so' - Shared object "mcrypt.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'gettext.so' - Shared object "gettext.so" not found in Unknown on line 0
    PHP Fatal error: Unable to load dynamic library 'sockets.so' - Shared object "sockets.so" not found in Unknown on line 0
    [Tue Mar 21 10:26:46 2006] [notice] Apache/1.3.33 (Unix) PHP/4.0.0 configured -- resuming normal operations

20. flash87
    Member
    Posted 6 years ago #

    If someone could just let me know if this is purely a hosting or server configuration issue, and has nothing to do with WordPress, that would help. I'm not getting any response from Verio and this will let me know if I have to really jump on them or find out if it's something I could fix myself. Thanks.

21. Chris_K
    Member
    Posted 6 years ago #

    Those aren't good errors -- and WP doesn't write them out. I'd, personally, start shopping for hosts.

22. Autarkes
    Member
    Posted 6 years ago #

    Hey, check your encoding -- I just found mine is now Latin1_swedish_ci and prior to upgrade it was UTF8_general_ci

    Now if I could figure out how to change the collation back I could see if that fixes things for me.

23. flash87
    Member
    Posted 6 years ago #

    Thanks for the idea. Where is the encoding set (and how do I change it)? In MySQL or the WordPress PHP scripts?

Topic Closed

This topic has been closed to new replies.