MathTricks Web Solutions

03/07/2023

I want to create a table of 325 column: CREATE TABLE NAMESCHEMA.NAMETABLE ( ROW_ID TEXT NOT NULL , //this is the primary key 324 column of these types: CHAR(1), DATE...

28/06/2021

When we try to print google maps we have to faced for some issues.Some times the maps are not printed.Sometimes The maps are printed partially.Most probably ...

06/02/2021

STOP! Please do NOT delete ibdata1 file!

Deleting this file is like playing a Russian roulette with your databases, it could work and restablish everything, but also, probably could leave unusable every database you have.

Instead, first try using the MySQL backup folder which is included with XAMPP. So do the next:

Rename the folder mysql/data to mysql/data_old (you can use any name)
Create a new folder mysql/data
Copy the content that resides in mysql/backup to the new mysql/data folder
Copy all your database folders that are in mysql/data_old to mysql/data (skipping the mysql, performance_schema, and phpmyadmin folders from data_old)
Finally copy the ibdata1 file from mysql/data_old and replace it inside mysql/data folder
Start MySQL from XAMPP control panel

When I open XAMPP and click start MySQL button and it gives me an error. I had started it just before, but now it isn't working. 12:19:12 PM [mysql] Attempting to start MySQL app... 12:19:12 ...

29/01/2021

Unable to Open Outlook Message Files(.MSG) in Web Browser

  I recently ran into an issue where a user had uploaded an Outlook Message file to a web application. The users were reporting an error that each time they tried to click on a link to the .MSG file, the web browser would display an error message that the file had been moved or…

24/12/2020

In this tutorial we'll use Shared Preferences in our android application to store data in the form of key-value pair. n Android Shared Preferences

23/12/2020

How important is RAM speed to your game? How to check your RAM speed quickly? Here are best ways for you to check RAM speed and what you must know about it.

02/08/2020

Install Ubuntu on Aspire 5:

you can not change the BIOS mode UEFI to LEGACY in most of new laptops especially in Acer laptop. No way to select boot option as USB flash drive. We share a...

24/06/2020

How to disable WordPress plugin update/ update messages.

If you don't want to see WordPress plugin update message for one or many WordPress plugins, If you don't want update WordPress plugins, if you change a plugi...

26/05/2020

Consider this QUERY (DEMO IS HERE) (SELECT * FROM `titles` where title = 'test\\') UNION ALL (SELECT * FROM `titles` where title LIKE 'test\\\\') Output: | ID | TITLE | -------------- | 1 | tes...

13/05/2020

https://gist.github.com/ashanrupasinghe/1ed276a84b59f56e1077bc159946c337

GitHub Gist: instantly share code, notes, and snippets.

11/01/2020

I am using XAMPP, version 3.2.1. I just installed it on Windows 8. Every time I need to go to the XAMPP Control Panel to start services (MySQL, Apache,...); in windows 7 it started automatically when

02/01/2020

I am using below code for html 5 camera access and uploading the image to server. HTML Code