This topic is locked

PHP Error Happened

10/2/2011 11:10:18 AM
PHPRunner General questions
S
swanside author

Hi there.

When I build my project and test it using WAMP, its all OK.

I publish by FTP to my remote server and I get this error
Error Type 2

Error Dscription Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()

URL sqlblogs.net/dailylog/Faults_list.php?

Error File Unknown

Error Line 0

SQL Query SELECT departmentId,Department FROM department ORDER BY department.Department
WHile I am uploading it starts with file 1 of 300 and goes up, but occasionally it goes backwards and carries on forward? like 1 of 300, 2 of 300, 3 of 300, 2 of 300, 3 of 300, 4 of 300 and so on?

This is uploading using passive FTP as well.

I have tried it on the demo site and it is fine?

Sergey Kornilov admin 10/2/2011

I guess your web hosting serve uses some old or unusual version of PHP. Try to find what version of PHP is there and what are options of changing it.

C
CK. 10/2/2011



Hi there.

When I build my project and test it using WAMP, its all OK.

I publish by FTP to my remote server and I get this error
Error Type 2

Error Dscription Unknown: 1 result set(s) not freed. Use mysql_free_result to free result sets which were requested using mysql_query()

URL sqlblogs.net/dailylog/Faults_list.php?

Error File Unknown

Error Line 0

SQL Query SELECT departmentId,Department FROM department ORDER BY department.Department
WHile I am uploading it starts with file 1 of 300 and goes up, but occasionally it goes backwards and carries on forward? like 1 of 300, 2 of 300, 3 of 300, 2 of 300, 3 of 300, 4 of 300 and so on?

This is uploading using passive FTP as well.

I have tried it on the demo site and it is fine?


Place this code

<?php

phpinfo();

?>



and compare the version of php in your server and wamp.
Upload 300 files via ftp is really a pain task.
Why not zip or tar it and upload only a single file. Then unzip or (un)tar it. This make sure all folder are created and sit in the correct locations.
Hope this help

S
swanside author 10/2/2011



Place this code

<?php

phpinfo();

?>



and compare the version of php in your server and wamp.
Upload 300 files via ftp is really a pain task.
Why not zip or tar it and upload only a single file. Then unzip or (un)tar it. This make sure all folder are created and sit in the correct locations.
Hope this help


Thanks, I dont know how to unzip a file on my remote server, but, it does not do this while I am at home, only when I am at work?

I will try again when I get home next week. cheers

S
swanside author 10/10/2011



I guess your web hosting serve uses some old or unusual version of PHP. Try to find what version of PHP is there and what are options of changing it.


Hi Sergey.

I have just found out they are using 5.2.14, would that be OK?
Cheers

Paul

Sergey Kornilov admin 10/10/2011

This version of PHP is just fine.
I guess you need to contact support directly providing a way to reproduce and troubleshoot this error.