## tech problems
P: (parted) p Error: Can’t have a partition outside the disk!
A: fdisk “/dev/sdb1″ instead of “fdisk /dev/sdb”
P: No handlers for package.xml version 2.0
A: sudo pear upgrade PEAR
P: “You do not have sufficient security priviliges to install devices on this computer. Please contact your site administrator, or log out and log in again as an administrator and try again.”
A:
- Log in as administrator
- Start, Run, Gpedit.msc
- Computer Configuration, Windows Settings, Security Settings, Local
Policies, User Rights Assignment
- Add your normal username into Load and Unload Device Drivers
P: jquery serialize sets checkboxes to “on” when unchecked.
A: use form plugin serialize methods instead: $(‘#myform input’).fieldSerialize();
P: Credentials supplied conflict with an existing set of credentials
A: you can connect to server with another username if you use the hostname for connection A and the IP address for connection B
P: postgres No dictionary with name ‘en_stem’
A: load tsearch2.sql into your schema first.
P: could not find tsearch config by locale
A: show lc_collate; update pg_ts_cfg set locale = ‘en_GB.UTF-8′ where ts_name = ‘default’;
select to_tsvector(‘I wish this worked’);
P:
ERROR: could not find function “snb_ru_init” in file “/usr/lib/postgresql/8.2/lib/tsearch2.so”
ERROR: function public.snb_ru_init(internal) does not exist
A: this is a missing func upgrading to 8.2.
P: postgres dump (pg_dump) generates insert statements instead of COPY statements.
A: postgres has the -d DBNAME option for psql. But don’t use this for pg_dump. That will generate insert staments instead of COPY.
P: ERROR: invalid input syntax for integer: “” during postgres copy
A: use “with null as ”” option to copy command in order to treat empty strings as nulls.
P: ERROR: phpize not found
A: install php5-dev
