StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>A few questions: </p> <ul> <li><em>What database backend is PDO using? MySQL? Other? If it's MySQL try the MySQL(i) adapter?</em> Data is being stored in <strong>MySQL</strong></li> <li>If you copy/paste the query (omitting the blob data for simplicity) does the query execute, or even get a more verbose error? Does it just work?</li> <li>Does the backend you're using support blob nicely? <strong>MySQL Does</strong></li> <li>Can you show the <code>SHOW CREATE TABLE</code> for your details table?</li> </ul> <p>I don't think the compression is the issue, it would have failed earlier, like around here: <a href="https://github.com/preinheimer/xhprof/blob/master/xhprof_lib/utils/xhprof_runs.php#L434" rel="nofollow">https://github.com/preinheimer/xhprof/blob/master/xhprof_lib/utils/xhprof_runs.php#L434</a></p> <p>Taking your updated <code>SHOW CREATE TABLE</code> and query, I get:</p> <pre><code>Database changed mysql> CREATE TABLE `details` ( -> `id` char(17) NOT NULL, -> `url` varchar(255) DEFAULT NULL, -> `c_url` varchar(255) DEFAULT NULL, -> `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -> `server name` varchar(64) DEFAULT NULL, -> `perfdata` mediumblob, -> `type` tinyint(4) DEFAULT NULL, -> `cookie` blob, -> `post` blob, -> `get` blob, -> `pmu` int(11) unsigned DEFAULT NULL, -> `wt` int(11) unsigned DEFAULT NULL, -> `cpu` int(11) unsigned DEFAULT NULL, -> `server_id` char(3) NOT NULL DEFAULT 't11', -> `aggregateCalls_include` varchar(255) DEFAULT NULL, -> PRIMARY KEY (`id`), -> KEY `url` (`url`), -> KEY `c_url` (`c_url`), -> KEY `cpu` (`cpu`), -> KEY `wt` (`wt`), -> KEY `pmu` (`pmu`), -> KEY `timestamp` (`timestamp`) -> ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO `details` (`id`, `url`, `c_url`, `timestamp`, `server name`, `perfdata`, `type`, `cookie`, `post`, `get`, `pmu`, `wt`, `cpu`, `server_id`, `aggregateCalls_include`) VALUES('5279085839571', '/whats-on/?', '/whats-on/?', FROM_UNIXTIME('1383663629'), 'local.mysitename', 'x^��\0\0�\0�', '1', 'a:1:{s:8:\"_profile\";s:1:\"1\";}', 'a:0:{}', 'a:0:{}', '', '', '', 'localhost', '') ; Query OK, 1 row affected, 4 warnings (0.00 sec) </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload