Bug :Bug with counting the number of pages in the category
Status :Validated
Severity :Normal
Reporter :Amro 25-12-14 19:23
Updated by :Amro 25-12-14 20:11
CategoryPages
Version :175
Frequency :Consistently
Fixed in :
Details :

Bug associated with the wrong condition L IKE in a SQL query in list.inc.php.

 $sql4 = sed_sql_query("SELECT COUNT(*) FROM $db_pages p, $db_structure s 
       WHERE p.page_cat=s.structure_code 
       AND s.structure_path LIKE '".$sed_cat[$i]['rpath']."%' 
       AND page_state=0 "); 

Fix

 $sql4 = sed_sql_query("SELECT COUNT(*) FROM $db_pages p, $db_structure s 
       WHERE p.page_cat=s.structure_code 
       AND (s.structure_path LIKE '".$sed_cat[$i]['rpath'].".%' OR s.structure_path = '".$sed_cat[$i]['rpath']."') 
       AND page_state=0 "); 

 

Items affected :list.inc.php

History and comments :

15-05-20 01:03   Samantha Lock

Be one drop of the ocean.

ac repair San Diego   ac repair Chula Vista    ac repair Santee

12-02-20 11:00   shipfromca

ShipFromCA allows you to reserve oc 5 – 80 mg online without RX to cast off your ache. Opioid analgesic is the brand name for oxycontin containing the active factor oxycodone. The same is also observed in Percocet and Percodan. If you are stricken by ache with cancer, backache, or arthritis, then Oxycontin could be a powerful medicine for you. Buy Oxycontin online from ShipFromCA pharmacy.

08-02-20 01:14   leo1122

see site | our site 

17-01-20 10:04   joshuaprice153

We need develop more strategies in this regard, thanks for sharing. I think we need to bring more ideas for this purpose. tree service

15-01-20 13:10   luciham20

Loving the information on this site five nights at freddy's 2 scratch, you have done great job on the information.