Syntax error in update statement

[Tickle]

Hi,

has anyone seen this error in V9? I get the error whenever I retrieve orders but it's only recently started. There seems to be no mention of this elsewhere on the forum.

[Jan]

What is the full error message?

Regards,

[Tickle]

It's the same as I've put in the title of this thread - not very helpful message.

[Tickle]

It doesn't seem to cause any problems with downloading but it's a bit worrying.

[Jan]

Try switching off autopurging of PSP pending orders, that might get rid of it, that's the only update SQL statement I can think of for order download.

Regards,

[Tickle]

You're a genius! - that stopped the error message.

A bug to note for the developers I think.

[Jan]

Were you using 9.0.0 tickle or 9.0.1?

Regards,

[Tickle]

9.0.0 at the moment - I'll update this post when I've upgraded.

[Jan]

Did you have lots and lots of PSP pending orders - more than 30 say?

Regards,

[Tickle]

No, it was even doing it even without any orders to download.

[Jan]

Actually I meant orders already downloaded but listed in the PSP pending tab.

Regards,

[Tickle]

I only had about 10 or so pending. I've removed those (1 remaining) and it still causes the error unless I leave the purge option switched off. I've now upgraded to 9.0.1 but that hasn't solved the problem.

I wonder whether this is linked to another problem I'm getting with it not updating stock levels -I can't see it would be. Here's a link to my other thread

http://community.actinic.com/showthread.php?t=36898

[fainster]

I have just upgraded from 8.04 to 9.01 and i have just started to have this error as well - i only had 1 pending in the psp and that was the order i downloaded which was a test order that i placed. I will try turning off the auto purging of psp pending orders and let you know what happens.

[guccij]

My 9.0.1 started off with this error, too. Uninstalling didn't help. Now it won't install zat all ... have given up for the moment as I can't be arsed when I've 8.5.3 running well.