How can a user run a report?

Re: How can a user run a report?

Postby admin » Thu Apr 10, 2014 9:28 am

rnott,

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

Steven
admin
Site Admin
 
Posts: 3162
Joined: Mon Jun 15, 2009 9:53 am

Re: How can a user run a report?

Postby massiws » Thu Apr 10, 2014 9:45 am

rnott,
I made your test:
test.png
test.png (148.42 KiB) Viewed 7628 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
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: How can a user run a report?

Postby rnott » Thu Apr 10, 2014 12:55 pm

can you try to add/delete browse form columns?

I'm attaching the zip file
thanks
Attachments
testdb_dump_04092014152228.zip
(49.39 KiB) Downloaded 204 times
rnott
 
Posts: 31
Joined: Sat Mar 15, 2014 2:44 am

Re: How can a user run a report?

Postby rnott » Fri Apr 11, 2014 10:58 am

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...
rnott
 
Posts: 31
Joined: Sat Mar 15, 2014 2:44 am

Re: How can a user run a report?

Postby massiws » Fri Apr 11, 2014 9:50 pm

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;
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: How can a user run a report?

Postby rnott » Wed Apr 23, 2014 4:25 am

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
rnott
 
Posts: 31
Joined: Sat Mar 15, 2014 2:44 am

Re: How can a user run a report?

Postby massiws » Wed Apr 23, 2014 9:19 am

Ok!
massiws
 
Posts: 503
Joined: Thu May 24, 2012 9:38 am
Location: Milan, Italy

Re: How can a user run a report?

Postby admin » Wed Apr 23, 2014 12:28 pm

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
admin
Site Admin
 
Posts: 3162
Joined: Mon Jun 15, 2009 9:53 am

Previous

Return to Report Writer



cron