reserved word in fieldname ?

reserved word in fieldname ?

由Julio Monetti發表於
Number of replies: 10


Hello,


I'm trying to install version 3.4. 


The database creation script says

     CREATE TABLE mdl_chat_messages (
      id BIGINT(10) NOT NULL auto_increment,
      chatid BIGINT(10) NOT NULL DEFAULT 0,
      userid BIGINT(10) NOT NULL DEFAULT 0,
      groupid BIGINT(10) NOT NULL DEFAULT 0,
       system TINYINT(1) NOT NULL DEFAULT 0,  <========


In my (mysql / mariadb) "system" is  a

reserved word.


Of course: the database creation stop at

this point.


Could you please help me with this issue ?


Julio.


評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Howard Miller發表於
Core developers的相片 Documentation writers的相片 Particularly helpful Moodlers的相片 Peer reviewers的相片 Plugin developers的相片

It shouldn't matter... can we get some more info?

What operating system, database server is this and how are you installing Moodle?

評比平均分數： -
In reply to Howard Miller

Re: reserved word in fieldname ?

由Julio Monetti發表於

Howard,


Thank you very much for responding.  More info:

OS:  Fedora 26

Mysql: Ver 8.0.3-rc for Linux on x86_64 (MySQL Community Server (GPL))

Moodle:  3.4  (eng)

php: PHP 7.1.11 (cli)


I'm installing the server from   http://192.168.1.10/moodle  (from the same

lan network).   (is it what you ask ?)


Can I send you any other information ?


Thank you again for responding  微笑


Julio



評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Ken Task發表於
Particularly helpful Moodlers的相片

As one who learned Linux on the RH family systems and have used Fedora in the past, Fedora isn't long term support - shelf life only two years?  

I'd consider it RH Family (Fedora) 'experimental' as evident in the version of MySQL you have ... an 'rc' is a 'release candidate'.  I have moved away from Fedora because I grew tried of having to backup moodle implementation, archive that backup, wipe out the Fedora X completely and then grabbing the latest supported version of Fedora only have to repeat the entire process in 2 years.  While I learned a lot, decided it best for a production Moodle to be on something long term support.

Suggest using CentOS 7 (that's based on RH Enterprise and is long term support) ... if you want to stay with RH 'family' or Ubuntu 16.04 which is also LTS.

However, should you desire to continue, investigate your RC version of MySQL for 'sql-mode' ... which, if set to ANSI, should alllow you to install 3.4 - in other words, use reserved words as column names in DB's.

If you do continue with what you have, just remember you might run into other issues and due the OS itself, since many in these forums use LTS Linuxes,   answers may not be forthcoming easily. ;)

My 2 'sense', of course! ;)

'spirit of sharing', Ken


評比平均分數： -
In reply to Ken Task

Re: reserved word in fieldname ?

由Julio Monetti發表於

Thank you Ken.  As I am just installing/starting my arquitecture, i'll follow

your suggestion in moving to Centos 7   微笑


Julio.

評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Emma Richardson發表於
Documentation writers的相片 Particularly helpful Moodlers的相片 Plugin developers的相片

Created just fine in mysql for me.  What database are you using?  Do you perhaps have a custom setting on your database server causing this?

評比平均分數： -
In reply to Emma Richardson

Re: reserved word in fieldname ?

由Julio Monetti發表於


database name:  moodle


> Do you perhaps have a custom setting on your database server causing this?

hmmm.. I don't think so.  The database was just created for the installer.

I've not configured anything in the mysql engine from it was installed.


I simplyfied the "experiment".  I create a simple table to verify

    create table A(

        system int

   )


...And got the same error.  So:  Can you (anybody else) ensure the

field name is "system",  and mysql accept it as field name ?



Julio.

評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Emma Richardson發表於
Documentation writers的相片 Particularly helpful Moodlers的相片 Plugin developers的相片

I notice you are using mysql 8?  But the latest version I see is 5.7.  So, are you sure you are using mysql and not some other database engine?

Also, you note an rc version of mysql - perhaps that is the issue.

評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Emma Richardson發表於
Documentation writers的相片 Particularly helpful Moodlers的相片 Plugin developers的相片

Mine was a fresh install with 5.7 and the field with the 'system' name is present.

If this is perhaps a sign of things to come, devs probably need to be aware so that they can adjust their naming scheme.

評比平均分數： -
In reply to Julio Monetti

Re: reserved word in fieldname ?

由Ken Task發表於
Particularly helpful Moodlers的相片

From where did you acquire the code?   And are you, by chance, installing a dev version?

Look at your version.php file in the moodle code.

Reason asked: in a git installed stock 3.4, inspecting that table shows a 'system' but installed with no issues.

'spirit of sharing', Ken



評比平均分數： -