SAS Data Hard to get in

[deltacharlie]

Is SAS (ShareASale) data hard to import? I've tried two SAS data feeds tonight and both of them failed. I am on the 15 day trial and set up a pretty simple post template to use during import. I then went to run the cron job manually via web browser.

Both failed with a similar error:

Importing XXXXX.txt...
Starting at line #0 and character #0<div id='error'>
<p class='wpdberror'><strong>WordPress database error:</strong> [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 'WHERE ID = 2' at line 1]<br />
<code>UPDATE wp_wfreview_jobs SET status = 2, last_run = 1265954948, last_result = 'Imported posts', progress_posts = WHERE ID = 2</code></p>
</div>done.
All jobs completed.
Updating category counts... done.
Updating tag counts... done.
Deleting blog posts... done.

Thanks

[deltacharlie]

Looks like somebody else found this today also:

http://www.reviewpluginforwordpress.com/support/showthread.php?t=743&highlight=wp_wfreview_jobs

[WFReviewAdmin]

This issue has been fixed in 3.1.5. Thank you!

[deltacharlie]

I hope 3.1.5 was released in the past 6 hours. I just DLed and installed.

[deltacharlie]

Some issues I've noticed - and I am still working with SAS.

1. In some cases only the first couple of words are being imported from the description field. The field may say "Free Shipping! yada yada yada" and the site only imports "Free Shipping". In other cases it is not getting the first sentence or two and leaving off the rest.

2. In some cases it is leaving off prices. Not just the data - the entire line where I put "Price: $ [pricefield]" is completely missing even though it is in the template. Same thing going on with other fields.

[WFReviewAdmin]

Send your csv to support@reviewpluginforwordpress.com and I will take a look. Thanks!

[deltacharlie]

Done Lucas. Thanks.