sql type not recognized: 'int unsigned' when I expand

I prefer these integers be unsigned - is this a Dreamweaver bug? I'm don't have
that much expertise in MySQL, so do you know if it is unusual to use an
unsigned integer with auto-increment for a primary key? I'm baffled that I seem
to be one of very few having this problem.

Thanks

Yes it is a bug.

http://www.adobe.com/cfusion/mmform/index.cfm?name=wishform

I can't speak for anybody but I stooped using unsigned integers as primary keys when DW started hiccupping on them.

--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com


"Bagger Vance" <webforumsuser RemoveThis @macromedia.com> wrote in message news:f1l5q4$lij$1@forums.macromedia.com...
>I prefer these integers be unsigned - is this a Dreamweaver bug? I'm don't have
> that much expertise in MySQL, so do you know if it is unusual to use an
> unsigned integer with auto-increment for a primary key? I'm baffled that I seem
> to be one of very few having this problem.
>
> Thanks
>

Thanks for the info. I'll definitely fill out the request form.

Hi Bagger and Ken

With some help from Randy Edmunds at Adobe was able to find a solution to
this bug.
*note I am still using DW MX 2004 so there may be some variation with your
version.

ANSWER: You need to add the sql type "int unsigned" to the
[b]dwscriptsServer.js[/b] in Dreamweavers files.

The file to ammend is [your path to the DW
root]\Configuration\Shared\Common\Scripts\[b]dwscriptsServer.js[/b]
do a search for the alert: "MM.MSG_SQLTypeAsNumNotInMap" and then go up from
there (it is about line 2059 in the DW MX 2004 file).
underneath a["unsignedint"] = 19;
add a new line a["int unsigned"] = 19; // variation of unsigned int

I then deleted the delete the FileCache.dat (from step #4
http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_19105) and
restarted DW.

That should fix it!

If that doesn't work then search the DW folders for
"MM.MSG_SQLTypeAsNumNotInMap" and ammend the sql data types where the functions
raise the error alert.

I hope this is helpful!

Cheers
Martin

ps I would be using the CS3 web premium suite if it wasn't for the fact that
the UK upgrade price is (£539) - >US$1000 which is more then double what US
customers pay. (OK my whinge over, boo hoo)

Thanks for working on this. When I try to save the dwscriptsServer.js file
after making the changes, I get the message:

Access to C:\Program Files\Adobe\Dreamweaver CS3\Adobe Dreamweaver
CS3\configuration\Shared\Common\Scripts\dwscriptsServer.js was denied.

Is there a way around this?

Thanks -Bagger

Bagger

I just opened up my file in my favourite editor .... oh that'd be Dreamweaver
and saved it from there without any problems.
Sounds like your files might be "read only" - so just change them to modify or
read & write (In Windows - right click on the file, select properties, security
tab and click the edit button).
If you can't edit it, open up DW or notepad, cut and paste the entire contents
from dwscriptsServer.js into a new file, make your changes and then save the
files as, you guessed it: dwscriptsServer.js in another directory
(if using notepad make sure the file type is set to "Save as Type: All files"
so you don't get dwscriptsServer.js.txt)
Delete the original dwscriptsServer.js and put your revised copy in it's
place, then follow my instructions as before.

I recently upgraded to Dreamweaver CS4 and noticed that this bug still hasn't
been fixed (disappointing!).
My instructions above still seem to work only with the amendment that when you
delete the FileCache.dat the location for that file in Windows Vista is
C:\Users\[username]\AppData\Roaming\Adobe\Dreamweaver CS4\en_US\Configuration\
and is called something like WinFileCache-3012BA81.dat (it will be the only one
there).

BTW - I really love all the new features in CS4. Very glad to see Subversion
and Live View in Dreamweaver, however the properties panel doesn't seem to show
things like the link box reliably(?).
I will try and post the link to this post to Adobe in the hope that this int
unsigned doesn't appear in future editions.

Cheers to all.
Marty