Issue #6 invalid

Database error

stalliononline
repo owner created an issue

When running some tests on agentmid, I added a query for property OFFICELIST=MESA21. When query attempted to process 2012-04-11 22:53:00, received error. When removing added query, still receiving error.

Total Records: 1 - Office - Office | Query: (UID=MESA21) [1] Updated Office Total Records: 1 - Agent - Agent | Query: (UIDOFFICE=MESA21) [1] Updated Agent Total Records: 1 - Property - RES | Dates: 2012-04-11T22:53:00 - 2012-04-12T22:53:00 | Query: (MODIFIED=2012-04-11T22:53:00-2012-04-12T22:53:00),(OFFICELIST=MESA21),(LISTSTATUS=ACT),(INTERNETLIST_ALL=OMWS),(INTERNETDISPLAYYN=Y),((COUNTY=Tarrant)|(COUNTY=Rockwall)|(COUNTY=Denton)|(COUNTY=Dallas)|(COUNTY=Collin)) A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: database/DB_active_rec.php

Line Number: 0 A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/sandbox/public_html/iPALS-beta/application/libraries/resource.php:0)

Filename: core/Common.php

Line Number: 0 A Database Error Occurred

Error Number: 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 'WHERE ` IS NULL' at line 2

SELECT * WHERE ` IS NULL

Filename: /home/sandbox/public_html/iPALS-beta/libraries/resource.php

Line Number: 0

Comments (6)

  1. Cameron Spear
    • changed status to open

    isn't it OFFICEUID instead of OFFICELIST? I think the error is because false was returned on a RETS query. I'll put in code to notify you if a RETS query failed.

  2. Cameron Spear

    I just meant, in the agent query, you're using OFFICEUID, or whatever.

    I'm not quite sure what's causing this issue and I don't know why there's no line number. Somewhere it has to do with it expecting it to be an array and it's not, I think.

  3. Log in to comment