4th September 2016 : Database errors etc

The title says it all.
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

4th September 2016 : Database errors etc

Post 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
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post by bekateen »

Hi Jools,

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

Cheers, Eric
Attachments
wp_ss_20160904_0002.png
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post by bekateen »

And this, trying to view the Genus CLOG page for Ancistomus:
http://planetcatfish.com/ancistomus#2292

Cheers, Eric
Attachments
wp_ss_20160904_0003.png
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post 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
Attachments
wp_ss_20160904_0004.png
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post by Jools »

bekateen wrote:I typed L427 in the search box and I received this reply.
Fixed this one, thanks.

Jools
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post by Jools »

bekateen wrote:And this, trying to view the Genus CLOG page for Ancistomus:
http://planetcatfish.com/ancistomus#2292
Fixed!

Jools
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post by bekateen »

Great work, Jools. :-)
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
jac
Posts: 1223
Joined: Sat Apr 19, 2008 1:56 pm
My articles: 3
My images: 71
My cats species list: 81 (i:0, k:9)
My BLogs: 15 (i:16, p:755)
Spotted: 25
Location 1: Ede
Location 2: Holland
Interests: Fish of all types but mostly Loricariidae, Callichthyidae and Auchenipteridae. My awesome dogs and walking through nature and taking pictures.

Re: 4th September 2016 : Database errors etc

Post 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)
Every great achievement begins with a dream ;-)
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post 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
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post by Jools »

jac wrote:I wanted to look up Auchenipteridae but got this:
Auchenipteridae is fixed!

Jools
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post by Jools »

bekateen wrote:One more: Tried to look at Family Loricariidae http://www.planetcatfish.com/loricariidae

Loricariidae fixed!

Jools
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post by bekateen »

:-BD
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
jac
Posts: 1223
Joined: Sat Apr 19, 2008 1:56 pm
My articles: 3
My images: 71
My cats species list: 81 (i:0, k:9)
My BLogs: 15 (i:16, p:755)
Spotted: 25
Location 1: Ede
Location 2: Holland
Interests: Fish of all types but mostly Loricariidae, Callichthyidae and Auchenipteridae. My awesome dogs and walking through nature and taking pictures.

Re: 4th September 2016 : Database errors etc

Post by jac »

Thanks Jools :YMHUG:

It looks like this morning we've got a spammer X_X
Every great achievement begins with a dream ;-)
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post by bekateen »

Yup. Sigh...
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post by Jools »

Sorted.

Jools
User avatar
Dave Rinaldo
Posts: 2143
Joined: Tue Dec 31, 2002 10:49 am
I've donated: $551.00!
My images: 235
My cats species list: 65 (i:0, k:0)
Spotted: 95
Location 2: Austin, Texas

Re: 4th September 2016 : Database errors etc

Post by Dave Rinaldo »

Related problem? I noticed Aquatic Republic hasn't been up for a couple of days.
http://www.aquaticrepublic.com/
Contribute to Planet Catfish!

Use this Amazon.com link to benefit Planet Catfish!!
User avatar
jac
Posts: 1223
Joined: Sat Apr 19, 2008 1:56 pm
My articles: 3
My images: 71
My cats species list: 81 (i:0, k:9)
My BLogs: 15 (i:16, p:755)
Spotted: 25
Location 1: Ede
Location 2: Holland
Interests: Fish of all types but mostly Loricariidae, Callichthyidae and Auchenipteridae. My awesome dogs and walking through nature and taking pictures.

Re: 4th September 2016 : Database errors etc

Post 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
Every great achievement begins with a dream ;-)
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post 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!
User avatar
bekateen
Posts: 6694
Joined: Tue Sep 09, 2014 5:50 pm
I've donated: $40.00!
My articles: 4
My images: 65
My cats species list: 107 (i:37, k:43)
My aquaria list: 30 (i:14)
My BLogs: 35 (i:120, p:1816)
My Wishlist: 39
Spotted: 131
Location 1: USA, California, Stockton
Location 2: USA, California, Stockton
Contact:

Re: 4th September 2016 : Database errors etc

Post 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
Image
http://youtube.com/user/Bekateen1
Would you like to buy my fish? Click HERE for prices.
Buying caves from https://plecocaves.com? Plecocaves is now sponsoring Bekateen's Fishroom. Use coupon code "bekateen" (no quotes) for 15% off your order.
User avatar
Jools
Expert
Posts: 14969
Joined: Mon Dec 30, 2002 3:25 pm
My articles: 190
My images: 911
My catfish: 243
My cats species list: 89 (i:0, k:6)
My aquaria list: 2 (i:2)
My BLogs: 7 (i:5, p:194)
My Wishlist: 18
Spotted: 973
Location 1: M8
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: 4th September 2016 : Database errors etc

Post 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
Post Reply