Skip to content

Instantly share code, notes, and snippets.

View blt's full-sized avatar

Brian L. Troutwine blt

View GitHub Profile
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE NOT EXISTS ( SELECT id FROM PlatonicBridgeUser WHERE jid= ' at line 1
CREATE TABLE A (
id SERIAL NOT NULL PRIMARY KEY
);
CREATE TABLE B (
id SERIAL NOT NULL PRIMARY KEY
);
CREATE TABLE Parent (
id SERIAL NOT NULL PRIMARY KEY,
server {
listen 80; ## listen for ipv4; this line is default and implied
root /var/www/domains/example.com/docdir/;
index index.html index.htm index.php;
# Make site accessible from http://localhost/
server_name app0.example.com;
location / {
$ mvn clean compile assembly:single
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building khatami 1.0-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-clean-plugin:2.4.1:clean (default-clean) @ khatami ---
[INFO] Deleting /home/blt/projects/com/carepilot/repos/khatami/target
[INFO]
source :rubygems
gem "sinatra", "1.2.6"
gem "shotgun", "0.9"
# If the commit is, say, "a156c0b4e8b6b81e9e5e1e0e4bbb66599301b17a" then
# the directory created is "a156c0b4e8b6b81e9e5e1e0e4bbb66599301b17a\102".
# Why is that?
commit = `git log -n 1 | grep -m 1 commit | awk '{print $2}'`
vhost_dir = commit
Dir.mkdir vhost_dir
root@ci:~# aptitude install postgresql-9.0
The following NEW packages will be installed:
libpq5{a} postgresql-9.0 postgresql-client-9.0{ab}
postgresql-client-common{a} postgresql-common{a} ssl-cert{a}
0 packages upgraded, 6 newly installed, 0 to remove and 0 not upgraded.
Need to get 7,403 kB/7,756 kB of archives. After unpacking 22.3 MB will be used.
The following packages have unmet dependencies:
postgresql-client-9.0: Depends: libpq5 (>= 9.0~) but 8.4.8-0squeeze1 is to be installed.
The following actions will resolve these dependencies:
server {
listen 80;
root /var/www/;
index index.html index.htm index.php;
server_name dev.example.com
location / {
# First attempt to serve request as file, then
location ~* /projects/(?P<pname>[a-Z0-9]*)/(?P<commit>[a-Z0-9]*)/[a-Z]*\.php {
# Rewrite $uri
rewrite ^ /$pname/build/$commit/public/index.php break;
}
$ pear install phpunit/PHPUnit
Failed to download pear/HTTP_Request2 within preferred state "stable", latest release is version 2.0.0RC1, stability "beta", use "channel://pear.php.net/HTTP_Request2-2.0.0RC1" to install
phpunit/PHPUnit can optionally use PHP extension "curl"
phpunit/PHPUnit can optionally use PHP extension "dbus"
phpunit/PHPUnit can optionally use PHP extension "json"
pear/XML_RPC2 requires package "pear/HTTP_Request2" (version >= 0.6.0)
phpunit/PHPUnit requires package "pear/XML_RPC2"
No valid packages found
install failed