SQL Error from 1.0.7

[sykosoft]

(12-04-2010 11:23 PM)flotix Wrote:  The value is correct.
But is not a domain, it's a resseler.

---

For domain it's ok, it's just for resseler, there are this error

---

No problem with a new resseler :s

Is there any update to this? It's happening to me also with one reseller. I've checked several database tables (admin, domains, etc) and see no abnormal values.

Michael

---

(12-17-2010 12:46 PM)sykosoft Wrote:  

(12-04-2010 11:23 PM)flotix Wrote:  The value is correct.
But is not a domain, it's a resseler.

---

For domain it's ok, it's just for resseler, there are this error

---

No problem with a new resseler :s

Is there any update to this? It's happening to me also with one reseller. I've checked several database tables (admin, domains, etc) and see no abnormal values.

Michael

I found my problem:

I had a mismatch (don't know how or why) in admin and domain for an admin_id and a domain_admin_id, where in the admin table, the domain user had an id of 128, in domain, the domain_admin_id was 126. Don't know how this happened, but that mismatch was causing this problem. I found this by turning on my mysql general query log, looking at the last few queries, where I could tell that it was bombing, and is was a select from domain where domain_admin_id = x (which when executed manually returned an empty set).

Michael