I am user 1 - I have accepted the cookies but I can't log into the website at all. It might be the wrong JQuery version, too many scripts loading, or something else.

The popup works, but honestly I don't know if it is collecting cookies or turning off javascript.

I had another plug in (MyLiveChat), that I had to turn off to get this to work, but I never uninstalled it. That might also be interfering.

I can turn the status off in the DB, but the client really likes your plugin! I'm hoping you might be able to point me in the right direction before they need to update the content of the site.

Many thanks!

Comments

april26 created an issue. See original summary.

svenryen’s picture

svenryen commented

Hi! Thanks for writing in.

I haven't heard of cases where users are unable to log in before.
Are you able to run drush vget eu_cookie_compliance and share the setup here so that we can try to reproduce?

Let me know if you don't use drush, and I can tell you how to extract the info from the database instead.

april26’s picture

april26 commented

Thank you, I don't use Drush. Please let me know. I can see a table in the database for EU cookie compliance, with about 200 rows.

https://apollobrick.com

One interesting thing - the favicon and Page title is not showing in the browser tab?

The client reported this morning (I tested an enquiry form), that although they received the letter they didn't get any of the form information. Once I can log in, I will be able to see if the information was collected but not sent, or not collected.

svenryen’s picture

svenryen commented

So if you have access to the database, can you run this query?

select * from variable where name like 'eu_cookie%'.

It will return some rows, which may be barely readable, but don't worry, just paste them here, preferably into a code section.

april26’s picture

april26 commented

Thank you for your help. I ran the query and exported the results.

-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 19, 2021 at 06:35 PM
-- Server version: 10.3.28-MariaDB
-- PHP Version: 7.3.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--

-- --------------------------------------------------------

--
-- Table structure for table `variable`
--

