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.

@LeytonC Wow great catch. Sounds like back ticks should be added to the initialisation scripts to avoid this error? If so, please could you report the bug on the issue tracker so it can be assigned and fixed in a future release? Or better yet, submit a PR yourself :wink: