Hi Modxers!
I moved my site from my local server to a web server now and everything works except the
SMF brigde. When I try to synchronize users it gives out the following:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’-forum.smf_settings (variable,value) VALUES(’integrate_pre_include’,’/is/htdocs/’ at line 1 »
SQL: REPLACE INTO db100-forum.smf_settings (variable,value) VALUES(’integrate_pre_include’,’/is/htdocs/**here goes my secret path **/assets/modules/smforum/smf.integrate.inc.php’);
Take a look at the red text, it says "-forum". The whole name of the db is however db100-forum.
I have encountered this problem before, on my local machine. There I could change the database name (removing the "-") and then it suddenly worked. Now I’m on dedicated webspace and I cannot change the database name.
MySQL 4.1.15-Debian, PHP 5 latest update and ModX 0.95
Any ideas what is going wrong there?
Your help is desperately needed!
Konsum