• From: Indonesia, Jakarta
  • Registered: 01/12/2020
  • Posts: 1

Topic: db_pager.inc bug, sql with no "where" keyword error

File: includes/db_pager.inc

// parse the query

                $parts = preg_split('/\sFROM\s/si', $sql, 2);
                    if (count($parts) == 2) {
                        $this->select = $parts[0];
                        $sql = $parts[1];
                    } else {
                        if ($SysPrefs->go_debug)
                            display_error("Invalid sql input for db_pager");
                    }

// fixed

                               $parts = preg_split('/\sFROM\s/si', $sql, 2);
                    if (count($parts) == 2) {
                        $this->select = $parts[0];
                        $this->from = $parts[1];
                        $sql = $parts[1];
                        
                    } else {
                        if ($SysPrefs->go_debug)
                            display_error("Invalid sql input for db_pager");
                    }
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: db_pager.inc bug, sql with no "where" keyword error

@joe: is this necessary?

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: db_pager.inc bug, sql with no "where" keyword error

I will check, but @FreeMan, what is the difference between the current sentence and the fixed one?

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: db_pager.inc bug, sql with no "where" keyword error

The inserted line in the proposed solution is:

$this->from = $parts[1];

There is no "else" in the current codebase nor thru from FA v2.2.1.
It is not there even in @FreeMan's  cloned repo as of 4 years ago.

Wonder which version of FA is being used.

apmuthu's Website