rch1231 169 Posting Shark

Based on what I have seen in the past this is due to selecting a video mode that your monitor cannot display. Boot in VGA mode and then select the lowest resolution available and reboot. It should come up normally and then let you change the resolution.

rch1231 169 Posting Shark

I am willing to bet your running windows XP. What the error means is that you need to increase the size of the virtual memory file (also called page file) on your computer.
Before you go to change the size of the file you need to check how much space is available on your hard drive and know how much memory you have installed in the computer.

To change the virtual memory file size use the following:

  1. Right Click My Computer and select Properties from the list.
  2. Click the tab at the top labeled Advanced and the dialog box will change to show three groups.
  3. Click the settings button under performance
  4. Select the tab at the top labeled Advanced and you should see a group called Virtual Memeorn at the bottom of the dialog box
  5. Click Change and a new window will open with options for the location and size of the paging file.
  6. The size of your virtual memory shuld be at least 1024MB no matter how much memory you have and no more than 3072MB as a max. This is my personal opinion and not a microsoft or standard setting.
  7. Change the setting and select ok to each of the dialog boxes as you go out. then reboot.
rch1231 169 Posting Shark

Hello,

Try the following site for some suggestions and comparisons:
http://sectools.org/

rch1231 169 Posting Shark

When I have seen this in the past it is because I picked a resolution or frequency that my monitor could not display. Try hitting <F8> as you boot and instead of safe mode pick VGA Mode. Once up and running you can reset the video to a resolution that has worked in the past.

rch1231 169 Posting Shark

Ah I cheat and run
sudo su -
Opens a root shell with all of roots paths and variables.

rch1231 169 Posting Shark

I would try setting the wireless router over to gateway mode and let everything get their IP addresses from the 192.168.1.X network. That way every thing will be on the sam e subnet.

rch1231 169 Posting Shark

A lot of this depends on what IP addresses are being used by the wired and wireless networks. If the wireless router is using dhcp and your wired network is also using dhcp then you could logically turn off the DHCP on the wireless system and have the computers obtain an address from your network.
If not send more information on your configuration and we can provide more information or guidance.

rch1231 169 Posting Shark

Click install and then Protocol and the NETBIOS...

rch1231 169 Posting Shark

Check in the CMOS setup to see if the PATA controller is enabled. Also check to see if the cable is properly connected to the motherboard. The controller is built in to the motherboard and not really something you can access as hardware. If it is PATA (vs SATA) there will be jumpers to set it for Master, Slave or Cable select.

rch1231 169 Posting Shark

On the XP systems go to Your network connections and add in the protocol for NETBOIS IPX/SPX. You won't need a CD or disk. It is what windows systems need to be able to see each other on a network.

rch1231 169 Posting Shark

How about if you let the PS3 choose automatically and set the PC wired at

IP: 192.168.0.100
NM: 255.255.255.0
GW:

and the wifi on the pc at:
IP: 192.168.2.100
NM: 255.255.255.0
GW: 192.168.2.1

Should work then.

rch1231 169 Posting Shark

Is it possible to set up a separate table with the ID's or to flag the records in the database somehow. You have to get the list from somewhere so why not set up a table with the ID's and do a join off of the ID.

rch1231 169 Posting Shark

Boost it up to 2GB RAM.

rch1231 169 Posting Shark

I take it your media server is on the PS3 network. OK add 192.168.0.1 back in to your DNS list but do not add the gateway. I think what is happening is that your media server is only registering with the DNS server on the wired network and since you are not checking the wired network for DNS (WinS in this case I will bet) you don't get a response.

The gateway tells the systems "If you want to talk to an IP outside our subnet you go out through this address."

The number of IP addresses in yur subnet is defined by your netmask (255.255.255.0) which in your case says IP addresses between 192.168.0.1 and 192.168.0.255 are on our subnet. You could decrease the size of the subnet from 255 addresses to 128 by using a netmask or 255.255.255.128 or to 64 using 255.255.255.192 and so on. Hope that helps.

Here is a table of netmasks just to really drive you nuts....

ID	# Bits	Number Hosts	Usable Hosts	Netmask		Note

