Posts by rch1231

In effect your are running three separate queries to three separate tables with each one pulling the most current records from their respective tables and then joining the output into one large table. In answer to your question a slim maybe. The system runs the three queries and then once it has the results combines them into one table. The three queries would run at the same time. Does that make sense?

Your log from Malwarebytes is for a quick scan not the full scan. Run the full scan.

Hello,

What you need is the motherboard chipset driver. It has the drivers for the CPU, memory controller and other motherboard resources. Normally it is best to install it first them any other drivers. Without it your system cannot talk to the onboard video chipset so the drivers would not install for it properly.

I think what you are looking for is probably a combination of the LIMIT option and the UNION command. If you have 4 sets of like results for 4 queries (each query returns like columns and the same number of columns ) then write your selection statements in parentheses and put UNION between them. Something like this:

(Select table1.topic, table1.comment, table1.username, table1.mydate from table1
where topic = topic1
order by mydate desc
Limit 10)
UNION
(Select table2.topic, table2.comment, table2.username, table2.mydate from table2
where topic = topic2
order by mydate desc
Limit 10)
UNION
(Select table3.topic, table3.comment, table3.username, table3.mydate from table3
where topic = topic3
order by mydate desc
Limit 10)

Each table will be limited to 10 results and all of the results will appear in a 30 column table.

I would disable these and free up a few IRQ's

Serial Port1 Address [Disabled]
Parallel Port Address [Disabled]
Parallel Mode [Normal]
Parallel Port IRQ [Disabled]

Check under Chipset and see if there is an option for the onboard sound card or game port. If so disable them since you are installing a replacement card.

