This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
January 17, 2011 4:33pm
Subscribe [4]#1 / Jan 17, 2011 4:33pm
I’m running EE v1.7.0 build 20101018 with the current version of a 4-site MSM.
When I was running EE v1.6.9, the MSM worked fine. When I upgraded to v1.7.0, I now get the following error when editing or publishing to any site other than the main site:
A Database Error Occurred
Error Number: 1064
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 ‘’ at line 3
SELECT weblog_id FROM exp_weblogs WHERE
#2 / Jan 18, 2011 7:44am
Hi, Doug. Did you also upgrade the MSM files?
Are you using any sort of third party add-ons?
#3 / Jan 18, 2011 10:02am
Hey Sue!
I did download the current version of MSM just to make sure.
I’m using Solspace’s Calendar module, the Low NoSpam module and the Title Image module.
#4 / Jan 18, 2011 10:00pm
Did you replace any of the index.php files for the additional sites? Are you using an admin.php file or the like?
#5 / Jan 23, 2011 11:07am
I have index.php, admin.php and path.php in each site directory.
#6 / Jan 24, 2011 3:42am
DougH,
Can you update any of your Solspace add-ons. I know there was previous issues when they were not the most current of versions.
#7 / Jan 24, 2011 6:24pm
That seemed to have fixed it, John.
I was running Calendar v1.5.0 and their module was up to 1.5.3.
Thanks!
#8 / Jan 25, 2011 3:52pm
Excellent! Please don’t hesitate to post again as needed.