- If you removed the prefix from the screenshot, I can only guess the error as it's not very clearly displayed there. MySQL tables with MyISAM engine have a limit of 64 kbytes per row, including varchars. When using InnoDB engine, it's 8 KB, but not including all varchars. So maybe by just changing the engine for jos_comprofiler you can get rid of that limit, even in MySQL 5.0, without changing hosting.
I have attached the screenshot with the prefix shown. Any new information can be inferred?
How can the engine for jos_comprofiler be changed?
Anyway, I am moving away from Godaddy hosting. I will be purchasing Joomlapolis! hosting soon. So when I migrate to Joomlapolis! server with MySQL 5.5, the problem will be automatically rectified, right? Or do I have to change the engine also?
I look forward to detailed instructions so that I can move my site without any problems to Joomlapolis! hosting ASAP.
How can the engine for jos_comprofiler be changed?
Within phpmyadmin navigate to the _comprofiler table then click "Operations" on the top menu bar. You should find "Storage Engine" there, which will let you change the storage engine to InnoDB for example.
Anyway, I am moving away from Godaddy hosting. I will be purchasing Joomlapolis! hosting soon. So when I migrate to Joomlapolis! server with MySQL 5.5, the problem will be automatically rectified, right? Or do I have to change the engine also?
If you want to change to InnoDB then you'll need to do that before or after exporting and importing your database as it won't be done automatically.
I look forward to detailed instructions so that I can move my site without any problems to Joomlapolis! hosting ASAP.
Download your entire file structure of your site. Now compress it in a ZIP. Once you've JP hosting upload it using Virtualmin and use the Extract feature to uncompress your entire site automatically to your web root. Now navigate to Install Scripts and install phpmyadmin. Now import your database back in. Next edit your configuration.php to update the database connection information (username, password, host, etc..) to the new hosting database. You should be moved over just fine at this point.
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.
The following user(s) said Thank You: interspaceintel
For moving your site you could also use Akeebabackup.
But please remove the compressed site file once move is done, as it will take weight for nothing in your backups.
I changed the engine of jos_comprofiler to InnoDB. Even then, the same error occurs. But the fact is that now the error occurs for other new field types too! Not just Web Address.
I changed back to MyISAM for testing, and now also no new field (any type) can be created!
Have you changed hosts or are you still on GoDaddy? What is the error when trying to create a new fieldtype? Same as before? You only other solution is to change varchar columns to text to provide more column space if you're having column size limit issues.
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.
beat
