This topic has 2 replies, 2 voices, and was last updated 2 years, 1 months ago ago by Tony Rodriguez
PRODUCT STATUS – In stock, Out of stock, On sale – not work;
when i turn on debug, i get this error:
In stock
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 14]
SELECT ID FROM wp_posts as p INNER JOIN wp_postmeta pm on p.ID = pm.post_id and pm.meta_key=’_stock_status’ AND pm.meta_value = ‘instock’ AND p.post_status = ‘publish’ AND p.post_type = ‘product’ AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
Out of stock
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 14]
SELECT ID FROM wp_posts as p INNER JOIN wp_postmeta pm on p.ID = pm.post_id and pm.meta_key=’_stock_status’ AND pm.meta_value = ‘outofstock’ AND p.post_status = ‘publish’ AND p.post_type = ‘product’ AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
On sale
WordPress-Datenbank-Fehler: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 11]
SELECT ID FROM wp_posts as p WHERE p.post_status = ‘publish’ AND p.post_type IN (‘product’) AND p.ID IN (7649,7650,7651,7652,7653,7654,7655,7656,7657,7658,7663,7664,7665,7666,7667,7668,7669,7670,7671,7672,8949,8953,8957,8961,8963,8966,8969,8972,11288,11289,11290,11291,11292,11293,11294,11295,11296,11297,11330,11331,11332,11333,11334,11335,11336,11337,11338,11339,11350,11351,11352,11353,11354,11355,11356,11357,11358,11359,12249,12250,12251,12252,12253,12254,12264,12265,12266,12267,12268,12269,12280,12281,12282,12283,12284,12285,12294,12295,12296,12297,12298,12299,12310,12311,12312,12313,12314,12315,12324,12325,12326,12327,12328,12329,12340,12341,12342,12343,12344,12345,12354,12355,12356,12357,12358,12359,12370,12371,12372,12373,12374,12375,12384,12385,12386,12387,12388,12389,12396,12397,12398,12399,12400,12401,12412,12413,12414,12415,12416,12417,12426,12427,12428,12429,12430,12431,12442,12443,12444,12445,12446,12447,12759,12760,12761,12762,12763,12764,12765,12774,12775,12776,12777,12778,12779,12780,12787,12788,12789,12790,12791,12792,12793,12804,12805,12806,12807,12808,12809,13497,13551,13561,7644,7659,7452,7458,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12758,12773,12786,12803) AND p.ID NOT IN ( SELECT tr.object_id FROM wp_terms as t JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id JOIN wp_term_relationships AS tr ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE t.name = ‘exclude-from-catalog’) AND p.ID IN ( SELECT pl.element_id FROM wp_icl_translations WHERE pl.language_code = ‘de’ AND p.ID IN (7397,7445,7452,7458,7461,7617,7629,7644,7659,7675,544,754,834,844,853,885,902,904,2196,1995,2217,2204,2223,2228,2632,2680,7876,6606,44,150,363,370,380,387,396,4922,4946,4953,4962,5028,5287,5295,5528,7397,7445,7452,7458,7461,7684,7700,7707,7718,7723,7729,7733,7740,7749,7754,7858,7974,7994,8006,8018,8032,8043,8054,8074,8090,14158,8094,14148,8113,14133,8129,14118,8144,14105,8159,14099,8172,14088,8185,14076,8198,14064,8209,14055,8218,14039,8231,13996,8355,8359,8364,8380,8392,8408,8440,8454,8470,8490,8517,8531,8570,8591,8606,8618,8630,7617,7644,7675,7659,7629,8661,8693,8706,8714,8731,8770,8798,8812,8827,8838,8849,8862,8875,8903,8914,8949,8953,8957,8961,8963,8966,8969,8972,10214,10239,10253,10270,10279,10293,10300,10312,10505,10528,10541,10555,10567,10581,10594,10609,10625,10639,10666,10683,10698,10714,10723,10732,10746,10755,10785,10795,10804,10815,10826,10838,10851,10864,10881,10888,10899,10907,10921,10929,10939,10948,10960,10972,10984,10995,11008,11019,11030,11039,11052,11065,11084,11097,11111,11122,11137,11147,11158,11171,11184,11193,11206,11218,11232,11375,11382,11389,11396,11403,11410,11417,11424,11435,11444,11453,11460,11469,11478,11487,11496,11503,11510,11517,11524,11568,11594,11614,11634,11652,11669,11686,11702,11719,11734,11754,11773,11792,11811,11830,11860,11886,11972,11990,12021,12093,12248,12263,12279,12293,12309,12323,12339,12353,12369,12383,12395,12411,12425,12441,12477,12573,12626,12644,12677,12690,12711,12737,12758,12773,12786,12803,12814,12830,12842,12860,12870,12886,12900,12914,13150,13162,13176,13212,13233,13259,13277,13301,13329,13345,13366,13378,13388,13400,13412,13426,13439,13453,13467,13483,13497,13507,13517,13533,13541,13551,13561,13577,13595,13609,13621,13633,13650,13662,13674,13685,13695,13705,13715,13746,13759,13771,13782,13797,13807,13828,13840,13854,13859,13863,13867,13873,13922,13933,13945,13957,13971,13983,14005,14017,14028,14044,14059,14082,14104,14128,14153,14168,14181,14193,14206,14219,14232,14244,14257,14270,14280,14293,14305,14316,14328,14339,14351,14363,14374,14383,14395,14407,14419,14434,14446,14460,14474,14486,14497,14508,14522,14536,14550,14563,14576,14588,14600,14611,14623,14634,14643,14655,14666,14677,14687,14700,14713,14726,14737,14746,14757,14768,14779,14820,14833,14846,14857,14868,14879,14890,14903,14915,14928,14941,14954,14967,14979,14991,15004,15017,15031,15045,15060,15073,15085,15098,15110,15118,15125,15132,15142,15154,15165,15176,15186,15197,15208,15218,15227,15236,15246,15256,15266,15276,15285,15294,15304,15453,15464,15475,15486,15497,15507,15515,15526,15537,15548,15558,15569,15580,15591,15603,15616,15627,15638,15650,15662,15673,15686,15698,15710,15725,15739,15753,15766,15778,15790,15802,15814,15826,15841,15853,15865,15877,15889,15901,15916,15928,15939,15989,16001,16013,16025,16037,16049,16061,16073,16083,16094,16106,16118,16129,16140,16150,16160,16170,16180,16190,16200,16210,16220,16231,16240,16251,16260,16270,16279,16290,16300,16309,16319,16328,16338,16348,16358,16368,16378,16388,16398,16408,16418,16428,16438,16448,16457,16466,16476,16486,16644,16651,16658,16665,16674,16682,16691,16699,16707,16716,16724,16733,16741,16749,16757,16767,16777,16787,16801,16815,16830,16844,16858,16872,16885,16896,16911,16925,16937,16949,16959,16969,16979,16992,17002,17010,17018,17026,17037,17045,17053,17062,17069,17077,17085,17092,17099,17106,17113,17122,17130,17135,17139,17148,17153,17159,17185,17190,17193,17202,17206,17211,17219,17224,17230,17235,17239,17246,17278,17286,17290,17299,17305,17312,17318,17327,17340,17356,17373,17379,17384,17390,17635,17754,17786,17803,17821,17837,17858,17877,17892,17910,17928,17949,17967,17987,18007,18026,18044,18065,18081,18097,18142,18160,18179,18196,18214,18232,18253,18284,18303,18321,18339,18353,18371,18391,18410,18432,18451,18469,18486,18506,18532,18567,18574,18582,18588)
(0)
Hello, @Lashamika,
1. Did you use any Custom Code in Child Theme? Please try to remove it and check back again.
2. Did you make changes in DB?
3. Was the prefix of tables changed?
4. Is the error there if all 3rd party plugins are disabled? Please try this as well.
This seems to be the server-end database issue, so please once reach out to your hosting provider as well, they will check it for you as well.
Regards 8Themes Team.
Tagged: in stock, on sale, out of stock, product status, themes, woocommerce, wordpress
You must be logged in to reply to this topic.Log in/Sign up