View Issue Details

IDProjectCategoryView StatusLast Update
0000176My infrastructureGeneralpublic2023-04-02 19:35
Reporterdvl Assigned Todvl  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Summary0000176: freshports query error
Description/search.php?stype=tree&method=match&query=Doc%2C%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=category&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head HTTP/2.0" 200 220 "https://www.freshports.org/search.php?stype=depends_all&method=match&query=Doc%2C%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=html&branch=head

creates this error:

Apr 11 01:42:59 aws-1-nginx01 FreshPorts[90617]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:42:59 aws-1-nginx01 FreshPorts[90617]: LINE 4: WHERE EP.pathname
Apr 11 01:42:59 aws-1-nginx01 FreshPorts[90617]: ^

Other examples:

/search.php?stype=depends_run&method=match&query=Doc%2C%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=category&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: ERROR: syntax error at end of input
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: LINE 15: AND P.element_id = E.id AND
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: ^:
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: SELECT count(*)
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: FROM ports P LEFT OUTER JOIN ports_vulnerable PV ON PV.port_id = P.id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: LEFT OUTER JOIN commit_log CL ON P.last_commit_id = CL.id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: LEFT OUTER JOIN repo R ON CL.repo_id = R.id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: LEFT OUTER JOIN commit_log_branches CLB ON CL.id = CLB.commit_log_id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: JOIN system_branch SB ON SB.branch_name = 'head'
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: AND SB.id = CLB.branch_id,
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: categories C, element E
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]:
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: JOIN element_pathname EP on E.id = EP.element_id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: AND EP.pathname IN ('/ports/head/Doc,/Desiree,/or/ramos,/or/', '/ports/head/Schuppan,+sex+video')
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]:
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: WHERE P.category_id = C.id
Apr 11 01:45:33 aws-1-nginx01 FreshPorts[91606]: AND P.element_id = E.id AND


/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2CDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:47:33 aws-1-nginx01 FreshPorts[91584]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:47:33 aws-1-nginx01 FreshPorts[91584]: LINE 4: WHERE EP.pathname
Apr 11 01:47:33 aws-1-nginx01 FreshPorts[91584]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:50:03 aws-1-nginx01 FreshPorts[92517]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:50:03 aws-1-nginx01 FreshPorts[92517]: LINE 4: WHERE EP.pathname
Apr 11 01:50:03 aws-1-nginx01 FreshPorts[92517]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:50:58 aws-1-nginx01 FreshPorts[92512]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:50:58 aws-1-nginx01 FreshPorts[92512]: LINE 4: WHERE EP.pathname
Apr 11 01:50:58 aws-1-nginx01 FreshPorts[92512]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2FDesiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:51:47 aws-1-nginx01 FreshPorts[93222]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:51:47 aws-1-nginx01 FreshPorts[93222]: LINE 4: WHERE EP.pathname
Apr 11 01:51:47 aws-1-nginx01 FreshPorts[93222]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2Fclasses_comints_Desiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:52:44 aws-1-nginx01 FreshPorts[93407]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:52:44 aws-1-nginx01 FreshPorts[93407]: LINE 4: WHERE EP.pathname
Apr 11 01:52:44 aws-1-nginx01 FreshPorts[93407]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2Fclasses_commits_Desiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:53:23 aws-1-nginx01 FreshPorts[93532]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:53:23 aws-1-nginx01 FreshPorts[93532]: LINE 4: WHERE EP.pathname
Apr 11 01:53:23 aws-1-nginx01 FreshPorts[93532]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2Fclasses_commits_Desiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:53:42 aws-1-nginx01 FreshPorts[93460]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:53:42 aws-1-nginx01 FreshPorts[93460]: LINE 4: WHERE EP.pathname
Apr 11 01:53:42 aws-1-nginx01 FreshPorts[93460]: ^

/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2Fclasses_by_tree_location_commits_Desiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:54:27 aws-1-nginx01 FreshPorts[93611]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:54:27 aws-1-nginx01 FreshPorts[93611]: LINE 4: WHERE EP.pathname
Apr 11 01:54:27 aws-1-nginx01 FreshPorts[93611]: ^


/search.php?stype=tree&method=soundex&query=Doc%2C%2Fsrc%2C%2Fpath%2Fuser%2Fwww.freashports.com%2Fclasses_commints_by_tree_location_Desiree%2C%2For%2Framos%2C%2For%2F+Schuppan%2C%2Bsex%2Bvideo&num=10&deleted=includedeleted&orderby=port&orderbyupdown=asc&search=Search&include_src_commits=include_src_commits&format=depends&effort=1&branch=head

Apr 11 01:56:32 aws-1-nginx01 FreshPorts[94227]: /usr/local/www/freshports/classes/commits_by_tree_location.php::73: ERROR: argument of AND must be type boolean, not type text
Apr 11 01:56:32 aws-1-nginx01 FreshPorts[94227]: LINE 4: WHERE EP.pathname
Apr 11 01:56:32 aws-1-nginx01 FreshPorts[94227]: ^
TagsNo tags attached.

Activities

dvl

2022-09-17 14:19

manager   ~0000179

Fixed via 4a0766ad

dvl

2023-04-02 19:35

manager   ~0000186

Testing now, it gives:

Sorry, but you messed something up in your manually created query

Issue History

Date Modified Username Field Change
2022-04-11 13:47 dvl New Issue
2022-09-17 14:19 dvl Assigned To => dvl
2022-09-17 14:19 dvl Status new => resolved
2022-09-17 14:19 dvl Resolution open => fixed
2022-09-17 14:19 dvl Note Added: 0000179
2023-04-02 19:35 dvl Note Added: 0000186
2023-04-02 19:35 dvl Status resolved => closed