installation error

zaire

I got the following error message:

Type: 256

Message: mysqlt error: [1074: Column length too big for column 'tpl' (max = 255); use BLOB or TEXT instead] in EXECUTE("CREATE TABLE recordbrowser_table_properties ( tab VARCHAR(64) NOT NULL, quickjump VARCHAR(64) DEFAULT '', tpl VARCHAR(256) DEFAULT '', favorites TINYINT DEFAULT 0, recent SMALLINT DEFAULT 0, full_history TINYINT DEFAULT 1, caption VARCHAR(32) DEFAULT '', icon VARCHAR(256) DEFAULT '', access_callback VARCHAR(128) DEFAULT '', data_process_method VARCHAR(256) DEFAULT '', PRIMARY KEY (tab) ) TYPE=InnoDB") 

File: /home/zaire/public_html/epesi/libs/adodb/adodb-errorhandler.inc.php

Line=77

error backtrace:

File: /home/zaire/public_html/epesi/include/error.php

    line 126

    function called: handle_error

[PHP core called function]

    function called: handle_epesi_error

File: /home/zaire/public_html/epesi/libs/adodb/adodb-errorhandler.inc.php

    line 77

    function called: trigger_error

File: /home/zaire/public_html/epesi/libs/adodb/adodb.inc.php

    line 916

    function called: ADODB_Error_Handler

File: /home/zaire/public_html/epesi/libs/adodb/adodb.inc.php

    line 891

    function called: _Execute

File: /home/zaire/public_html/epesi/libs/adodb/adodb-datadict.inc.php

    line 377

    function called: Execute

File: /home/zaire/public_html/epesi/include/database.php

    line 77

    function called: ExecuteSQLArray

File: /home/zaire/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowserInstall.php

    line 33

    function called: CreateTable

[PHP core called function]

    function called: install

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 500

    function called: call_user_func

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 191

    function called: install

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 484

    function called: satisfy_dependencies

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 191

    function called: install

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 484

    function called: satisfy_dependencies

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 191

    function called: install

File: /home/zaire/public_html/epesi/include/module_manager.php

    line 484

    function called: satisfy_dependencies

File: /home/zaire/public_html/epesi/modules/Base/Setup/Setup_0.php

    line 231

    function called: install

[PHP core called function]

    function called: validate

File: /home/zaire/public_html/epesi/modules/Libs/QuickForm/3.2.9/HTML/QuickForm.php

    line 1655

    function called: call_user_func

[PHP core called function]

    function called: process

File: /home/zaire/public_html/epesi/modules/Libs/QuickForm/QuickForm_0.php

    line 60

    function called: call_user_func_array

[PHP core called function]

    function called: __call

File: /home/zaire/public_html/epesi/modules/Base/Setup/Setup_0.php

    line 139

    function called: process

File: /home/zaire/public_html/epesi/modules/Base/Setup/Setup_0.php

    line 22

    function called: body

[PHP core called function]

    function called: admin

File: /home/zaire/public_html/epesi/include/module.php

    line 762

    function called: call_user_func_array

File: /home/zaire/public_html/epesi/include/module.php

    line 689

    function called: get_html_of_module

File: /home/zaire/public_html/epesi/include/module.php

    line 846

    function called: display_module

File: /home/zaire/public_html/epesi/modules/Base/Admin/Admin_0.php

    line 32

    function called: pack_module

[PHP core called function]

    function called: body

File: /home/zaire/public_html/epesi/include/module.php

    line 762

    function called: call_user_func_array

File: /home/zaire/public_html/epesi/include/module.php

    line 689

    function called: get_html_of_module

File: /home/zaire/public_html/epesi/modules/Base/Box/Box_0.php

    line 120

    function called: display_module

File: /home/zaire/public_html/epesi/include/epesi.php

    line 151

    function called: body

File: /home/zaire/public_html/epesi/include/epesi.php

    line 193

    function called: go

File: /home/zaire/public_html/epesi/process.php

    line 19

    function called: process

ethnar

Thank you for the report. Perhaps, as pointed out in error message, 255 would be more suitable value there. I'll make sure to include this fix in next release.
For now I can only advise you (assuming you are using ver 1.0.0rc1) to edit manually all the occurrences of 256 char long varchar types.
To do so, you'd need to edit following files:
Utils/Messenger/MessengerInstall.php, line 18
Utils/RecordBrowser/RecordBrowserCommon_0.php, lines 47, 58 and 71
Utils/RecordBrowser/RecordBrowserInstall.php, lines 25, 30 and 32
Utils/Tasks/TasksInstall.php, line 18

All you need to do is to change
C(256)
to
C(255)

Once again, thank you for sharing this information with us.

Kind regards,
Arek

zaire

OK, I changed 256 to 255 in several places as you described. The installation went smoothly; however, the RSS Feed applet doesn't work. It shows the following error message:

Fatal error: Class 'DOMDocument' not found in /web/zaire/www/admin/modules/Applets/RssFeed/rsslib.php on line 71

ethnar

I'm glad that one is solved.

To get past the next issue you mentioned, you will (most likely) need to install php-xml package on your system.

Hope this helps,
Arek

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge