Page 1 of 1

4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 09:23
by Jools
All,

The environment that supports PlanetCatfish has been upgraded. This affects a number of things but in the main how it interacts with the database. The upshot is that you'll see errors relating to "mysql" or similar. I'm fix these up over the next day or two. Feel free to post specific URLs here if you want something checked out. I'll keep everyone updated on progress.

Cheers,

Jools

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 15:48
by bekateen
Hi Jools,

I typed L427 in the search box and I received this reply.

Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 15:55
by bekateen
And this, trying to view the Genus CLOG page for Ancistomus:
http://planetcatfish.com/ancistomus#2292

Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 19:01
by bekateen
At the bottom of the front page there are three errors listed at the end of the text for Book Reviews, Shane's World, and Site Information.

Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 21:38
by Jools
bekateen wrote:I typed L427 in the search box and I received this reply.
Fixed this one, thanks.

Jools

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 21:43
by Jools
bekateen wrote:And this, trying to view the Genus CLOG page for Ancistomus:
http://planetcatfish.com/ancistomus#2292
Fixed!

Jools

Re: 4th September 2016 : Database errors etc

Posted: 04 Sep 2016, 22:35
by bekateen
Great work, Jools. :-)

Re: 4th September 2016 : Database errors etc

Posted: 05 Sep 2016, 06:17
by jac
I wanted to look up Auchenipteridae but got this:

[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 145: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 146: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 147: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 160: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 161: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 162: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 181: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 189: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 204: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 205: mysql_close() expects parameter 1 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 229: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3931)

Re: 4th September 2016 : Database errors etc

Posted: 06 Sep 2016, 06:56
by bekateen
One more: Tried to look at Family Loricariidae http://www.planetcatfish.com/loricariidae, and obtained this:

[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 145: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 146: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 147: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 160: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 161: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 162: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 181: mysql_query() expects parameter 2 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 189: mysql_fetch_assoc() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 204: mysql_free_result() expects parameter 1 to be resource, null given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 205: mysql_close() expects parameter 1 to be resource, object given
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/404_redirecter.php on line 229: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3931)


Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 06 Sep 2016, 11:04
by Jools
jac wrote:I wanted to look up Auchenipteridae but got this:
is fixed!

Jools

Re: 4th September 2016 : Database errors etc

Posted: 06 Sep 2016, 11:05
by Jools
bekateen wrote:One more: Tried to look at Family Loricariidae http://www.planetcatfish.com/loricariidae

fixed!

Jools

Re: 4th September 2016 : Database errors etc

Posted: 06 Sep 2016, 14:00
by bekateen
:-BD

Re: 4th September 2016 : Database errors etc

Posted: 07 Sep 2016, 05:50
by jac
Thanks Jools :YMHUG:

It looks like this morning we've got a spammer X_X

Re: 4th September 2016 : Database errors etc

Posted: 07 Sep 2016, 05:59
by bekateen
Yup. Sigh...

Re: 4th September 2016 : Database errors etc

Posted: 07 Sep 2016, 08:48
by Jools
Sorted.

Jools

Re: 4th September 2016 : Database errors etc

Posted: 08 Sep 2016, 05:00
by Dave Rinaldo
Related problem? I noticed Aquatic Republic hasn't been up for a couple of days.
http://www.aquaticrepublic.com/

Re: 4th September 2016 : Database errors etc

Posted: 09 Sep 2016, 06:39
by jac
Hi Jools, I just posted a reply and used the clog tag. When posted on the forum the picture does not come up when hovering above it with the mouse ;). Haven't tried it with other blog tags, so don't know if it's only this one or more.
This is the thread: http://www.planetcatfish.com/forum/view ... 96#p300896

Re: 4th September 2016 : Database errors etc

Posted: 09 Sep 2016, 21:07
by Jools
Dave Rinaldo wrote:Related problem? I noticed Aquatic Republic hasn't been up for a couple of days.
http://www.aquaticrepublic.com/
Dave,

Sometimes your genius shines so bright I have to wear shades. Yes, the problem I've been trying to resolve for days IS replicated at AR and it IS becuase of some old cached files which I figured out when you made me look in that direction.

Have a cold one for me,

Jools

PS AR is back up!

Re: 4th September 2016 : Database errors etc

