Cannot add template variables

Hello all,

I’ve installed ModX cms version 0.9.6.1B , everything worked well except when i tried to create a template variable i get the message "$rs not set! New variable not saved!"

what should I do ?

First thing you should do is help us help you by providing more information with which to diagnose your problem. This is described here.

First impression is that you have MySQL 5.0.x in with what is known as strict sql_modes on.

thanks, you nailed it there ... that was the problem

in the future posts, I will provide more infos concerning the problem

I had this same problem-- apparently I found this post a little late, because I have implemented a workaround that might be of use to someone:

Changed line 31 in manager/processors/save_tmplvars.processor.php to read:

$rank = (!empty($_POST[’rank’]))? mysql_escape_string($_POST[’rank’]) : 0;

Apparently though I need to change my PHP version. Best of luck.

It’s the MySQL version in question, not PHP, and just a mode change in the MySQL server, nothing else. This function not working in the strict SQL modes is a bug that needs fixing, so if you have a chance, feel free to visit the bug tracker to make sure it has been reported and is being taken care of.