Recent Questions

I have Windows 10 on a Surface Pro 3. I am trying to use Visual Studio Code. Unfortunately, there seems to be no combination whatsoever where I can run my program. Any time I hit F5 or ctrl f5 or shift f5, the windows 10 search bar from the OS pops up. There seems to be no way to make the application received the F5 before the OS and I can find no way to swap any key to make the program Let's block ads! بخوانید...

I have a MySQL database that was created from data output by another application. On of the columns is for an email address, however the data in this column is all duplicates. For example, the "email" for a single record looks like this "[email protected],[email protected]". I would like the field to contain the address just once. Is there a way through a MySQL command, to remove anything from the , onward? I know I can write a PHP script to loop through all the data, but i was hoping there was a ...

I'm trying to restart my mysqld process on CentOS 6.6. I have root access to the server and when I run top, this is the first line: PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3874 mysql 15 0 2859m 336m 7188 S 120.5 16.4 74730:50 mysqld Clearly there is an issue there (and I may need to increase the DB server since it's maxing out) but the first step I want to take is to put the process through a power cycle to restart it since it hasn't been restarted in a very...

Just experimenting with mysql and batch file (call me nostalgic :-) ) echo SELECT some_field FROM some_table WHERE some_field like '%needle%' G > command.sql mysql -s -q -h %svr% --user=%user% --password=%pass% %database% < command.sql This command works perfect for numerical results, but for string results, it is just blank. even if I list the complete table result, it shows all the numerical values, but the field that has strings it is just blank. example 2 rows have "jane doe", and ...

$serveame = 'edited'; $useame = 'edited'; $password = 'edited'; $dbname = 'edited'; $name = $_POST ['name']; $email = $_POST ['email']; $number = $_POST ['number']; $manufacturer = $_POST ['manufacturer']; $birth = $_POST ['birth']; // Create connection $conn = new mysqli($serveame, $useame, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; $sql = mysql_query("INSERT INTO hgcasestudy (nam...

Yes, I know this question has been asked here: http://stackoverflow.com/questions/25086363/how-to-create-a-zero-or-one-to-many-relationship-in-mysql-workbench However, at least in MySQL Workbench 6.3, there is no 'NN' check-box under the Foreign Keys tab. Therefore, the answer given is inadequate. Let's block ads! بخوانید...

I have 2 exchange servers (EXCH1 and EXCH2) that have Exchange 2013 on them. They are both on Windows Server 2012 R2 (Standard) machines. They are also a part of a DAG (Database Availability Group) (DAG1). Both servers are CAS (Client Access Server) and MAILBOX roles. Currently, my router NAT settings are forwarding ports 25, 110, 80, and 443 to EXCH1. Would it be possible to port forward to DAG1 for these ports and let the Failover Cluster Manager decide which machine to use? I tried Network Lo...

I am trying to install Wordpress using Microsoft's web platform installer. I went to the Microsoft website and downloaded the installer, and it walked me through the installation. I was prompted to set a MySQL password and it then started installing MySQL itself and froze. It shows download progress at 100% but this progress bar has been going for about an hour now. As you can see, there is not really any activity coming from the installer. Sorry for my sloppy mouse drawing. How can I fix this?...

I am deploying failover clustering on windows server 2012 r2 enterprise When validate configuration, failover cluster validation report an error At system configuration > Validate Active Directory Configuration This is error message: Connectivity to a writable domain controller from node srv-12-01.clusterdomain.local could not be determined because of this error: Could not get domain controller name from machine srv-12-01. Connectivity to a writable domain controller from node srv-12-02.clust...

Is it possible to change GUI language in Devart dbForge for MySQL? Wish to change from Russian to English? ...

apache is running good and mysql is running good, xampp is running good also but i cant log in myweb myphp when i try to access it in my network i cant log in. keep coming back at main page instead in my profile password and useame is right. the data is located at htdocs i checked httdp config is right. what is my mistake or error. Let's block ads! بخوانید...

I am a new fedora user and i am installing ROR on my machine. but when i try to enter the following command "rake db:create" it shows the following errors. can any one please tell me how can i solve this problem. [smehsan@localhost proone]$ rake db:create '/var/run/mysqld/mysqld.sock' (13 "Permission denied")> Couldn't create database for {"adapter"=>"mysql2", "encoding"=>"utf8", "pool"=>5, "useame"=>"root", "password"=>nil, "socket"=>"/var/run/mysqld/mysqld.sock", "database...

I like to create a local WiFi network for a bunch of devices, that connects to the inteet via another Wifi AP or UMTS WWAN, if the WiFi connection fails. As there are many devices in the local WiFi network, but the environment network may change (ETH cable, some WiFi or none of them), the local network would provide a constant configuration for my local devices. There are routers that provide WWAN failover, but they only provide AP mode (the Inteet is connected by Etheet then) or client mode (Th...

So a followup to my other question: http://stackoverflow.com/a/37057476/2890156 I've tried port-forwarding as suggested here: http://stackoverflow.com/questions/19749599/openshift-how-to-remote-access-mysql but when I try rhc port-forward -a myapp it gives me an error: Error trying to forward ports. You can try to forward manually by running: ssh -N [email protected] So when I execute the command it gives me another error: Failed to add the host to the list of known hosts (/.ssh/known_...

Rename a folder from XYZ to ABC. The new name is not visible in Explorer. Double click (or press enter) on the folder. Windows will say "Folder cannot be found". It appears that Explorer is not aware that the folder was not renamed. I have seen some fixes for this on the inteet but none for Windows 10. Let's block ads! بخوانید...

I followed the guide from http://aoldthebat.co.uk/wordpress/chromium-os/ Use 7zip to extract IMG file from the downloaded file. Use Win32 Image Writer, then select the IMG file and select the USB device from the menu. Click on “Write”. Boot from USB stick and I see the chromium screen, once it goes away I only get a black screen, nothing happens, I have tried numerous times but with the same result, black screen Any suggestions? Let's block ads! بخوانید...

I need to get callsign, channel number and xmltvid from this HTML source. Here's a link to a larger sample of the file: http://pastebin.com/VuzBRhq6 In this case each TD of the table contains a span with the callsign($sign) <span class="callsign">KETSDT</span> in this case "KETSDT". It has a span with <span class="chan">2-1</span> where 2-1 is the channel($chan) The TD also has a title element that looks like this title="KETSDT (KETS-DT) (id: 44002)", where the number aft...

What am I doing wrong here? GRANT ALL PRIVILEGES ON *.* TO 'demoUser'@'localhost' REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0; C:Usersme>"C:Program FilesMySQLMySQL Server 5.7binmysql.exe" "--defaults-file=C:ProgramDataMySQLMySQL Server 5.7my.ini" -udemoUser -pitsAsecret mysql: [Waing] Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'demoU...

When clicking to Export Data, the default format is CSV, but when the data element is text that contains a double quote and/or newline, such characters are treated by common readers (e.g. Excel) as an end of the element, with all sorts of formatting and document structure messed up, lots of new lines inserted, etc. Is there something I can change about the export format, or Excel's import, that makes this (exporting from MySQL Workbench and opening in Excel) work? (image from here) This entry p...

good day friends. They can help me implement a system of discount coupon in my shopping cart, fulfilling these functions please. System discount coupon create several coupons each with a different function. Limited discount coupon date: (expire-date) when does this coupon expire :date/timestamp. Discount coupon single use (discount coupon valid only for a limited number.): The client can use just one time, the coupon discount. Discount coupon only valid for Minimum Total Order: the customer can ...