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
)