CREATE TABLE `variable` (
  `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The name of the variable.',
  `value` longblob NOT NULL COMMENT 'The value of the variable.'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Named variable/value pairs created by Drupal core or any...';

--
-- Dumping data for table `variable`
--

INSERT INTO `variable` (`name`, `value`) VALUES
('eu_cookie_compliance', 0x613a35333a7b733a31333a22706f7075705f656e61626c6564223b693a313b733a363a226d6574686f64223b733a363a226f70745f696e223b733a31333a22696e666f5f74656d706c617465223b733a333a226e6577223b733a33303a22656e61626c655f736176655f707265666572656e6365735f627574746f6e223b693a313b733a32393a22736176655f707265666572656e6365735f627574746f6e5f6c6162656c223b733a31363a225361766520707265666572656e636573223b733a33343a226163636570745f616c6c5f63617465676f726965735f627574746f6e5f6c6162656c223b733a31383a2241636365707420616c6c20636f6f6b696573223b733a32303a2264697361626c65645f6a61766173637269707473223b733a303a22223b733a32353a226175746f6d617469635f636f6f6b6965735f72656d6f76616c223b693a313b733a31353a22616c6c6f7765645f636f6f6b696573223b733a303a22223b733a32323a22636f6e73656e745f73746f726167655f6d6574686f64223b733a353a226261736963223b733a32373a22706f7075705f636c69636b696e675f636f6e6669726d6174696f6e223b623a303b733a31303a22706f7075705f696e666f223b613a323a7b733a353a2276616c7565223b733a3238343a223c703e427920636c69636b696e67202241636365707420436f6f6b6965732220796f7520616772656520746f207468652073746f72696e67206f6620636f6f6b696573206f6e20796f75722064657669636520746f20656e68616e63652073697465206e617669676174696f6e2c20616e616c797365207369746520757361676520616e642061737369737420696e206f7572206d61726b6574696e67206566666f7274732e3c6272202f3e0d0a3c6272202f3e0d0a4d6f726520696e666f726d6174696f6e20726567617264696e67206f757220757365206f6620436f6f6b69657320697320617661696c61626c65206f6e206f7572205072697661637920506167652e3c2f703e0d0a0d0a3c703e266e6273703b3c2f703e0d0a223b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b7d733a31383a227573655f6d6f62696c655f6d657373616765223b693a303b733a31373a226d6f62696c655f706f7075705f696e666f223b613a323a7b733a353a2276616c7565223b733a3133363a223c68323e57652075736520636f6f6b696573206f6e2074686973207369746520746f20656e68616e636520796f7572207573657220657870657269656e63653c2f68323e0d0a0d0a3c703e42792074617070696e67207468652041636365707420627574746f6e2c20796f7520616772656520746f20757320646f696e6720736f2e3c2f703e0d0a223b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b7d733a31373a226d6f62696c655f627265616b706f696e74223b733a333a22373638223b733a32363a22706f7075705f61677265655f627574746f6e5f6d657373616765223b733a31343a2241636365707420636f6f6b696573223b733a32303a2273686f775f64697361677265655f627574746f6e223b623a313b733a32393a22706f7075705f64697361677265655f627574746f6e5f6d657373616765223b733a32313a22526576696577205072697661637920506f6c696379223b733a32313a2264697361677265655f627574746f6e5f6c6162656c223b733a31323a224465636c696e652020616c6c223b733a31363a2277697468647261775f656e61626c6564223b693a313b733a32393a2277697468647261775f627574746f6e5f6f6e5f696e666f5f706f707570223b693a303b733a31363a2277697468647261775f6d657373616765223b613a323a7b733a353a2276616c7565223b733a3236393a223c703e427920636c69636b696e67202241636365707420436f6f6b6965732220796f7520616772656520746f207468652073746f72696e67206f6620636f6f6b696573206f6e20796f75722064657669636520746f20656e68616e63652073697465206e617669676174696f6e2c20616e616c797365207369746520757361676520616e642061737369737420696e206f7572206d61726b6574696e67206566666f7274732e204d6f726520696e666f726d6174696f6e20726567617264696e67206f757220757365206f6620436f6f6b69657320697320617661696c61626c65206f6e206f7572205072697661637920506167652e3c2f703e0d0a0d0a3c703e266e6273703b3c2f703e0d0a223b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b7d733a32353a2277697468647261775f7461625f627574746f6e5f6c6162656c223b733a31363a22507269766163792073657474696e6773223b733a32383a2277697468647261775f616374696f6e5f627574746f6e5f6c6162656c223b733a31363a22576974686472617720636f6e73656e74223b733a32303a22706f7075705f6167726565645f656e61626c6564223b693a303b733a31373a22706f7075705f686964655f616772656564223b693a303b733a31323a22706f7075705f616772656564223b613a323a7b733a353a2276616c7565223b733a3131343a223c68323e5468616e6b20796f7520666f7220616363657074696e6720636f6f6b6965733c2f68323e0d0a0d0a3c703e596f752063616e206e6f7720686964652074686973206d657373616765206f722066696e64206f7574206d6f72652061626f757420636f6f6b6965732e3c2f703e0d0a223b733a363a22666f726d6174223b733a393a2266756c6c5f68746d6c223b7d733a33303a22706f7075705f66696e645f6d6f72655f627574746f6e5f6d657373616765223b733a393a224d6f726520696e666f223b733a32353a22706f7075705f686964655f627574746f6e5f6d657373616765223b733a343a2248696465223b733a31303a22706f7075705f6c696e6b223b733a373a226e6f64652f3435223b733a32313a22706f7075705f6c696e6b5f6e65775f77696e646f77223b693a313b733a32313a22636f6f6b69655f706f6c6963795f76657273696f6e223b733a353a22312e302e30223b733a31383a22636f6e7461696e696e675f656c656d656e74223b733a343a22626f6479223b733a31343a22706f7075705f706f736974696f6e223b623a303b733a31323a227573655f626172655f637373223b693a303b733a31343a22706f7075705f746578745f686578223b733a363a22666666666666223b733a31323a22706f7075705f62675f686578223b733a363a22303737396266223b733a31323a22706f7075705f686569676874223b733a303a22223b733a31313a22706f7075705f7769647468223b733a343a2231303025223b733a31383a2266697865645f746f705f706f736974696f6e223b693a313b733a31313a22706f7075705f64656c6179223b733a343a2231303030223b733a32363a2264697361677265655f646f5f6e6f745f73686f775f706f707570223b693a303b733a31313a2272656c6f61645f70616765223b693a303b733a32383a22706f7075705f7363726f6c6c696e675f636f6e6669726d6174696f6e223b623a303b733a31313a22636f6f6b69655f6e616d65223b733a303a22223b733a31343a22646f6d61696e735f6f7074696f6e223b733a313a2231223b733a31323a22646f6d61696e735f6c697374223b733a303a22223b733a31333a226578636c7564655f7061746873223b733a303a22223b733a31393a226578636c7564655f61646d696e5f7061676573223b693a303b733a31333a226578636c7564655f7569645f31223b693a303b733a31323a227363726970745f73636f7065223b733a363a22666f6f746572223b733a33333a226265747465725f737570706f72745f666f725f73637265656e5f72656164657273223b693a303b733a31343a22636f6f6b69655f73657373696f6e223b693a303b7d),
('eu_cookie_compliance_cookie_lifetime', 0x733a333a22313030223b),
('eu_cookie_compliance_domain', 0x733a303a22223b),
('eu_cookie_compliance_domain_all_sites', 0x693a303b);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `variable`
--
ALTER TABLE `variable`
  ADD PRIMARY KEY (`name`);
COMMIT;

/*!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 */;
april26’s picture

april26 commented

Here is just a clipboard copy of the four rows

 Showing rows 0 -  3 (4 total, Query took 0.0005 seconds.)

select * from variable where name like 'eu_cookie%'

name	value	
eu_cookie_compliance	
    [BLOB - 2.9 KiB]
	
eu_cookie_compliance_cookie_lifetime	
    [BLOB - 10 B]
	
eu_cookie_compliance_domain	
    [BLOB - 7 B]
	
eu_cookie_compliance_domain_all_sites	
    [BLOB - 4 B]
svenryen’s picture

svenryen commented

Thanks. I'll take a look.

april26’s picture

april26 commented

Hi Sven,

I turned the module off in the database, and was able to log in. JS aggregation wasn't on, and when I turned it on and switched the module back on it now works! So it was just JS aggregation causing the initial problem. Unfortunately with JS aggregation on, I don't know how to stop any JS scripts?

Under the settings:

1) I have left "allowed cookies" blank.
2) I have added the following under "Disable JS".
https://www.google-analytics.com/analytics.js

The site has two webforms. From what I can see, when I disable cookies as a user, the information isn't stored in the database? So this is already set?

svenryen’s picture

svenryen commented
Status: Active » Closed (works as designed)

That's good to hear you got the module working. I'll go ahead and close this issue then. Likely another Javascript was interfering.

As for storing consent details, kindly refer to the "Consent storage method" in the settings. "Basic storage" should be available for both Drupal 7 and 8. It will store records of consent to your database, if that's required by your legal advisor.

svenryen’s picture

svenryen commented

Just for the record, I reverted my local module to version 7.x-1.36 and imported the config given in this issue. Upon clearing all caches I had no problems logging in as admin using Bartik as my theme.