Errors with SQL queries???

17 years 10 months ago #16041 by dhoffman
Errors with SQL queries??? was created by dhoffman
I don't know if this is an actual problem, but today I happened to be looking in my log files and saw that the following entries were showing up any time I attempted to add or remove fields in the Field Manager. Any info or troubleshooting help would be appreciated.

I am using:
Joomla 1.0.9
Community Builder 1.0
Joomlaboard Forum 1.1.2

Thanks:

[code:1][Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 394
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 391
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 394
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 391
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 394
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 391
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 394
[Mon Jun 26 12:02:18 2006] [error] PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /site/includes/database.php on line 391
[/code:1]

Please Log in to join the conversation.

17 years 10 months ago #16055 by beat
Replied by beat on topic Re:Errors with SQL queries???
Doesn't tell which component / URL generates these errors...

Need to correlate with the accesses log...and if possible with the log of queries...

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

17 years 10 months ago #16066 by dhoffman
Replied by dhoffman on topic Re:Errors with SQL queries???
Like I said, any info or troubleshooting help is appreciated, but comments about what it doesn't show don't really tell me much, especially when I already covered the action that triggers the errors.

Like I said in the first note, it happens when I add or delete a field in Field Manager. I guess I was hoping that would help narrow it down for anyone who works with development of CB.

Apparently something is done to call functions in the database.php code and it is not being passed some argument correctly.

It doesn't seem to affect usability, when I add a field, it's there. And when I remove a field, it goes away. But it generates several errors like these each time. So if it's a bug, it's not critical. But if it is one, then I thought perhaps my noting it would have been considered helpful at the least.

Please Log in to join the conversation.

17 years 10 months ago #16077 by beat
Replied by beat on topic Re:Errors with SQL queries???
:ohmy: Oops, reading to much posts at the time with diagonal reading missed that part. Sorry. :blush:

Yes it helps. Yes, looks like a minor bug at first glance, but certainly worthwhile hunting for next release.

Could you please shortly log it at forge here:

forge.joomla.org/sf/tracker/do/listArtifacts/projects.cb/tracker.bugs?openPriority=all

with a link to this thread please ?

This will make sure it gets tracked down properly, when we fix bugs for next release.

Thanks again, and sorry again, thumbs (and Karma) up :)

Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

17 years 10 months ago #16090 by dhoffman
Replied by dhoffman on topic Re:Errors with SQL queries???
No sweat Beat. I know you read (and respond to) LOTS of posts on here, so I can understand.

I'll log into forge and log it there too.

Thanks,
David

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.208 seconds

Facebook Twitter LinkedIn