SQL Error from 1.0.7

[flotix]

Hello,

From 1.0.7 when i want to incarn a resseler i have this message :

Quote:PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number: no parameters were bound - Query: SELECT * FROM `domain` WHERE `domain_id` = ?

A solution? :s

---

An exception with the following message was raised in file
/var/www/ispcp/gui/include/sql.php (Line: 90):

=================================================================

PDOStatement::execute(): SQLSTATE[HY093]: Invalid parameter number:
no parameters were bound - Query:
SELECT
*
FROM
`domain`
WHERE
`domain_id` = ?

=================================================================

Debug backtrace:
---------------

File: /var/www/ispcp/gui/include/reseller-functions.php (Line: 568)
Function: exec_query()
File: /var/www/ispcp/gui/include/reseller-functions.php (Line: 370)
Function: get_user_props()
File: /var/www/ispcp/gui/reseller/index.php (Line: 178)
Function: generate_reseller_user_props()
File: /var/www/ispcp/gui/reseller/index.php (Line: 348)
Function: generate_page_data()

[tomdooley]

Seems like "created_by" has an invalid value for the domain in "admin" database table. Can you verify this?

[flotix]

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

[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

[Boss Online]

how ? can you write tutorial for this, i have it problem too. need help.