NuBuilder Form nuData error line 161

[calhoun1]

New to nuBuilder trying to use the Pizza Delivery demo on my local machine. Have tried two installs and get the same error and I am sure it is configuration related but can't track it down.

Warning: in_array() expects parameter 2 to be array, null given in C:\xampp\htdocs\nubuilder4\nudata.php on line 161

{"record_id":null,"after_event":false,"user_name":null,"access_level_code":"","user_id":"globeadmin","database":"pizzadelivery","dimensions":{"browse":{"height":707,"width":860},"edit":{"height":305,"width":781},"grid":{"height":"150","width":5540}},"translation":[],"tableSchema":{"":{"names":[],"types":[],"primary_key":[],"valid":1}},"viewSchema":[null,null],"formSchema":[],"session_id":"s15826709125942","callback":"","errors":["zzzzsys_form<\/b> is not a valid table name for a Subform"],"log_again":null,"global_access":"1","form_access":"1","javascript":null,"target":null,"buttons":{"Add":"1","Print":"1","Save":"1","Clone":"1","Delete":"1","Run":"","RunHidden":""},"run_code":"","run_description":""}

Screen is populated. Also get the same thing when I try to add a new form.

Dumped data on screen and get this:

object(stdClass)#10 (13) {
["id"]=>
string(18) "nuBuilder4EditForm"
["foreign_key"]=>
string(0) ""
["primary_key"]=>
string(15) "zzzzsys_form_id"
["object_id"]=>
string(6) "nuform"
["table"]=>
string(12) "zzzzsys_form"
["action"]=>
string(4) "save"
["rows"]=>
array(1) {
[0]=>
array(12) {
[0]=>
string(15) "5d894c645d44009"
[1]=>
int(0)
[2]=>
string(10) "browseedit"
[3]=>
string(3) "CUS"
[4]=>
string(8) "Customer"
[5]=>
string(8) "customer"
[6]=>
string(11) "customer_id"
[7]=>
string(22) "SELECT * FROM customer"
[8]=>
string(0) ""
[9]=>
string(0) ""
[10]=>
string(0) ""
[11]=>
string(0) ""
}
}
["columns"]=>
NULL
["chartData"]=>
NULL
["chartDataPivot"]=>
NULL
["edited"]=>
array(1) {
[0]=>
array(12) {
[0]=>
int(0)
[1]=>
int(0)
[2]=>
int(1)
[3]=>
int(0)
[4]=>
int(0)
[5]=>
int(0)
[6]=>
int(0)
[7]=>
int(0)
[8]=>
int(0)
[9]=>
int(0)
[10]=>
int(0)
[11]=>
int(0)
}
}
["deleted"]=>
array(1) {
[0]=>
int(0)
}
["fields"]=>
array(12) {
[0]=>
string(2) "ID"
[1]=>
string(8) "nuDelete"
[2]=>
string(8) "sfo_type"
[3]=>
string(8) "sfo_code"
[4]=>
string(15) "sfo_description"
[5]=>
string(9) "sfo_table"
[6]=>
string(15) "sfo_primary_key"
[7]=>
string(14) "sfo_browse_sql"
[8]=>
string(21) "sfo_browse_row_height"
[9]=>
string(24) "sfo_browse_rows_per_page"
[10]=>
string(27) "sfo_browse_redirect_form_id"
[11]=>
string(14) "sfo_javascript"
}
}
object(stdClass)#10 (13) {
["id"]=>
string(18) "nuBuilder4EditForm"
["foreign_key"]=>
string(0) ""
["primary_key"]=>
string(15) "zzzzsys_form_id"
["object_id"]=>
string(6) "nuform"
["table"]=>
string(12) "zzzzsys_form"
["action"]=>
string(4) "save"
["rows"]=>
array(1) {
[0]=>
array(12) {
[0]=>
string(15) "5d894c645d44009"
[1]=>
int(0)
[2]=>
string(10) "browseedit"
[3]=>
string(3) "CUS"
[4]=>
string(8) "Customer"
[5]=>
string(8) "customer"
[6]=>
string(11) "customer_id"
[7]=>
string(22) "SELECT * FROM customer"
[8]=>
string(0) ""
[9]=>
string(0) ""
[10]=>
string(0) ""
[11]=>
string(0) ""
}
}
["columns"]=>
NULL
["chartData"]=>
NULL
["chartDataPivot"]=>
NULL
["edited"]=>
array(1) {
[0]=>
array(12) {
[0]=>
int(0)
[1]=>
int(0)
[2]=>
int(1)
[3]=>
int(0)
[4]=>
int(0)
[5]=>
int(0)
[6]=>
int(0)
[7]=>
int(0)
[8]=>
int(0)
[9]=>
int(0)
[10]=>
int(0)
[11]=>
int(0)
}
}
["deleted"]=>
array(1) {
[0]=>
int(0)
}
["fields"]=>
array(12) {
[0]=>
string(2) "ID"
[1]=>
string(8) "nuDelete"
[2]=>
string(8) "sfo_type"
[3]=>
string(8) "sfo_code"
[4]=>
string(15) "sfo_description"
[5]=>
string(9) "sfo_table"
[6]=>
string(15) "sfo_primary_key"
[7]=>
string(14) "sfo_browse_sql"
[8]=>
string(21) "sfo_browse_row_height"
[9]=>
string(24) "sfo_browse_rows_per_page"
[10]=>
string(27) "sfo_browse_redirect_form_id"
[11]=>
string(14) "sfo_javascript"
}
}
string(4) "save"
array(1) {
[0]=>
array(12) {
[0]=>
string(15) "5d894c645d44009"
[1]=>
int(0)
[2]=>
string(10) "browseedit"
[3]=>
string(3) "CUS"
[4]=>
string(8) "Customer"
[5]=>
string(8) "customer"
[6]=>
string(11) "customer_id"
[7]=>
string(22) "SELECT * FROM customer"
[8]=>
string(0) ""
[9]=>
string(0) ""
[10]=>
string(0) ""
[11]=>
string(0) ""
}
}
array(1) {
[0]=>
array(12) {
[0]=>
int(0)
[1]=>
int(0)
[2]=>
int(1)
[3]=>
int(0)
[4]=>
int(0)
[5]=>
int(0)
[6]=>
int(0)
[7]=>
int(0)
[8]=>
int(0)
[9]=>
int(0)
[10]=>
int(0)
[11]=>
int(0)
}
}
array(1) {
[0]=>
int(0)
}
array(12) {
[0]=>
string(2) "ID"
[1]=>
string(8) "nuDelete"
[2]=>
string(8) "sfo_type"
[3]=>
string(8) "sfo_code"
[4]=>
string(15) "sfo_description"
[5]=>
string(9) "sfo_table"
[6]=>
string(15) "sfo_primary_key"
[7]=>
string(14) "sfo_browse_sql"
[8]=>
string(21) "sfo_browse_row_height"
[9]=>
string(24) "sfo_browse_rows_per_page"
[10]=>
string(27) "sfo_browse_redirect_form_id"
[11]=>
string(14) "sfo_javascript"
}
string(12) "zzzzsys_form"
string(15) "zzzzsys_form_id"
string(0) ""
string(15) "5d894c645d44009"
array(0) {
}

