BUG when you try to list all images

[Fernando Gietz]

Works!! Thanks

[Squeaner]

Tom, I’m having this issue with SVN Revision 2608. I can’t get the “List All Images” list to appear.

I’m finding the following error in apache.log.

[Mon Nov 10 10:08:19.920633 2014] [:error] [pid 15849] [client x.x.x.x:55628
] PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/fog/lib/d
b/MySQL.class.php on line 74, referer: [url]http://x.x.x.x/fog/management/index[/url]
.php?node=image&sub=edit&id=31

I replaced the IP addresses with x.x.x.x.

Let me know how I can help troubleshoot.

[Tom Elliott]

Should be fixed in 2609, the display of the error of mysqli you’re seeing is probably because you have display error’s on?

[Squeaner]

Tom, I installed SVN 2609, but the bug still seems to be present for me.

I checked my PHP config and “display_errors” and “display_startup_errors” to are both [B]Off[/B].

Here’s my configuration:
Ubuntu Server 14.04.1 LTS 64-bit
Apache2 - 2.4.7
PHP5 - 5.5.9-1ubuntu4.5
MySQL:
Version: 5.5.40-0ubuntu0.14.04.1
Version: 5.5.35+dfsg-1ubuntu1

Here’s the warnings from apache error.log

[Mon Nov 10 11:58:49.904242 2014] [:error] [pid 23103] [client 172.16.21.7:57448] PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 74, referer: [url]http://172.16.21.254/fog/management/index.php?node=image&sub=list[/url]
[Mon Nov 10 11:58:49.904819 2014] [:error] [pid 23103] [client 172.16.21.7:57448] PHP Warning: mysqli::select_db(): Couldn’t fetch mysqli in /var/www/fog/lib/db/MySQL.class.php on line 74, referer: [url]http://172.16.21.254/fog/management/index.php?node=image&sub=list[/url]

[url=“/_imported_xf_attachments/1/1497_foglog.txt?:”]foglog.txt[/url]

[Tom Elliott]

Forgive my brashness here, but I fail to understand how a warning is considered a bug?

[Squeaner]

It’s not, but I’m just trying to provide you with anything I can that will help you identify the root of the issue.

I appreciate all that you do. Keep up the good work.

[Tom Elliott]

I know what the issue is, but I don’t know of a good means to test.

Basically, it’s trying to detect if the database is available. If it’s not, (such as when it’s performing an upgrade and mysql is restarting) it’s going to throw the select_db() error.

[Tom Elliott]

Alright,

Hopefully this should be fixed.

[Tom Elliott]

Try the latest svn 2612 and it should, hopefully, be fixed.

[Squeaner]

Tom, I just installed the latest SVN Revision 2636 and still have the issue.

Let me know if I can help in any way to help troubleshoot.

[Tom Elliott]

[quote=“Squeaner, post: 38940, member: 350”]Tom, I just installed the latest SVN Revision 2636 and still have the issue.

Let me know if I can help in any way to help troubleshoot.[/quote]

Which issue? The select_db()?

[Squeaner]

Yes, the select_db(). The issue where when I choose “List All Images” and nothing is displayed.

Thanks.

[Tom Elliott]

I know what’s wrong. The select_db is still not it.

Can you give me a print out of imageID’s you have and the imageGroupAssociation tables?

[Tom Elliott]

Okay:

Please try 2637. I’m trying some better error handling, hopefully.

[Squeaner]

Tom, I just installed SVN 2637 and it worked!

[Squeaner]

[quote=“Tom Elliott, post: 38948, member: 7271”]I know what’s wrong. The select_db is still not it.

Can you give me a print out of imageID’s you have and the imageGroupAssociation tables?[/quote]

Tom, do you still need this information?

Thanks.

[Tom Elliott]

No,

Sorry I didn’t get back sooner. Yes you’ll likely still have the select_db messages, but no if all is working you should be good.

My guess is some of your images are setup without having a storage group assigned to them. All that release did was make it so it would “fail gracefully?” as I like to call it.