Help me please MYSQL problem

[adrian010]

Hey guys i moved my site from one server and url to another server and url when i moved the site i moved teh SQL database as well

every thing works escept when i go to the event listing page i get this worning but the events still show up

========================================================

Warning: mktime() expects parameter 6 to be long, string given in /hermes/bosweb/web036/b366/sl.parheaca/public_html/event_list.php on line 31

=========================================================

However when when I click on the event i do not see the event i get a page and a set of errors

=========================================================
comm:select * from events where status=1 and id=
error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Server databse operation error!
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 108

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 111

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 119

please help me

PS the script is still running on my old server and it works there
the new server is running newer versions of php and mysql

[Krik]

Your going to have to show us the code related to those lines. Those errors do point to fairly specific problems but to give you an answer that is even close will require all code from those lines and related to those lines.

Beyond that do note the first error points out an error with the [man]mktime[/man] function. Likely you made some mistake in your use of it.

The other set of errors are all a result of the first one in the set. It basically states you have a syntax error in your sql query. Fix your syntax error in the first error and I suspect the rest will be fixed also.

PS the script is still running on my old server and it works there
the new server is running newer versions of php and mysql

The error could possibly be connected to the versions but as you don't give the versions it is anyone's guess as to what maybe the problems.

[adrian010]

Thank you for your help here is the codes for the lines as you requested

Warning: mktime() expects parameter 6 to be long, string given in /hermes/bosweb/web036/b366/sl.parheaca/public_html/event_list.php on line 31

+++++++++++++++++++++++++++++++++++++++++++
$date = mktime(0,0,0,$date[1],$date[2],$date[0]);

++++++++++++++++++++++++++++++++++++++++++

comm:select * from events where status=1 and id=
error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Server databse operation error!
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 108

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 111

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /hermes/bosweb/web036/b366/sl.parheaca/public_html/include/mysql_func.php on line 119

108
++++++++++++++++++++++++++++++++++++++++++
$num_fields = mysql_num_fields($result);

++++++++++++++++++++++++++++++++++++++++++
111
++++++++++++++++++++++++++++++++++++++++++
if( $row = mysql_fetch_array($result) )

++++++++++++++++++++++++++++++++++++++++++
119
++++++++++++++++++++++++++++++++++++++++++
mysql_free_result($result);

++++++++++++++++++++++++++++++++++++++++++

[adrian010]

the versions are as follows. thanks

new site
PHP Version: 5.2.12
MySQL Version: 5.0.45

Old site
PHP version 4.3.11
MySQL version 4.1.22-standard

[adrian010]

Line 31
$date = mktime(0,0,0,$date[1],$date[2],$date[0]);

line 108

$num_fields = mysql_num_fields($result);

line 111

if( $row = mysql_fetch_array($result) )

Line 119
mysql_free_result($result);

[Krik]

What is the value of "$date[0]"? As that is what the mktime error is saying is incorrect. Make sure it is a 4 digit value . If you need to, place an echo in the line before the mktime to see what the value of "$date[0]" is.

comm:select * from events where status=1 and id=
error:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

This error is the important one out of that group of 4 errors. This error is referring to the SQL string that lines 108, 111, and 119 are using. If you could post the SQL query it would help to identify the problem.