Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jason Crouse

    (@coolmann)

    Are you using a caching plugin?

    Thread Starter PyroSteveJr

    (@pyrostevejr)

    No. I have disabled and removed all caching.

    So I found the problem is when the database are being created. I tried to do it manually by installing on localhost, then exporting, then importing to live site.

    -- phpMyAdmin SQL Dump
    -- version 3.5.1
    -- https://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Apr 15, 2014 at 03:33 PM
    -- Server version: 5.5.24-log
    -- PHP Version: 5.3.13
    
    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";
    
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;
    
    --
    -- Database: <code>transquility</code>
    --
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>qlugklsx27_slim_browsers</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>qlugklsx27_slim_browsers</code> (
      <code>browser_id</code> smallint(5) unsigned NOT NULL AUTO_INCREMENT,
      <code>browser</code> varchar(40) DEFAULT '',
      <code>version</code> varchar(15) DEFAULT '',
      <code>platform</code> varchar(15) DEFAULT '',
      <code>css_version</code> varchar(5) DEFAULT '',
      <code>type</code> tinyint(3) unsigned DEFAULT '0',
      <code>user_agent</code> varchar(2048) DEFAULT '',
      PRIMARY KEY (<code>browser_id</code>),
      UNIQUE KEY <code>unique_browser</code> (<code>browser</code>,<code>version</code>,<code>platform</code>,<code>css_version</code>,<code>type</code>)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>qlugklsx27_slim_content_info</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>qlugklsx27_slim_content_info</code> (
      <code>content_info_id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>content_type</code> varchar(64) DEFAULT '',
      <code>category</code> varchar(256) DEFAULT '',
      <code>author</code> varchar(64) DEFAULT '',
      <code>content_id</code> bigint(20) unsigned DEFAULT '0',
      PRIMARY KEY (<code>content_info_id</code>),
      UNIQUE KEY <code>unique_content_info</code> (<code>content_type</code>(20),<code>category</code>(20),<code>author</code>(20),<code>content_id</code>)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>qlugklsx27_slim_outbound</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>qlugklsx27_slim_outbound</code> (
      <code>outbound_id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>outbound_domain</code> varchar(255) DEFAULT '',
      <code>outbound_resource</code> varchar(2048) DEFAULT '',
      <code>type</code> tinyint(3) unsigned DEFAULT '0',
      <code>notes</code> varchar(512) DEFAULT '',
      <code>position</code> varchar(32) DEFAULT '',
      <code>id</code> int(10) unsigned NOT NULL DEFAULT '0',
      <code>dt</code> int(10) unsigned DEFAULT '0',
      PRIMARY KEY (<code>outbound_id</code>),
      KEY <code>fk_qlugklsx27_id</code> (<code>id</code>),
      KEY <code>odt_idx</code> (<code>dt</code>)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>qlugklsx27_slim_screenres</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>qlugklsx27_slim_screenres</code> (
      <code>screenres_id</code> mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
      <code>resolution</code> varchar(12) DEFAULT '',
      <code>colordepth</code> varchar(5) DEFAULT '',
      <code>antialias</code> tinyint(1) DEFAULT '0',
      PRIMARY KEY (<code>screenres_id</code>),
      UNIQUE KEY <code>unique_screenres</code> (<code>resolution</code>,<code>colordepth</code>,<code>antialias</code>)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table <code>qlugklsx27_slim_stats</code>
    --
    
    CREATE TABLE IF NOT EXISTS <code>qlugklsx27_slim_stats</code> (
      <code>id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,
      <code>ip</code> int(10) unsigned DEFAULT '0',
      <code>other_ip</code> int(10) unsigned DEFAULT '0',
      <code>user</code> varchar(255) DEFAULT '',
      <code>language</code> varchar(5) DEFAULT '',
      <code>country</code> varchar(16) DEFAULT '',
      <code>domain</code> varchar(255) DEFAULT '',
      <code>referer</code> varchar(2048) DEFAULT '',
      <code>searchterms</code> varchar(2048) DEFAULT '',
      <code>resource</code> varchar(2048) DEFAULT '',
      <code>browser_id</code> smallint(5) unsigned NOT NULL DEFAULT '0',
      <code>screenres_id</code> mediumint(8) unsigned NOT NULL DEFAULT '0',
      <code>content_info_id</code> int(10) unsigned NOT NULL DEFAULT '1',
      <code>plugins</code> varchar(255) DEFAULT '',
      <code>notes</code> varchar(2048) DEFAULT '',
      <code>visit_id</code> int(10) unsigned NOT NULL DEFAULT '0',
      <code>dt</code> int(10) unsigned DEFAULT '0',
      PRIMARY KEY (<code>id</code>),
      KEY <code>fk_qlugklsx27_browser_id</code> (<code>browser_id</code>),
      KEY <code>fk_qlugklsx27_content_info_id</code> (<code>content_info_id</code>),
      KEY <code>dt_idx</code> (<code>dt</code>)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    
    --
    -- Constraints for dumped tables
    --
    
    --
    -- Constraints for table <code>qlugklsx27_slim_outbound</code>
    --
    ALTER TABLE <code>qlugklsx27_slim_outbound</code>
      ADD CONSTRAINT <code>fk_qlugklsx27_id</code> FOREIGN KEY (<code>id</code>) REFERENCES <code>qlugklsx27_slim_stats</code> (<code>id</code>) ON DELETE CASCADE ON UPDATE CASCADE;
    
    --
    -- Constraints for table <code>qlugklsx27_slim_stats</code>
    --
    ALTER TABLE <code>qlugklsx27_slim_stats</code>
      ADD CONSTRAINT <code>fk_qlugklsx27_browser_id</code> FOREIGN KEY (<code>browser_id</code>) REFERENCES <code>qlugklsx27_slim_browsers</code> (<code>browser_id</code>),
      ADD CONSTRAINT <code>fk_qlugklsx27_content_info_id</code> FOREIGN KEY (<code>content_info_id</code>) REFERENCES <code>qlugklsx27_slim_content_info</code> (<code>content_info_id</code>);
    
    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

    It dies when tries to create qlugklsx27_slim_stats table and only message I get is “#1005 – Can’t create table ‘bugma001_wpmain.qlugklsx27_slim_stats’ (errno: -1) (Details…) ”

    Plugin Author Jason Crouse

    (@coolmann)

    We’re working on streamlining this process. If you would like to test version 3.6.1 in advance, shoot us a message at

    https://support.getused.to.it/

    Plugin Author Jason Crouse

    (@coolmann)

    Problem solved ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Not capturing anything!’ is closed to new replies.