PDOStatement: SUPER privilege?

by jernst, Thursday, August 07, 2014, 19:41 (3901 days ago) @ jernst

Turns out I only get this message on the very first access of the new install with a browser. As soon as I hit refresh, the front page shows as if nothing had ever happened.

I decided to switch on the MySQL query log. It appears that on the first HTTP GET, these two statements are executed:

140807 17:34:59 1809 Connect CN0BmDJEQRRQkElB@localhost as anonymous on ghtqrcnshudgzeyu
1809 Query SET NAMES utf8
1809 Query SHOW TABLES
1809 Query CREATE TABLE items (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
datetime DATETIME NOT NULL ,
title TEXT NOT NULL ,
content LONGTEXT NOT NULL ,
thumbnail TEXT ,
icon TEXT ,
unread BOOL NOT NULL ,
starred BOOL NOT NULL ,
source INT NOT NULL ,
uid VARCHAR(255) NOT NULL,
link TEXT NOT NULL,
updatetime DATETIME NOT NULL,
INDEX (source)
) ENGINE = MYISAM DEFAULT CHARSET=utf8
140807 17:35:00 1809 Query CREATE TRIGGER insert_updatetime_trigger
BEFORE INSERT ON items FOR EACH ROW
BEGIN
SET NEW.updatetime = NOW();
END
1809 Quit

while on the second HTTP GET, tables sources, version, tags are created. So chances are that Selfoss on MySQL (actually MariaDB in my case) aren't seeing eye to eye on the CREATE TRIGGER statement. Indeed, SHOW TRIGGERS does not show anything.