Lim
|
| Posted: 11/01/2004, 2:31 PM |
|
I have been developing web based applications using CodeCharge Studio, PHP 4 & MySQL 4.0.1 for some time.
The latest releases of PHP and MySQL seems to not work with older scripts. Is CodeCharge Studio compatible with these latest versions?
If not, when will we see the compatible version of CodeCharge?
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 11/01/2004, 4:10 PM |
|
It is compatible.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
BlakeSeven
|
| Posted: 11/02/2004, 11:45 AM |
|
Quote peterr:
It is compatible.
Maybe you should elaborate on this.
Is CCS able to authenticate with the new authentication in MySQL 4.1 or do you have to configure mysql to use the old password scheme?
Does CCS use the updated PHP mysqli extension to connect and manage MySQL 4.1 or does it still use the older mysql extension?
|
|
|
|
RonB
Posts: 228
|
| Posted: 11/10/2004, 5:23 AM |
|
I'm very interested to hear the answer to this one as well. We are setting up a test enviroment for php5 and mysql 5 and I would like to know if I can install the new mysqli extension.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/10/2004, 12:26 PM |
|
Hi,
"Is CCS able to authenticate with ..."
Yes, with anything, since CCS only uses the ODBC driver and doesn't know which database is being used, or which version. You could create own database with own ODBC driver and it should work as well. We see users using some databases that we've never heard of.
"Does CCS use the updated PHP mysqli extension"
The generated PHP doesn't use MySQLi. Therefore:
a) PHP generated by CCS 2.3 should work with any database (including MySQL 4.1 and databases we never heard of) via ODBC, though again, with the appropriate driver.
b) PHP generated by CCS 2.3 should work directly with MySQL 4.1 if you set it up to use the old authentication scheme.
c) Next version of CCS should generated PHP that works directly with MySQL 4.1 via mysqli.
d) You can contact the product support to report any problems with any popular database. We want to support all of them and will resolve any issues that you find, including the possibility of sending you any necessary fixes for the current CCS version.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
BlakeSeven
|
| Posted: 11/12/2004, 2:30 PM |
|
Quote peterr:
c) Next version of CCS should generated PHP that works directly with MySQL 4.1 via mysqli.
Aww, yeah. Thanks Peter
|
|
|
|
martin K
|
| Posted: 11/12/2004, 11:55 PM |
|
Hello.
This works fine for me.
Apache/2.0.52 (Win32) mod_ssl/2.0.52 OpenSSL/0.9.7d PHP/5.0.1 MySQL 4.0.20a. phpMyAdmin 2.6.0-pl1
Download:
http://www.apachefriends.org/en/
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/28/2004, 2:33 PM |
|
Hello,
For those upgrading to MySQL 4.1, please refer to the following new knowledge base article:
http://support.yessoftware.com/kb_article.asp?article_id=75
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DaaNtje
|
| Posted: 11/30/2004, 3:36 PM |
|
Well, I just went from PHP4 to PHP5 and well, guess what I am having alot! of troubles 
For example GD2 doesnt work anymoer *I do have the extension *uncommented* and I don't get any error while booting apache*
and the worst part is, that I cant seem to get the mysql extension to work!
extension=php_mysql.dll
is set in php.ini but it just does not work and keeps giving me this error
Fatal error: Call to undefined function mysql_connect() in E:\WWW\marjolijn\includes\include_class_db.php on line 18
or
Fatal error: Call to undefined function mysql_query() in E:\WWW\marjolijn\includes\include_class_db.php on line 59
So does any1have an answer for this? on how to fix it?
thanks in advance
|
|
|
|
klwillis
Posts: 428
|
| Posted: 11/30/2004, 6:31 PM |
|
PHP5 is expecting a different version of MySQL - one with
the correct (C-API) calling interface.
I would suggest "downgrading" to PHP4 if you can, until
someone has clearly documented which versions of MySQL
work with PHP5, and on what platforms.
Quote DaaNtje:
Well, I just went from PHP4 to PHP5 and well, guess what I am having alot! of troubles
For example GD2 doesnt work anymoer *I do have the extension *uncommented* and I don't get any error while booting apache*
and the worst part is, that I cant seem to get the mysql extension to work!
extension=php_mysql.dll
is set in php.ini but it just does not work and keeps giving me this error
Fatal error: Call to undefined function mysql_connect() in E:\WWW\marjolijn\includes\include_class_db.php on line 18
or
Fatal error: Call to undefined function mysql_query() in E:\WWW\marjolijn\includes\include_class_db.php on line 59
So does any1have an answer for this? on how to fix it?
thanks in advance
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
Lim
|
| Posted: 12/01/2004, 6:02 PM |
|
I am currently using PHP 5.0.2 with MySQL 4.0.22 with no problems.
I use the PHP/MySQL development package from this website:
http://www.wampserver.com/en/index.php
|
|
|
|
BlakeSeven
|
| Posted: 12/08/2004, 9:05 AM |
|
Quote peterr:
Great work Peter! Thanks
|
|
|
|
bigy
|
| Posted: 12/09/2004, 1:19 PM |
|
Quote :For those upgrading to MySQL 4.1, please refer to the following new knowledge base article:
Unfortunately, it doesn't work. I use PHP4 and MySQL 4.1.
As soon as I changed the "Php Database Library" to "MySQLi", it happens this:
What is "informix"?? and why does it chang from MySQL to informix??
THX
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/09/2004, 1:36 PM |
|
Please do not open the Connection dialog after performing the steps described in the article. Informix is a database and is shown there because MySQLi is not included in CCS 2.3. Thus if you open this dialog and click "OK" then you will need to again repeat the steps described in the article.
If you experience technical issues please contact product support.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
RonB
Posts: 228
|
| Posted: 12/18/2004, 2:42 AM |
|
re:DaaNtje
I have php5 and myslq 5 running fine with CCS.
PHP5 differs from earlier versions when setting up. You should not upgrade an older version of php but do a new install. Follow the install notes exactly. Move all the php extensions dll to the apache directory and make sure the php dll's are there as well.
See this for more help:
http://www.notestips.com/80256B3A007F2692/1/TAIO-64MEGD
|
|
|
|
Paul Robinson
|
| Posted: 12/20/2004, 1:32 PM |
|
Have installed PHP 5.03 and MySQL 4.1.8 on Fedora Core 2. Installed PHP from archive from php.net and MySQL from RPMS from mysql.com. Had difficulty installing PHP but after a few tries was able to come up with the correct configuration. Beware if you previously had PHP 4.x installed you will need to manually clean up the php.conf file in the /etc/httpd/conf.d directory. Also make sure NOT to install MySQL-shared-compat.x.RPM it will cause client authentiction problems with MySQL servers hosted on a different server. PHP5 can be compiled with both mysql and mysqli functionality so it is possible to run projects that are connectiong to a MySQL server version less than 4.0 using the mysql functions as well as a 4.0 server using mysqli.
Eight existing codecharge projects have been migrated, without a single issue, following the instructions from the knowledge base on installing the mysqli library into your codecharge studio project. I have also run these projects without any modifications using the standard mysql library.
This allows me to maintain existing projects where my client doesn't want to upgrade, as well as developing new projects without concerns of incompatibility. Way to Go YesSoftware and Code Charge Studio!!!
|
|
|
|
klwillis
Posts: 428
|
| Posted: 12/21/2004, 12:40 PM |
|
I would like to know the steps you took to get the new versions
of PHP and MySQL installed correctly on your Fedora Core 2 server.
I have a Fedora Core 1 server I'd like to upgrade PHP on.
I was able to get MySQL 4.1.7-Max installed from a binary distribution,
and it works fine with PHP 4.3.4.
Upgrading to PHP 5.0.3 is something I've held off doing due to
lack of clear instructions.
Any help you can provide would be appreciated. :)
Kevin Willis
klwillis.dsl@verizon.net
Quote Paul Robinson:
Have installed PHP 5.03 and MySQL 4.1.8 on Fedora Core 2. Installed PHP from archive from php.net and MySQL from RPMS from mysql.com. Had difficulty installing PHP but after a few tries was able to come up with the correct configuration. Beware if you previously had PHP 4.x installed you will need to manually clean up the php.conf file in the /etc/httpd/conf.d directory. Also make sure NOT to install MySQL-shared-compat.x.RPM it will cause client authentiction problems with MySQL servers hosted on a different server. PHP5 can be compiled with both mysql and mysqli functionality so it is possible to run projects that are connectiong to a MySQL server version less than 4.0 using the mysql functions as well as a 4.0 server using mysqli.
Eight existing codecharge projects have been migrated, without a single issue, following the instructions from the knowledge base on installing the mysqli library into your codecharge studio project. I have also run these projects without any modifications using the standard mysql library.
This allows me to maintain existing projects where my client doesn't want to upgrade, as well as developing new projects without concerns of incompatibility. Way to Go YesSoftware and Code Charge Studio!!!
_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"
Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006 |
|
|
|
Last Hero
|
| Posted: 12/22/2004, 6:18 AM |
|
Download and compile :)
Or try to find rpms on http://rpmfind.net/linux/rpm2html/search.php?query=php&...em=fedora&arch=
and install them
|
|
|
|
David Menzel
|
| Posted: 01/18/2005, 11:29 AM |
|
I simply changed these lines -
if($this->Persistent)
$this->Link_ID=mysql_pconnect($DBHost, $DBUser, $DBPassword);
else
$this->Link_ID=mysql_connect($DBHost, $DBUser, $DBPassword);
to
if($this->Persistent)
$this->Link_ID=mysql_pconnect('ip addy', your name', 'your pass');
else
$this->Link_ID=mysql_connect('ip addy', 'your name', 'your pass');
replace ip addy, your name, and your pass with correct values of course. But it did get all my old scripts working right away again.
|
|
|
|
