Installing and upgrading help

reserved word in fieldname ?

 
Picture of Julio Monetti
reserved word in fieldname ?
 


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.


 
Average of ratings: -
Picture of Howard Miller
Re: reserved word in fieldname ?
Core developersDocumentation writersParticularly helpful MoodlersPlugin developers

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

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

 
Average of ratings: -
Picture of Julio Monetti
Re: reserved word in fieldname ?
 

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  smile


Julio



 
Average of ratings: -
Picture of Ken Task
Re: reserved word in fieldname ?
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


 
Average of ratings: -
Picture of Julio Monetti
Re: reserved word in fieldname ?
 

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

your suggestion in moving to Centos 7   smile


Julio.

 
Average of ratings: -
Picture of Emma Richardson
Re: reserved word in fieldname ?
Documentation writersParticularly helpful Moodlers

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?

 
Average of ratings: -
Picture of Julio Monetti
Re: reserved word in fieldname ?
 


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.

 
Average of ratings: -
Picture of Emma Richardson
Re: reserved word in fieldname ?
Documentation writersParticularly helpful Moodlers

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.

 
Average of ratings: -
Picture of Julio Monetti
Re: reserved word in fieldname ?
 

Yes Emma.  (adjunt image)

 
Average of ratings: -
Picture of Emma Richardson
Re: reserved word in fieldname ?
Documentation writersParticularly helpful Moodlers

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.

 
Average of ratings: -
Picture of Ken Task
Re: reserved word in fieldname ?
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



 
Average of ratings: -