var-type undefined: stringIgnoreNull(Daniel) - Account Edit

[mesnitu]

Hi
Getting this var-type undefined: stringIgnoreNull(Daniel) , on account edit page trying to update some info.

There's no log report on this one..... javascript ?

Thanks

[mesnitu]

I have rewards points on this page.... but not sure what should I be looking

[mesnitu]

And also happening in address_book_process .........

[mesnitu]

ok, I've narrow down the issue to this type stringIgnoreNull
If I change all this :
$sql_data_array = array(array('fieldName'=>'customers_firstname', 'value'=>$firstname, 'type'=>'stringIgnoreNull'),

to this :

$sql_data_array = array(array('fieldName'=>'customers_firstname', 'value'=>$firstname, 'type'=>'string'),


Life is much better.
But I guess, this is here for a reason. So where could this error coming from ? php, mysql version ?
Using php5.6.15 , mysql mysqlnd 5.0.11...

Thanks

[mc12345678]

Where is this code from? Looks like information possibly related to ZC 1.5.5a or the recent sanitization software that should be installed/incorporated into ZC 1.5.x.

[mesnitu]

Hi
I just found out, but yes, probably that's it... I've check the lasted download package and compare it and
I had no

case 'stringIgnoreNull':
        return '\'' . $this->prepare_input($value) . '\'';
        break;

in query_factor.php .
I've downloaded the last update that you've mentioned... but there was no change on this file... Or probably I've updated to 155a and miss this file ( and hopefully, nothing else )
It's working now !

Thanks

[mesnitu]

But looking at the docs folder changed_files-v1-5-5.html, I see no changes reported to this file...
But no one has reported this.... so I guess it's a matter of karma :)

[mc12345678]

1. To help others that come along this thread, could you please identify what version of ZC you are/were using when this issue arose?
2. You said something about 1.5.5 and some sort of file comparison, but how did the version of ZC you are using come to be?
3. Was this an upgrade?
4. Is/was this happening with your ZC base code or was it in relation to a plugin?

[DrByte]

It's possible that the query_factory file might not have been listed in the docs as one of the changed files. But it definitely was changed!

[mesnitu]

1. To help others that come along this thread, could you please identify what version of ZC you are/were using when this issue arose?
2. You said something about 1.5.5 and some sort of file comparison, but how did the version of ZC you are using come to be?
3. Was this an upgrade?
4. Is/was this happening with your ZC base code or was it in relation to a plugin?

My current version is 155a

I started with v155
Looking at the original files from 155, this type stringIgnoreNull is not there in \includes\classes\db\mysql\query_factor.php

So it has been added on update 155a.
But it was not mentioned in the changed files docs that I followed when I updated to 155a... so... error.

This type stringIgnoreNull is use around 5 files, related to customers, accounts edits, etc...

So it's better to "reupload" the query_factor.php from 155a... in case one gets this error.

I think I've express my self very badly :)