How to prevent child rows closing in Datatable when refreshing content using AJAX?

Last updated: 20210818

Follow this:

https://datatables.net/forums/discussion/53712/re-open-collapsed-child-rows-after-ajax-reload

 

then also..

Also make sure your Datatable during initialization, is not using RESPONSIVE for a smooth experience as it would cause some glitching.

$options[‘responsive’] = true; // will cause blinking glitches during ajax refresh of datatable content

How to adjust offsync SRT subtitle file timing?

1. determine if it’s a timescale difference, or a simple “timing” offsync. (here we talk about the more problematic timescale difference)
2. sync 1st line in SRT, to the video’s first line, save this new SRT as “VIDEONAME.srt”, take note of the time (FIRSTTIME)
3. find the last line in the SRT file, take note of the time. (LASTSRTTIME)
4. find the last line in the VIDEO, take note of the time as well. (LASTVIDEOTIME)
5. head to: https://subshifter.bitsnbites.eu/
6. use Linear correction
7. choose the “VIDEONAME.srt”
8. Time #1 = FIRSTTIME –> FIRSTTIME
9. Time #2 = LASTSRTTIME –> LASTVIDEOTIME
10. Hit Resync! that’s it!

How to fix or restore files lost due to corrupted partition, data disk failure or CHKDSK? Best harddisk recovery tool

Last updated: 20200216

Summary:

The best tool to restore and get all your files from the lost/corrupted partition is: EaseUS Data Recovery Wizard.

Period. It’s so good I even paid US$149 for a lifetime of upgrades. (NOTE: it’s for 1 computer only it seems, had difficulty running the software on another computer with the same license)

Disclaimer: This is NOT a paid article. I’m not affiliated even. I just need good tools to get back important data files, as that’s part of my work.

And you can use the Free version of course, but after I saw the files that it can restore, I knew I should support this software.

I’ve personally spent US thousands of dollars on lost data, and hiring experts to restore damaged HDD drives.

What it can do:

  1. Find missing files on a failed drive or lost partition.

  2. Restore lost partitions, names, files and even folders and structure!

There are about 4-5 other programs that I tried, and they are not even close. Some attempt to deep scan for 1 hour for my 256GB SSD drive, others can restore files but cannot get the names right.

Some can get files and names right, but it loses folder and path info, placing all files in 1 big folder – that’s really useless for me, my programs and work will not work.

How?

Make sure you do not write or force a CHKDSK on your drive when you see partition failure or missing files. You don’t want to risk overwriting any files.

If you are trying out various programs to restore files, choose to restore files TO ANOTHER DRIVE. It is very important to restore to ANOTHER DRIVE.

What happened?

So I have an SSD that suddenly started automatically running CHKDSK during a system restart.

And that was it, the files in the drive are no longer accessible and when accessing the drive from Windows File Explorer, it says:

X:\ is not accessible.

The disk structure is corrupted and unreadable.

 

Thank you so much Windows. So I had to research ways to fix it.

I googled and started trying:

  1. MiniTool Partition Wizard, and used Data Recovery.
  2. Recuva
  3. Stella

I must admit MiniTool Partition Wizard is a great software, if you want to copy, resize and upgrade your SSD or HDD drives. It is incredible for resizing! But when it came to data recovery, EaseUS Data Recovery Wizard is king.

MiniTool manage to list and restore all my files without their filenames.

Recuva managed to list and restore all my files, with their filenames, but without their folder structure -they were all in 1 large folder.

Stella took 1 hour and hung when trying to restore my SSD.

 

Let me know if my advice worked for you, or other tools you tried.

How to fix “Disc read error [5.0] ‘xxx .ff’ crash issue with Call of Duty: Modern Warfare 2019?

You need to reinstall the game. Simple as that BUT!

Yes, make sure you DO NOT PAUSE or INTERRUPT the installation throughout the 120GB install from Blizzard Battle.net.

