|
Rank: Newbie Groups: Member
Joined: 12/23/2007 Posts: 4 Points: 0 Location: Toronto
|
For some reason, I can edit all tables except one. Whenever I try to display a specific table, I get a mock error window. -- myLittleAdmin Error Dialog Box .Net SqlClient Data Provider The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Close -- It doesn't seem serious, and it only gives me the option to close it, but when I do, another pops up in it's place, making it impossible to see or edit that table. Is there a way to disable these non-essential error dialogs? Thanks in advance. Michael michael@maumedia.com
|
|
![](/yafnet/resource.ashx?u=2) Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Thanks to tell us the structure of this table so that we can test it.
|
|
Rank: Newbie Groups: Member
Joined: 12/23/2007 Posts: 4 Points: 0 Location: Toronto
|
id - PK, int, not null brief - ntext, null date - nvarchar(50), not null location - nvarchar(50), not null title - nvarchar(200), not null year - smallint, not null
Not a complicated table by any measure. And, oddly, I was using a version of MyLittleAdmin on 1and1.com, and it didn't mind the table at all.
Now I'm using MyLittleAdmin on Liquidweb.com, and it's giving me hassles.
Sorry for the delay, so few hours in the day =(
Michael
|
|
![](/yafnet/resource.ashx?u=2) Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
I just created the table. I get no error at all and am able to manipulate the data and the structure.
Which version of myLittleAdmin are you using ?
|
|
Rank: Newbie Groups: Member
Joined: 12/23/2007 Posts: 4 Points: 0 Location: Toronto
|
3.1e lite edition
release: 0026
build: 2694
Thanks for looking into this, Ellan
|
|
![](/yafnet/resource.ashx?u=2) Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
Hi- I just tested it with myLittleAdmin Lite v3.1g and v3.2a and i did not get any error. You should try to update your install to the latest available version.
Thanks
|
|
Guest |