Page 3 of 3

Re: How can a user run a report?

PostPosted: Thu Apr 10, 2014 9:28 am
by admin
rnott,

If you zip up your problem db and attach it I'll take a look.

Steven

Re: How can a user run a report?

PostPosted: Thu Apr 10, 2014 9:45 am
by massiws
rnott,
I made your test:
test.png
test.png (148.42 KiB) Viewed 8460 times


But...
rnott wrote:... Extra Action Buttons tab->Title=Test & Javascript=alert("Test"); -> Delete is not checked ...

if you use double quotes in Extra Action Button -> Javascript to run you get a javascript error : you MUST use single quote:
Code: Select all
alert('clicked!');


@Steven: maybe could this be correct on next releases?

Max

Re: How can a user run a report?

PostPosted: Thu Apr 10, 2014 12:55 pm
by rnott
can you try to add/delete browse form columns?

I'm attaching the zip file
thanks

Re: How can a user run a report?

PostPosted: Fri Apr 11, 2014 10:58 am
by rnott
If I do a tail -f /var/log/mysql/mysql.log
...I get about 7000+ lines of output in the mysql log whenever I click the Save button when trying to Add or Delete Browse columns...whenever I have 30+ objects on my edit form...

Re: How can a user run a report?

PostPosted: Fri Apr 11, 2014 9:50 pm
by massiws
rnott,
problem is in your table structure: try to remove UNIQUE KEY constraint:
Code: Select all
CREATE TABLE IF NOT EXISTS `test_table` (
  `test_table_id` varchar(25) COLLATE utf8_unicode_ci NOT NULL COMMENT 'nuBuilder ID',
  `tes_test1` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test1',
  `tes_Test2` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test2',
  `tes_test3` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test3',
  `tes_test4` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test4',
  `tes_test5` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test5',
  `tes_test6` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test6',
  `tes_test7` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test7',
  `tes_test8` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test8',
  `tes_test9` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test9',
  `tes_test10` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test10',
  `tes_test11` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test11',
  `tes_test12` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test12',
  `tes_test13` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test13',
  `tes_test14` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test14',
  `tes_test15` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test15',
  `tes_test16` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test16',
  `tes_test17` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test17',
  `tes_test18` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test18',
  `tes_test19` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test19',
  `tes_test20` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test20',
  `tes_test21` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test21',
  `tes_test22` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test22',
  `tes_test23` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test23',
  `tes_test24` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test24',
  `tes_test25` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test25',
  `tes_test26` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test26',
  `tes_test27` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test27',
  `tes_test28` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test28',
  `tes_test29` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test29',
  `tes_test30` varchar(10) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Test30',
  PRIMARY KEY (`test_table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Re: How can a user run a report?

PostPosted: Wed Apr 23, 2014 4:25 am
by rnott
I increased the max_input_vars in php.ini ... and it fixed my problems

I found this post...
http://forums.nubuilder.com/viewtopic.php?f=13&t=8413

Thanks!! :D

Re: How can a user run a report?

PostPosted: Wed Apr 23, 2014 9:19 am
by massiws
Ok!

Re: How can a user run a report?

PostPosted: Wed Apr 23, 2014 12:28 pm
by admin
rnott wrote:I just cloned the nuBuilder github repository-->modified config.php-->and ran nuinstall.php

but still not creating Extra Action Button on my form...

I created a new form and I was able to create the Extra Action Button--> and when I clicked it I got the alert message

I have 90 objects on the form that will not create the Extra Action Button. The Order value is set to 10 on most of them & others have duplicate values...this may be the problem...I will Reorder the objects and see if it will fix.
Thanks


rnott,

For this problem, increase max_input_vars in php.ini

Steven