back to phpList.org

Problem with creating new tables on new 3.4.5 install

Greetings programs, I am installing a new copy of phplist 3.4.5 on AWS lightsail Ubuntu 18.04 server using a AWS database (8.0.11). Everything is connected ok, but when the install routines runs to create tables 2 of them are giving errors… (See below.) I presuming these are important as I am getting plenty of warnings about unable to upgrade and blank database versions.

These are the only errors I am getting during the install, so i am wondering if there are some fixes about, I downloaded the .tar.gz from source forge (I think, its been a busy day)

Thanks for any help in advance, I did have a poke around on the forum, but cannot see anything about this.

Leyton.

Creating tables

Initialising table attribute … ok
Initialising table user_attribute … ok
Initialising table user … ok
Initialising table user_history … ok
Initialising table list … ok
Initialising table listuser … ok
Initialising table message … ok
Initialising table messagedata … ok
Initialising table listmessage … ok
Initialising table user_blacklist … ok
Initialising table user_blacklist_data … ok
Initialising table message_attachment … ok
Initialising table attachment … ok
Initialising table usermessage … ok
Initialising table user_message_view … ok
Initialising table sendprocess … ok
Initialising table template … ok
Initialising table templateimage … ok
Initialising table bounce … ok
Initialising table user_message_bounce … ok
Initialising table user_message_forward … ok
Initialising table config … ok
Initialising table admin … ok
Initialising table adminattribute … ok
Initialising table admin_attribute … ok
Initialising table admin_password_request

Database error 1064 while doing query 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 ‘admin integer,key_value varchar (32) not null ) default character set utf8’ at line 2

… failed
Initialising table subscribepage … ok
Initialising table subscribepage_data … ok
Initialising table eventlog … ok
Initialising table urlcache … ok
Initialising table linktrack … ok
Initialising table linktrack_ml … ok
Initialising table linktrack_uml_click … ok
Initialising table linktrack_forward … ok
Initialising table linktrack_userclick … ok
Initialising table userstats … ok
Initialising table bounceregex

Database error 1064 while doing query 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 ‘admin integer,comment text,status varchar(255),count integer default 0,unique re’ at line 2

… failed
Initialising table bounceregex_bounce … ok
Initialising table admintoken … ok
Initialising table i18n … ok

Just FYI, the problem is both of the tables use a field called admin, it is a restricted word in MySQL 8.0.11 - looks like it wont be in 8.0.12 In the mean time I backticked the field name and the install completed, everything seems to work fine. Not sure if there will be issues later on…

Leyton.