Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

How can a user run a report?

admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: How can a user run a report?

Unread post by admin »

rnott,

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

Steven
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: How can a user run a report?

Unread post by massiws »

rnott,
I made your test:
test.png
test.png (148.42 KiB) Viewed 10368 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
rnott
Posts: 31
Joined: Fri Mar 14, 2014 6:14 pm

Re: How can a user run a report?

Unread post by rnott »

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 366 times
rnott
Posts: 31
Joined: Fri Mar 14, 2014 6:14 pm

Re: How can a user run a report?

Unread post 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...
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: How can a user run a report?

Unread post 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;
rnott
Posts: 31
Joined: Fri Mar 14, 2014 6:14 pm

Re: How can a user run a report?

Unread post by rnott »

I increased the max_input_vars in php.ini ... and it fixed my problems

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

Thanks!! :D
massiws
Posts: 503
Joined: Thu May 24, 2012 2:08 am
Location: Milan, Italy
Contact:

Re: How can a user run a report?

Unread post by massiws »

Ok!
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: How can a user run a report?

Unread post 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
Locked