Pixel 2

Advanced Search

Theme installation creates driverExeption

Permalink Browser Info Environment
When i try to install the theme i get the error message below.

What should I do to try and debug this ?
- Thanks in advance

Doctrine\DBAL\Exception\DriverException thrown with message "An exception occurred while executing 'INSERT INTO btCoreConversation (bID, cnvID, enablePosting, paginate, itemsPerPage, displayMode, orderBy, enableOrdering, enableCommentRating, enableTopCommentReviews, displaySocialLinks, reviewAggregateAttributeKey, displayPostingForm, addMessageLabel, dateFormat, customDateFormat) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [183, "5", "1", "1", "50", "threaded", "date_asc", 0, "1", 0, "1", "", "top", "Add Message", "default", ""]:
SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'reviewAggregateAttributeKey' at row 1"
Stacktrace:
#45 Doctrine\DBAL\Exception\DriverException in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
#44 Doctrine\DBAL\Driver\AbstractMySQLDriver:convertException in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:128
#43 Doctrine\DBAL\DBALException:driverExceptionDuringQuery in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1015
#42 Doctrine\DBAL\Driver\PDOException in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107
#41 PDOException in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#40 PDOStatement:execute in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105
#39 Doctrine\DBAL\Driver\PDOStatement:execute in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1008
#38 Doctrine\DBAL\Connection:executeUpdate in /data/WWW/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:714
#37 Doctrine\DBAL\Connection:insert in /data/WWW/concrete/src/Database/Connection/Connection.php:308
#36 Concrete\Core\Database\Connection\Connection:replace in /data/WWW/concrete/src/Legacy/Model.php:65
#35 Concrete\Core\Legacy\Model:Replace in /data/WWW/concrete/src/Block/BlockController.php:194
#34 Concrete\Core\Block\BlockController:performSave in /data/WWW/concrete/src/Block/BlockController.php:210
Viewing 15 lines of 49 lines. View entire code block.
Type: Ticket
Status: Archived
2rDK
View Replies:
shahroq replied on at Permalink Reply
shahroq
Hi,
Plz check this topic:
https://www.concrete5.org/marketplace/themes/pixel/support/error-on-...
2rDK replied on at Permalink Reply
2rDK
Thanks for your reply.

Changed the sql-mode in my.conf* and restarted the mysql service.

I now have the following environmental info:
# concrete5 Version
Core Version - 8.5.2
Version Installed - 8.5.2
Database Version - 20190925072210
# Database Information
Version: 5.7.28
SQL Mode: STRICT_ALL_TABLES
# concrete5 Packages
Pixel Theme (2.3.0)
...


I then uninstalled the theme, reinstalled with content, but i get the same error.


* had to do it in my.conf, as it doesnt persist after restart if i do it using phpmyadmin
shahroq replied on at Permalink Reply
shahroq
Fixed?
2rDK replied on at Permalink Reply
2rDK
Unfortunatly not.
2rDK replied on at Permalink Reply
2rDK
Wait a second....

I tried to uninstall the theme again, but this time i chose to delete the installation files (send to trash).

I reinstalled but now i have a new sql error:

Doctrine\DBAL\Exception\SyntaxErrorException thrown with message "An exception occurred while executing 'select cID from Pages where cParentID in () and cInheritPermissionsFromCID = ':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and cInheritPermissionsFromCID =' at line 1"
shahroq replied on at Permalink Reply
shahroq
I recommend installing a fresh instance of C5 and the theme. If it didn't work out, send me your site/host credentials via private msg and I will look into it.
Cheers,
2rDK replied on at Permalink Reply
2rDK
Ok, I'll try and revert with results :+1:
2rDK replied on at Permalink Reply
2rDK
So far i did the following:

* Kept the sql-mode setting to STRICT_ALL_TABLES
* Deleted all site files and dropped the database to start over
* Reinstalled WITHOUT content
* Tried to install the theme
got an:
Error Call to a member function getPageTemplateID() on null


Guessed this perhaps was due to som issue with the template missing some content it tries to remove in the process.

* deleted the site and database again
* reinstalled site WITH content
* Tried to install the theme again

Back to the original problem:
An exception occurred while executing 'INSERT INTO btCoreConversation (bID, cnvID, enablePosting, paginate, itemsPerPage, displayMode, orderBy, enableOrdering, enableCommentRating, enableTopCommentReviews, displaySocialLinks, reviewAggregateAttributeKey, displayPostingForm, addMessageLabel, dateFormat, customDateFormat) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [183, "5", "1", "1", "50", "threaded", "date_asc", 0, "1", 0, "1", "", "top", "Add Message", "default", ""]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'reviewAggregateAttributeKey' at row 1


# Database Information
Version: 5.7.28
SQL Mode: STRICT_ALL_TABLES


Is it an compability issue with my mysql version ?

I'll send you some credentials
shahroq replied on at Permalink Reply
shahroq
Sorry for the inconvenience. Plz send me your site credentials and I look into it.
2rDK replied on at Permalink Reply
2rDK
You should have received them in a PM now.
lemminger replied on at Permalink Reply
lemminger
deleted
nishiaraimasterz replied on at Permalink Reply
nishiaraimasterz
Hello Ladies and Gents,
I've been also suffering the same trouble with same (really same!) error message.

I am looking forward to hear you soon, and hope to solve it!
2rDK replied on at Permalink Reply
2rDK
A solution is not found yet.

But I've tried a lot of PHP/MySQL combinations with the same outcome.

But it seems the problem is that when the demo-content of the theme installs, It causes the installation to crash and leaves many of the demo-pages broken and page types blank.

So far I've made two observations:

Method 1
1. Install theme and let it crash.
2. Uninstall theme
3. Install theme WITHOUT content
-> successful install

This leaves you with some demo-content but all the page types are blank. It is also not possible to add new pages. No good.

Method 2
1. Reinstall a clean FULL site (default content)
2. Install theme WITHOUT content
-> Successful install

This gives you a site where page types works, new pages can be added and the theme seems to work. Unfortunately there is no demo-content to figure out which blocks go where.
JeffPaetkau replied on at Permalink Reply
JeffPaetkau
I'm having the same issue. Method 2 "works" with the same results. :(
shahroq replied on at Permalink Reply
shahroq
Plz, use the latest version of the theme, 2.4.0. And it would be best if the theme installed on top of a c5 instance with core sample content.
ConcreteCMS replied on at Permalink Reply
ConcreteCMS
Attention: Since there has been no activity on this issue for two weeks, this issue has been automatically archived.

To re-open this issue, reply to this message.

concrete5 Environment Information

# concrete5 Version
Core Version - 8.5.2
Version Installed - 8.5.2
Database Version - 20190925072210

# Database Information
Version: 5.7.28
SQL Mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

# concrete5 Packages
Pixel Theme (2.3.0)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
nginx/1.17.5

# Server API
fpm-fcgi

# PHP Version
7.1.33

# PHP Extensions
cgi-fcgi, Core, ctype, curl, date, dom, fileinfo, filter, ftp, gd, hash, iconv, json, libxml, mbstring, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, posix, readline, Reflection, session, SimpleXML, SPL, sqlite3, standard, tokenizer, xml, xmlreader, xmlwriter, zip, zlib

# PHP Settings
max_execution_time - 900
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.97 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.