6	/6  	67108864	67108862	 252.0.0.0  	

7	/7 	33554432	33554430	254.0.0.0 	

8	/8 	16777216	16777214	255.0.0.0 	Class A Network 

9	/9 	8388608		8388606		255.128.0.0 	

10	/10 	4194304		4194302		255.192.0.0 	

11	/11 	2097152		2097150		255.224.0.0 	

12	/12 	1048576		1048574		255.240.0.0 	

13	/13 	524288		524286		255.248.0.0 	

14	/14 	262144		262142		255.252.0.0 	

15	/15 	131072		131070		255.254.0.0 	

16	/16 	65536		65534		255.255.0.0 	Class B Network 

17	/17 	32768		32766		255.255.128.0 	

18	/18 	16384		16382		255.255.192.0 	

19	/19 	8192		8190		255.255.224.0 	

20	/20 	4096		4094		255.255.240.0 	

21	/21 	2048		2046		255.255.248.0 	

22	/22 	1024		1022		255.255.252.0 	

23	/23 	512		510		255.255.254.0 	

24	/24 	256		254		255.255.255.0 	Class C Network 

25	/25 	128		126		255.255.255.128 	

26	/26 	64		62		255.255.255.192 	

28	/28	16		14		255.255.255.240	

27	/27	32		30		255.255.255.224	

29	/29 	8		6		255.255.255.248 	

30	/30 	4		2		255.255.255.252
rch1231 169 Posting Shark

Hello,

One way to do it is to make the output column names the same in both queries and then use UNION to combine the two:

(Select xxxx as Field1, yyy as field2 ....
)
UNION
(Select zzz as Field1, ttt as field2 ....
)

rch1231 169 Posting Shark

Well my first suggestion would be to run mysql on windows instead of MS SQLServer. But barring that is the field indexed in MS SQL server?

rch1231 169 Posting Shark

OK

Then what you need to do is get rid of the gateway entry for the wired network because the system does not know which gateway takes priority. I would drop the DNS entries also or set them to the data from the wireless network.

rch1231 169 Posting Shark

Hello,

From what I see in the documentation you can treat the GROUP_CONCAT(itemname) as a list to test against.

select ContainerName, ContentType, and GROUP_CONCAT(ItemName) as itemnamelist
where "Apple" in GROUP_CONCAT(ItemName)
group by ContainerName

At least that is the way I read it. I would like to know if it works...

rch1231 169 Posting Shark

Hello,

I can see a couple of ways to do this but some questions first.

Does a ticket always have an entry in the ticket_history table?

In your description of the output you reference the status three times. Twice from ticket_history and once from ticket. Is that required?

Is this just for one ticket id at a time or will it be a report of all tickets?

rch1231 169 Posting Shark

they are not on the same subnet. The wireless is getting an address from the 192.168.2.X subnet and wired is from 192.168.0.X and your gateways are different. Is your wireless router the same as your wired one?

rch1231 169 Posting Shark

Can you access the index file on the new server? I would say you need to look at the IIS log files and see what files it is using for displaying the site. You might also try creating a dummy site as a test, For example if you owned the domain mydomsite.com try adding a site called test1.mydomsite.com to the server and see where it points. If it is windows can you access the server via RDP (remote desktop) if you can only get in through plesk then I know it has ways to check the log files for iis.

rch1231 169 Posting Shark

You need to see if the site is setup in Plesk properly and find out where httpd is looking. If it is Linux server for both old and new then files should have the same permissions on old and new. Try

httpd -V

from a command prompt to see where your configuration files are stored. Make sure you have created the site in plesk on the new server and that it points to the directory you have put the old files in. Is the new IP address associated with the site in the new server?

rch1231 169 Posting Shark

Hello,

The first thing I can think of is that the date of the month must be greater than the 14th and less than the 22nd (ie 15th through the 21st ). then just test for weekday being wed.

rch1231 169 Posting Shark

First you have to find out what device name the system has given the new drive. Normally it is something like /dev/sda (which stands for scsi or sata drive a) or /dev/hda (pata drive a) and then it will be broken down by partitions. For example the second sata drive primary partition would be /dev/sdb0 .
You can check what partitions the system sees with

