SQL syntax error confused

Hello,

I’ve put all var_dump and triggers on errors on line 504 or code:

/* Display categories list & tags cloud & categories/tags of posts in the selected language */
if ( ! function_exists( ‘mltlngg_terms_filter’ ) ) {
function mltlngg_terms_filter( $terms ) {
global $mltlngg_terms_table_translate, $wpdb, $mltlngg_current_language;
foreach ( $terms as $mltlngg_one_term ) {
if ( isset( $mltlngg_one_term->term_id ) ) {
$mltlngg_one_term_name = $wpdb->get_var(
$wpdb->prepare(
“SELECT name
FROM $mltlngg_terms_table_translate
WHERE term_ID = %d AND language = ‘%s’
“, $mltlngg_one_term->term_id, $mltlngg_current_language
)
);
//var_dump(‘5>>’.$item->object_id,$mltlngg_current_language); die();
if ( isset( $mltlngg_one_term_name ) && “” != $mltlngg_one_term_name ) /* If translation is exist and not empty, filter terms */
$mltlngg_one_term->name = $mltlngg_one_term_name;
}
}
return $terms;
}
}

A response on landing page and admin is:

string(3) “5>>” string(5) “en_US”

Hello,

I found where is problem. A variable $mltlngg_terms_table_translate returns NULL. This means that as string is “”. NULL === “”

Example:

If I dump this:

if ( ! function_exists( ‘mltlngg_terms_filter’ ) ) {
function mltlngg_terms_filter( $terms ) {
global $mltlngg_terms_table_translate, $wpdb, $mltlngg_current_language;
foreach ( $terms as $mltlngg_one_term ) {
if ( isset( $mltlngg_one_term->term_id ) ) {
$mltlngg_one_term_name = $wpdb->get_var(
$wpdb->prepare(
“SELECT name
FROM $mltlngg_terms_table_translate
WHERE term_ID = %d AND language = ‘%s’
“, $mltlngg_one_term->term_id, $mltlngg_current_language
)
);

var_dump($mltlngg_terms_table_translate); die(); // RETURNS NULL

OR A FULL QUERY IS:
SELECT name FROM WHERE term_ID = 49 AND language = ‘en_US’

So after i tried to find where is variable $mltlngg_terms_table_translate and refer to table name “wp_mltlngg_terms_translate”.

Then in SQL query check for table:

MariaDB [—]> select * from wp_mltlngg_terms_translate;
Empty set (0.00 sec)

Okay, than i changed a code and instead of null of name table i changed to string:

“SELECT name
FROM wp_mltlngg_terms_translate
WHERE term_ID = %d AND language = ‘%s’
“

and in a LOG IS NOW CLEAN. No errors shown. Didn’t received a table name “wp_mltlngg_terms_translate”.

Doesn’t know why, but i think is problem that a function didn’t received in other function from:

$mltlngg_terms_table_translate = $wpdb->prefix . ‘mltlngg_terms_translate’;

Create table:

MariaDB [—]> show create table wp_mltlngg_terms_translate;
+—————————-+—————————————————————————————————————————————————————————————————————————————-+
| Table | Create Table |
+—————————-+—————————————————————————————————————————————————————————————————————————————-+
| wp_mltlngg_terms_translate | CREATE TABLE wp_mltlngg_terms_translate (
ID int(6) unsigned NOT NULL AUTO_INCREMENT,
term_ID int(6) NOT NULL,
name text NOT NULL,
language text NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+—————————-+—————————————————————————————————————————————————————————————————————————————-+
1 row in set (0.00 sec)