Selection, Insertion, Deletion, and Updation
August 31st, 2009 by Leons PetrazickisIn the future, we might all say “updation”.
Posted in links | No Comments »
In the future, we might all say “updation”.
Posted in links | No Comments »
Here’s how you solve either of the following errors on Ubuntu (and possibly Debian):
device br0 already exists; can't create bridge with the same name device eth0 is already a member of a bridge; can't enslave it to bridge br1.
Removing the device specs from /etc/network/interfaces and restarting the network doesn’t actually remove the device if already active. You need to do it manually.
List the active devices:
And then do this to any that you don’t want there, such as br0, eth0, eth1, etc:
This deactivates the device. At this point you’ll need to restart the network layer twice:
And you should be sitting pretty. On some systems, networking is known as network, as in:
Posted in unix | No Comments »
No fresh download quite yet, but I just made a large commit to the MediaWiki source of the last week’s work. This is going in the trunk — aka MediaWiki 1.16alpha. There are a few bugs I hope to catch this weekend, at which point I’ll put up a fresh archive of working code.
config/index.php:
* Made installation on IBM DB2 more robust
* Replaced E_ALL error reporting mode with E_ALL | E_STRICT
includes/db/DatabaseIbm_db2.php
* Enabled DB2_CASE_LOWER option for all connections and statements
* Enabled DB2_DEFERRED_PREPARE_ON for all statements — delays statement preparation until execution to reduce database load
* Enabled DB2_ROWCOUNT_PREFETCH_ON for all statements — makes db2_num_rows() work correctly
* Cleaned up error handling
* Cleaned up method signatures
* Rewrote insertion to use prepared statements — required for inserting more than 32k of text
* Insertion will never try to insert a NULL value into a primary key
* Now relying on implicit casting in DB2 9.7 — no longer sniffing to see if column is integer or string before adding quotes
* Implemented actual prepared statement handling — required for correct INSERT, UPDATE behaviour
* In install mode, the class will print additional messages to the install bullet scroll
* Added bitwise operation abstraction (BITNOT, BITAND, BITOR)
includes/specials/SpecialAncientpages.php
* Added skeleton DB2 syntax to the database-specific switch statement
maintenance/convertLinks.inc
* Made limit clause database-agnostic
maintenance/ibm_db2/README
* Contents replaced with link to http://www.mediawiki.org/wiki/Manual:IBM_DB2
maintenance/ibm_db2/tables.sql
* Revised types to better match the main schema
* All tables names now the same as MySQL — was using Postgres schema’s names before
* Added some additional indices
* Added the change_tag, tag_summary, valid_tag, user_properties, log_search, and l10n_cache tables
* Added several new columns
maintenance/storage/compressOld.inc
* Made limit clause database-agnostic
Posted in mediawiki | No Comments »