Go into the computer BIOS setup (normally Hit <DEL> or <F1> or <F2> depending on manufacturer) as the computer is booting and disable the onboard game port. While you are in there you might disable the onboard serial and parallel ports (if they are installed. Also I bet the motherboard has a 15 game port on a spacer that would fit in one of your expansion slots. The 9 pin port is normally a serial port.

Maybe this will help. I wrote it for another thread that was having problems with two routers on the network. I think what you need is a wireless access point instead of a router in the second location. An access point will connect to the router to allow it to set DHCP.

--

DHCP is the service that provides systems with an IP address, Gateway and DNS if they ask for it.

A router controls a block of IP addresses and the flow in and out of the subnet to the WAN (or internet). Where a hub or switch (sometimes referred to as gateway mode on routers ) is simply a box that connects several ports together without supplying any services DHCP or Routing (Network address translation in this case). TO put the router in gateway mode you have to turn off both DHCP and routing.

It took me a while to get a handle of how network routing and subnets work and really just took somebody taking the time to explain what is going on.

You have three settings to deal with:
IP Address 192.168.1.100
Netmask 255.255.255.0
Gateway 192.168.1.254

These tell me that the computers address is 192.168.1.100. The subnetmask tells me that I can get to any IP address from 192.168.1.1 to 192.168.1.255 locally on my local network. That if I want to get to an IP outside that …

Hello,

The dell site has the codes for the flashing lights in the service manual for the specific model. Go to their site and use the service code to get to the manuals on your computer. On Dell desktops if your don't see a label that specifically says it is the service code it is usually on a 1/2 X 3/4 inch white label on the back of the unit.

Hello,

Normally installing mysql will not overwrite your database files however to be on the safe side use phpmyadmin to backup the databases or export them using mysqldump (or both). My suggestion is: make two separate copies of the data files. Murphy's Law says if you have two backups then you won't need both, or they are corrupt on the same file. Having two different exports means you should be able to handle any situation that comes up if you have to restore.

Then if you are running on a Windows based PC I recommend using XAMP. It usually picks up your current configuration and adjusts for the environment.

Ok I have looked around for something that might help but the only think I can see is I believe there should be a space after the IN

class CHAR(10) NOT NULL CHECK class IN ('x1','x2','x3'),

I am not sure what you mean by "A value that I choose" but there are several ways. Here is an example from the mysql cookbook that should do the trick:

We've used lookup tables often in this chapter in join queries, typically to map ID values or codes onto more descriptive names or labels. But lookup tables are useful for more than just SELECT statements. They can help you create new records as well. To illustrate, we'll use the artist and painting tables containing information about your art collection.
Suppose you travel to Minnesota, where you find a bargain on a $51 reproduction of "Les jongleurs" by Renoir. Renoir is already listed in the artist table, so no new record is needed there. But you do need a record in the painting table. To create it, you need to store the artist ID, the title, the state where you bought it, and the price. You already know all of those except the artist ID, but it's tedious to look up the ID from the artist table yourself. Because Renoir is already listed there, why not let MySQL look up the ID for you? To do this, use INSERT ... SELECT to add the new record. Specify all the literal values that you know in the SELECT output column list, and use a WHERE clause to look up the artist ID from the name:

INSERT INTO painting (a_id, title, state, price)
SELECT a_id, 'Les jongleurs', 'MN', 51 …

If I am reading the error correctly you do not have an index built on the account_number field.

Looking at the code I think the problem is you are not using the "SET" command to identify the variable you are updating. Normal syntax for an update statement is something like:

UPDATE table_name
set table_name.field5 = <field5data>,
table_name.field10 = <field10data>
where table_name.id = <record_id>

In your case I think the line should read:

$query= "UPDATE account 
set account_type =`".$_POST['account_type']."` , 
fd_period = '"$_POST['fd_period']."' 
WHERE `account_number`='".$_POST['account_number']."'";

Hopefully this will help but I am not sure about the $_POST. I think it should be the array (or hash) $info instead.

Have you tried to get to the port locally inside you network to make sure it is available. You can use telnet to connect to a port and see if it is working:

telnet 192.168.1.3:25

Would connect you to port 25 on the local system at 192.168.1.3.

Sorry never really used that particular shell app. Try asking again and including that information and someone better qualified may have a better idea.

Are we talking linux(unix) shell scripting or Windows scripting?

Your problem comes from a couple of things. Try this:

a=3
type=$a
echo $type

Hello,

Are they on the same subnet as the server 2003 system. What is the server IP, subnet, Gateway and what IP, subnet,gateway do the other computers have? It could be that there is another router between them and you that connects through your current system. For example: They could be in the 192.168.2.X subnet and connect to your subnet at 192.168.1.X to go out to the internet. They would see systems on your subnet but you would not have a route setup to go to them unless they sent a request with the routing attached. Does that make sense?

Hello,

There are several issues with the statements you made. 1) installing XP twice usually means you installed XP on top of it's self. If you are seeing two options when you initially boot for running XP it just means that your boot loader has two entries however both of them will most probably not run. Right click on My Computer and then select Properties from the dialog box. Next select the Advanced tab at the top and then click the Startup and recovery button in the bottom box. From there you can Edit the boot.ini file and remove the extra entry for the XP version you don't need.

Installing Linux normally requires a separate partition formatted for Linux however there are versions of Umbutu that will run under the Windows operating system that give you most of the functionality of linux. Here is a link to the windows installer for Umbutu
http://www.ubuntu.com/download/ubuntu/windows-installer

Just looking at it real quick is identity your primary key and set for auto-increment? If so then do not attempt to set the value as the system will automatically fill it in.

Hello,

More like 3 page by dynamic pages that are created on the fly by php querying the database. I would set up a table for each of the selection criteria. Table 1 Countries, Table 2 Majors by country, Table 3 Universities including country and majors.

The code is not that difficult to write however there are a million example out there. See if you can find a copy of the PHP cookbook. It give your excellent code examples that you can simply adjust for your needs.

Not that I am aware of. However if you gave it a fixed (static) IP address then you already know it and it does not change.

If the adapter is disabled it does not have an IP address. If you have used a fixed address and disabled it then the address is stored in your OS but not being used. If you are using DHCP then the NIC is disabled and therefor has not requested an address from the DHCP server. So technically you could say the address is 0.0.0.0.

