| Author |
 Topic  |
|
|
andrewctskidmore
Starting Member
1 Posts |
 Posted - 12 December 2005 : 10:56:53
|
I get the folloing message when moving a topic from one forum to another.
It only happens with this one particular topic.
-----------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.
/forum/post_info.asp, line 562
------------------------------------------------
Any ideas please.
Many thanks
Andrew |
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 12 December 2005 : 14:13:35
|
Weird, indeed. What SQL Server version are you using? Also, any changes to the Snitz code and / or DB structure.
Finally, any reason for you to use the ODBC connection string instead of the OLEDB provider? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 09 February 2008 : 14:24:53
|
has there been a fix for this I am getting a error message the same
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-log]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 'll kick off. Boff looking to start a team or join a team. I'm not bothered who ' at line 1
/post_info.asp, line 646
Its strange because I have put in the edit error a long while ago in post.asp, but a small number of my members still cannot edit their posts, when I attempt to move the same members posts I as admin can't because of the above error, I am unsure if it is related but the only posts I can't move (and get this error) are the members who still cant edit their own posts.
|
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 09 February 2008 : 14:32:46
|
| OOps just when doing a forum search this post came up and I have just saw this is MS sql, I am using mysql not sure if this is posted in the right place now. I will leave it a day or so and post again in bugs forum |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 09 February 2008 : 15:29:52
|
| Try again as a fresh topic under the MySQL section, people tend to have DB specialisms! |
|
|
| |
Topic |
|
Topic Locked
