MySQL problem(s)

phpDeveloper200

Hi,

My PHP website run on MySQL 4.0 without any problem. But now host server company switched me to MySQL 4.1 and my PHP website has problem(s).

My PHP website still can run on MySQL 4.1 but but nothing is populating into my PHP website. And I know the data is in the database. (MySQL 4.1 database)

Question #1: What is the problem?

Question #2: How can I make my PHP website so that my PHP website can run on MySQL 4.1?

Any suggestions would be much appreciated!

Thanks,
May

bogu

And what is the php version?

MarkR

You clearly have a problem with error handling in your application. Enable error_reporting(E_ALL) and set up a suitable error handler.

Have you tried running it with MySQL 4.1 on your dev server? Does it work there?

Are you seeing any mysql-related errors on the error log?

You should probably have an error handler which detects any mysql problem and causes the page to stop, logging as appropriate and sending the user a message or something.

Mark

phpDeveloper200

Hi Everyone,

Thanks for your help! My friend has just help me to put my site on MySQL 4.0 (a new host server company).

May

phpDeveloper200

After upload all files to the new server which running
MySQL 4.0. But I get the following error messages:

Warning: mysql_connect(): Access denied for user: 'weekmar1_notname@localhost' (Using password: YES) in /home/weekmar1/public_html/new/thxree.inc on line 2

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/weekmar1/public_html/new/thxree.inc on line 3

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/weekmar1/public_html/new/co1.php on line 91

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/weekmar1/public_html/new/co1.php on line 92

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/weekmar1/public_html/new/teama.php on line 86

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/weekmar1/public_html/new/teama.php on line 87

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/weekmar1/public_html/new/we1.php on line 78

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/weekmar1/public_html/new/we1.php on line 79

If you have any suggestions on how to fix these errors.
Then please let me know. Thanks. Please note that
there is no problem for my PHP site running on MySQL 4.0 on
an old server.

Thanks,
May

TobyRT

If you could show us the code which is throwing up errors, we might be able to point you in the direction of the correct syntax.

Looking at your errors though, I would wager that once you sort out your first two errors (the connect and the password), the others will disappear

phpDeveloper200

TobyRT wrote:
If you could show us the code which is throwing up errors, we might be able to point you in the direction of the correct syntax.

Looking at your errors though, I would wager that once you sort out your first two errors (the connect and the password), the others will disappear

I have just found out that my friend has not created any
database tables on the new server. What is the best way
to transfer all the data from an old server to the new server?

Thanks,
May

TobyRT

The most straightforward way would be to do a straight SQL dump to a file, then re-import it. Depending on your hosts, this should be fairly straightforward.