Search:

Nevermind, found it. I had parms defined in both httpd.conf and apache2.conf and they were conflicting. Removed everything from httpd.conf and it fixed my issue. Thanks!

I am trying to setup a local webserver on my laptop.

I'm getting this on startup of apache2:

(9Address already in use: make_sock: could not bind to address 0.0.0.0:80


It doesn't look to me...

Decided this should really be a new thread... sorry.

EDIT: Just realized how old this post was... you probably don't need this anymore - but maybe it will help someone else.

Your problem is with the while loop. Your date gets set at the top, once...

Ignore my last query - it won't work, you can use your subquery as if it were a table and join to it. Try this one:

SELECT e.id, e.event_name, MIN(ea.dtetime) AS min_date
FROM `event_activities`...

Sorry - I misunderstood. So if I understand correctly, as long as the event has at least one activity >= today you want it listed, but you still want the min_date displayed in the report. I would...

Try something like this:

SELECT e.id, e.event_name, MIN( ea.dtetime ) AS min_date
FROM `event_activities` ea,
EVENTS e
WHERE e.id = ea.event_id
GROUP BY e.id
HAVING min_date > CURDATE();
...

Thanks everyone. I had looked at paste - but I guess I was leaving off the '' around the \n. Ran the command as you guys described it and it worked perfectly.

Thanks again!

No it's something I am trying to accomplish at work. I can use any program that will get the job done. What I am actually doing is generating database commands out of the system catalog and I want...

I've done some google searching but no one has given an example of what I am looking for. I have two files:


File 1
======
AAAA
BBBB
CCCC

File 2

I haven't tested this, but it looks like it would do what you need. I would suggest you test in different directory with only a few files in it first.
...

I'm probably a bad person to ask, I used to skip class a lot when it wasn't snowing too :). I say as long as you can keep up with the work, stay home.

Thanks a lot! I'll check that out.

I've been lurking on the forums for a while now, and have been running ubuntu as my main OS for a couple of years. I'm still a bit of a newbie when it comes to network security. I'm getting ready...

I had the same problem.

sudo apt-get check --fix-broken

fixed it for me. Hope this helps.