aengineer

I finally got it installed. To do so I had to take the following steps and am not sure which one solved the problem.

1) Deleted all previous WP folders locally and on the server
2) Deleted the DB on the server and then recreated it
3) Forced new password on the database – same as old one
4) Unpacked WP to the folder where I wanted it, then renamed that folder to the name I wanted “at”, rather than copying files to the “at” folder from somewhere else.
5) Recreated the wp-config.php file, exactly as before, but typing in the information afresh.

Somehow this did it.

Hmmmmm.

Yes I’m sure. I installed it to the same database using almost exactly the same wp-config.php file two days before (and deleted all those tables before starting to install this time – as well as changing the prefix).

The reason I started again was that I anticipate having multiple blogs and decided to have a directory structure in which all blogs live in a directory named “wp”

Jim Mitchell

I tried to follow moshu’s advice – with no luck. Here’s what I did.
– deleted all the files
– changed the directories to lower case – it’s now jcm2044.net/wp/at
– unzipped the wp file into a folder locally
– moved those files into the local …./jcm2044.net/wp/at folder
– edited the wp-config.php file in dreamweaver to the same state as before except now the table prefix is “at_”
– uploaded all the files via dreamweaver
– ran the install script.

As before, step 2 produces lots of SQL errors – the first few are below.

I’m baffled.

Jim Mitchell

*******************

Second Step

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

WordPress database error: [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 ‘usermeta ( umeta_id bigint(20) NOT NULL auto_increment, use]
CREATE TABLE at_ 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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘options (option_name, option_value, option_description, autoloa]
INSERT INTO at_ options (option_name, option_value, option_description, autoload) VALUES (‘siteurl’, ‘https://jcm2044.net/wp/at’, ‘WordPress web address’, ‘yes’)

WordPress database error: [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 ‘options (option_name, option_value, option_description, autoloa]
INSERT INTO at_ options (option_name, option_value, option_description, autoload) VALUES (‘blogname’, ‘My Weblog’, ‘Blog title’, ‘yes’)

……………

Thanks. I could have sworn I had r/w access, but you pushed me to go back and check on the host. Indeed I didn’t. It has now installed as promised.

Jim Mitchell

Help again. I’m not sure what you mean by the “read and write check boxes”. Is that in the MySQL admin, or in the server permissions, or is it something in the WP configuration – and if so, where?