If you do, you risk facing these errors anywhere along the game when you play it later.

How to fix “XXXXXXX can’t run on Windows” error for your Application?

After installing Cumulative update for your Windows 10, your program cannot start with the error message:

XXXXXX can’t run on Windows
Check for an updated version of this app that runs on Windows.
Compatibility Assistant
Check for updates – Dismiss

To bypass this problem and continue running the program:

  1. Download and run this tool:

    Compatibility Administrator (64-bit)

  2. Find the program that cannot run, then DISABLE the ENTRY that has: AppHelp – HARDBLOCK

  3. That’s it!

 

How to fix WordPress dashboard or login infinite redirect loop?

As of 20191003, you should be using PHP 7.1 and above for your WordPress websites.

However, some older plugins can cause your WordPress Dashboard or wp-login.php page to fail with an infinite redirect loop.

To diagnose, set ‘WP_DEBUG’ to true in your wp-config.php file, then attempt to login or visit your WordPress dashboard.

If it fails, head to your cPanel/WHM to change your PHP version for your website to 5.5, 5.6, 7.0, 7.2 and the likes.

While switching, you should be able to see error messages to help you diagnose the plugins that is causing the problem.

How to solve and fix “Invalid default value” MySQL error for dates and timestamp?

Last updated: 20211220

To avoid this issue, you need to remove NO_ZERO_DATE from the mysql mode configuration.

  1. Go to ‘phpmyadmin’. (in WHM not cPanel)
  2. Once phpmyadmin is loaded up, click on the ‘variables’ tab.
  3. Scroll down and search for ‘sql mode’.
  4. Click on the Edit option and remove NO_ZERO_DATE (and its trailing comma) from the configuration line.
  5. Save (hit ‘save’ on the left side) and that’s it!
  6. You will have to repeat this on every server upgrade/reboot of your MYSQL.

This is a very common issue in the local environment with wamp or xamp.

This will allow you to use default ” 0000-00-00 00:00:00″ as a timestamp value.

Reference:

https://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field

How to fix Composer not working on your cPanel/WHM server?

Composer not installing or working properly? Getting loads of error messages simply to run?

It looks something like this:

Fatal error: Uncaught Error: Call to undefined function Symfony\Polyfill\Mbstring\iconv() in phar:///opt/cpanel/composer/bin/composer/vendor/symfony/polyfill-mbstring/Mbstring.php:661
Stack trace:
#0 phar:///opt/cpanel/composer/bin/composer/vendor/symfony/polyfill-mbstring/bootstrap.php(48): Symfony\Polyfill\Mbstring\Mbstring::mb_strwidth(' [Composer\\Dow...', 'ASCII')
#1 phar:///opt/cpanel/composer/bin/composer/vendor/symfony/console/Helper/Helper.php(54): mb_strwidth(' [Composer\\Dow...', 'ASCII')
#2 phar:///opt/cpanel/composer/bin/composer/vendor/symfony/console/Application.php(654): Symfony\Component\Console\Helper\Helper::strlen(' [Composer\\Dow...')
#3 phar:///opt/cpanel/composer/bin/composer/vendor/symfony/console/Application.php(127): Symfony\Component\Console\Application->renderException(Object(Composer\Downloader\TransportException), Object(Symfony\Component\Console\Output\StreamOutput))
#4 phar:///opt/cpanel/composer/bin/composer/src/Composer/Console/Application.php(103): Symfony\Component\Console\Applicatio in phar:///opt/cpanel/composer/bin/composer/vendor/symfony/polyfill-mbstring/Mbstring.php on line 661
[aspapp@client-192-129-227-26 www]$ composer require maltyxx/restclient

 

1. Google the error message for more info: https://stackoverflow.com/questions/40800616/call-to-undefined-function-symfony-polyfill-mbstring-iconv-strlen
2. Install missing extensions: https://cyberpersons.com/2016/10/21/install-missing-php-extensions-cpanelwhm/
3. Then try again!