PhpMyAdmin Invalid Column Count in CSV input on line 1

If you are receiving this error while tryng to import a CSV file, make sure that the number of columns in your CSV matches that of your existing database table.I had an existing table with 10 columns, the first column was `id` an auto-increment field. I omitted this from my CSV file presuming it would be auto geberated but it's not.number of c...
Rate this blog entry:
Continue reading
9 Hits
0 Comments

Google In-Page Analytics Not Working

I find this Chrome plugin very useful. However recently it stopped working, the solution (always works for me) appears to be;​open Chromemanage extensionsdisable In-Page Analyticsre-enable In-Page Analyticsreload page (Ctrl+F5)Hope this helps!
Rate this blog entry:
Continue reading
39 Hits
0 Comments

Tsohost UK Web Host Review & Promo Discount Code

I recently moved hosts from SiteGround to Tsohost, mainly because my SiteGround renewal was coming in at far too much money for what I was receiving in my opinion. My first year was approximately £90, whereas my second year was approximately double this at £180 - for no extra services. I began my hunt for an alternative provider... enter ...
Rate this blog entry:
Continue reading
43 Hits
0 Comments

REGEX PostgreSQL Replace

​Working with MARC format, remove pipes and letters.Before;|aShakespeare, William,|d1564-1616.Regex;REGEXP_REPLACE(|aShakespeare, William,|d1564-1616.,'\|.',' ','g')After;Shakespeare, William, 1564-1616.
Rate this blog entry:
Continue reading
299 Hits
0 Comments

Ubuntu Remotely Connect to MySQL Database

In order to remotely access a MySQL database in Ubuntu it's necessary to edit the following file; /etc/mysql/my.cnf Find the following line; bind-address = 127.0.0.1 Comment it out, and change it to the following; #bind-address = 127.0.0.1 bind-address = 0.0.0.0 You then need to restart the MySQL service using the...
Rate this blog entry:
Continue reading
248 Hits
0 Comments

PHP 7.1 with Win 10, XAMPP & SQLSRV Driver

​If you're trying to use XAMPP on Windows and connect to a SQL server using PHP, hopefully the following will help.Firstly download XAMPP for Windows (32 bit). Follower the installer, default options.Then download the Microsoft Drivers 4.3 for PHP for SQL Server.  Extract the contents of this download to your PHP extensions directory...
Rate this blog entry:
Continue reading
2409 Hits
0 Comments