My cats adding issue.

A historical forum for issues reported in the suggestions and bugs forum that have been subsequently fixed or resolved.
Post Reply
Lee Meadows
Posts: 4
Joined: 20 Aug 2013, 00:36
My cats species list: 83 (i:0, k:0)
My aquaria list: 1 (i:0)
My BLogs: 1 (i:0, p:43)
Location 2: Edinburgh

My cats adding issue.

Post by Lee Meadows »

Hi Guys

When I click the My Cats link to add species I get the following:

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2013-08-19 23:44:38')' at line 1 [1064]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.

Can someone please advise?

Many thanks

Lee
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:97)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: My cats adding issue.

Post by MatsP »

I just tried this, and I can't make it go wrong.

Can you give a little more details on what you are doing - a start would be what species (could be something wrong with that species entry, perhaps)?

I don't think it really matters, but what web-browser are you using?

--
Mats
User avatar
Jools
Expert
Posts: 16162
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 948
My catfish: 237
My cats species list: 87 (i:237, k:1)
My BLogs: 7 (i:10, p:202)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: My cats adding issue.

Post by Jools »

Lee,

Greetings from an Edinburgh boy!

I think it has to be species specific, can you let us know which species you were trying to add?

Cheers,

Jools
Lee Meadows
Posts: 4
Joined: 20 Aug 2013, 00:36
My cats species list: 83 (i:0, k:0)
My aquaria list: 1 (i:0)
My BLogs: 1 (i:0, p:43)
Location 2: Edinburgh

Re: My cats adding issue.

Post by Lee Meadows »

Hi Jools,

Non buddy, I cannot even get into the page. I was also getting the same problem when clicking on CotM and My Aquaria. For some reason it wont even let me open the page.

I am using chrome..
User avatar
Jools
Expert
Posts: 16162
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 948
My catfish: 237
My cats species list: 87 (i:237, k:1)
My BLogs: 7 (i:10, p:202)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: My cats adding issue.

Post by Jools »

Lee,

I can see the problem. Should be fixed now - can you confirm? Actually it was affecting all new users to the site, so I am very gratefully for you reporting it.

Mats,

The fix is in R1290.

Jools
Lee Meadows
Posts: 4
Joined: 20 Aug 2013, 00:36
My cats species list: 83 (i:0, k:0)
My aquaria list: 1 (i:0)
My BLogs: 1 (i:0, p:43)
Location 2: Edinburgh

Re: My cats adding issue.

Post by Lee Meadows »

Thanks guys

Currently at work so will start uploading when I get home.

I will have a play with tapatalk and see if it lets me post things.

Sent from my GT-N7105 using Tapatalk 2
Lee Meadows
Posts: 4
Joined: 20 Aug 2013, 00:36
My cats species list: 83 (i:0, k:0)
My aquaria list: 1 (i:0)
My BLogs: 1 (i:0, p:43)
Location 2: Edinburgh

Re: My cats adding issue.

Post by Lee Meadows »

Seems to be working fine now, thanks again guys :)
User avatar
MatsP
Posts: 21038
Joined: 06 Oct 2004, 13:58
My articles: 4
My images: 28
My cats species list: 117 (i:33, k:0)
My aquaria list: 10 (i:8)
My BLogs: 4 (i:0, p:97)
Spotted: 187
Location 1: North of Cambridge
Location 2: England.

Re: My cats adding issue.

Post by MatsP »

Yeah, I looked at Jools' change, and it makes sense that a "new user" would have a problem, but someone who has used the My Cats etc doesn't.

Glad we got it sorted.

--
Mats
KittyKat
Posts: 26
Joined: 15 Aug 2007, 09:57
My cats species list: 6 (i:0, k:0)
My aquaria list: 4 (i:0)
My BLogs: 1 (i:0, p:41)
Location 1: Norwich, UK
Location 2: Norwich, UK
Contact:

Re: My cats adding issue.

Post by KittyKat »

Hi, I'm getting a similar error when trying to update my aquaria. When the saves succeeds, the details are not updated. For example, if I add a filter, then either I get an error as above or it looks like it succeeded, but doesn't update the filter details.
Kat
User avatar
Jools
Expert
Posts: 16162
Joined: 30 Dec 2002, 15:25
My articles: 198
My images: 948
My catfish: 237
My cats species list: 87 (i:237, k:1)
My BLogs: 7 (i:10, p:202)
My Wishlist: 23
Spotted: 450
Location 1: Middle Earth,
Location 2: Scotland
Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
Contact:

Re: My cats adding issue.

Post by Jools »

I think that's a new issue but I'll look to it. Would you mind posting a new bugs thread describing what you are doing in a little more detail?

Cheers

Jools
Post Reply

Return to “All Resolved Issues”