iandol

Updates: OK, part of the problem is that WP doesn’t like using non alpha characters in the path (I’ll check mosquito and see if its known), so if I have:

http://ip.address.here/-/

As my root for the WP install, this causes a crash before getting to step 2. I made another install at:

http://ip.address.here/bs/

This time I get this error for the authors on step 1:

Warning: Attempt to assign property of non-object in C:wwwbswp-includeswp-db.php on line 241

Fatal error: Call to a member function query() on a non-object in C:wwwbswp-includeswp-db.php on line 244

There are ONLY two authors in the MT file, and their names map to already existing users in WP.

If I ignore that and click enter in one of the text fields, it starts to import a few entries, and then crashes Apache. This error is shown:

Warning: Invalid argument supplied for foreach() in C:\www\brainsource\wp-admin\import-mt.php on line 130

Warning: Invalid argument supplied for foreach() in C:\www\brainsource\wp-admin\import-mt.php on line 135

If I keep trying to reload, it keeps crashing after adding just a few more items, with more errors such as:

Warning: Attempt to assign property of non-object in C:wwwbrainsourcewp-includeswp-db.php on line 177
Post imported successfully...
Processing post... Temporal Evolution of Stereoscopic Processing...
Warning: Unknown list entry type in request shutdown (2358529) in C:wwwbrainsourcewp-includeswp-db.php on line 142

WordPress database error: [Duplicate entry '' for key 2]
INSERT INTO wp_users (user_level, user_login, user_pass, user_nickname) VALUES ('1', '', 'MD5 Hash was here!!!', '')

and

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 '0' at line 1]
0

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 'AND category_id = 27' at line 1]
SELECT * FROM wp_post2cat WHERE post_id = AND category_id = 27

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 ' 27)' at line 4]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 27)

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 'AND category_id = 28' at line 1]
SELECT * FROM wp_post2cat WHERE post_id = AND category_id = 28

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 ' 28)' at line 4]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 28)

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 'AND category_id = 27' at line 1]
SELECT * FROM wp_post2cat WHERE post_id = AND category_id = 27

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 ' 27)' at line 4]
INSERT INTO wp_post2cat (post_id, category_id) VALUES (, 27)

To reiterate: I run phpMyAdmin, Blog:CMS and WikkaWiki on this machine with NO problems – they NEVER crash either MySQL or Apache. Now this may not entirely be WP’s fault, but there is some specific instability that WP manages to evoke in Apache/MySQL…

Just to update this thread: I upgraded to V1.5 of WP, and the MySQL crash going to stage 3 of the install was fixed.

I’m using 4.1.9 – I will download 1.5 and check to see if it is resolved. Is there a particular recommended nightly?

Hmmm, I jst noticed this thread:

http://wordpress.org/support/topic.php?id=18010

Where others have noted crashes with recent MySQL versions, and suggest a downgrade. Can any developers comment on whether this issue is being addressed – it’d be nice not to have to depend on old versions of the core dev system to get things to work…

Here is the step 2 results (returned about 40 seconds after MySQL has crashed – though my service is set to restart automatically):

First we’re going to create the necessary blog tables in the database…

The first table has been created! …

The test post has been inserted correctly…

Categories are up and running…

Comments are groovy…

Post metadata table ready to go…

Option Tables created okay.

Option Data inserted okay.

Links option data inserted okay.

Database error: [Lost connection to MySQL server during query]
INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(86,’default_geourl_lat ‘, 8, 0.0, ‘The default Latitude ICBM value – see here’, 8, 20)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(87,’default_geourl_lon’, 8, 0.0, ‘The default Longitude ICBM value’, 8, 20)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_optiongroups (group_id, group_name, group_desc) VALUES(9,’Geo Options’, ‘Settings which control the posting and display of Geo Options’)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,84,1)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,85,1)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,86,1)

Database error: [Can’t connect to MySQL server on ‘localhost’ (10061)]
INSERT INTO wp_optiongroup_options (group_id, option_id, seq) VALUES(9,87,1)

Geo option data inserted okay.

OK. We’re nearly done now. We just need to ask you a couple of things:

What is the web address of your WordPress installation? (We probably guessed it for you correctly.)