I have a new site setup with the following specs:
Dedicated Win server 2008 R2 Standard
IIS 7.5
PHP 5.2.14
MySQL 5.1
Wordpress 3.0.1
(these were installed using the Windows Web App Gallery installer)
Gold Cart 2.4
Cat. Importer 1.4
Prod. Importer Dlx 2.2
e-commerce 3.7.6.7
other misc plugins – shadowbox js, wp-mail-smtp
(I think thats everything…. )
I am trying to import from the sample .csv file hosted here at visser labs.
When I import categories, everything seems to work fine. No error messages and it says 5 imports successful. Problem is, there are no categories added. I get the same result when I try to import products with manually configured categories. I verified that there are no products being written to the table using phpmyadmin. If I add a test product by hand, I can see it in phpmyadmin, but none of the imported products show up.
I did some digging around, and found that there were some entries being written to C:windowstempphp-errors.log
This is what is there after one try with the sample .csv –
4 occurrences of :
[27-Aug-2010 21:07:23] WordPress database error Table ‘hp.wp_wpsc_checkout_forms’ doesn’t exist for query SELECT * FROM wp_wpsc_checkout_forms
WHERE active
= ‘1’; made by require_once, require_once, require_once, include_once, require_once, require_once, wpsc_purchaselogs->wpsc_purchaselogs, wpsc_purchaselogs->getall_formdata
and 1 occurrence of this for each category:
[27-Aug-2010 21:07:36] WordPress database error Field ‘description’ doesn’t have a default value for query INSERT INTO wp_wpsc_product_categories
(group_id
,name
,nice-name
) VALUES (‘1′,’Accessories’,’accessories’) made by do_action, call_user_func_array, vl_wpscci_html_page
Any ideas? This is a dedicated server just for this website, and I have full control of the server so any changes can be made.
Thanks