Buy Now
Sign in

mysql3 support

dwikristianto , June 06 2007
D
dwikristianto
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
D
dwikristianto
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
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
admin
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
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
D
dwikristianto
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
admin
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
Max
If your main question got answered then please mark the answer using the button!​
​Please let us know if you have any problems with the new forums text editor, we appreciate your feedback!
D
dwikristianto
no problemo.
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much