flash87

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

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.

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

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.

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.

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

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.

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

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.

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

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

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

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

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.

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.)