• Member Avatar for rch1231
    rch1231

    Replied To a Post in Looking for Gmail integrated ticket system

    Take a look at OSTicket. Pretty good and will work with Gmail and other email systems. [OS Ticket](http://osticket.com/) I have set it up for a few customers and they all …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Insert Delayed

    Hello, From what I am reading it was upgraded for INNODB tables and replaced with INSERT [LOW_PRIORITY | HIGH_PRIORITY] If you use the LOW_PRIORITY keyword, execution of the INSERT is …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Is it safe to share the name server of your hosting account

    Your name server are available on the internet anyway. If you are on a system with whois installed (rwhois) then you can enter whois <domainname> And you get all of …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Path cannot be empty error

    The easiest way to install in on a windows system is to download the MySQL installer MSI from: [http://dev.mysql.com/downloads/installer/](http://dev.mysql.com/downloads/installer/) and running it. It has worked for me every time and …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Analyze the running time complexity of the following piece of code

    Under Linux you can use the time command to give you the amount of time taken to run a command. To review the manual entry for time use: man time …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Hard Disk Full cannot Track

    There is a wierd issue with linux files systems it they ever are completely filled (0 bytes free). If you try deleting files to recover the space it does not …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Why testers are dumb?

    I have always considered the following when writing a program: When you write a program that is idiot proof the world builds a better idiot.
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Website dns issue

    If you get out to a command prompt and do an nslookup on your domain what do you get? nslookup <yourdomain.com> it will tell you what IP address it is …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Sed Command

    You can use any delimiting character with sed and the backslash and astereisk need to be escaped. If you use a # as your delimiter this should work: `sed -i …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in if condition is not working

    Have you tried: if [ "$DEV_ORA" -eq 0 ] then Also on line 23 should the output file be /tmp/dump.txt like the others? and what is the output of `grep …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in create receipt image using php

    I realize this is not what you were asking for but have you considered creating a PDF instead of an image. Smaller file and there are several free PDF creators …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in how to completely wipe mac drive

    There is an option built into the OS to do a drive wipe. Here is a link to a page that explains the procedure with screen shots, etc. : [http://www.howtogeek.com/179284/how-to-securely-wipe-a-hard-drive-on-your-mac/](http://www.howtogeek.com/179284/how-to-securely-wipe-a-hard-drive-on-your-mac/)
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in if condition is not working

    Over 30 years of writing scripts and debugging code that I and others have written, I find it makes it easier if you simply echo (or print) the variables as …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in PostgreSQL Database Location

    You said 32 bit but I am including both just for reference. 32 bit. On windows7 all the database are referred by a number in the file named pg_database under …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in LAN Connection speed

    Gigabit transfer requires cat 5e or cat6 cable. Cat 5 will not transfer at 1GB. from: [http://www.lifehacker.com.au/2013/04/ask-lh-whats-the-difference-between-cat5-cat5e-and-cat6-cables/](http://www.lifehacker.com.au/2013/04/ask-lh-whats-the-difference-between-cat5-cat5e-and-cat6-cables/) Cat5: A Little Older, A Little Slower Category 5 cabling, also known as …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Win7 -- Will Global Policies survive domain disjoin?

    I would also have to say no. To remove it from the domain you are going to have to use a Domain Admin account and if you can't get to …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in monitor not showing native display

    I would try a different converter and/or cable. Some of the converters do not pass all of the pins that VGA can use just the ones that they have to …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in How to install mysql on server computer and client computer

    I think what you are trying to ask is how to install the MySQL database on a server and how to access that MySQL database from the client computers. If …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Help to build MYSQL Search query

    It is going to depend on what type of result you want from the data. For example: are you wanting it to be selected if the individual elements of the …
  • Member Avatar for rch1231
    rch1231

    Gave Reputation to tech6916 in Missing D Drive from Windows Explorer

    It may have been helpful to specity if you "D" drive is removable such as a NAS for example. If that is the case here, please specify the unc with …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in about bittorrent

    Here is a pdf that is a few years old but covers the basics pretty good without being very big. Their license says I can share it as long as …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Missing D Drive from Windows Explorer

    If the drive is on the same disk then when you go into *Administrative Tools, Computer Management,* then *Disk Management*. In the center frame you will see the *Volume List* …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Missing D Drive from Windows Explorer

    Hello, If that is your CD-ROM/DVD drive like in most windows systems now a days then the solution could be as simple as putting a disk in the drive. I …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in SQL Like Command - how to find records without 1-9 but using 0

    I have found it is a good idea to cover the records where the field is blank, 0 or null with something like: ` SELECT * FROM settlement WHERE settlement …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in An Old Fake Microsoft Scam

    My brother received a call that was from the IRS about the middle of December and they wanted him to go to Kroger and buy Prepaid credit cards and give …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Displaying from the database by category

    Really need to see what your tables look like. If Category is a seperate table with ID and Name and the doctors table only has Cat_ID not Cat_Name then your …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in The page isn't redirecting properly - php wamp

    I may be wrong but I believe the issue you are having is in line 6 which reads: `header("location:accountSummary.php");` You should have some sort of path to the accountSummary.php file …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in No signal on monitor

    I would check to make sure that your video card is properly seated. I have knocked mine loose a few times when connecting cables. Does the computer power on and …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in mysql memory usage

    I would take a look at what processes are being kicked off in MySQL. You can run the following command to see what is running in MySQL ` mysqladmin processlist …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Does exist software for transforming data from one DB schema to another?

    You could do this quite easily with SQL by creating the new tables in your current database and then exporting the tables to be imported to the new database. To …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Popping/Cracking sound and audio lag?

    My guess would be a IRQ conflict which Windows has always had issues allocating properly. Click "Start," then click "Control Panel" to open the Control Panel window. Double-click the "System" …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Fatal error

    We would need to see the code in question in order to be able to help. What database are you using? Do you have any indexes created on the tables?
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in SQL query with one join only returning the first record

    Hello, In mysql you can use LIMIT to limit the number of rows of output: SELECT OrderLine.LineNo, Order.OrderNumber, Order.Description, WarehouseOrder.WhsRef, WhsPick.PickRequired, WhsPick.PickAvailable, WhsPick.EstimatedDispatch, Carton.CartonNumber FROM WhsPick INNER JOIN WarehouseOrder ON …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Management Reporting from various dbs - what is the best approach?

    My suggestion is to set up a server with a database you are familiar with and then regularly export the data from the various databases and import it to your …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in what am i missing here

    Hello, I can see what is causing your problem but just telling you will not help you solve this in the future. What I do when a piece of code …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in need help to fix errors in php with xampp server(Apache and mysql)

    What really helps is if you put the code you are using and the error you are getting like you did initially. We can't debug your code without seeing it.
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in System Menu: how can i change the standard System Menu?

    Hello, How to geek as a good discussion of how to do this in WIndows Vista and later. [http://www.howtogeek.com/howto/windows-vista/add-any-application-to-the-desktop-right-click-menu-in-vista/](http://www.howtogeek.com/howto/windows-vista/add-any-application-to-the-desktop-right-click-menu-in-vista/)
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in WordPress Permalinks

    Hello, I noticed your other posts about this recently and thought this might be a little late but will really help. The best way I have found to allow me …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in need help to fix errors in php with xampp server(Apache and mysql)

    Hello, When are you getting the error about firstname not in field list? Is it when you are running the create table query or at another point in the process? …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in unable to connect to mysql database using pony

    One other thing I will mention just in case, Is the script running from your local machine at the 197.253.66.85 address, or is it running on a server through a …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in unable to connect to mysql database using pony

    Hello, If you have root access to the mysql server then you can run the following from the mysql prompt to get a list of users and permissions: mysql> select …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Linux Services vs Daemons

    Service is the command that calls the scripts from /etc/init.d which control the daemon processes. Many people use the terms service and daemon to refer to the same thing however …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Mac shows slow in loading a webpage.

    Hello, The MAC OS is based on Linux and normally loads web pages as fast or faster than a comparable Windows system. In an system it will depend on the …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in how to display server load in php

    This may be over simplfying it but I used the following to give me the load average depending on the OS . For Linux <?php $output = shell_exec('w | head …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Question on Access 2003

    So what error are you getting?
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in My USB Flash Disk demands formating and on the process it fail to do so

    Hello, The first question is are you doing a quick format or not. If the USB filesystem becomes corrupted a quick format, which basically just deletes the entries in the …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in updates

    Hello, I have seen this before and it took me a minute to find the reference I used to fix it. The error is due to Windows Update running out …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Centos 5.11 hacked

    Hello, I would start with what processes are running on the server and what is calling the offending scripts. If you run `ps auxf` you will see all of the …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in Microsoft's Heavy Handed Approach to Windows 10 Upgrades

    I came across a python script for Windows 7 called GWX Control Panel that allows you to disable the GWX application and also disables the ability for Windows upgrade your …
  • Member Avatar for rch1231
    rch1231

    Replied To a Post in What is SSH commands for this: run 20 times, break 2 seconds, and repeated

    Hello, Here is a shell script for what you are requesting but I home you are not really going to do a wget 20 times. If you do you will …

The End.