Db error after upgrade
- cspgsl
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 0
- Karma: 2
Add-ons
Add-ons
14 years 11 months ago #99120
by cspgsl
Db error after upgrade was created by cspgsl
Getting the following error when upgrading to 1.0.1 -- Not being a Db guy it is Greek to me (no offense Nick)
CBSQLupgrader::changeColumn (CHANGE `avatar`) of Table #__comprofiler Column avatar failed with SQL error: BLOB/TEXT column 'avatar' used in key specification without a key length SQL=ALTER TABLE `jos_comprofiler` CHANGE `avatar` `avatar` text
ALTER TABLE `#__comprofiler` CHANGE `avatar` `avatar` text
Thanks in advance
CBSQLupgrader::changeColumn (CHANGE `avatar`) of Table #__comprofiler Column avatar failed with SQL error: BLOB/TEXT column 'avatar' used in key specification without a key length SQL=ALTER TABLE `jos_comprofiler` CHANGE `avatar` `avatar` text
ALTER TABLE `#__comprofiler` CHANGE `avatar` `avatar` text
Thanks in advance
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68482
- Thanks: 9076
- Karma: 1434
14 years 10 months ago #99344
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Re:Db error after upgrade
Error appears to be un-related to CBSubs. There's a problem with your Avatar field, please run CB Tools.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.237 seconds
-
You are here:
- Home
- Forums
- Archive
- CBSubs
- Maybe a problem with 1.0.1?
- Db error after upgrade