Discussion Forum: Thread 352188

 Author: crimson30 View Messages Posted By crimson30
 Posted: Jan 1, 2024 16:30
 Subject: Reddish Orange error
 Viewed: 152 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crimson30 (370)

Location:  USA, Utah
Member Since Contact Type Status
Sep 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Crimsonic
If I try to add a Reddish Orange part to a wantlist, nothing happens when I hit
submit. Also, if I try to change a part to Reddish Orange, I get a tinyint error.

Also, whenever I try to upload an image file for a post to this forum section,
I keep getting 403 errors.
 Author: Nubs_Select View Messages Posted By Nubs_Select
 Posted: Jan 1, 2024 16:36
 Subject: Re: Reddish Orange error
 Viewed: 37 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Nubs_Select (3768)

Location:  Canada, Ontario
Member Since Contact Type Status
Mar 15, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Nub's Select
shrink the image width to sub 640 px and you should be good
 Author: crimson30 View Messages Posted By crimson30
 Posted: Jan 1, 2024 16:41
 Subject: Re: Reddish Orange error
 Viewed: 41 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crimson30 (370)

Location:  USA, Utah
Member Since Contact Type Status
Sep 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Crimsonic
It was originally 552x610, but here's a smaller version:
 
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jan 1, 2024 16:45
 Subject: Re: Reddish Orange error
 Viewed: 48 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, crimson30 writes:
  If I try to add a Reddish Orange part to a wantlist, nothing happens when I hit
submit. Also, if I try to change a part to Reddish Orange, I get a tinyint error.

:facepalm:  The BL number for Reddish Orange is 256.  That’s above 8bit (tinyint:
0 to 255).


  Also, whenever I try to upload an image file for a post to this forum section,
I keep getting 403 errors.

As Nubs hinted, if your image is above 640-pixel wide, the forum ‘needs’ to resize
it, and its resizing function is borken since November.
So resize before uploading.
 Author: crimson30 View Messages Posted By crimson30
 Posted: Jan 1, 2024 16:48
 Subject: Re: Reddish Orange error
 Viewed: 47 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crimson30 (370)

Location:  USA, Utah
Member Since Contact Type Status
Sep 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Crimsonic
Efficient database fields strike again 😉
 Author: qwertyboy View Messages Posted By qwertyboy
 Posted: Jan 1, 2024 19:04
 Subject: Re: Reddish Orange error
 Viewed: 82 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

qwertyboy (7862)

Location:  Canada, Alberta
Member Since Contact Type Status
Apr 9, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Maple Bricks
In Technical Issues, crimson30 writes:
  Efficient database fields strike again 😉

In this case, it appears to be "just" the frontend that is limited. The
color ID for Reddish Orange looks to be OK in the database, judging by the nightly
brickstock/brickstore data dumps (they do show 256 as the ID - if the DB field
was too tight, it would show ID 0 if anything).

Niek.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jan 2, 2024 07:58
 Subject: Re: Reddish Orange error
 Viewed: 48 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, qwertyboy writes:
  In Technical Issues, crimson30 writes:
  Efficient database fields strike again 😉

In this case, it appears to be "just" the frontend that is limited. The
color ID for Reddish Orange looks to be OK in the database, judging by the nightly
brickstock/brickstore data dumps (they do show 256 as the ID - if the DB field
was too tight, it would show ID 0 if anything).

It may be the DB field in Wanted Lists that’s too small, while the other fields
containing a colour ID are fine….
 Author: CE_Eric View Messages Posted By CE_Eric
 Posted: Jan 3, 2024 16:38
 Subject: Re: Reddish Orange error
 Viewed: 85 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CE_Eric

Location:  USA, California
Member Since Contact Type Status
Jul 19, 2023 Contact Member Admin
Buying Privileges - OKSelling Privileges - OK
BrickLink Administrator
In Technical Issues, SylvainLS writes:
  In Technical Issues, qwertyboy writes:
  In Technical Issues, crimson30 writes:
  Efficient database fields strike again 😉

In this case, it appears to be "just" the frontend that is limited. The
color ID for Reddish Orange looks to be OK in the database, judging by the nightly
brickstock/brickstore data dumps (they do show 256 as the ID - if the DB field
was too tight, it would show ID 0 if anything).

It may be the DB field in Wanted Lists that’s too small, while the other fields
containing a colour ID are fine….

Thanks for pointing out this issue. BrickLink does have free available color
ID indices between 0 and 255, so we changed the new color Reddish Orange to ID
167.

There are over one-hundred-sixty free color IDs, still, so we can keep the efficient
database! 😉

-Eric
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jan 3, 2024 16:45
 Subject: Re: Reddish Orange error
 Viewed: 42 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Technical Issues, CE_Eric writes:
  […]
There are over one-hundred-sixty free color IDs, still, so we can keep the efficient
database! 😉

Er, I count 207 different IDs in the downloadable list of colours.
That leaves 256 − 207 = 49 free IDs.
(And we’ll need 2 for the new browns, so 47.)
 Author: crimson30 View Messages Posted By crimson30
 Posted: Jan 8, 2024 21:31
 Subject: Re: Reddish Orange error
 Viewed: 44 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

crimson30 (370)

Location:  USA, Utah
Member Since Contact Type Status
Sep 20, 2017 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Crimsonic
Another issue with Reddish Orange: internal server error when you click either
of the Reddish Orange links here https://www.bricklink.com/browseList.asp?colorID=167&itemType=P