Skip to content

Instantly share code, notes, and snippets.

View NeilHanlon's full-sized avatar

Neil Hanlon NeilHanlon

72 followers · 30 following
View GitHub Profile
@NeilHanlon
NeilHanlon / gist:6eb41dc90138380faaa6
Created April 30, 2014 15:47
140430 11:25:16 InnoDB: Error: table 'venomgfx_venom/wp_users'
InnoDB: in InnoDB data dictionary has tablespace id 80889,
InnoDB: but the tablespace with that id has name ./venomgfx_venom_bak/wp_users.ibd.
InnoDB: Have you deleted or moved .ibd files?
InnoDB: Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
140430 11:25:16 InnoDB: Waiting for the background threads to start
InnoDB: Dump of the child page:
140430 11:25:16 InnoDB: Page dump in ascii and hex (16384 bytes):
@NeilHanlon
NeilHanlon / gist:892182a4517f420d7fb9
Created April 30, 2014 16:08
root@xo2 [/var/log]# ps aux | grep mysql
root 124288 0.0 0.0 106200 1512 pts/24 S+ 12:04 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 124549 1.2 1.3 1292772 220564 pts/24 Sl+ 12:04 0:03 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xo2.x10hosting.com.err --open-files-limit=50000 --pid-file=xo2.x10hosting.com.pid
root 144705 0.0 0.0 103252 864 pts/15 S+ 12:08 0:00 grep mysql
@NeilHanlon
NeilHanlon / gist:6bf80bc7ad82ec1ba712
Created April 30, 2014 22:10
mysqlcheck: Got error: 1102: Incorrect database name '' when executing 'CHECK TABLE ... '
@NeilHanlon
NeilHanlon / gist:22044267d93e9d3822ae
Created May 1, 2014 15:54
[2014-05-01 11:53:57 -0400] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request error: namespace=[Cpanel] module=[park] function=[ADD]: set error in context park: statusmsg=[Ran adminbin Cpanel/park/ADD] at /usr/local/cpanel/Cpanel/Wrap.pm line 118
Cpanel::Wrap::send_cpwrapd_request('namespace', 'Cpanel', 'module', 'park', 'function', 'ADD', 'data', 'lsgamers.org.uk ', 'action', 'run', 'env', HASH(0x53c2360)) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 104
Cpanel::AdminBin::adminrun('park', 'ADD', 'lsgamers.org.uk', undef) called at /usr/local/cpanel/Cpanel/Park.pm line 249
Cpanel::Park::_park('LSGamers.org.uk') called at /usr/local/cpanel/Cpanel/Park.pm line 202
Cpanel::Park::Park_park('LSGamers.org.uk') called at (eval 67) line 1
eval 'Cpanel::Park::Park_park(@{$argref});' called at cpanel line 1641
main::_api1('Park', 'park', 'park($RAW_FORM{\'domain\'})', 'park', ARRAY(0x7f3f29752340), 'safe_html_encode', undef, undef) called at cpanel line 1572
@NeilHanlon
NeilHanlon / gist:f70c53b1ad1fdce2cb6f
Created May 14, 2014 23:44
Chain INPUT (policy DROP)
target prot opt source destination
acctboth all -- 0.0.0.0/0 0.0.0.0/0
ACCEPT tcp -- 8.8.4.4 0.0.0.0/0 tcp dpt:53
ACCEPT udp -- 8.8.4.4 0.0.0.0/0 udp dpt:53
ACCEPT tcp -- 8.8.4.4 0.0.0.0/0 tcp spt:53
ACCEPT udp -- 8.8.4.4 0.0.0.0/0 udp spt:53
ACCEPT tcp -- 8.8.8.8 0.0.0.0/0 tcp dpt:53
ACCEPT udp -- 8.8.8.8 0.0.0.0/0 udp dpt:53
ACCEPT tcp -- 8.8.8.8 0.0.0.0/0 tcp spt:53
@NeilHanlon
NeilHanlon / gist:5af73aecd4a96fc6c840
Last active August 29, 2015 14:01
Chain INPUT (policy DROP)
target prot opt source destination
acctboth all -- 0.0.0.0/0 0.0.0.0/0
ACCEPT tcp -- 8.8.4.4 0.0.0.0/0 tcp dpt:53
ACCEPT udp -- 8.8.4.4 0.0.0.0/0 udp dpt:53
ACCEPT tcp -- 8.8.4.4 0.0.0.0/0 tcp spt:53
ACCEPT udp -- 8.8.4.4 0.0.0.0/0 udp spt:53
ACCEPT tcp -- 8.8.8.8 0.0.0.0/0 tcp dpt:53
ACCEPT udp -- 8.8.8.8 0.0.0.0/0 udp dpt:53
ACCEPT tcp -- 8.8.8.8 0.0.0.0/0 tcp spt:53
@NeilHanlon
NeilHanlon / gist:3c8b0eeeb01b99845719
Created June 26, 2014 18:15
2014-06-26 14:07:04.945 [INFO] Failed to open file [/tmp/lshttpd/swap/0/3/c5c83cb20bc6618d24d84dd0bc0889.lsz], error: No such file or directory
@NeilHanlon
NeilHanlon / sadf.js
Created July 2, 2014 16:47
$('button[name=save]').click(function () {
$('div[data-item_id]').each(function () {
form = $(this).find('form');
$.ajax({
'url': form.attr('action'),
'type': 'post',
'dataType': 'json',
'data': form.serialize(),
'statusCode': {
200: function (res) {
@NeilHanlon
NeilHanlon / gist:f416a7a1b1e9c8a003b3
Created July 3, 2014 15:17
delimiter $$
CREATE DEFINER=`jridley_admin`@`localhost` PROCEDURE jrridley_circlenew.`GetPostList`()
BEGIN
drop temporary table if exists jrridley_circlenew.tmpPosts;
drop temporary table if exists jrridley_circlenew.pIDs;
create temporary table jrridley_circlenew.pIDs(post_id int);
create temporary table jrridley_circlenew.tmpPosts(post_id int, group_id int, parent_id int, root_id int, author varchar(100), title varchar(100), content varchar(255), create_date timestamp);
Insert into jrridley_circlenew.pIDs(post_id) select root_id from jrridley_circlenew.post where root_id > 0 group by root_id order by count(root_id) DESC, create_date;
Insert into jrridley_circlenew.tmpPosts(post_id, group_id, parent_id, root_id, author, title, content, create_date)
@NeilHanlon
NeilHanlon / gist:b5d77f25f58d90c96c98
Created July 3, 2014 15:46
select root_id from jrridley_circlenew.post where root_id > 0 group by root_id order by count(root_id) DESC, create_date AS a INNER JOIN
(select p.post_id, group_id, parent_id, root_id, concat(u.first_name, ' ' , u.last_name), p.title, content, create_date from jrridley_circlenew.post p inner join jrridley_circlenew.users u on p.user_id = u.user_id)as b on a.post_id = b.post_id;