Something to keep in mind is that when run locally, SSI Web studies store their data in an SQLite database. It appears that on your remote server, however, the data is stored in a MySQL database. The syntax is mostly the same, but there are some differences.
I have, on occasion, found that the SQL statements I rely on in MySQL don't function in a SQLite environment. Are you writing any of your own SQL for this free format question?