Gossamer Forum: Products: DBMan: Customization: maximum number of fields to send to the script

Hi,

I read on the forum that there should be no limit of number of fields for the script, that it could only make default.db very large or hang the clients computer as forms tend to eat all the memory, however, I get an 'internal server error'.

To make sure it was the amount of fields I tried deleting fields in the string sent to the script both at the end and at the beginning. It didn't matter where I took them away, as soon as the number of fields had decreased enough, the script would run, no more internal server error.

I tried to give the fields shorter names, but that didn't make any difference, so I guess it is the number of fields that causes the problem. Now, my problem is, I can't have less fields in my records. What am I to do? Anybody any tip?

Too long is:

Code:
..../cgi-bin/db/db.cgi?db=default&uid=Lex.104256466317489&ID=&Userid=&Date=&Title=&Designer=---&Category=---&Description_en=&Description_es=&Description_de=&Description_fr=&Width=&Depth=&Height=&Weight=&Total_Weight=&Version_A=&Version_B=&Version_C=&Version_D=&Version_X=&X1_defenition=&X2_defenition=&X3_defenition=&X4_defenition=&P_A1_US=&P_A1_EU=&P_A1_US_s=&P_A1_EU_s=&S_A1_US=&S_A1_EU=&P_A2_US=&P_A2_EU=&P_A2_US_s=&P_A2_EU_s=&S_A2_US=&S_A2_EU= &P_A3_US=&P_A3_EU=&P_A3_US_s=&P_A3_EU_s=&S_A3_US=&S_A3_EU=&P_A4_US=&P_A4_EU=&P_A4_US_s=&P_A4_EU_s=&S_A4_US=&S_A4_EU=&P_A5_US=&P_A5_EU=&P_A5_US_s=&P_A5_EU_s=&S_A5_US=&S_A5_EU=&P_A6_US=&P_A6_EU=&P_A6_US_s=&P_A6_EU_s=&S_A6_US=&S_A6_EU=&P_A7_US=&P_A7_EU=&P_A7_US_s=&P_A7_EU_s=&S_A7_US=&S_A7_EU=&P_B1_US=&P_B1_EU=&P_B1_US_s=&P_B1_EU_s=&S_B1_US=&S_B1_EU=&P_B2_US=&P_B2_EU=&P_B2_US_s=&P_B2_EU_s=&S_B2_US=&S_B2_EU=&P_C1_US=&P_C1_EU=&P_C1_US_s=&P_C1_EU_s=&S_C1_US=&S_C1_EU=&P_D1_US=&P_D1_EU=&P_D1_US_s=&P_D1_EU_s=&S_D1_US=&S_D1_EU=&P_D2_US=&P_D2_EU=&P_D2_US_s=&P_D2_EU_s=&S_D2_US=&S_D2_EU=&P_D3_US=&P_D3_EU=&P_D3_US_s=&P_D3_EU_s=&S_D3_US=&S_D3_EU=&P_D4_US=&P_D4_EU=&P_D4_US_s=&P_D4_EU_s=&S_D4_US=&S_D4_EU=&P_X1_US=&P_X1_EU=&P_X1_US_s=&P_X1_EU_s=&S_X1_US=&S_X1_EU=&P_X2_US=&P_X2_EU=&P_X2_US_s=&P_X2_EU_s=&S_X2_US=&S_X2_EU=&P_X3_US=&P_X3_EU=&P_X3_US_s=&P_X3_EU_s=&S_X3_US=&S_X3_EU=&P_X4_US=&P_X4_EU=&P_X4_US_s=&P_X4_EU_s=&S_X4_US=&S_X4_EU=&keyword=*&mh=10&sb=---&so=ascend&view_records=View+Records[/url]

However, if I get rid of a number of fields at the end (or at the beginning (after the uid fields etc...)) it works well:

Code:
..../cgi-bin/db/db.cgi?db=default&uid=Lex.104256466317489&ID=&P_A3_US=&P_A3_EU=&P_A3_US_s=&P_A3_EU_s=&S_A3_US=&S_A3_EU=&P_A4_US=&P_A4_EU=&P_A4_US_s=&P_A4_EU_s=&S_A4_US=&S_A4_EU=&P_A5_US=&P_A5_EU=&P_A5_US_s=&P_A5_EU_s=&S_A5_US=&S_A5_EU=&P_A6_US=&P_A6_EU=&P_A6_US_s=&P_A6_EU_s=&S_A6_US=&S_A6_EU=&P_A7_US=&P_A7_EU=&P_A7_US_s=&P_A7_EU_s=&S_A7_US=&S_A7_EU=&P_B1_US=&P_B1_EU=&P_B1_US_s=&P_B1_EU_s=&S_B1_US=&S_B1_EU=&P_B2_US=&P_B2_EU=&P_B2_US_s=&P_B2_EU_s=&S_B2_US=&S_B2_EU=&P_C1_US=&P_C1_EU=&P_C1_US_s=&P_C1_EU_s=&S_C1_US=&S_C1_EU=&P_D1_US=&P_D1_EU=&P_D1_US_s=&P_D1_EU_s=&S_D1_US=&S_D1_EU=&P_D2_US=&P_D2_EU=&P_D2_US_s=&P_D2_EU_s=&S_D2_US=&S_D2_EU=&P_D3_US=&P_D3_EU=&P_D3_US_s=&P_D3_EU_s=&S_D3_US=&S_D3_EU=&P_D4_US=&P_D4_EU=&P_D4_US_s=&P_D4_EU_s=&S_D4_US=&S_D4_EU=&P_X1_US=&P_X1_EU=&P_X1_US_s=&P_X1_EU_s=&S_X1_US=&S_X1_EU=&P_X2_US=&P_X2_EU=&P_X2_US_s=&P_X2_EU_s=&S_X2_US=&S_X2_EU=&P_X3_US=&P_X3_EU=&P_X3_US_s=&P_X3_EU_s=&S_X3_US=&S_X3_EU=&P_X4_US=&P_X4_EU=&P_X4_US_s=&P_X4_EU_s=&S_X4_US=&S_X4_EU=&keyword=*&mh=10&sb=---&so=ascend&view_records=View+Records[/url] 

I've got 132 fields. Did anybody ever have this problem and if yes, how did (s)he solve it?

Can I help it by playing with GET and POST?

Thanks,

Lex

p.s. I'm sorry for the long lines, hope you didn't scroll too much Cool