I'm not able to install erpal.
After selecting the installation method (no matter if i select quick or demo installation) I get following error:
SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
When I reload the site the error is gone and I can continue, but I get the next error after entering the site information:
Fatal error: Call to undefined function field_attach_load() in /Applications/XAMPP/xamppfiles/htdocs/erpal_quick/includes/entity.inc on line 316
I have no chance to continue.
System environment:
XAMPP for Mac (Version 1.8.3, PHP 5.5.15)
max execution time: 3000
memory limit: 1024M
allow packet size: 40M
Comments
Comment #1
n0103 commentedFixed it by increasing innodb_log_file_size to 128M and adding innodb_file_per_table in SQL config file. Additionally I deleted the files ib_logilfe0 and ib_logilfe0.
Have a look at http://drupal.stackexchange.com/questions/47908/pdoexception-sqlstate420... for further information.
Comment #2
agnosticdev commentedYes, I just updated my XAMPP install today too and had to add the following to the MySQL config file, my.ini.
innodb_log_file_size = 128M
innodb_file_per_table
innodb_file_format = Barracuda
This seemed to fix the issue.
Here is a good post on this issue: http://dba.stackexchange.com/questions/6598/innodb-create-table-error-ro...
Comment #3
Abhishek Verma commentedHi @agnosticdev,
Thank you for the post. It worked like charm.
I am facing this issues with backup and migrate module, while restoring from development server to production server.