[ic] Customer Housekeeping & IC 4.8.7 - Resend
mark at vwe.net
Fri Mar 4 11:41:02 EST 2005
At 16:08 04/03/2005, you wrote:
>>>This is untested...
>>>SELECT userdb.username from userdb LEFT JOIN transactions ON
>>>userdb.username=transactions.username WHERE transactions.code IS NULL
>>>AND FROM_UNIXTIME(mod_time) < SUBDATE (NOW(), INTERVAL 1 MONTH);
>>Many thanks for the select :)
>>Sadly it also fails in a similar way to the previous one and spews an
>>error about (NOW(), INTERVAL 1 MONTH) which would indicate it doesn't
>>like anything after < SUBDATE.
>>I suspect the solution is to upgrade to a newer version of MySQL as
>>clearly 3.23 is lacking in a fair bit of functionality.
>>Once again, many thanks for your help :)
>I use MySQL 3.23.58 and I pasted the query above into phpMyAdmin and it
>ran fine. Do you have any more information about the error?
I'm using mysql-server-3.23.49-3 and the exact error given by webmin is:
Failed to execute SQL : SQL SELECT userdb.username from userdb LEFT JOIN
transactions ON userdb.username=transactions.username WHERE
transactions.code IS NULL AND FROM_UNIXTIME(mod_time) < SUBDATE (NOW(),
INTERVAL 1 MONTH); failed : You have an error in your SQL syntax near
'(NOW(), INTERVAL 1 MONTH)' at line 1
vwe internet ltd
PO BOX 1067
Shop - http://www.eros-shop.co.uk
EMail - info at eros-shop.co.uk
Tel - 0870 284 3369
Fax - 0870 284 4469
More information about the interchange-users