Search results

  1. aleco

    Internal email not sending?

    Ah finally solved it! I removed the filter file found in /etc/vfilters for the domain I was having problems with, and it seems to have fixed it! Not quite sure why though as I've not changed that file for months...but oh well! :o
  2. aleco

    Internal email not sending?

    I couldn't find those exact log names, but found a maillog and an exim_mainlog file so tailed those. I'm far from being anywhere decent with linux, but tried my best lol - I got both logs up and then sent an email to my account. One from the address I was sending it to, and another from my gmail...
  3. aleco

    Internal email not sending?

    Hi all, I've got a VPS server running on CentOS (4.8 I think) which runs my email. Yesterday, it was offline for some reason and came back to life early this morning (I've no idea why, the hosts are useless). Anyway, I noticed that I can't send emails to myself today (i.e. to [email protected] from...
  4. aleco

    mysql help - sorting and counting

    I run my site on a VPS...but I don't really have any idea what I'm doing with it so just don't touch it unless I need to lol! I was on php4 til last year so at least I'm up to date with both now! :o
  5. aleco

    mysql help - sorting and counting

    Woohoo! Upgrading the mysql has done the trick - thanks everyone for the help! :D
  6. aleco

    mysql help - sorting and counting

    Just backing up now and will perform the upgrade - will report back when done! I need the date too for the timestamp, was just too lazy to type it out :o
  7. aleco

    mysql help - sorting and counting

    I'll see if I can upgrade (I presume it won't break backwards compatibility?), but the correct timestamp order should be: 1263921113 (5.11pm) 1263917863 (4.17pm) 1263915088 (3.31pm) edit: ah sorry I must've deleted a 3 off 126392111 in the first place getting the formatting correct!
  8. aleco

    mysql help - sorting and counting

    Hmm that's just how I want it! It says: MySQL client version: 4.1.22, do I need to upgrade? edit: actually not quite how I need it - it needs to then be sorted by timestamp too if poss!
  9. aleco

    mysql help - sorting and counting

    Not sure if it helps, but the nearest thing I've got to it so far is: SELECT user_id, timestamp, count(user_id) AS total FROM table WHERE item_id = 10001 GROUP BY user_id WITH ROLLUP which outputs: user_id timestamp total 3 1263915088 1 32 1263921113 1 5057 1263915032 3 NULL 1263915032 5...
  10. aleco

    mysql help - sorting and counting

    Afraid that's not it either! Gives the error: #1111 - Invalid use of group function
  11. aleco

    mysql help - sorting and counting

    Thanks for the reply but it's not quite it either! The "totals" column listed in my 2nd example isn't in the database, I need it to count up all the instances and list it, and also this code gives the timestamp from the earliest entry of any multiple entries rather than the latest, e.g.: it...
  12. aleco

    mysql help - sorting and counting

    I'm not that great with mysql commands, so was wondering if there's an easy way to do what I'm attempting: I have a table like the following: id item_no user_id timestamp 1 10001 5057 1263915032 2 10001 3 1263915088 3 10001 5057 1263917853 4 10001 5057 1263917863 5 10001 32 1263921113 6 10002...
  13. aleco

    mITX build - will these parts work well?

    I've got a blu-ray player already so it's not worth the £100 extra :)
  14. aleco

    mITX build - will these parts work well?

    Luckily, blu-ray isn't an issue/consideration, as there's a proper Panasonic BD35 blu-ray player for 24p playback hooked up to the TV, so that'll probably do a better job than a reasonably priced htpc I'd guess. But that case is pretty good - quite small, just 10cm wider than the mini-itx...
  15. aleco

    mITX build - will these parts work well?

    I'm trying to build a not too expensive but fully functional mITX PC which will be mainly used as a digital TV/Win7 media centre setup. So I'll be watching/recording digital tv, playing back dvds, watching hi-def downloaded videos, watching HD iPlayer/itv/4od, etc. This will all be hooked up...
  16. aleco

    Snow Leopard 10.6.2 is out

    Shame there's no mention of wireless improvements, had nothing but problems with it since upgrading to Snow Leopard :( Installed it anyway so will wait and see if it continues...
  17. aleco

    Macbook aluminium or Macbook pro 13"?

    Yeah :( Only seem to have the option for non-glossy on 15" and above. Although I must say I was extremely anti-glossy screens, but having used it on my MacBook for a while, it's not quite as bad as others I've seen/used and doesn't really bother me at all now.
  18. aleco

    Macbook aluminium or Macbook pro 13"?

    I think it's just fine for everything I do (although I do have a 24" monitor I hook it up to from time to time should I feel the urge for more screen estate). I actually wanted something smaller than 13" though for portability as I'd been using a 12" laptop beforehand, so was prepared for a...
  19. aleco

    Macbook aluminium or Macbook pro 13"?

    Yup yup - when I was researching my MacBook Pro 13" I read that they've updated the screen so that it matches the higher quality versions found in the 15" and 17" versions :)
  20. aleco

    tv card recommend

    I've got a BlackGold BGT3510 which I've been very pleased with, and comes with a low profile bracket so can fit into small cases nicely. Works great with Windows Media Centre. Bit pricey though I guess compared with some others. I *think*, looking at the stats of the Compro T750F, there's only...
Back
Top Bottom