fdisk -l

and then mount the partition as a directory on the system. The /mnt directory is normally used for this and the contents or the drive replace what was previously visible in the directory (so don't mount anything to /home or /var or /etc OK). To mount the second PATA hard drive primary partition as /mnt you would use:

mount /dev/hdb0 /mnt

If you are not sure about the mount options use the man pages to get more info:

man mount

rch1231 169 Posting Shark

So do we consider this solved?

rch1231 169 Posting Shark

Hello,

If you put your code to get the first result in place of temptable in the code below it should give what you are looking for. (I think)

Select ProdID, (Max(Price) - Max(Amount) ) as NewAmount
from temptable 
where 
TotQuantity >= BreakLevel 
Group By ProdID

Let me know how it goes...

rch1231 169 Posting Shark

Hello

You need spaces to separate the variable from the test:

//Skjekk passord
	if ($password != $password_db)
	echo "incorrect password";
	else
rch1231 169 Posting Shark

Hello,

For one thing you need spaces after the commas in you select:

select Emp_Id, First_Name, Last_Name, Gender, Mobile_No, Email_Id, Blood_Group from Employee where

rch1231 169 Posting Shark

Hello,

If you are not getting any link lights when a computer is connected directly via wire then it could be something in the router firmware. On the linksys if you press and hold the reset button for 30 seconds it will reset to original factory settings.

rch1231 169 Posting Shark

Try this and see how it works:

SELECT article.article_title, 
article.article.body, 
count(*), 
sum(comments.status) 
from articles, comments
where articles.ID = comments.Article_ID
group by article.article_title

Should be about right.

kylegetson commented: good simple concise answer. +2
rch1231 169 Posting Shark

Off the top of my head no. But you can find a bunch with google. You might also check to see if you have caching turned on.

http://httpd.apache.org/docs/2.1/caching.html

rch1231 169 Posting Shark

You can convert the date to epoch seconds do the math and convert back. Here is a sample from one of my reference books:

CORRECTION='172800'   # 2 days worth of seconds
# Code to extract the date portion from the data
# into $bad_date go here
# Suppose it is this:
bad_date='Jan 2 05:13:05'   # syslog formated date
# Convert to Epoch using GNU date
bad_epoch=$(date -d "$bad_date" '+%s')
# Apply correction
good_epoch=$(( bad_epoch + $CORRECTION ))
# Make corrected date human-readable
good_date=$(date -d "1970-01-01 UTC $good_epoch seconds")    # GNU Date
good_date_iso=$(date -d "1970-01-01 UTC $good_epoch seconds" +'%Y-%m-%d %T') # GNU
Date
echo "bad_date:       $bad_date"
echo "bad_epoch:      $bad_epoch"
echo "Correction:     +$CORRECTION"
echo "good_epoch:     $good_epoch"
echo "good_date:      $good_date"
echo "good_date_iso:  $good_date_iso"
# Code to insert the $good_date back into the data goes here
rch1231 169 Posting Shark

Try ATT again. If you own the Cell they can track it you just have to get to a tech or supervisor that is willing to do it. They can triangulate it from the cell towers and also they can deactivate the SIM in it if nothing else.

rch1231 169 Posting Shark

The trick is to get the basic query with all of the correct data showing first then add in the SUM options afterward. Try this:

SELECT id.RouteNo, id.PickVol AS total_volume, b.volume AS rested_volume
FROM imported_data id 
LEFT JOIN buff b ON id.RouteNo = b.route AND 
WHERE id.id_date = '2010-10-10'
AND id.LoggCode = 40
AND RouteNo = '019'
ORDER BY RouteNo, id.id_date  ;

Once that works select and sum the result data:

select data1.RouteNo, SUM(data1.total_volume), SUM(data1.rested_volume) from
(SELECT id.RouteNo, id.PickVol AS total_volume, b.volume AS rested_volume
FROM imported_data id 
LEFT JOIN buff b ON b.route  = id.RouteNo AND b.DATE = id.id_date
WHERE id.id_date = '2010-10-10'
AND id.LoggCode = 40
AND RouteNo = '019'
ORDER BY RouteNo, id.id_date ) as data1
Group By data1.RouteNo

See if that works...

rch1231 169 Posting Shark

Check and see if Imagmagick is installed to resize the images.

rch1231 169 Posting Shark

Ok so you do have 16 processors available. My personal recommendation would be to see if you can get more memory. 4GB should be enough and/or increase the size of your swap partition. If you think about it 512MB divided between 16 processors gives each processor 32MB to use.

Also try running "top" and see what is taking up most of your CPU time.

rch1231 169 Posting Shark

The main process controlling the operation is services.exe. It stops and restarts the services it needs to re-establish the DHCP connetion. services calls svchost and mDNSresponder and a few others I could not quite catch.

rch1231 169 Posting Shark

A couple of things seem a bit odd to me. Your specs say you have 16 processors but only 512MB memory and 30GB hard drive space. There may be 16 processors in the server but you are not being allocated all 16. And 512MB of memory is a bit low for any web server. How about running the following and posting the results here:

This will give you a realistic memory allocation:
cat /proc/meminfo

This will verify the number of processors you can use.
cat /proc/cpuinfo

rch1231 169 Posting Shark

how about:

$query = "SELECT count(`mail`) FROM `users` WHERE `username` = `$session->username`";

rch1231 169 Posting Shark

Hello,

At this point I really need to see the code for the page and the httpd.conf entry for the site. The errors suggest that apache is not running or does not have permission to read the files.

rch1231 169 Posting Shark

I think what you are looking for is grep (get regular expression) it is used to pull specific lines from a file. you could then use awk to strip out the fields you want.

It really depends on the format of the actual file in question. The page you directed to shows the data to be on multipe lines and this can be a pain. try

grep ticker <filename>

where <filename> is replaced with the name of the file you downloaded. Also look into xml which is the format used and can actually be read straight into your database.

rch1231 169 Posting Shark

I believe you will find it is:

ipconfig /renew

rch1231 169 Posting Shark

I am not sure but I believe you have the syntax for include wrong. It should look something like this:

<?php include "../config.php" ?>

and this would imply that config.php is one directory up from the file calling it or in your case:

/home/glbo123/public_html/

If it is in the same directory with the index.php file you would change it to:

<?php include "./config.php" ?>

./ is the currentl directory.
../ is one level up.

rch1231 169 Posting Shark

IF it comes up at first but goes blank when it is starting windows it could be your screen cannot handle the resolution you have chosen. If you hit <F8> as the system is booting your should get a prompt for how you want to start windows. Try VGA mode and see if you can get in that way.

rch1231 169 Posting Shark

You have to open the case and look.

rch1231 169 Posting Shark

Hello,

The only thing I have ever notice is that when you query a view from another view is that it can be slower if the first view creates a large amount of output. You might want to simply add the query as an outer select to the syntax for the first view.

rch1231 169 Posting Shark

CentOS. It is what is used in most web hosting centers and is designed for web hosting. Also if you want to use it as an email server check out qmailtoaster. They have a series of scripts that install and configure Apache, PHP and MySQL for you with a very secure configuration.

rch1231 169 Posting Shark

Hello,

You can run a login script for a specific user by adding it to their profile. Go to Control Panel, Administrative tools, Local Users and Groups, Users. Then right click on the user and select Properties and then the Profile tab.

rch1231 169 Posting Shark

The images are stored on a server at craigs list and only their servers can access the images to display them on the ads.

rch1231 169 Posting Shark

Well to begin with your CMOS battery is dead and needs to be replaced. When you turn your computer off does it still have access to power (i.e. plugged into the wall and powered off with the front panel power switch) or do you turn off the power strip it is connected to. The CMOS holds the configuration information for your computer (CPU speed, amount of memory, size and number of hard drives, etc.) If the system has power available it, then it uses that power to keep the information intact in memory. If it is completely cut off from power it uses the battery which is normally good for a year or two.

One of the components in your systems may be on the verge or failing and it is taking a while to recognise what it is.

Hope this helps.