Mysql error while initial sql script setup.

gianlucagiacometti / roundcube-toolbox

Set of tools for Roundcube webmail

15 stars 10 forks source link

Mysql error while initial sql script setup. #3

Closed boriska2005 closed 4 years ago

boriska2005 commented 4 years ago

Hi,

i have folowing error while running initial script and don't understand how to resolve it : [ #mysql -u user roundcubemail < mysql.initial.sql ]

ERROR 1054 (42S22) at line 43: Unknown column 'toolbox_customise_domains.domain_name' in 'field list'

please help me.

Centos 7, mysql Ver 14.14 Distrib 5.7.31, for Linux (x86_64)

gianlucagiacometti commented 4 years ago

Confirmed. I'll have a look ASAP

gianlucagiacometti commented 4 years ago

I updated the sql file with the correct syntax. I guess you already have the 2 tables in the db, so just run the "create view" section (otherwise you will get an error for already existing tables).

gianlucagiacometti commented 4 years ago

Fixed via #13ea5d5

boriska2005 commented 4 years ago

Thank you for quick answer and quick resolve problem.