Ajax Error 500 - Wikidot Open Source

Ajax Error 500

Forum » Wikidot version 1 / Bugs » Ajax Error 500

Started by:

(account deleted)
Date: 11 Jun 2009 05:15
Number of posts: 8

RSS: New posts

Unfold All Fold All More Options

Fold

Ajax Error 500

(account deleted) 11 Jun 2009 05:15

I just ran into an issue with my server at work when trying to save a page with a pretty large "complex" table ([[table]]…[[row]]..[[cell]]…[[/cell]]…[[/row]]…[[/table]]). If I reduce the size of the table, I can eventually get the page to save.

It seems like the the parser can't handle that amount of "wiki syntax" at once. I have pages with a lot more characters, but not as much wiki markup.

On the Pro site a similar error was reported and fixed (http://pro.wikidot.com/ticket:241)

Can you share what the fix was so I can try it on my server?

Thanks,
Ed

Community Admin

Reply Options

Unfold Ajax Error 500 by

(account deleted), 11 Jun 2009 05:15

Fold

Re: Ajax Error 500

Gabrys 18 Jun 2009 21:22

Oh, yeah, this seems like pcre regular expression library tweaks.

Check PCRE tweaks

Piotr Gabryjeluk
visit my blog

Reply Options

Unfold Re: Ajax Error 500 by

Gabrys, 18 Jun 2009 21:22

Fold

Re: Ajax Error 500

(account deleted) 18 Jun 2009 22:28

Hmmm… I already had PCRE installed - your instructions are exactly the same as those from Michal's early guide and the instructions i copied to my giude. After removing the comments from the 2 lines in php.ini, I still get the same error. BTW, I'm testing this on my VM with rev 466 (which otherwise seems very stable).

I think this is the error generated (from /var/log/lighttpd/error.log)

2009-06-18 17:20:06: (mod_fastcgi.c.2471) unexpected end-of-file (perhaps the fastcgi process died): pid: 6353 socket: unix:/var/run/lighttpd/php-fastcgi.socket-3

2009-06-18 17:20:06: (mod_fastcgi.c.3281) response not received, request sent: 58618 on socket: unix:/var/run/lighttpd/php-fastcgi.socket-3 for /ajax-module-connector.php , closing connection

Does this shed any more light? Anything else I can try?

Thanks for all your help!

-Ed

edit: This is the source of one of the pages I'm trying to save:

-- show code --

-- hide code --

[[iframe http://mytest.mywikidot.com/iframe/code/1 frameborder="0" scrolling="yes" width="600px" height="600px"]]

[[collapsible show=" " hide="-"]]
[[code type="html"]]
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8"/>
  <script type="text/javascript" src="http://www.google.com/jsapi"></script>
  <script type="text/javascript">
  google.load("visualization", "1", {packages:["table"]});
  google.setOnLoadCallback(drawTable);
  function drawTable() {
    // Create and populate the data table.
    var data = new google.visualization.DataTable();

    data.addColumn('string', 'Vendor');
    data.addColumn('number', 'Item Number(s)');
    data.addColumn('string', 'Item');
    data.addColumn('string', 'Unit');
    data.addColumn('number', 'Price');
    data.addColumn('number', 'Case Price');
    data.addColumn('number', 'Pack');

    data.addRows(128);

    data.setCell(0, 0, 'Appert`s');
    data.setCell(0, 1, 74250, '74250');
    data.setCell(0, 2, 'Almonds');
    data.setCell(0, 3, 'lb');
    data.setCell(0, 4, 4.79, '4.79');
    data.setCell(0, 5, 23.97, '23.97');
    data.setCell(0, 6, 5, '5');

    data.setCell(1, 0, 'Jerry`s');
    data.setCell(1, 1, '');
    data.setCell(1, 2, 'Anchovies');
    data.setCell(1, 3, 'tin');
    data.setCell(1, 4, 6.5, '6.50');
    data.setCell(1, 5, 6.5, '6.50');
    data.setCell(1, 6, 1, '1');

    data.setCell(2, 0, 'Appert`s');
    data.setCell(2, 1, 14986, '14986');
    data.setCell(2, 2, 'Bacon - Precooked Sl');
    data.setCell(2, 3, 'lb (3.8lb/cs)');
    data.setCell(2, 4, 6.68, '6.68');
    data.setCell(2, 5, 25.4, '25.40');
    data.setCell(2, 6, 3.8, '4');

    data.setCell(3, 0, 'Appert`s');
    data.setCell(3, 1, 14375, '14375');
    data.setCell(3, 2, 'Bacon Bits');
    data.setCell(3, 3, 'lb');
    data.setCell(3, 4, 3.89, '3.89');
    data.setCell(3, 5, 38.94, '38.94');
    data.setCell(3, 6, 10, '10');

    data.setCell(4, 0, 'Beer Supplier');
    data.setCell(4, 1, '');
    data.setCell(4, 2, 'Beer - Corona');
    data.setCell(4, 3, 'ea');
    data.setCell(4, 4, 1.03, '1.03');
    data.setCell(4, 5, 24.8, '24.80');
    data.setCell(4, 6, 24, '24');

    data.setCell(5, 0, 'Beer Supplier');
    data.setCell(5, 1, '');
    data.setCell(5, 2, 'Beer - Sam Adams');
    data.setCell(5, 3, 'ea');
    data.setCell(5, 4, 1.02, '1.02');
    data.setCell(5, 5, 24.55, '24.55');
    data.setCell(5, 6, 24, '24');

    data.setCell(6, 0, 'Beer Supplier');
    data.setCell(6, 1, '');
    data.setCell(6, 2, 'Beer - Standard');
    data.setCell(6, 3, 'ea');
    data.setCell(6, 4, 0.7, '0.70');
    data.setCell(6, 5, 16.75, '16.75');
    data.setCell(6, 6, 24, '24');

    data.setCell(7, 0, 'Beer Supplier');
    data.setCell(7, 1, '');
    data.setCell(7, 2, 'Beer - Stella');
    data.setCell(7, 3, 'ea');
    data.setCell(7, 4, 1.13, '1.13');
    data.setCell(7, 5, 27, '27.00');
    data.setCell(7, 6, 24, '24');

    data.setCell(8, 0, 'Appert`s');
    data.setCell(8, 1, 65908, '65908');
    data.setCell(8, 2, 'BIB MM Lemonade');
    data.setCell(8, 3, 'ea');
    data.setCell(8, 4, 56.07, '56.07');
    data.setCell(8, 5, 56.07, '56.07');
    data.setCell(8, 6, 1, '1');

    data.setCell(9, 0, 'Appert`s');
    data.setCell(9, 1, '65880,85,90,95,900,903,913');
    data.setCell(9, 2, 'BIB Soda/Pwrade');
    data.setCell(9, 3, 'ea');
    data.setCell(9, 4, 53.77, '53.77');
    data.setCell(9, 5, 53.77, '53.77');
    data.setCell(9, 6, 1, '1');

    data.setCell(10, 0, 'Appert`s');
    data.setCell(10, 1, 65792, '65792');
    data.setCell(10, 2, 'BIB Tea - Green');
    data.setCell(10, 3, 'ea');
    data.setCell(10, 4, 29.7, '29.70');
    data.setCell(10, 5, 29.7, '29.70');
    data.setCell(10, 6, 1, '1');

    data.setCell(11, 0, 'Appert`s');
    data.setCell(11, 1, 65790918, '65,790,918');
    data.setCell(11, 2, 'BIB Tea - Sweet/Rasp');
    data.setCell(11, 3, 'ea');
    data.setCell(11, 4, 28.55, '28.55');
    data.setCell(11, 5, 28.55, '28.55');
    data.setCell(11, 6, 1, '1');

    data.setCell(12, 0, 'Appert`s');
    data.setCell(12, 1, 65791, '65791');
    data.setCell(12, 2, 'BIB Tea - Unsweet');
    data.setCell(12, 3, 'ea');
    data.setCell(12, 4, 27.7, '27.70');
    data.setCell(12, 5, 27.7, '27.70');
    data.setCell(12, 6, 1, '1');

    data.setCell(13, 0, 'Appert`s');
    data.setCell(13, 1, 43304, '43304');
    data.setCell(13, 2, 'Black Beans');
    data.setCell(13, 3, 'can');
    data.setCell(13, 4, 0.74, '0.74');
    data.setCell(13, 5, 17.65, '17.65');
    data.setCell(13, 6, 24, '24');

    data.setCell(14, 0, 'Jerry`s');
    data.setCell(14, 1, '');
    data.setCell(14, 2, 'Black Pepper');
    data.setCell(14, 3, 'lb');
    data.setCell(14, 4, 4.9, '4.90');
    data.setCell(14, 5, 4.9, '4.90');
    data.setCell(14, 6, 1, '1');

    data.setCell(15, 0, 'Appert`s');
    data.setCell(15, 1, 63424, '63424');
    data.setCell(15, 2, 'Bottled Water');
    data.setCell(15, 3, 'ea');
    data.setCell(15, 4, 0.24, '0.24');
    data.setCell(15, 5, 5.73, '5.73');
    data.setCell(15, 6, 24, '24');

    data.setCell(16, 0, 'Oven Hearth');
    data.setCell(16, 1, 904, '904');
    data.setCell(16, 2, 'Breadsticks');
    data.setCell(16, 3, 'doz');
    data.setCell(16, 4, 2.7, '2.70');
    data.setCell(16, 5, 2.7, '2.70');
    data.setCell(16, 6, 1, '1');

    data.setCell(17, 0, 'Jerry`s');
    data.setCell(17, 1, '');
    data.setCell(17, 2, 'Broccoli');
    data.setCell(17, 3, 'head');
    data.setCell(17, 4, 1.15, '1.15');
    data.setCell(17, 5, 1.15, '1.15');
    data.setCell(17, 6, 1, '1');

    data.setCell(18, 0, 'Oven Hearth');
    data.setCell(18, 1, 630, '630');
    data.setCell(18, 2, 'Brownies');
    data.setCell(18, 3, 'ea');
    data.setCell(18, 4, 0.49, '0.49');
    data.setCell(18, 5, 17.64, '17.64');
    data.setCell(18, 6, 36, '36');

    data.setCell(19, 0, 'Oven Hearth');
    data.setCell(19, 1, 301, '301');
    data.setCell(19, 2, 'Buns - Ciabatta');
    data.setCell(19, 3, 'ea');
    data.setCell(19, 4, 0.55, '0.55');
    data.setCell(19, 5, 19.8, '19.80');
    data.setCell(19, 6, 36, '36');

    data.setCell(20, 0, 'Oven Hearth');
    data.setCell(20, 1, 1010201, '1,010,201');
    data.setCell(20, 2, 'Buns - Sliced');
    data.setCell(20, 3, 'doz');
    data.setCell(20, 4, 4.8, '4.80');
    data.setCell(20, 5, 4.8, '4.80');
    data.setCell(20, 6, 1, '1');

    data.setCell(21, 0, 'Oven Hearth');
    data.setCell(21, 1, 1020202, '1,020,202');
    data.setCell(21, 2, 'Buns - Unsliced');
    data.setCell(21, 3, 'doz');
    data.setCell(21, 4, 4.68, '4.68');
    data.setCell(21, 5, 4.68, '4.68');
    data.setCell(21, 6, 1, '1');

    data.setCell(22, 0, 'Appert`s');
    data.setCell(22, 1, 8266, '8266');
    data.setCell(22, 2, 'Buttermilk');
    data.setCell(22, 3, 'carton');
    data.setCell(22, 4, 1.05, '1.05');
    data.setCell(22, 5, 12.54, '12.54');
    data.setCell(22, 6, 12, '12');

    data.setCell(23, 0, 'Appert`s');
    data.setCell(23, 1, 14942, '14942');
    data.setCell(23, 2, 'Canadian Bacon');
    data.setCell(23, 3, 'lb');
    data.setCell(23, 4, 4.38, '4.38');
    data.setCell(23, 5, 52.58, '52.58');
    data.setCell(23, 6, 12, '12');

    data.setCell(24, 0, 'Jerry`s');
    data.setCell(24, 1, '');
    data.setCell(24, 2, 'Celery Salt');
    data.setCell(24, 3, 'lb');
    data.setCell(24, 4, 2.5, '2.50');
    data.setCell(24, 5, 2.5, '2.50');
    data.setCell(24, 6, 1, '1');

    data.setCell(25, 0, 'Jerry`s');
    data.setCell(25, 1, '');
    data.setCell(25, 2, 'Cheese - Cheddar Block');
    data.setCell(25, 3, 'lb');
    data.setCell(25, 4, 1.6, '1.60');
    data.setCell(25, 5, 1.6, '1.60');
    data.setCell(25, 6, 1, '1');

    data.setCell(26, 0, 'Appert`s');
    data.setCell(26, 1, 6022, '6022');
    data.setCell(26, 2, 'Cheese - Cheddar Shred');
    data.setCell(26, 3, 'lb');
    data.setCell(26, 4, 1.63, '1.63');
    data.setCell(26, 5, 32.53, '32.53');
    data.setCell(26, 6, 20, '20');

    data.setCell(27, 0, 'Appert`s');
    data.setCell(27, 1, 6926, '6926');
    data.setCell(27, 2, 'Cheese - Gorgonzola');
    data.setCell(27, 3, 'pk - 2.5lb');
    data.setCell(27, 4, 6.61, '6.61');
    data.setCell(27, 5, 26.45, '26.45');
    data.setCell(27, 6, 4, '4');

    data.setCell(28, 0, 'Jerry`s');
    data.setCell(28, 1, '');
    data.setCell(28, 2, 'Cheese - Mozz');
    data.setCell(28, 3, 'lb');
    data.setCell(28, 4, 1.48, '1.48');
    data.setCell(28, 5, 1.48, '1.48');
    data.setCell(28, 6, 1, '1');

    data.setCell(29, 0, 'Appert`s');
    data.setCell(29, 1, 6655, '6655');
    data.setCell(29, 2, 'Cheese - Ricotta');
    data.setCell(29, 3, 'tub - 3 lb');
    data.setCell(29, 4, 3.95, '3.95');
    data.setCell(29, 5, 23.67, '23.67');
    data.setCell(29, 6, 6, '6');

    data.setCell(30, 0, 'Jerry`s');
    data.setCell(30, 1, '');
    data.setCell(30, 2, 'Cheese - Romano Grated');
    data.setCell(30, 3, 'lb');
    data.setCell(30, 4, 5.75, '5.75');
    data.setCell(30, 5, 28.75, '28.75');
    data.setCell(30, 6, 5, '5');

    data.setCell(31, 0, 'Appert`s');
    data.setCell(31, 1, 6070, '6070');
    data.setCell(31, 2, 'Cheese - Romano Shred');
    data.setCell(31, 3, 'lb');
    data.setCell(31, 4, 3.92, '3.92');
    data.setCell(31, 5, 78.49, '78.49');
    data.setCell(31, 6, 20, '20');

    data.setCell(32, 0, 'Appert`s');
    data.setCell(32, 1, 24038, '24038');
    data.setCell(32, 2, 'Chicken Breast');
    data.setCell(32, 3, 'lb');
    data.setCell(32, 4, 3.42, '3.42');
    data.setCell(32, 5, 119.84, '119.84');
    data.setCell(32, 6, 35, '35');

    data.setCell(33, 0, 'Appert`s');
    data.setCell(33, 1, 69754756827, '69,754,756,827');
    data.setCell(33, 2, 'Chips - Baked Lays');
    data.setCell(33, 3, 'ea');
    data.setCell(33, 4, 0.34, '0.34');
    data.setCell(33, 5, 24.42, '24.42');
    data.setCell(33, 6, 72, '72');

    data.setCell(34, 0, 'Appert`s');
    data.setCell(34, 1, 69754756827, '69,754,756,827');
    data.setCell(34, 2, 'Chips - Davanni`s');
    data.setCell(34, 3, 'ea');
    data.setCell(34, 4, 0.39, '0.39');
    data.setCell(34, 5, 14.02, '14.02');
    data.setCell(34, 6, 36, '36');

    data.setCell(35, 0, 'Jerry`s');
    data.setCell(35, 1, '');
    data.setCell(35, 2, 'Cilantro');
    data.setCell(35, 3, 'bundle');
    data.setCell(35, 4, 0.5, '0.50');
    data.setCell(35, 5, 0.5, '0.50');
    data.setCell(35, 6, 1, '1');

    data.setCell(36, 0, 'Appert`s');
    data.setCell(36, 1, 66207, '66207');
    data.setCell(36, 2, 'Coffee Pkt');
    data.setCell(36, 3, 'cs - 40 ea');
    data.setCell(36, 4, 64.14, '64.14');
    data.setCell(36, 5, 64.14, '64.14');
    data.setCell(36, 6, 1, '1');

    data.setCell(37, 0, 'Oven Hearth');
    data.setCell(37, 1, 601, '601');
    data.setCell(37, 2, 'Cookies');
    data.setCell(37, 3, 'ea');
    data.setCell(37, 4, 0.36, '0.36');
    data.setCell(37, 5, 11.52, '11.52');
    data.setCell(37, 6, 32, '32');

    data.setCell(38, 0, 'Appert`s');
    data.setCell(38, 1, 73148, '73148');
    data.setCell(38, 2, 'Cooking Sherry');
    data.setCell(38, 3, 'bottle');
    data.setCell(38, 4, 2.19, '2.19');
    data.setCell(38, 5, 13.11, '13.11');
    data.setCell(38, 6, 6, '6');

    data.setCell(39, 0, 'Appert`s');
    data.setCell(39, 1, 43372, '43372');
    data.setCell(39, 2, 'Corn');
    data.setCell(39, 3, 'can');
    data.setCell(39, 4, 0.77, '0.77');
    data.setCell(39, 5, 18.43, '18.43');
    data.setCell(39, 6, 24, '24');

    data.setCell(40, 0, 'Appert`s');
    data.setCell(40, 1, 49550, '49550');
    data.setCell(40, 2, 'Craisins');
    data.setCell(40, 3, 'bag (48oz)');
    data.setCell(40, 4, 8.18, '8.18');
    data.setCell(40, 5, 16.35, '16.35');
    data.setCell(40, 6, 2, '2');

    data.setCell(41, 0, 'Appert`s');
    data.setCell(41, 1, 72404, '72404');
    data.setCell(41, 2, 'Croutons');
    data.setCell(41, 3, 'cs (250)');
    data.setCell(41, 4, 22.81, '22.81');
    data.setCell(41, 5, 22.81, '22.81');
    data.setCell(41, 6, 1, '1');

    data.setCell(42, 0, 'Jerry`s');
    data.setCell(42, 1, '');
    data.setCell(42, 2, 'Cucumbers');
    data.setCell(42, 3, 'ea');
    data.setCell(42, 4, 0.45, '0.45');
    data.setCell(42, 5, 0.45, '0.45');
    data.setCell(42, 6, 1, '1');

    data.setCell(43, 0, 'Oven Hearth');
    data.setCell(43, 1, 503, '503');
    data.setCell(43, 2, 'Deep - Large');
    data.setCell(43, 3, 'ea');
    data.setCell(43, 4, 2.16, '2.16');
    data.setCell(43, 5, 2.16, '2.16');
    data.setCell(43, 6, 1, '1');

    data.setCell(44, 0, 'Oven Hearth');
    data.setCell(44, 1, 502, '502');
    data.setCell(44, 2, 'Deep - Medium');
    data.setCell(44, 3, 'ea');
    data.setCell(44, 4, 1.38, '1.38');
    data.setCell(44, 5, 1.38, '1.38');
    data.setCell(44, 6, 1, '1');

    data.setCell(45, 0, 'Oven Hearth');
    data.setCell(45, 1, 501, '501');
    data.setCell(45, 2, 'Deep - Solo');
    data.setCell(45, 3, 'ea');
    data.setCell(45, 4, 0.98, '0.98');
    data.setCell(45, 5, 0.98, '0.98');
    data.setCell(45, 6, 1, '1');

    data.setCell(46, 0, 'Appert`s');
    data.setCell(46, 1, 72738, '72738');
    data.setCell(46, 2, 'Dr - Balsamic');
    data.setCell(46, 3, 'cs (100)');
    data.setCell(46, 4, 15.93, '15.93');
    data.setCell(46, 5, 15.93, '15.93');
    data.setCell(46, 6, 1, '1');

    data.setCell(47, 0, 'Appert`s');
    data.setCell(47, 1, 72740, '72740');
    data.setCell(47, 2, 'Dr - Bleu Cheese');
    data.setCell(47, 3, 'cs (100)');
    data.setCell(47, 4, 15.6, '15.60');
    data.setCell(47, 5, 15.6, '15.60');
    data.setCell(47, 6, 1, '1');

    data.setCell(48, 0, 'Appert`s');
    data.setCell(48, 1, 72773, '72773');
    data.setCell(48, 2, 'Dr - Caesar');
    data.setCell(48, 3, 'cs (100)');
    data.setCell(48, 4, 15.88, '15.88');
    data.setCell(48, 5, 15.88, '15.88');
    data.setCell(48, 6, 1, '1');

    data.setCell(49, 0, 'Appert`s');
    data.setCell(49, 1, 72779, '72779');
    data.setCell(49, 2, 'Dr - Chinese');
    data.setCell(49, 3, 'cs (48)');
    data.setCell(49, 4, 15.29, '15.29');
    data.setCell(49, 5, 15.29, '15.29');
    data.setCell(49, 6, 1, '1');

    data.setCell(50, 0, 'Appert`s');
    data.setCell(50, 1, 73220, '73220');
    data.setCell(50, 2, 'Dr - Chip Rnch Gal');
    data.setCell(50, 3, 'gal');
    data.setCell(50, 4, 16.95, '16.95');
    data.setCell(50, 5, 33.89, '33.89');
    data.setCell(50, 6, 2, '2');

    data.setCell(51, 0, 'Appert`s');
    data.setCell(51, 1, 72642, '72642');
    data.setCell(51, 2, 'Dr - Chip Rnch Pkt');
    data.setCell(51, 3, 'cs (48)');
    data.setCell(51, 4, 15.29, '15.29');
    data.setCell(51, 5, 15.29, '15.29');
    data.setCell(51, 6, 1, '1');

    data.setCell(52, 0, 'Jerry`s');
    data.setCell(52, 1, '');
    data.setCell(52, 2, 'Dr - Golden Italian');
    data.setCell(52, 3, 'gal');
    data.setCell(52, 4, 7.44, '7.44');
    data.setCell(52, 5, 29.75, '29.75');
    data.setCell(52, 6, 4, '4');

    data.setCell(53, 0, 'Appert`s');
    data.setCell(53, 1, 72742, '72742');
    data.setCell(53, 2, 'Dr - Honey French');
    data.setCell(53, 3, 'cs (100)');
    data.setCell(53, 4, 14.23, '14.23');
    data.setCell(53, 5, 14.23, '14.23');
    data.setCell(53, 6, 1, '1');

    data.setCell(54, 0, 'Appert`s');
    data.setCell(54, 1, 72892, '72892');
    data.setCell(54, 2, 'Dr - Honey Mstrd');
    data.setCell(54, 3, 'gal');
    data.setCell(54, 4, 10.46, '10.46');
    data.setCell(54, 5, 41.82, '41.82');
    data.setCell(54, 6, 4, '4');

    data.setCell(55, 0, 'Appert`s');
    data.setCell(55, 1, 72748, '72748');
    data.setCell(55, 2, 'Dr - Lite Italian');
    data.setCell(55, 3, 'cs (100)');
    data.setCell(55, 4, 12.2, '12.20');
    data.setCell(55, 5, 12.2, '12.20');
    data.setCell(55, 6, 1, '1');

    data.setCell(56, 0, 'Appert`s');
    data.setCell(56, 1, 72746, '72746');
    data.setCell(56, 2, 'Dr - Lite Ranch');
    data.setCell(56, 3, 'cs (100)');
    data.setCell(56, 4, 13.96, '13.96');
    data.setCell(56, 5, 13.96, '13.96');
    data.setCell(56, 6, 1, '1');

    data.setCell(57, 0, 'Appert`s');
    data.setCell(57, 1, 72739, '72739');
    data.setCell(57, 2, 'Dr - Red Balsamic');
    data.setCell(57, 3, 'cs (48)');
    data.setCell(57, 4, 15.29, '15.29');
    data.setCell(57, 5, 15.29, '15.29');
    data.setCell(57, 6, 1, '1');

    data.setCell(58, 0, 'Appert`s');
    data.setCell(58, 1, 9052, '9052');
    data.setCell(58, 2, 'Eggs - Hard Boiled');
    data.setCell(58, 3, 'pouch (2 ea)');
    data.setCell(58, 4, 0.56, '0.56');
    data.setCell(58, 5, 8.93, '8.93');
    data.setCell(58, 6, 16, '16');

    data.setCell(59, 0, 'Appert`s');
    data.setCell(59, 1, 9056, '9056');
    data.setCell(59, 2, 'Eggs - Hard Boiled');
    data.setCell(59, 3, 'pouch (12 ea)');
    data.setCell(59, 4, 2.25, '2.25');
    data.setCell(59, 5, 26.94, '26.94');
    data.setCell(59, 6, 12, '12');

    data.setCell(60, 0, 'Appert`s');
    data.setCell(60, 1, 75923, '75923');
    data.setCell(60, 2, 'Fajita Seasoning');
    data.setCell(60, 3, 'jar');
    data.setCell(60, 4, 9.16, '9.16');
    data.setCell(60, 5, 9.16, '9.16');
    data.setCell(60, 6, 1, '1');

    data.setCell(61, 0, 'Jerry`s');
    data.setCell(61, 1, '');
    data.setCell(61, 2, 'Flour');
    data.setCell(61, 3, 'lb');
    data.setCell(61, 4, 0.26, '0.26');
    data.setCell(61, 5, 12.75, '12.75');
    data.setCell(61, 6, 50, '50');

    data.setCell(62, 0, 'Jerry`s');
    data.setCell(62, 1, '');
    data.setCell(62, 2, 'Garlic Cloves');
    data.setCell(62, 3, 'lb');
    data.setCell(62, 4, 2.3, '2.30');
    data.setCell(62, 5, 11.5, '11.50');
    data.setCell(62, 6, 5, '5');

    data.setCell(63, 0, 'Jerry`s');
    data.setCell(63, 1, '');
    data.setCell(63, 2, 'Green Peppers');
    data.setCell(63, 3, 'lug - 25 lb');
    data.setCell(63, 4, 16.75, '16.75');
    data.setCell(63, 5, 16.75, '16.75');
    data.setCell(63, 6, 1, '1');

    data.setCell(64, 0, 'Appert`s');
    data.setCell(64, 1, 16060, '16060');
    data.setCell(64, 2, 'Ham - Boiled');
    data.setCell(64, 3, 'lb');
    data.setCell(64, 4, 1.32, '1.32');
    data.setCell(64, 5, 68.45, '68.45');
    data.setCell(64, 6, 52, '52');

    data.setCell(65, 0, 'Appert`s');
    data.setCell(65, 1, 16448, '16448');
    data.setCell(65, 2, 'Ham - Flat Buffet');
    data.setCell(65, 3, 'lb');
    data.setCell(65, 4, 1.87, '1.87');
    data.setCell(65, 5, 1.87, '1.87');
    data.setCell(65, 6, 1, '1');

    data.setCell(66, 0, 'Appert`s');
    data.setCell(66, 1, 16110, '16110');
    data.setCell(66, 2, 'Ham - Smoked');
    data.setCell(66, 3, 'lb');
    data.setCell(66, 4, 2.11, '2.11');
    data.setCell(66, 5, 2.11, '2.11');
    data.setCell(66, 6, 1, '1');

    data.setCell(67, 0, 'Appert`s');
    data.setCell(67, 1, 14260, '14260');
    data.setCell(67, 2, 'Hamburger');
    data.setCell(67, 3, 'lb');
    data.setCell(67, 4, 3.16, '3.16');
    data.setCell(67, 5, 63.13, '63.13');
    data.setCell(67, 6, 20, '20');

    data.setCell(68, 0, 'Jerry`s');
    data.setCell(68, 1, '');
    data.setCell(68, 2, 'Hot Peppers - Sm Jar');
    data.setCell(68, 3, 'jar');
    data.setCell(68, 4, 2.06, '2.06');
    data.setCell(68, 5, 24.75, '24.75');
    data.setCell(68, 6, 12, '12');

    data.setCell(69, 0, 'Appert`s');
    data.setCell(69, 1, 34756, '34756');
    data.setCell(69, 2, 'Jalapenos');
    data.setCell(69, 3, 'can');
    data.setCell(69, 4, 6.9, '6.90');
    data.setCell(69, 5, 27.58, '27.58');
    data.setCell(69, 6, 4, '4');

    data.setCell(70, 0, 'Jerry`s');
    data.setCell(70, 1, '');
    data.setCell(70, 2, 'Lemon Juice');
    data.setCell(70, 3, 'bottle');
    data.setCell(70, 4, 4.9, '4.90');
    data.setCell(70, 5, 4.9, '4.90');
    data.setCell(70, 6, 1, '1');

    data.setCell(71, 0, 'Jerry`s');
    data.setCell(71, 1, '');
    data.setCell(71, 2, 'Lettuce - Salad');
    data.setCell(71, 3, 'lb');
    data.setCell(71, 4, 1.47, '1.47');
    data.setCell(71, 5, 1.47, '1.47');
    data.setCell(71, 6, 1, '1');

    data.setCell(72, 0, 'Jerry`s');
    data.setCell(72, 1, '');
    data.setCell(72, 2, 'Lettuce - Shredded');
    data.setCell(72, 3, 'lb');
    data.setCell(72, 4, 0.74, '0.74');
    data.setCell(72, 5, 14.75, '14.75');
    data.setCell(72, 6, 20, '20');

    data.setCell(73, 0, 'Jerry`s');
    data.setCell(73, 1, '');
    data.setCell(73, 2, 'Lime Juice');
    data.setCell(73, 3, 'bottle');
    data.setCell(73, 4, 4.75, '4.75');
    data.setCell(73, 5, 4.75, '4.75');
    data.setCell(73, 6, 1, '1');

    data.setCell(74, 0, 'Appert`s');
    data.setCell(74, 1, 8872, '8872');
    data.setCell(74, 2, 'Liquid Egg');
    data.setCell(74, 3, 'carton');
    data.setCell(74, 4, 2.48, '2.48');
    data.setCell(74, 5, 37.14, '37.14');
    data.setCell(74, 6, 15, '15');

    data.setCell(75, 0, 'Oven Hearth');
    data.setCell(75, 1, 610, '610');
    data.setCell(75, 2, 'Margarine');
    data.setCell(75, 3, '50 lb box');
    data.setCell(75, 4, 38, '38.00');
    data.setCell(75, 5, 38, '38.00');
    data.setCell(75, 6, 1, '1');

    data.setCell(76, 0, 'Jerry`s');
    data.setCell(76, 1, '');
    data.setCell(76, 2, 'Mayo');
    data.setCell(76, 3, 'gal');
    data.setCell(76, 4, 7.94, '7.94');
    data.setCell(76, 5, 31.75, '31.75');
    data.setCell(76, 6, 4, '4');

    data.setCell(77, 0, 'Appert`s');
    data.setCell(77, 1, 72986, '72986');
    data.setCell(77, 2, 'Mayo - Chipotle');
    data.setCell(77, 3, 'bag (5 lb)');
    data.setCell(77, 4, 16.15, '16.15');
    data.setCell(77, 5, 64.58, '64.58');
    data.setCell(77, 6, 4, '4');

    data.setCell(78, 0, 'Appert`s');
    data.setCell(78, 1, 18675, '18675');
    data.setCell(78, 2, 'Meatballs');
    data.setCell(78, 3, 'lb');
    data.setCell(78, 4, 2.76, '2.76');
    data.setCell(78, 5, 41.37, '41.37');
    data.setCell(78, 6, 15, '15');

    data.setCell(79, 0, 'Appert`s');
    data.setCell(79, 1, 8180, '8180');
    data.setCell(79, 2, 'Milk - 1%');
    data.setCell(79, 3, 'ea');
    data.setCell(79, 4, 0.44, '0.44');
    data.setCell(79, 5, 10.62, '10.62');
    data.setCell(79, 6, 24, '24');

    data.setCell(80, 0, 'Appert`s');
    data.setCell(80, 1, 8180, '8180');
    data.setCell(80, 2, 'Milk - Choc - 1%');
    data.setCell(80, 3, 'ea');
    data.setCell(80, 4, 0.44, '0.44');
    data.setCell(80, 5, 10.62, '10.62');
    data.setCell(80, 6, 24, '24');

    data.setCell(81, 0, 'Appert`s');
    data.setCell(81, 1, 65854, '65854');
    data.setCell(81, 2, 'Minute Maid Btl');
    data.setCell(81, 3, 'ea');
    data.setCell(81, 4, 0.75, '0.75');
    data.setCell(81, 5, 18.04, '18.04');
    data.setCell(81, 6, 24, '24');

    data.setCell(82, 0, 'Jerry`s');
    data.setCell(82, 1, '');
    data.setCell(82, 2, 'Mushrooms');
    data.setCell(82, 3, 'lb');
    data.setCell(82, 4, 1.75, '1.75');
    data.setCell(82, 5, 8.75, '8.75');
    data.setCell(82, 6, 5, '5');

    data.setCell(83, 0, 'Jerry`s');
    data.setCell(83, 1, '');
    data.setCell(83, 2, 'Olive Oil');
    data.setCell(83, 3, 'can');
    data.setCell(83, 4, 28.75, '28.75');
    data.setCell(83, 5, 28.75, '28.75');
    data.setCell(83, 6, 1, '1');

    data.setCell(84, 0, 'Jerry`s');
    data.setCell(84, 1, '');
    data.setCell(84, 2, 'Olives - Black Sliced');
    data.setCell(84, 3, 'can');
    data.setCell(84, 4, 7.96, '7.96');
    data.setCell(84, 5, 47.75, '47.75');
    data.setCell(84, 6, 6, '6');

    data.setCell(85, 0, 'Jerry`s');
    data.setCell(85, 1, '');
    data.setCell(85, 2, 'Olives - Green');
    data.setCell(85, 3, 'jar');
    data.setCell(85, 4, 9.94, '9.94');
    data.setCell(85, 5, 39.75, '39.75');
    data.setCell(85, 6, 4, '4');

    data.setCell(86, 0, 'Jerry`s');
    data.setCell(86, 1, '');
    data.setCell(86, 2, 'Onion - Red');
    data.setCell(86, 3, 'lb');
    data.setCell(86, 4, 0.63, '0.63');
    data.setCell(86, 5, 15.75, '15.75');
    data.setCell(86, 6, 25, '25');

    data.setCell(87, 0, 'Jerry`s');
    data.setCell(87, 1, '');
    data.setCell(87, 2, 'Onion - White');
    data.setCell(87, 3, 'lb');
    data.setCell(87, 4, 0.3, '0.30');
    data.setCell(87, 5, 0.3, '0.30');
    data.setCell(87, 6, 1, '1');

    data.setCell(88, 0, 'Appert`s');
    data.setCell(88, 1, 42336, '42336');
    data.setCell(88, 2, 'Oranges - Mandarin');
    data.setCell(88, 3, 'can');
    data.setCell(88, 4, 0.94, '0.94');
    data.setCell(88, 5, 22.59, '22.59');
    data.setCell(88, 6, 24, '24');

    data.setCell(89, 0, 'Jerry`s');
    data.setCell(89, 1, '');
    data.setCell(89, 2, 'Oregano');
    data.setCell(89, 3, 'lb');
    data.setCell(89, 4, 7.75, '7.75');
    data.setCell(89, 5, 7.75, '7.75');
    data.setCell(89, 6, 1, '1');

    data.setCell(90, 0, 'Jerry`s');
    data.setCell(90, 1, '');
    data.setCell(90, 2, 'Parsley');
    data.setCell(90, 3, 'lb');
    data.setCell(90, 4, 9.75, '9.75');
    data.setCell(90, 5, 9.75, '9.75');
    data.setCell(90, 6, 1, '1');

    data.setCell(91, 0, 'Appert`s');
    data.setCell(91, 1, 47496, '47496');
    data.setCell(91, 2, 'Pasta - Penne');
    data.setCell(91, 3, 'lb');
    data.setCell(91, 4, 1.15, '1.15');
    data.setCell(91, 5, 20.71, '20.71');
    data.setCell(91, 6, 18, '18');

    data.setCell(92, 0, 'Appert`s');
    data.setCell(92, 1, 47468, '47468');
    data.setCell(92, 2, 'Pasta Sheets');
    data.setCell(92, 3, 'cs');
    data.setCell(92, 4, 23.6, '23.60');
    data.setCell(92, 5, 23.6, '23.60');
    data.setCell(92, 6, 1, '1');

    data.setCell(93, 0, 'Appert`s');
    data.setCell(93, 1, 20014, '20014');
    data.setCell(93, 2, 'Pastrami');
    data.setCell(93, 3, 'lb');
    data.setCell(93, 4, 3.82, '3.82');
    data.setCell(93, 5, 3.82, '3.82');
    data.setCell(93, 6, 1, '1');

    data.setCell(94, 0, 'Jerry`s');
    data.setCell(94, 1, '');
    data.setCell(94, 2, 'Pepperocini');
    data.setCell(94, 3, 'jar');
    data.setCell(94, 4, 6.75, '6.75');
    data.setCell(94, 5, 6.75, '6.75');
    data.setCell(94, 6, 1, '1');

    data.setCell(95, 0, 'Appert`s');
    data.setCell(95, 1, 14300, '14300');
    data.setCell(95, 2, 'Pepperoni');
    data.setCell(95, 3, 'lb');
    data.setCell(95, 4, 2.19, '2.19');
    data.setCell(95, 5, 54.64, '54.64');
    data.setCell(95, 6, 25, '25');

    data.setCell(96, 0, 'Appert`s');
    data.setCell(96, 1, 42570, '42570');
    data.setCell(96, 2, 'Pineapple - 20 oz can');
    data.setCell(96, 3, 'ea');
    data.setCell(96, 4, 1.28, '1.28');
    data.setCell(96, 5, 30.78, '30.78');
    data.setCell(96, 6, 24, '24');

    data.setCell(97, 0, 'Appert`s');
    data.setCell(97, 1, 42587, '42587');
    data.setCell(97, 2, 'Pineapple - #10 can');
    data.setCell(97, 3, 'ea');
    data.setCell(97, 4, 4.79, '4.79');
    data.setCell(97, 5, 28.75, '28.75');
    data.setCell(97, 6, 6, '6');

    data.setCell(98, 0, 'Appert`s');
    data.setCell(98, 1, '65835,40,45');
    data.setCell(98, 2, 'Pop Cans');
    data.setCell(98, 3, 'ea');
    data.setCell(98, 4, 0.38, '0.38');
    data.setCell(98, 5, 9.23, '9.23');
    data.setCell(98, 6, 24, '24');

    data.setCell(99, 0, 'Appert`s');
    data.setCell(99, 1, 43585, '43585');
    data.setCell(99, 2, 'Red Peppers - Can');
    data.setCell(99, 3, 'can');
    data.setCell(99, 4, 2.55, '2.55');
    data.setCell(99, 5, 30.54, '30.54');
    data.setCell(99, 6, 12, '12');

    data.setCell(100, 0, 'Oven Hearth');
    data.setCell(100, 1, 600, '600');
    data.setCell(100, 2, 'Rice Crispy Bar');
    data.setCell(100, 3, 'ea');
    data.setCell(100, 4, 0.39, '0.39');
    data.setCell(100, 5, 9.4, '9.40');
    data.setCell(100, 6, 24, '24');

    data.setCell(101, 0, 'Appert`s');
    data.setCell(101, 1, 18312, '18312');
    data.setCell(101, 2, 'Roast Beef - Dan Prize');
    data.setCell(101, 3, 'lb');
    data.setCell(101, 4, 3.86, '3.86');
    data.setCell(101, 5, 3.86, '3.86');
    data.setCell(101, 6, 1, '1');

    data.setCell(102, 0, 'Appert`s');
    data.setCell(102, 1, 19715, '19715');
    data.setCell(102, 2, 'Salami');
    data.setCell(102, 3, 'lb');
    data.setCell(102, 4, 3.76, '3.76');
    data.setCell(102, 5, 37.59, '37.59');
    data.setCell(102, 6, 10, '10');

    data.setCell(103, 0, 'Jerry`s');
    data.setCell(103, 1, '');
    data.setCell(103, 2, 'Salt');
    data.setCell(103, 3, 'box (26 oz)');
    data.setCell(103, 4, 0.55, '0.55');
    data.setCell(103, 5, 0.55, '0.55');
    data.setCell(103, 6, 1, '1');

    data.setCell(104, 0, 'Appert`s');
    data.setCell(104, 1, 76906, '76906');
    data.setCell(104, 2, 'Sauce - Al Dente');
    data.setCell(104, 3, 'can');
    data.setCell(104, 4, 4.89, '4.89');
    data.setCell(104, 5, 29.32, '29.32');
    data.setCell(104, 6, 6, '6');

    data.setCell(105, 0, 'Appert`s');
    data.setCell(105, 1, 34408, '34408');
    data.setCell(105, 2, 'Sauce - Alfredo');
    data.setCell(105, 3, 'cs - 6');
    data.setCell(105, 4, 54.75, '54.75');
    data.setCell(105, 5, 54.75, '54.75');
    data.setCell(105, 6, 1, '1');

    data.setCell(106, 0, 'Appert`s');
    data.setCell(106, 1, 77076, '77076');
    data.setCell(106, 2, 'Sauce - Deep Dish');
    data.setCell(106, 3, 'cs - 5');
    data.setCell(106, 4, 25.51, '25.51');
    data.setCell(106, 5, 25.51, '25.51');
    data.setCell(106, 6, 1, '1');

    data.setCell(107, 0, 'Appert`s');
    data.setCell(107, 1, 77078, '77078');
    data.setCell(107, 2, 'Sauce - Red');
    data.setCell(107, 3, 'cs - 8');
    data.setCell(107, 4, 26.11, '26.11');
    data.setCell(107, 5, 26.11, '26.11');
    data.setCell(107, 6, 1, '1');

    data.setCell(108, 0, 'Appert`s');
    data.setCell(108, 1, 77070, '77070');
    data.setCell(108, 2, 'Sauce - Traditional');
    data.setCell(108, 3, 'cs - 4');
    data.setCell(108, 4, 22.72, '22.72');
    data.setCell(108, 5, 22.72, '22.72');
    data.setCell(108, 6, 1, '1');

    data.setCell(109, 0, 'Appert`s');
    data.setCell(109, 1, 34270, '34270');
    data.setCell(109, 2, 'Sausage - Lasagna');
    data.setCell(109, 3, 'lb');
    data.setCell(109, 4, 2.34, '2.34');
    data.setCell(109, 5, 38.55, '38.55');
    data.setCell(109, 6, 16.5, '17');

    data.setCell(110, 0, 'Appert`s');
    data.setCell(110, 1, 14326, '14326');
    data.setCell(110, 2, 'Sausage - Pizza');
    data.setCell(110, 3, 'lb');
    data.setCell(110, 4, 2.15, '2.15');
    data.setCell(110, 5, 42.93, '42.93');
    data.setCell(110, 6, 20, '20');

    data.setCell(111, 0, 'Appert`s');
    data.setCell(111, 1, 13254, '13254');
    data.setCell(111, 2, 'Sausage Links');
    data.setCell(111, 3, 'lb');
    data.setCell(111, 4, 2.65, '2.65');
    data.setCell(111, 5, 26.51, '26.51');
    data.setCell(111, 6, 10, '10');

    data.setCell(112, 0, 'Appert`s');
    data.setCell(112, 1, 3005, '3005');
    data.setCell(112, 2, 'Snap Peas');
    data.setCell(112, 3, 'lb');
    data.setCell(112, 4, 3.65, '3.65');
    data.setCell(112, 5, 7.3, '7.30');
    data.setCell(112, 6, 2, '2');

    data.setCell(113, 0, 'Jerry`s');
    data.setCell(113, 1, '');
    data.setCell(113, 2, 'Spinach');
    data.setCell(113, 3, 'bag - 2.5lb');
    data.setCell(113, 4, 4.74, '4.74');
    data.setCell(113, 5, 4.74, '4.74');
    data.setCell(113, 6, 1, '1');

    data.setCell(114, 0, 'Oven Hearth');
    data.setCell(114, 1, 516, '516');
    data.setCell(114, 2, 'Thin - Cut Large');
    data.setCell(114, 3, 'ea');
    data.setCell(114, 4, 1.1, '1.10');
    data.setCell(114, 5, 1.1, '1.10');
    data.setCell(114, 6, 1, '1');

    data.setCell(115, 0, 'Oven Hearth');
    data.setCell(115, 1, 515, '515');
    data.setCell(115, 2, 'Thin - Cut Medium');
    data.setCell(115, 3, 'ea');
    data.setCell(115, 4, 0.74, '0.74');
    data.setCell(115, 5, 0.74, '0.74');
    data.setCell(115, 6, 1, '1');

    data.setCell(116, 0, 'Oven Hearth');
    data.setCell(116, 1, 513, '513');
    data.setCell(116, 2, 'Thin - Large');
    data.setCell(116, 3, 'ea');
    data.setCell(116, 4, 1.05, '1.05');
    data.setCell(116, 5, 1.05, '1.05');
    data.setCell(116, 6, 1, '1');

    data.setCell(117, 0, 'Oven Hearth');
    data.setCell(117, 1, 512, '512');
    data.setCell(117, 2, 'Thin - Medium');
    data.setCell(117, 3, 'ea');
    data.setCell(117, 4, 0.69, '0.69');
    data.setCell(117, 5, 0.69, '0.69');
    data.setCell(117, 6, 1, '1');

    data.setCell(118, 0, 'Jerry`s');
    data.setCell(118, 1, '');
    data.setCell(118, 2, 'Tomatoes - Roma');
    data.setCell(118, 3, 'lb (25 lb/lug)');
    data.setCell(118, 4, 1.11, '1.11');
    data.setCell(118, 5, 27.75, '27.75');
    data.setCell(118, 6, 25, '25');

    data.setCell(119, 0, 'Jerry`s');
    data.setCell(119, 1, '');
    data.setCell(119, 2, 'Tomatos');
    data.setCell(119, 3, 'lug (20 lb/lug)');
    data.setCell(119, 4, 27.75, '27.75');
    data.setCell(119, 5, 27.75, '27.75');
    data.setCell(119, 6, 1, '1');

    data.setCell(120, 0, 'Appert`s');
    data.setCell(120, 1, 72392, '72392');
    data.setCell(120, 2, 'Tortilla Strips');
    data.setCell(120, 3, 'cs (100)');
    data.setCell(120, 4, 13.36, '13.36');
    data.setCell(120, 5, 13.36, '13.36');
    data.setCell(120, 6, 1, '1');

    data.setCell(121, 0, 'Appert`s');
    data.setCell(121, 1, 31400, '31400');
    data.setCell(121, 2, 'Tuna');
    data.setCell(121, 3, 'pouch');
    data.setCell(121, 4, 10.73, '10.73');
    data.setCell(121, 5, 64.39, '64.39');
    data.setCell(121, 6, 6, '6');

    data.setCell(122, 0, 'Appert`s');
    data.setCell(122, 1, 25400, '25400');
    data.setCell(122, 2, 'Turkey');
    data.setCell(122, 3, 'lb');
    data.setCell(122, 4, 3.19, '3.19');
    data.setCell(122, 5, 3.19, '3.19');
    data.setCell(122, 6, 1, '1');

    data.setCell(123, 0, 'Oven Hearth');
    data.setCell(123, 1, 521, '521');
    data.setCell(123, 2, 'Wheat Thin - Solo');
    data.setCell(123, 3, 'ea');
    data.setCell(123, 4, 0.44, '0.44');
    data.setCell(123, 5, 0.44, '0.44');
    data.setCell(123, 6, 1, '1');

    data.setCell(124, 0, 'Wine Supplier');
    data.setCell(124, 1, '');
    data.setCell(124, 2, 'Wine - Chardonnay');
    data.setCell(124, 3, 'Bottle');
    data.setCell(124, 4, 1.19, '1.19');
    data.setCell(124, 5, 28.45, '28.45');
    data.setCell(124, 6, 24, '24');

    data.setCell(125, 0, 'Wine Supplier');
    data.setCell(125, 1, '');
    data.setCell(125, 2, 'Wine - Merlot');
    data.setCell(125, 3, 'Bottle');
    data.setCell(125, 4, 1.19, '1.19');
    data.setCell(125, 5, 28.45, '28.45');
    data.setCell(125, 6, 24, '24');

    data.setCell(126, 0, 'Appert`s');
    data.setCell(126, 1, 72394, '72394');
    data.setCell(126, 2, 'Wontons');
    data.setCell(126, 3, 'cs (100)');
    data.setCell(126, 4, 16.15, '16.15');
    data.setCell(126, 5, 16.15, '16.15');
    data.setCell(126, 6, 1, '1');

    data.setCell(127, 0, 'Jerry`s');
    data.setCell(127, 1, '');
    data.setCell(127, 2, 'Yeast');
    data.setCell(127, 3, 'cs (40 ea)');
    data.setCell(127, 4, 41.75, '41.75');
    data.setCell(127, 5, 41.75, '41.75');
    data.setCell(127, 6, 1, '1');

    // Create and draw the visualization.
    var table = new google.visualization.Table(document.getElementById('mytable_div'));
    table.draw(data, {allowHtml: true, showRowNumber: false, alternatingRowStyle: true});
  }
  </script>
 </head>

 <body>
  <div id="mytable_div"></div>
 </body>
</html>
[[/code]]
[[/collapsible]]

Community Admin

Last edited on 18 Jun 2009 22:33 by

(account deleted) Show more

Options

Unfold Re: Ajax Error 500 by

(account deleted), 18 Jun 2009 22:28

Fold

Re: Ajax Error 500

Gabrys 18 Jun 2009 22:41

Unfortunately this can mean almost anything, it's like:

some PHP error appear (probably with PCRE or other library)
therefor PHP dies with no output (Wikidot echoes the content all at once at the end of processing)
the bug is so critical that even no Fatal Error: message appears
the fcgi connection breaks (because backend actually dies)
Lighttpd logs the situation

I have one more idea. Raise memory limit in php.ini (to like 200-300 MB to be sure). I bet this solves the problem (that, I still believe, is connected to regular expressions or some process during compiling page).

You can share what amount of memory you ended with.

Piotr Gabryjeluk
visit my blog

Options

Unfold Re: Ajax Error 500 by

Gabrys, 18 Jun 2009 22:41

Fold

Re: Ajax Error 500 - SOLVED!

(account deleted) 19 Jun 2009 04:16

OK, now I'm embarrassed. After trying all of your suggestions with no success I decided to double-check my PCRE config (even though I was sure it was correct - NOT!) It did turn out to be a problem with my PCRE config:

root@mywikidot:/usr/src/debian/pcre/pcre3-7.4# pcretest -C | grep 'Match recursion'
  Match recursion uses stack

Redoing the steps in the PCRE tweaks article gave the correct result and my pages are saving fine now.

root@mywikidot:/usr/src/debian/pcre/pcre3-7.4# pcretest -C | grep 'Match recursion'
  Match recursion uses heap

The funny thing is that I was extremely careful in documenting my steps to insure that I had a bullet-proof install. I obviously had some kind of error or missed step when I did the PCRE stuff. Thanks for helping me sort it out.

I'm going to do some more testing with rev 466 and then create an updated installable ISO.

-Ed

Community Admin

Options

Unfold Re: Ajax Error 500 - SOLVED! by

(account deleted), 19 Jun 2009 04:16

Fold

Re: Ajax Error 500 - SOLVED!

Gabrys 19 Jun 2009 09:44

So, memory limit didn't have to be raised?

Don't be ashamed, I'm really glad, that this works for you, and we know EXACTLY what is the problem. And the solution is put on wiki page for anyone encountering the same problem in future.

Thanks Ed.

Piotr Gabryjeluk
visit my blog

Options

Unfold Re: Ajax Error 500 - SOLVED! by

Gabrys, 19 Jun 2009 09:44

Fold

Re: Ajax Error 500 - SOLVED!

(account deleted) 19 Jun 2009 14:05

I'm not as embarrassed as I was last night. I just figured out that an update to PCRE reverted the match recursion setting back to using "stack" instead of "heap". I set up a new VM with my rev 393 ISO and found that after applying a bunch of Ubuntu updates (including pcre) that the setting got switched back.

I had previously increased my memory limits a while ago due to a similar error. I blogged about it here. I just increased it to 64M, 4x the default of 16M - I was totally making a guess! ;) Do you think I should crank it up to 200m - 300m as you suggest? Is there any chance of a performance hit if I set it too high?

-Ed

Community Admin

Options

Unfold Re: Ajax Error 500 - SOLVED! by

(account deleted), 19 Jun 2009 14:05

Fold

Re: Ajax Error 500 - SOLVED!

Gabrys 19 Jun 2009 14:41

64 should be OK. If you have some problems (that can appear on very specific pages) you can try if increasing it makes sense.

But sometimes increasing the memory limit means that script will hit the time limit, so probably setting it too high is also not a perfect solution.

Summing up, this all depends on way you use Wikidot.

And yes, upgrading pcre installs the default Debian/Ubuntu version, that uses stack, so you need to recompile it again, to benefit from it.

Piotr Gabryjeluk
visit my blog

Reply Options

Unfold Re: Ajax Error 500 - SOLVED! by

Gabrys, 19 Jun 2009 14:41

New Post

Wikidot Open Source

Contribute!

Resources

Tags

Who watches?