Archive for December 17th, 2007
Monday, December 17th, 2007
Customised Front Page for Client: they want the latest forum posts on the front page.
Restored production environment (TODO: write script to make a test environment based on production environment):
backup production database
restore production database to test database
copy production data dir to test datadir
set cookieprefix to testxxxxx
copy production theme dir to test ...
Posted in BrnDmp | No Comments »
Monday, December 17th, 2007
tried to optimize mysql DB performance on server. Especially when querying groups and users there is a high load on the database.
To show the type of DB-engine used for a database (and performance vars):
SHOW TABLE STATUS FROM db_name;
SHOW STATUS;
SHOW VARIABLES;
Set key_buffer = 256M and user queries went much faster, especially ...
Posted in BrnDmp | No Comments »
Monday, December 17th, 2007
got php error for custom scripts at client:
: No such file or directory: line 1: ?php
so probably, php interpreter or something is not working correctly. Check it. Forgot to add php at the beginning of script.
Then error remained: changed ../config to ./config and script worked again.
Posted in BrnDmp | No Comments »
