Forums

Hi, Been using CF for quite a while now, great product does exactly what it says once you get the hang of it!! One query, I have some old tables that I no longer need - what is the best/simplest way to delete them please? This is purely a 'housekeeping' exercise.

Hi glarkin,
You could either use the Tables Manager in recent versions of ChronoForms, or your favourite DB tool (such as phpmysql or similar).

/Fredrik

Hi Fredrik Many thanks, any problems upgrading to newer version with table manager that you know of??? Cheers G

Hi glarkin,
That depends on which version you are currently running, and how advanced your forms are. There are a few (or more) threads regarding upgrading different versions of CF on the forum. Let me know if you have some trouble finding them, or need further advice. Please include any information regarding version of both Joomla and currently installed CF, as well as details if your forms use any php and/or javascripts.

/Fredrik

thanks, I'll check it out and get back to you if any further probs. cheers G

Hi Fredrik

I'm using version 3.0 [ I think!!] is upgrade to latest version straight forward??

Thanks G

Hi glarkin,
Unfortunately, upgrading from 3.0 Stable to 3.1RC5.5 is not straightforward. Bob wrote a good upgrade-howto some time ago here: http://www.chronoengine.com/forums/index.php?option=com_chronoforums&cont=posts&f=5&t=16539

What you need to keep in mind, that if you've added some advanced php-code, such as the FAQ#31 "email selector", the code to interact with ChronoForms has changed, and your old code will most certainly not work properly.
It's advisable to do the form-upgrading on a temporary or development-site, and wait with the live upgrade until you've got your new forms working properly.

/Fredrik

Hi Fredrik

OK mate, that's good info and one to ponder on. Going back to my original problem of removing unwanted tables, I would also like to change the field size in one of my existing tables from 255 characters to something greater. I've looked at phpmysql but I fear a little beyond me! any bright ideas?? cheers G

Hi glarkin,
Well, there are plenty of different SQL tools. PhpMyAdmin is one rather common, so that's the one I'm used to. Unfortunately, I can't recommend any particular other tool. Having a basic understanding of SQL and database structures does help with most of the tools though.

Changing the field size:
VARCHAR is pretty much capped at 255. A better type is TEXT, as this has no fixed length. There are several different kinds of TEXT types however, each with different max-size. These range from:

TINYTEXT   - 255
TEXT       - 65,535
MEDIUMTEXT - 16,777,215
LONGTEXT   - 4,294,967,295

For most cases, TEXT works well enough.

/Fredrik

excellent, as ever some good info and more homework for me!!! Great stuff many thanks G