Forum Problems Installing LAMS: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: Re: new error

By: Fiona Malikoff

[ Reply | Forward ]

If you want to check what the values really are in the database try this (replacing the path with your path to mysql, and the "use moodle" statement to "use <databasename>" if Moodle uses a different database).

I did this in a cmd window. You can do the same sql statement (select name, concat('\'',value,'\'') from mdl_config where name like 'lamstwo%';) in any database client - just make sure you keep all the quotes intact.

C:\>"c:\program files\xampp\mysql\bin\mysql" -ulams2 -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 793
Server version: 5.0.33 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use moodle;
Database changed

mysql> select name, concat('\'',value,'\'') from mdl_config
    -> where name like 'lamstwo%';
+-----------------------+------------------------------+
| name                  | concat('\'',value,'\'')      |
+-----------------------+------------------------------+
| lamstwo_requestsource | 'Moodle'                    |
| lamstwo_serverid      | 'moodle'                    |
| lamstwo_serverkey    | 'moodle'                    |
| lamstwo_serverurl    | 'http://localhost:8080/lams' |
+-----------------------+------------------------------+
4 rows in set (0.00 sec)

mysql>exit

If you see any extra spaces within the quotes, then you have a problem!

Fiona

Posted by Fiona Malikoff