Error changing mySQL column
3 posts by 2 authors in: Forums > CMS Builder
Last Post: August 12, 2010 (RSS)
Hello,
I have a mySQL table which I have created through phpmyadmin, and have linked it manually to CMSB.
Doing so, all the fields in CMSB are type 'none' - so to make them viewable, I want to change their type, to textfield for example.
Works for most, but a few error with this:
"There was an error changing the MySQL column, the error was:
BLOB/TEXT column '[field name]' used in key specification without a key length"
I presume this has something to do with the field type in the mySQL after the phpmyadmin creation. That is fixed - i.e. I can't change the type within phpmyadmin, so is there a way to still make it display (ie give it a type) in CMSB?
Cheers!
I have a mySQL table which I have created through phpmyadmin, and have linked it manually to CMSB.
Doing so, all the fields in CMSB are type 'none' - so to make them viewable, I want to change their type, to textfield for example.
Works for most, but a few error with this:
"There was an error changing the MySQL column, the error was:
BLOB/TEXT column '[field name]' used in key specification without a key length"
I presume this has something to do with the field type in the mySQL after the phpmyadmin creation. That is fixed - i.e. I can't change the type within phpmyadmin, so is there a way to still make it display (ie give it a type) in CMSB?
Cheers!
Re: [rjbathgate] Error changing mySQL column
By Jason - August 12, 2010
Hi,
If you go into phpmyadmin and look at the table. What is the type of the field you're trying to change? What type of field do you want to make it in CMS Builder? CMS Builder doesn't use the type BLOB/TEXT for any of it's fields.
Try changing the data type in phpmyadmin to something like medium text and then try again.
Hope this helps.
If you go into phpmyadmin and look at the table. What is the type of the field you're trying to change? What type of field do you want to make it in CMS Builder? CMS Builder doesn't use the type BLOB/TEXT for any of it's fields.
Try changing the data type in phpmyadmin to something like medium text and then try again.
Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Error changing mySQL column
Hey,
It's field type VARCHAR - exactly the same as a few other fields which are usable within CMSB.
If I try and change it to anything in phpmyadmin, I got exactly the same error.
Collaciton, atrributes etc etc are all normal and same same as other workable fields. Same problem even after dumping contents of table.
The field was actually marked as a KEY (although not primary key). Althought removing this didn't make any difference either.
So, I just rebuilt the table from scratch, and now it works!
Odd, but fixed - solution, start again!
Cheers
It's field type VARCHAR - exactly the same as a few other fields which are usable within CMSB.
If I try and change it to anything in phpmyadmin, I got exactly the same error.
Collaciton, atrributes etc etc are all normal and same same as other workable fields. Same problem even after dumping contents of table.
The field was actually marked as a KEY (although not primary key). Althought removing this didn't make any difference either.
So, I just rebuilt the table from scratch, and now it works!
Odd, but fixed - solution, start again!
Cheers