So... there are some MSSQL Bugs

[Garrett M.]

I know I've only submitted my issues with MSSQL in the past day or two, but I've noticed some bugs that have gone unfiled for more than a month... some surprisingly show-stopping bugs. I figured I'll provide a summary to see if I can poke someone to try and get this stuff fixed.

This example prevents me from assigning templates to the articles system because of what user Matt (FDNZ) says is a database ID issue. I also can't edit the default article templates because the system reports that there aren't any. adding custom templates doesn't fix this, either.



This, in turn, prevents me from changing the templates in the article system.



There's also a different bug report that prevents me from adding pages at all.





There is also a problem with sorting by custom fields, and filtering by custom fields, preventing any type of sorting outside of the date-specific ones.





Any chance these can get looked at and fixed soon? IP.Content on MSSQL is basically unusable with these bugs in the way. =/

[Robulosity2]

You know, generally it helps if you post the content from the error it self (the logged query, or trace the query on SQL itself)

[Garrett M.]

The links in my first post link to several of the actual errors.

[Mat Barrie]

I know I've only submitted my issues with MSSQL in the past day or two, but I've noticed some bugs that have gone unfiled for more than a month... some surprisingly show-stopping bugs. I figured I'll provide a summary to see if I can poke someone to try and get this stuff fixed.

This [url="http://community.invisionpower.com/tracker/issue-23583-ipcontent-2-next-to-impossible-to-get-articles-to-work/"]example[/url] prevents me from assigning templates to the articles system because of what user Matt (FDNZ) says is a database ID issue. I also can't edit the default article templates because the system reports that there aren't any. adding custom templates doesn't fix this, either.

This, in turn, prevents me from changing the templates in the article system.

Don't get me started on the articles system. Seriously.

There's also a [url="http://community.invisionpower.com/tracker/issue-24074-mssql-cannot-create-pages-at-all/"]different bug report[/url] that prevents me from adding pages at all.

This one's not too hard to fix. Open Management Studio, browse to your IPB database, then in the CCS_FOLDERS table change the data type of the column FOLDER_PATH to VARCHAR(MAX).

There is also a [url="http://community.invisionpower.com/tracker/issue-24389-mssql-custom-article-field-driver-error/"]problem[/url] with sorting by custom fields, and filtering by custom fields, preventing any type of sorting outside of the date-specific ones.

Any chance these can get looked at and fixed soon? IP.Content on MSSQL is basically unusable with these bugs in the way. =/

Hmmph. More TEXT fields. I said I had some harassment to do, didn't I?

[Matt]

Worth noting that we no longer use "text" fields in new installations. They will be completely phased out over time. I'll take a look at the MSSQL reports today.