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

Ubuntu 14 Install and Configure SSH

Ensure the OS is up to date.Install OpenSSH server on the OS.It's also a good idea to make a copy of the default SSH configuration, so that if you ever mess up your SSH settings you can revert to the original.That's all you need in order to get SSH working. You should now be able to use a program like Putty in order to connect to the remote OS...
Rate this blog entry:
Continue reading
461 Hits
0 Comments