Date: Mon, 17 May 2010 23:33:57 -0700 From: Douglas Thrift <douglas@douglasthrift.net> To: shaun@FreeBSD.org Cc: ports@FreeBSD.org Subject: Re: FreeBSD Port: portscout-0.7.4_2 Message-ID: <4BF234D5.3080908@douglasthrift.net> In-Reply-To: <4BF20803.3010606@douglasthrift.net> References: <4BF20803.3010606@douglasthrift.net>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. --------------070302020106000305070000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit On 5/17/2010 8:22 PM, Douglas Thrift wrote: > Hello, > > Today I decided to set up portscout on my server. Everything seemed fine > until I went to run "portscout generate" to make the HTML output: > > portscout v0.7.4, by Shaun Amott > > Found 21749 ports > > Organising results... > DBD::Pg::st execute failed: ERROR: cannot insert multiple commands into > a prepared statement at /usr/local/bin/portscout line 1844. > Generating index sorted by withnewdistfile... > DBD::Pg::st execute failed: ERROR: relation "results" does not exist > LINE 1: SELECT * FROM results ORDER BY withnewdistfile DESC > ^ at /usr/local/bin/portscout line 1873. > DBD::Pg::st fetchrow_hashref failed: no statement executing at > /usr/local/bin/portscout line 1875. > Generating index sorted by maintainer... > DBD::Pg::st execute failed: ERROR: relation "results" does not exist > LINE 1: SELECT * FROM results ORDER BY maintainer ASC > ^ at /usr/local/bin/portscout line 1873. > DBD::Pg::st fetchrow_hashref failed: no statement executing at > /usr/local/bin/portscout line 1875. > Generating index sorted by total... > DBD::Pg::st execute failed: ERROR: relation "results" does not exist > LINE 1: SELECT * FROM results ORDER BY total DESC > ^ at /usr/local/bin/portscout line 1873. > DBD::Pg::st fetchrow_hashref failed: no statement executing at > /usr/local/bin/portscout line 1875. > Generating index sorted by percentage... > DBD::Pg::st execute failed: ERROR: relation "results" does not exist > LINE 1: SELECT * FROM results ORDER BY percentage DESC > ^ at /usr/local/bin/portscout line 1873. > DBD::Pg::st fetchrow_hashref failed: no statement executing at > /usr/local/bin/portscout line 1875. > Creating maintainer pages... > DBD::Pg::st execute failed: ERROR: relation "results" does not exist > LINE 1: SELECT DISTINCT maintainer FROM results > ^ at /usr/local/bin/portscout > line 1903. > DBD::Pg::st fetchrow_array failed: no statement executing at > /usr/local/bin/portscout line 1905. > Creating restricted ports (portconfig) page... > > That's all it output. > > Thanks! Hello again, After further inspection I've fixed the problem and it seems to work. I've attached my patch. -- Douglas William Thrift <douglas@douglasthrift.net> <http://douglasthrift.net/>; --------------070302020106000305070000 Content-Type: text/plain; name="patch-portscout.pl" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="patch-portscout.pl" LS0tIHBvcnRzY291dC5wbC5vcmlnCTIwMDgtMDEtMjMgMjA6MTA6MzUuMDAwMDAwMDAwIC0w ODAwCisrKyBwb3J0c2NvdXQucGwJMjAxMC0wNS0xNyAyMzoyODozMi4wMDAwMDAwMDAgLTA3 MDAKQEAgLTMzMCw3ICszMzAsNyBAQAogCiAjIEdlbmVyYXRlSFRNTAogCi0kc3Fse3BvcnRk YXRhX2dlbnJlc3VsdHN9ID0KKyRzcWx7cG9ydGRhdGFfZ2VucmVzdWx0czF9ID0KIAlxKFNF TEVDVCAqCiAJICAgIElOVE8gVEVNUCBfcmVzdWx0cwogCSAgICBGUk9NIChTRUxFQ1QgRElT VElOQ1QKQEAgLTM0MSw5ICszNDEsMTAgQEAKIAkgICAgICAgICAgICAgQU5EIG5ld3ZlciBp cyBub3QgTlVMTAogCSAgICAgICAgICAgICBBTkQgbW92ZWQgIT0gdHJ1ZQogCSAgICAgICAg ICAgR1JPVVAgQlkgbG93ZXIobWFpbnRhaW5lcikpCi0JICAgICAgQVMgcGQxOworCSAgICAg IEFTIHBkMSk7CiAJCi0JICBTRUxFQ1QgbWFpbnRhaW5lciwgdG90YWwsCiskc3Fse3BvcnRk YXRhX2dlbnJlc3VsdHMyfSA9CisJcShTRUxFQ1QgbWFpbnRhaW5lciwgdG90YWwsCiAJICAg ICAgICAgQ09BTEVTQ0UgKHdpdGhuZXdkaXN0ZmlsZSwgMCkgQVMgd2l0aG5ld2Rpc3RmaWxl LAogCSAgICAgICAgIENBU1QgKDEwMCood2l0aG5ld2Rpc3RmaWxlKjEuMC90b3RhbCoxLjAp IEFTIEZMT0FUKSBBUyBwZXJjZW50YWdlCiAJICAgIElOVE8gVEVNUCByZXN1bHRzCkBAIC0x ODM3LDExICsxODM4LDEyIEBACiAKIAkkZGJoID0gREJJLT5jb25uZWN0KEBkYl9jb25uZWN0 X2FyZ3MpIG9yIGRpZSBEQkktPmVycnN0cjsKIAotCXByZXBhcmVfc3FsKFwkZGJoLCBcJXN0 aHMsIHF3KHBvcnRkYXRhX2dlbnJlc3VsdHMgcG9ydGRhdGFfc2VsZWN0YWxsCi0JICAgICAg ICAgICAgcG9ydGRhdGFfc2VsZWN0YWxsX2xpbWl0ZWQpKTsKKwlwcmVwYXJlX3NxbChcJGRi aCwgXCVzdGhzLCBxdyhwb3J0ZGF0YV9nZW5yZXN1bHRzMSBwb3J0ZGF0YV9nZW5yZXN1bHRz MgorCSAgICAgICAgICAgIHBvcnRkYXRhX3NlbGVjdGFsbCBwb3J0ZGF0YV9zZWxlY3RhbGxf bGltaXRlZCkpOwogCiAJcHJpbnQgIk9yZ2FuaXNpbmcgcmVzdWx0cy4uLlxuIjsKLQkkc3Ro c3twb3J0ZGF0YV9nZW5yZXN1bHRzfS0+ZXhlY3V0ZTsKKwkkc3Roc3twb3J0ZGF0YV9nZW5y ZXN1bHRzMX0tPmV4ZWN1dGU7CisJJHN0aHN7cG9ydGRhdGFfZ2VucmVzdWx0czJ9LT5leGVj dXRlOwogCiAJZW1wdHlkaXIoJHNldHRpbmdze2h0bWxfZGF0YV9kaXJ9KTsKIAo= --------------070302020106000305070000--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4BF234D5.3080908>