Active to Inactive (Client Status SQL)

[Dedigeeks-Sean]

Hello,

 

I remember a user on this forum quite a while ago advised on an SQL you could run to turn "Active" clients "Inactive" if they had an inactive "Affiliate, Hosting, & Domain" service.

 

Something like this:

 

Switching where "active" to "inactive" where has no domains (or all cancelled 6+months ago) and has no hosting (or all cancelled 6+months ago) and no telephone calls in 6+months and no support tickets in 6+months

Switching where "inactive" to "active" where domain.status in Active/Pending/Pending Transfer/Expired

Switching where "inactive" to "active" where hosting.status in Active/Pending/Suspended

Switching where "inactive" to "active" where in tblAffiliates

 

Unfortunately this cannot run under SQL anymore for me:

 

#1064 - 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 'Switching where "active" to "inactive" where has no domains (or all cancelled 6+' at line 1

 

 

Does anyone know any other way to manage this same operation?

[othellotech]

Your SQL error is because you're sending "english" into an sql command

[Dedigeeks-Sean]

Hey

 

Can you assist me with the correct command line?