It is really kind of hard to help you without seeing the code for your site. If you post it up here make sure you change the password to something different.

If you have not fixed this yet here are a couple of things to do.

I take it you are trying to connect via the 10-base T cable instead of the wireless.

1) Check for link lights on both the Router and the NIC card.

2) Try setting the wired connection to a fixed IP address on the local network. In your case I would use the following:

IP 192.168.1.50
Netmask 255.255.255.0
Gateway 192.168.1.1

DNS1 68.105.28.11
DNS2 4.2.2.2

Then do a power down reboot and unplug the wire from the NIC.

3) If you still cannot connect lets see how far you can get by pinging various IPs. Start with the local card, then the router, then an IP on the internet and finally an address using DNS.

ping 192.168.1.50
ping 192.168.1.1
ping 4.2.2.2
ping google.com

Let me know how it goes.

In order to be able to see the XP systems you will need to make sure a protocol is loaded on the XP based system. Go to Control Panel, Network Connections the right click on Local Area Connection and then select properties. When the box comes up look through the list for

NWLink IPX/SPX NetBIOS Compatible Transport.

This protocol is what lets two windows systems see each other and communicate. If it is not listed click the Install button just below the box and select "Protocol" you should see NWLink IPX/SPX in the list. Select it and click OK. It will take a second to load then OK the first screen and reboot the computer.

Ok why do you have the DNS set to 127.0.0.1 and can you ping an IP address on the internet. Try pinging 4.2.2.2 which is a public name server that you can also set as your DNS.

Hello,

You need to look into a book on the shell (bash shell programming) and the difference between commands with and without sudo is that sudo executes the command as root.

This might help also:

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

OReilly.Classic.Shell.Scripting

Here is a link to the site I used to install the driver from:

http://unixmen.com/linux-tutorials/linux-distributions/fedora/1376-how-to-install-nvidia-drivers-in-fedora-13-and-14

Are you pinging the IP address of the host name?

Can you ping the gateway OK and and you ping each of the cards IP addresses?

Is Windows firewall turned on because it may not be letting the pings through.

The message you are receiving could be from a virus that is trying to get you to install it. To find out for sure get the latest copy of MALWAREBYTES from the link below. The free version will usually get rid of almost everything and you can install it in "Safe Mode with Networking" and get the updates and for the software too.

Remove the gateway IP address from the card that is not using DHCP. There can only be one gateway to the internet. Here is the data from my ipconfig:

Windows IP Configuration


Wireless LAN adapter Wireless Network Connection 2:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::543d:fc8a:dc8c:be5d%20
   IPv4 Address. . . . . . . . . . . : 192.168.1.10
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . : 192.168.1.1

Ethernet adapter Local Area Connection:

   Connection-specific DNS Suffix  . :
   Link-local IPv6 Address . . . . . : fe80::c5af:a780:ec0f:e2fe%10
   IPv4 Address. . . . . . . . . . . : 192.168.0.1
   Subnet Mask . . . . . . . . . . . : 255.255.255.0
   Default Gateway . . . . . . . . . :

The code you have is selecting every record from question and only joining info from records in answer that match the criteria. I think what you ar looking for would be:

SELECT * 
FROM question 
LEFT JOIN answer ON question.Que_ID=answer.Que_ID 
AND question.Que_Answer1=answer.Ans_Answer1 
AND question.Que_Answer2=answer.Ans_Answer2 
AND question.Que_Answer3=answer.Ans_Answer3
AND question.Que_Answer4=answer.Ans_Answer4
WHERE				
question.Tes_ID=7
AND answer.Use_ID=1

May I suggest that you take a look at qmail and the install provided at qmailtoaster. I use it on my servers with the addition of spamdyke and it works great. It has the features you are looking for and more.

http://www.qmailtoaster.com/

Your problem is coming from the field being treated as a string rather than a number. Basically you have two options.
1. Split the files into tree separate fields as integers and then do the order by using all three fields.

