PRODUCT STATUS – In stock, Out of stock, On sale – not work

This topic has 2 replies, 2 voices, and was last updated 2 years, 1 months ago ago by Tony Rodriguez

  • Avatar: Lashamika
    Lashamika
    Participant
    November 15, 2022 at 21:11

    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)

    1 Answer
    Avatar: Tony Rodriguez
    Tony Rodriguez
    Support staff
    November 16, 2022 at 05:58

    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.

  • Viewing 2 results - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.