dbi_free_result: Invalid DBI result handle
Hi,
The following code is supposed to retrieve some stuffs from my database using AMXX v1.76a: Code:
The connection to the DB works, and the query doesn't fail. Most of the time, there is a row result (i.e., when the table isn't empty). The problem is at the last line ; every time it's executed, I've got a message in the error log: Code:
[MySQL] Invalid DBI result handle 54If you can explain me the reason for that error message, please do it, because I'm really tired of that error log pollution :| Thanks in advance :wink: |
Re: dbi_free_result: Invalid DBI result handle
as far as i know your sql qry is false.
You can't use an subselect to get an tablename. |
Re: dbi_free_result: Invalid DBI result handle
Quote:
|
Re: dbi_free_result: Invalid DBI result handle
Change your RESULT_NONE to RESULT_FAIL. See if that helps.
|
segfault in dbi_result ?
I've tried, but actually, since RESULT_FAILED < RESULT_NONE, it didn't change anything :(
I've changed the SQL query and added a few debug output: Code:
Code:
QUERY = SELECT MAX(`xp`) as `xp_avg` FROM `war3FTusers`Code:
QUERY = SELECT AVG(`xp`) as `xp_avg` FROM (SELECT `xp` FROM `war3FTusers` ORDER BY `xp` DESC LIMIT 0, 15) AS `best_players`Maybe my problem is related to this thread ? But I didn't find more details about that segfault in the AMXX's flyspray :| Using the 3 parameters form of dbi_result (with a float reference instead of a buffer), there's no error message anymore, so I guess it will work better this way ... Since it looks like my bug isn't a scripting one anymore, I guess I should not post anything more in that forum. BTW, thanks for the help ;) |
| All times are GMT -4. The time now is 06:43. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.