Bug with Accessories

[ewtwolf]

I am running 2.01 and just started populating it with Resources and Accessories. Is there a limit to how many accessories I can have? I had created 44 separate accessories and now I cannot Edit or Delete existing ones and cannot Create new ones. When I click on any of those options, the browser URL changes to: /Web/admin/manage_accessories.php#

Not sure if that is relavent. But it doesn't appear to be loading anything and wasn't sure if the # sign was an error.

Any ideas?

Cheers,

-Edward

[ewtwolf]

Not sure if it will help, but these are the accessories I created with their quantities. I also noticed that I cannot checkout an accessory with an unlimited quantity. I get an error saying there is not enough.


Accessory Name   Quantity Available   

ADVANCED GRIP - C-Stand 20"   1   
ADVANCED GRIP - C-Stand 40"   20   
ADVANCED LIGHTING - 1K Baby Fresnel    5   
ADVANCED LIGHTING - 1K Colortran Broad   1   
ADVANCED LIGHTING - 200W Mini Mole    4   
ADVANCED LIGHTING - 250W Clamp Light   8   
ADVANCED LIGHTING - 650W Colortran Spots   15   
ADVANCED LIGHTING - 650W Tweenie   4   
ADVANCED LIGHTING - 750W Lowel Softlight   1   
ADVANCED LIGHTING - Flag, 4'x4'    2   
ADVANCED LIGHTING - Light Meter      8   
ADVANCED SUPPORT - Crab Dolly    3   
ADVANCED SUPPORT - Hi Hat      2   
ADVANCED SUPPORT - Tripod Cartoni   3   
ADVANCED SUPPORT - Tripod Manfrotto   1   
ADVANCED SUPPORT - Tripod Miller   2   
ADVANCED SUPPORT - Tripod Sachtler   3   
AUDIO - Shotgun Mic, Cable, Boom      10   
AUDIO - Sound Blanket      40   
CAMERA - Slate   5   
ELECTRIC - Stinger 25 ft.   15   
ELECTRIC - Stinger 50 ft.   5   
GRIP - Clamp, C47 - Clothespin   24   
GRIP - Clamp, Spring   45   
GRIP - Sand Bag 15#   10   
GRIP - Sand Bag 25#   10   
GRIP - Stand, Baby Jr   2   
GRIP - Stand, Baby Jr Rolling      2   
GRIP - Stand, Baby Pony   3   
GRIP - Stand, Beefy Baby Dbl      2   
GRIP - Stand, Beefy Baby Triple   1   
LIGHTING - Bounce, Flexfill   9   
LIGHTING - Bounce, Foam Core White   10   
LIGHTING - Diffusion, 1/2   ?   
LIGHTING - Diffusion, 1/4   ?   
LIGHTING - Diffusion, Full   ?   
LIGHTING - Diffusion, Opal   ?   
LIGHTING - Flag, 18"x24" Kit      3   
LIGHTING - Flag, 24"x36" Kit      2   
LIGHTING - Flag, Foam Core Black      5   
LIGHTING - Flag, Roadflags Kit   1   
LIGHTING - Gels, CTB    ?   
LIGHTING - Gels, CTO    ?   
LIGHTING - Lowel Omni Kit   11   

[ewtwolf]

Is there a way to reset the accessories without doing a complete reinstall? Right now I am stuck and can't use the software with the bug and if I can just reset the accessories list by reloading something to the server it would really help.

Cheers

[Nick]

I haven't tried this many, but I cannot see why that would be an issue. I'll do a load test on this and see what I find.

In the meantime, if you can get into phpMyAdmin or another interface into the database, you can run the following query to remove the accessories:

Code:

delete from accessories;

[ewtwolf]

Thanks Nick   

[IflyGC]

etfwolf / Nick,

I too am having the same issue but it only appears on IE.  Running in Firefox with Firebug on shows no problems whatsoever.  In IE though I'm getting the following issues:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; MDDC; .NET CLR 3.5.30729; .NET CLR 3.0.30729; IPH 1.1.21.4019; .NET4.0C)
Timestamp: Thu, 12 Apr 2012 19:35:06 UTC


Message: Expected identifier
Line: 51
Char: 77
Code: 0
URI: http://www.mysite.com/Web/scripts/admin/accessory.js


Message: Expected identifier, string or number
Line: 730
Char: 3
Code: 0
URI: http://www.mysite.com/Web/admin/manage_accessories.php


I have 60+ accessories and with the last version had no problems with this at all. 

Dave

[Nick]

I'll be fixing this IE problem shortly.

[neiltorda]

We were having a similar issue, and the problem had to do with someone entering 8' Dolly Track as the accessory name.
The ' symbol was not being escaped and causing a php error when the page loaded. I went into the database and changed it to 8 foot and now everything is working again.

Hope this helps someone else.

neil

[Nick]

Thanks, Neil. I'll get this fixed!

[dovermiller]

Thanks for the info, my accessory page got "buggy" after I entered an "8' table." I deleted the entry in phpmyadmin as suggested and it solved the problem, thanks!

[geertvandeweyer]

This bug is still present in in the 2.3 version it seems. Thank's for pointing out what the issue was !

[Nick]

The syntax error is still present?

[thepsychotherapist]

I am experiencing the same issue with v2.4.2.

When I added an accessory with an apostrophe, I was no longer able to add any additional accessories until I dropped that entry in the DB. 

Thanks for phpScheduleIt! 

[Nick]

I'll take a look. Thanks!