2. Change the columns that need it in your data to be 2 digit based instead of one or two.

So the data would look like this possibly:
1.1.01
1.1.02
1.1.03
......
1.1.10
1.1.11

What you want is a RAID controller card to connect the drives to. You will setup the RAID on the drives prior to installing the OS and the OS will see the array without any problems as a single install drive.

If you can't turn the laptop back on then there is a hardware issue. My first guess is that the system is over-heating. Make sure the vents on the bottom and sides are not blocked and check to see if there air coming out at least one of the vents from the CPU fan.

It does not make sense for the server to block you unless the account is restricted to only one connection per user. I am not sure what ssh client you are using to access the server but may I suggest you try PUTTY.

http://www.chiark.greenend.org.uk/~sgtatham/putty/

I work for a hosting company and have been supporting Linux for 20 years and it is the best free client. You will be able to connect and if nothing else see why you are not connected.

I don't believe what you are describing is possible with just one hard drive. You are attempting to use partitions for the RAID instead of physical disks. RAID, an acronym for Redundant Array of Independent Disks (Changed from its original term Redundant Array of Inexpensive Disks), is a technology that provides increased storage functions and reliability through redundancy. This is achieved by combining multiple disk drive components into a logical unit, where data is distributed across the drives in one of several ways called "RAID levels".

You would actually run slower attempting to access multiple partitions on the same drive as opposed to accessing data across multiple physical drives. The following site may give you a better idea of what RAID is and how it is used:

http://en.wikipedia.org/wiki/RAID

Your problem is probably due to the fact that most ISP's limit the upload speed to one a lot slower than their download. For example my ISP gives me 3Mb/s download but only 512kb/s upload. You can check this at any of the speed test sites. Persnally I like this one:
http://www.speakeasy.net/speedtest/

try
ftp 111.92.1.214
but the question is do you have an ftp server running to allow the connection. Try this from the command line:

ps aux | grep ftp

this will show you any processes with ftp in the name that are running. You may need to install an ftp server (like vsftp) with apt-get.

Not pretty but it works and I moved 1 from the first position for testing:

#!/bin/bash
 y=0
for x in 4 6 23 1 5 7 100 2
do
if [ $y -eq 0 ]
then
y=$x
fi
if [ $x -lt $y ]
then
y=$x
fi
done
echo "Answer: $y"

Have you tried uninstalling mysql and then reinstalling it to see if it removes the registry entries or restoring to a point prior to the changes you made and working from there?

2 things:
You may have to give the full path for grep which you can find by running
which grep
from a shell prompt and second what happens when you run the command from the command line?

Here is a link to one I have used that works pretty good.

http://ckeditor.com/

try this to seewhat is happening:

/bin/sh -x cup.sh
it will show you each line and result as it executes.

If I am reading you post correctly you have A desktop a Laptop , a router (wireless or not) and a Modem (Cable or DSL) and want to be able to use the internet and to share files on both systems.

The systems should have no problem connecting to the router and provided the network cards on both are set to get an IP from the router (DHCP or Obtain an address automatically) you should be able to use the internet on both at the same time. TO get the two to communicate you will need to make sure a protocol is loaded on the XP based system. Go to Control Panel, Network Connections the right click on Local Area Connection and then select properties. When the box comes up look through the list for

NWLink IPX/SPX NetBIOS Compatible Transport.

This protocol is what lets two windows systems see each other and communicate. If it is not listed click the Install button just below the box and select "Protocol" you should see NWLink IPX/SPX in the list. Select it and click OK. It will take a second to load then OK the first screen and reboot the computer.

If you have a Vista system go to Network and sharing center and turn on File Sharing, Network Discovery, and Public folder sharing.

Duplicate the lines from 62 through 82 and change the select to:

$qry = "SELECT * FROM members WHERE email is not null and email = '$email'";

And the error message to:

$errmsg_arr[] = 'email address already in use on another ID';