paschoolboards

odd. i see that it was committed and verified in dec of 2019, but i have 2.7.26.2 according to wordpress, but i’m nt seeing this update. I ended up have to completely remove pods and reinstall it manually

469: self::$current_language = $lang_data[‘language’];

changed to:

469: self::$current_language = isset($lang_data[‘language’]) ? $lang_data[‘language’] : ”;

i used isset since array_key_exists has been deprecated

On Line 12, you can see how the double quotes are used to depict a strict but when ANSI_QUOTES is enabled, it sees “blahblah” as an identifired same as ` is used. So it’s looking for a column instead of seeing it as a string value. just changing it to ‘product_type’ makes it ANSI SQL compliant.

01. WordPress database error Unknown column ‘product_type’ in ‘where clause’ for query 02. SELECT DISTINCT
03. *, t.term_id AS pod_item_id
04. FROM
05. wp_terms AS t
06. LEFT JOIN wp_term_taxonomy AS tt
07. ON tt.term_id = t.term_id
08. LEFT JOIN wp_term_relationships AS tr
09. ON tr.term_taxonomy_id = tt.term_taxonomy_id
10. WHERE
11. ( ( t.term_id = 19 )
12. AND ( tt.taxonomy = “product_type” ) )

made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, PSBA_Sync_Service->psba_product_postHandler, wp_update_post, wp_insert_post, apply_filters(‘wp_insert_post_data’), WP_Hook->apply_filters, PodsMeta->save_post_track_changed_fields, PodsAPI::handle_changed_fields, Pods->export, PodsAPI->export_pod_item, PodsAPI->export_pod_item_level, Pods->field, PodsData->select, pods_query, PodsData::query

sure i will turn back on ansi_quotes and post an example

Line 1160:

        for ($j = 0; $j < $x_length; ++$j) { // ie. $i = 0
            if (array_key_exists($j, $x_value) && array_key_exists(0, $y_value))
            {
                $temp = $x_value[$j] * $y_value[0] + $carry; // $product_value[$k] == 0
                $carry = (int) ($temp / 0x4000000);
                $product_value[$j] = (int) ($temp - 0x4000000 * $carry);
            }
        }

Line 153x:

        for ($i = count($dividend) - 1; $i >= 0; --$i) {
            $temp = 0x4000000 * $carry + ((array_key_exists($i, $dividend)) ? $dividend[$i] : 0);
            $result[$i] = (int) ($temp / $divisor);
            $carry = (int) ($temp - $divisor * $result[$i]);
        }

Line 34xx ( in function _trim):

        for ($i = count($value) - 1; $i >= 0; --$i) {
          if (array_key_exists($i, $value))
          {
            if ($value[$i] ) {
                break;
            }
            unset($value[$i]);
          }
        }

• This reply was modified 4 years, 3 months ago by paschoolboards.