ID: 22045
Comment by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
Status: Open
Bug Type: Filesystem function related
Operating System: WinME
PHP Version: 4.3.0
New Comment:
I will post you the error massage what i got :
___________________________________________________________
Warning: fopen(mysql/pphl_xxxxx_logs.sql) [function.fopen]: failed to
create stream: No such file or directory in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: filesize() [function.filesize]: Stat failed for
mysql/pphl_xxxxx_logs.sql (errno=2 - No such file or directory) in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: fread(): supplied argument is not a valid stream resource in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: fopen(mysql/pphl_xxxxx_mpdl.sql) [function.fopen]: failed to
create stream: No such file or directory in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: filesize() [function.filesize]: Stat failed for
mysql/pphl_xxxxx_mpdl.sql (errno=2 - No such file or directory) in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: fread(): supplied argument is not a valid stream resource in
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php
on line 79
Warning: Cannot modify header information - headers already sent by
(output started at
/usr/local/httpd/htdocs/kunden/web152/html/libraries/load_sql.lib.php:79)
in /usr/local/httpd/htdocs/kunden/web152/html/modules/usercreate.php on
line 63
___________________________________________________________
Line 79 ist
___________________________________________________________
$sql_query = fread(fopen($sql_file, "r"), filesize($sql_file));
___________________________________________________________
And that works before !
Thanx Alf
Previous Comments:
------------------------------------------------------------------------
[2003-02-04 11:47:37] [EMAIL PROTECTED]
So I want to creat two new Tables with this funktionscript
__________________________________________________________
exec_sql_lines(SQL_LOGS, "pphl_xxxxx_logs",
$tbl_prefix.$id.$tbl_logs);
exec_sql_lines(SQL_MPDL, "pphl_xxxxx_mpdl",
$tbl_prefix.$id.$tbl_mpdl);
__________________________________________________________
The Funktion 'exec_sql_lines' is
__________________________________________________________
function exec_sql_lines($sql_file, $old_string = '', $new_string = '')
{
$sql_query = isset($sql_query) ? $sql_query : "";
if(!empty($sql_file) && $sql_file != "none") {
$sql_query = fread(fopen($sql_file, "r"), filesize($sql_file));
/* If magic_quotes_runtime is enabled, most functions that return
data from any sort of external source
including databases and text files will have quotes escaped with a
backslash.
*/
if (get_magic_quotes_runtime() == 1) $sql_query =
stripslashes($sql_query);
/* replace old_string with new_string if they are set */
if($old_string != '') {
$sql_query = ereg_replace($old_string,$new_string,$sql_query);
}
}
$sql_query = trim($sql_query);
if($sql_query != "") {
$sql_query = remove_remarks($sql_query);
$pieces = split_sql_file($sql_query,";");
$cnt_pieces = count($pieces);
/* run multiple queries */
for ($i=0; $i<$cnt_pieces; $i++) {
$sql = trim($pieces[$i]);
if (!empty($sql) and $sql[0] != "#") $result =
mysql_query($sql);
}
}
return true;
}
__________________________________________________________
It works before my provider changed the php-version
and i don't changed anything on the script but the tables dosn't creat
and the script can't read it
when it dosn't exist.
I hope this information can help you to help me with my problem when
not tell me what information do you need.
Thanx alf from germany
------------------------------------------------------------------------
[2003-02-04 10:26:06] [EMAIL PROTECTED]
WHAT part of that script does not work?
Please provide a short and COMPLETE script which
clearly shows the 'bug'. Most likely the problem
is not any bug anyway...
------------------------------------------------------------------------
[2003-02-04 09:29:27] [EMAIL PROTECTED]
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php
If you can provide more information, feel free to add it
to this bug and change the status back to "Open".
Thank you for your interest in PHP.
------------------------------------------------------------------------
[2003-02-04 09:28:49] [EMAIL PROTECTED]
I' am sorry for my bad english, but I have a Problem with this Script.
function exec_sql_lines($sql_file, $old_string = '', $new_string = '')
{
$sql_query = isset($sql_query) ? $sql_query : "";
if(!empty($sql_file) && $sql_file != "none") {
$sql_query = fread(fopen($sql_file, "r"), filesize($sql_file));
/* If magic_quotes_runtime is enabled, most functions that return
data from any sort of external source
including databases and text files will have quotes escaped with a
backslash.
*/
if (get_magic_quotes_runtime() == 1) $sql_query =
stripslashes($sql_query);
/* replace old_string with new_string if they are set */
if($old_string != '') {
$sql_query = ereg_replace($old_string,$new_string,$sql_query);
}
}
$sql_query = trim($sql_query);
if($sql_query != "") {
$sql_query = remove_remarks($sql_query);
$pieces = split_sql_file($sql_query,";");
$cnt_pieces = count($pieces);
/* run multiple queries */
for ($i=0; $i<$cnt_pieces; $i++) {
$sql = trim($pieces[$i]);
if (!empty($sql) and $sql[0] != "#") $result =
mysql_query($sql);
}
}
return true;
}
My Provider changed the PHP-Verion to 4.3.0 and from this
time this Script dosn't work.
Is there a Bug, nobody can help me.
Thanx Alf
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=22045&edit=1