XAMPP 3.2.4
MYSQL 8.0.19
PHP 7.4.2
Windows 10 64 bit

[kev1n]

Hi,

Could you post the lines from nudata.php around line 161 here?

Are you using the latest file from Github? https://github.com/steven-copley/nubuilder4

[calhoun1]

Thx Kev1n,

I have downloaded from GitHub and from sourceforge with exactly the same results. Tried it with xampp and apache. Tried many things but when I go and try to add any form or update form I get same errors. With creating a new one or trying to use the pizza delivery demo/sample that already has from created. Has to be a version for mysql/php or something. Spent hours trying to figure it out with no luck.

It is like it is not getting form id or something from the page.

Code: Select all

	for($d = 0 ; $d < count($nudata) ; $d++){
		
		$sf			= $nudata[$d];
		$action		= $sf->action;
		$rows		= $sf->rows;
		$edited		= $sf->edited;
		$deleted	= $sf->deleted;
		$fields		= $sf->fields;
		$table		= $sf->table;
		$pk			= $sf->primary_key;
		$fk			= $sf->foreign_key;
		$fv			= $_POST['nuHash']['record_id'];
		$auto		= nuAutoNumbers($sf->object_id);
		$log		= in_array($table . '_nulog', $cts[$table]['names']);       Best I can tell this is line 161.
		
		for($r = 0 ; $r < count($rows) ; $r++){

Thanks in advance.

[kev1n]

Could you upload a db dump?

https://forums.nubuilder.cloud/viewtopic. ... 234#p20312

[admin]

calhoun1,

What version of PHP are you using?


Steven

[kev1n]

XAMPP 3.2.4
MYSQL 8.0.19
PHP 7.4.2
Windows 10 64 bit

[calhoun1]

Thanks Kev1n,

I uploaded my pizzadelivery db. Here is the download link it gave me.

You can download it from address: http://s000.tinyupload.com/?file_id=733 ... 6604264000

Mike

[kev1n]

I'm not getting any error messages here. My configuration:

-- XAMPP 3.2.4
-- Server-Version: 10.4.11-MariaDB
-- PHP-Version: 7.4.2
-- Windows 10 64bit


The only difference I see is that you are using MYSQL.

I used this XAMPP link: https://www.apachefriends.org/xampp-fil ... taller.exe

[calhoun1]

Kev1n,

Thanks for your help. I dumped db, uninstalled everything. I then reinstalled using MariaDB and things seem to be working. I mean there are some app issues but can add rows in the forms and other stuff. Had some issues re-importing but worked thru those.

So now I can start playing with the demo and trying things.

Thanks again.

Mike