Red Web Turtle

Got this error while trying to import a large .sql file in MySQL Workbench: ERROR 1118 (42000) at line 171970: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_size. Solution to the above error in XAMPP is as follows: In xampp\mysql\bin\my.ini file, set innodb_log_file_size = 128M (the default value was around 20M) Save the file and restart MySQL server.

While testing a website I was developing, I got an error message saying "Internet Explorer has stopped working". This is followed by this line added before the URL: res://ieframe.dll/acr_error.htm# . I was using Internet Explorer 11 in Windows 7 64-bit machine. I tried disabling all add-ons in IE but that did not resolve the issue. I've found this solution to my problem: From Tools menu, open "Internet options". Go to the Advanced tab. Under "Accelerated graphics", tick the box that says "Use software rendering instead of GPU rendering". Click Apply and Ok. Test your website. You might need to restart your computer if it does not immediately show any effect. This worked for me.

When MercuryMail shuts down unexpectedly, you get the following message on XAMPP control panel: Error: Mercury shutdown unexpectedly. 6:25:56 PM  [mercury]     This may be due to a blocked port, missing dependencies, 6:25:56 PM  [mercury]     improper privileges, a crash, or a shutdown by another method. I restarted Mercury but that did not help. However this worked for me. Open up your Mercury's /QUEUE directory. It should be located somewhere at "C:\xampp1.8.3\MercuryMail\QUEUE". There should be one or more *.QCF files. Delete all of them. Then start Mercury from XAMPP Control Panel.

After installing Cygwin, there was a warning on the Win 7 command prompt that says 'cygintl-2.dll' file is missing. It turned out to be a conflict between Cygwin and OpenSSH program, which I had installed prior to Cygwin. 'ls.exe' was part of both Cygwin's /bin and OpenSSH's /bin directories and it looked like the 'ls' command was running off OpenSSH's path. I just uninstalled OpenSSH. Then it started working again. Alternatively, I could simply remove OpenSSH from the Window's PATH. That might have resolved the issue too but didn't try. If you have found another solution, free free to share.

This SQL helps you list the tables with a certain column name. As you can see in the script, you can also use comma-separated multiple column names. SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN ('column_name1', 'column_name2') AND TABLE_SCHEMA='database_name' You may also use "COLUMN_NAME LIKE" to find a closer match of something you are looking for such as: SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE 'column_name%' AND TABLE_SCHEMA='database_name'

I was trying to send emails to my localhost account in Windows Live Mail and it's giving me an error message "421 service not available closing channel". This is nothing to do with the email client. This is an issue in xampp's MercuryMail folder. I am using XAMPP 1.8.3 and it appears MercuryMail seems to have "QUEUE" folder missing. Place a "QUEUE" folder inside MercuryMail as in "C:\xampp1.8.3\MercuryMail\QUEUE" and this problem goes away. The same path for the QUEUE folder should be used in the "Mail queue" tab in Mercury's Configuration > Mercury Core Module Configuration.

In Windows, MySQL database tables are saved with lowercase letters. When you import tables with case sensitive names, these get converted into lowercase names. If you want to maintain case sensitivity in MySQL database, do the following: In your MySQL installation folder, find my.ini file and open it. If you are using xampp, it's usually located in /mysql/bin/ directory. In [mysqld] section, modify the value of lower_case_table_names to 0. If this entry is not there already, simply add this line: lower_case_table_names = 0 Then restart your MySQL server.