Posted: 10 Sep 2016, 00:45
by bekateen
Next - I tried typing CW006 in the quickfind search box. When I complete typing the letters "CW006" the popup thumbnail image of the cory appears, and I can click directly on that and it works to take me to the clog page. BUT, if instead I hit the <enter> or <return> key I get a message saying "no results found" rather than being taken to a screen showing all the fish that fit the search term.

Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 14 Sep 2016, 00:36
by Jools
bekateen wrote:Next - I tried typing CW006 in the quickfind search box. When I complete typing the letters "CW006" the popup thumbnail image of the cory appears, and I can click directly on that and it works to take me to the clog page. BUT, if instead I hit the <enter> or <return> key I get a message saying "no results found" rather than being taken to a screen showing all the fish that fit the search term.
Aha! Tricky one that, it's fixed now - thanks for reporting.

Jools

Re: 4th September 2016 : Database errors etc

Posted: 14 Sep 2016, 08:16
by bekateen
Two more, both on the Edit spawning report data entry page.

First, on the edit screen there is a multi-line error message visible when window size is reduced:
[phpBB Debug] PHP Warning: in file /home/webcat/planetcatfish.com/common/functions/display_food_list.php on line 36: mysql_num_rows() expects parameter 1 to be resource, object given
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5339: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3931)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5339: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3931)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5339: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3931)
Second, when you try to enter a food option, no matching foods appear. Instead, when you type the fourth letter of your desired food, an error message appears.
feed.jpg
Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 17 Sep 2016, 13:49
by Jools
I think the two errors on the Edit Spawning report page are now fixed. I've made the last enviromental change now, so there may be a few new errors across the site I've not identified. So, nearly there but please keep reporting anything you find.

Cheers,

Jools

Re: 4th September 2016 : Database errors etc

Posted: 18 Sep 2016, 08:27
by jac
jac wrote:Hi Jools, I just posted a reply and used the clog tag. When posted on the forum the picture does not come up when hovering above it with the mouse ;). Haven't tried it with other blog tags, so don't know if it's only this one or more.
This is the thread: http://www.planetcatfish.com/forum/view ... 96#p300896
Maybe you missed this post, or it is not that important maybe ;)
If you use the clogs and you hover above it with your mouse, the pictures don't show.

Re: 4th September 2016 : Database errors etc

Posted: 18 Sep 2016, 16:05
by Jools
jac wrote:
jac wrote:Hi Jools, I just posted a reply and used the clog tag. When posted on the forum the picture does not come up when hovering above it with the mouse ;). Haven't tried it with other blog tags, so don't know if it's only this one or more.
This is the thread: http://www.planetcatfish.com/forum/view ... 96#p300896
Maybe you missed this post, or it is not that important maybe ;)
If you use the clogs and you hover above it with your mouse, the pictures don't show.
Sorry, I thought I'd fixed it. or any other doesn't indeed work. I will check it.

Jools

Re: 4th September 2016 : Database errors etc

Posted: 29 Sep 2016, 00:34
by bekateen
Hi Jools,

I just received an email notice from you that the Distribution data for L486 has been changed to [Rio Caura, Venezuela] from []. And yet when I look at the CLOG page, there is no text in the Distribution field stating “Rio Caura, Venezuela” (I'm specifically referring to the text in that field, not to the Google map occurrence data; I added that manually and it's working fine).

I also notice that on the PC front page, the [changes] field which appears beside the name Ancistrus sp. L486 (in the Cat-eLog Species Updates window on the right side of the screen) has a pop-up window which is not functioning properly. Onmouseover, this should pop up with a screen that states,
Original_desc changed to [-] from [].
Distribution changed to [Rio Caura, Venezuela.] from [].
However, when I hover my mouse over the word [changes], all I see is a thin horizontal black line without text.
error.png
Perhaps this is related to the recent website update?

Cheers, Eric

Re: 4th September 2016 : Database errors etc

Posted: 03 Nov 2016, 21:30
by Jools
So, quick find, the android app, the hover over clog tag in the forums and bug on the species updates are all now fixed, tested and working as of this post.

The last one, regarding species updates, will not show as fixed until new species updates are made in which case it should then provide updated data.

Cheers,

Jools