Over populated where clause on leftjoin

6 posts by 3 authors in: Forums > CMS Builder
Last Post: April 28, 2016   (RSS)

By Daryl - April 21, 2016

Hi Jeff,

It seems like the function doesn't add the table name to "createdByUserNum".
Ie:

AND ((`members`.`createdByUserNum` = '1')

I will look into this and let you know.

Thanks,

Daryl Maximo
PHP Programmer - interactivetools.com

By kitsguru - April 21, 2016 - edited: April 21, 2016

HI Daryl,

BUT none of the extra columns is needed or wanted. So the fact that the table name is missing is not really the issue.

Jeff

Jeff Shields

By Daryl - April 21, 2016

You're right, the 'createdByUserNum', and the other fields, shouldn't be included at all.

I will check this out and let you know ASAP.

Cheers,

Daryl Maximo
PHP Programmer - interactivetools.com

By Daryl - April 27, 2016

Hi Jeff,

I can't replicate the issue on my local test server.

I'd like to take a closer look if you don't mind. Could you send through a second level support request?

https://www.interactivetools.com/support/email_support_form.php

Thanks,

Daryl Maximo
PHP Programmer - interactivetools.com

By Damon - April 28, 2016

Hi Jeff,

We recently moved to a new server and are having some issue with email forms. If you have sent in a Support Request, could you resend the details (CMS Builder login, FTP) to us directly at support@interactivetools.com.

Thanks!

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/