My Installation Troubles and their Solutions

Here are some solutions to problems I had after first installing WordPress:

1- in the wp-config file, had to set $table_prefix = ‘wordpress.wp_’;

2- in the database, since the app. folder was not off the root of the domain, I had to change the ‘site_url’ in the wp_options table to ‘https://localhost:8080/fun/wordpress/’ so the context would be correct for the php code

3- ran across the following error:
‘Field ‘pinged’ doesn’t have a default value’
solution::
the following 3 fields in the “wp_posts” table had to be set to “Allow Nulls”:

1) to_ping
2) pinged
3) post_content_filtered

end solution::

4- was getting an error ‘Invalid argument supplied for foreach() in /wp-includes/functions.php ln 1161’
solution :: had to add a category to the wp_categories table

5- the post.php file needs to have an sql insert statement (INSERT INTO $wpdb->posts) changed at line 140; the ID needs to be removed from the query because it is autogenerated

6- the wp-includes/links.php file needs to be modified at lines 536 and 537 to be (the single quotes that were wrapped around the table names was causing problems):
FROM “.$wpdb->links.”
LEFT JOIN “.$wpdb->linkcategories.” ON (link_category = cat_id)