mysql3 support

dear all,

what about add mysql3 support?
i still use mysql3 for development at my own computer, because it's easier to deploy and recreate the installer.

best regards,
dwi

The current version of MySQL is 5.0 (with 6.0 in alpha). I've never found it too difficult to install or upgrade (on Windows XP in my case).

Bob

hi greyhead,

i dont have that problem either, but my customers does, that's why i still use mysql3.

for now, i just hack it in the administrator directory.

the questions is,
is it possible to select the database version in the chronoform configs ?


TIA,
dwi

Hi,

What are you trying to do? ChronoForms only uses the Joomla! database. Is there something that doesn't work under later versions? Or do you need to export the data?

Bob

Hi Dwi,

Yes I have the same question here like Bob, what are you using exactly ? if Joomla works fine with you then why Chronoforms won't ? if its installed on joomla then it should be fine, OR do you someway use it on a different system ?

Cheers

Max

hi max+bob,

thanks for the fast responses.

here is snippets from admin.chronocontact.php (approximate line number 375) taken from administrator/components/com_chronocontact folder.

	if ( count($chrono_fields) > 0){
		$table_sql = "CREATE TABLE `#__chronoforms_".$id."` (";
		$table_sql .= $table_sql_body ." , PRIMARY KEY ( `cf_id` )";
		$table_sql .= "«») TYPE = MYISAM ;";
	}

take a look at

$table_sql .= "«») TYPE = MYISAM ;";

that's my edited version that run smooth on mysql3.

the error show up when i try to create a table according to a form that i've entered at chronoform.


if i'm not wrong the previous code is

$table_sql .= "«») ENGINE = MYISAM ;";

btw, it just suggestion to make chronoform more flexible.
again, thx for the responses.

regards,
dwi

Thanks Dwi, I will look at this issue and see if there is any multi plathform solution, if not then we will add this to next release!!

Thanks

Max

no problemo.

In the MySQL 5.0 manual ENGINE or TYPE are both accepted though ENGINE is preferred (I'd guess that's to distinguish it from column type).

Bob