Linuxdelta

LinuxDelta => Knowledgeroot => Topic started by: ag0927 on December 21, 2007, 12:50:11 PM

Title: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 12:50:11 PM
When I upload a *.ppt file,
after finish upload,
the brower become blank page.
who can tell me why?

Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 21, 2007, 12:59:04 PM
Hi,

do you have the same problems with the demo?

What Webserver, DB, Browser, ... do you use?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 01:52:44 PM
Webserver : Linux + Apache
DB            : MySQL
Browser     : Firefox 2.0 & IE7

Thanks
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 21, 2007, 01:57:11 PM
Do you also have the problems on the knowledgeroot demo?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 02:12:25 PM
On the knowledgeroot demo I don't have the problems!!

Do you also have the problems on the knowledgeroot demo?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 21, 2007, 02:16:50 PM
Hi,

i think ".ppt" is not the exactly name or? Do you use taiwan or any other language for the name of the file?

Did you take a look in the apache errorlog?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 02:58:14 PM
Yes,I use zh-tw language.

and apache errorlog is
============================
[Fri Dec 21 21:47:44 2007] [error] [client 122.126.73.129] PHP Notice:  Undefined index:  error in /var/www/html/knowledge/include/class-mysql.php on line 94, referer: http://www.xxxx.com.tw/knowledge/index.php?id=33
[Fri Dec 21 21:47:44 2007] [error] [client 122.126.73.129] PHP Fatal error:  Call to a member function log() on a non-object in /var/www/html/knowledge/include/class-mysql.php on line 94, referer: http://www.xxxx.com.tw/knowledge/index.php?id=33
============================

and I try the same file name, but file size is smaller(1138KB&959KB)
the knowledgeroot is work!!

Hi,

i think ".ppt" is not the exactly name or? Do you use taiwan or any other language for the name of the file?

Did you take a look in the apache errorlog?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 21, 2007, 03:04:45 PM
Which version of knowledgeroot do you use?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 03:06:01 PM
0.9.8.5

Which version of knowledgeroot do you use?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 21, 2007, 03:25:16 PM
OK. I will try to reproduce this problem at weekend.

What php version and mysql and apache version du you use exactly?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 21, 2007, 03:34:41 PM
Thanks for your help!!

php : 5.1.6
mysql : mysql-server-5.0.27-1.fc6
           php-mysql-5.1.6-3.7.fc6
           mysql-5.0.27-1.fc6
httpd: 2.2.6

I guess  file size is the problem,but I can't solve

This weekend I will to take a vacation
Thank you very much!!!

OK. I will try to reproduce this problem at weekend.

What php version and mysql and apache version du you use exactly?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 24, 2007, 09:52:45 AM
Hi,

Do you have a solution?

Thx.
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 24, 2007, 10:48:04 AM
Not releay. Only some hints at the moment you should test.

What value is in your php.ini for upload_max_filesize?
What value is in knowledgeroot in admin interface at configure - knowledgeroot.maxfilesize?

Try to change this values to your needs.
I hope this helps. The error in the log file is a real bug ;) Programming problem. I will add this to trac.

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 24, 2007, 03:04:29 PM
It still can not work!!

The value of upload_max_filesize in php.ini,I try 20M&20971520
The value of knowledgeroot.maxfilesize I try 20971520


What value is in your php.ini for upload_max_filesize?
What value is in knowledgeroot in admin interface at configure - knowledgeroot.maxfilesize?

Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 26, 2007, 07:46:46 PM
Sorry but i did not understand. Does it work now or not?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 27, 2007, 02:55:02 AM
It does not work!!

Sorry but i did not understand. Does it work now or not?

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 27, 2007, 09:24:17 AM
Could you give me the exact name of the file?
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on December 28, 2007, 05:58:04 AM
It seems not to be a file name problem.
Because I change the file name into English.
But not work.

Could you give me the exact name of the file?
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 30, 2007, 01:06:08 AM
Hi,

i will change a file for you to get more debug information. I will post the link here if i have done this.

Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on December 30, 2007, 01:17:15 AM
Hi again,

OK. Change in include/mysql.php on line 94
this:
Code: [Select]
$this->CLASS['error']->log("ERROR IN QUERY: \"$query\"",1,mysql_errno() . ":".mysql_errno());to:
Code: [Select]
echo "ERROR IN QUERY: \"$query\"",1,mysql_errno() . ":".mysql_errno() . "<br />\n";
After that change try to upload the file again. You should see now a error message on the display. Please post this message here.

Thanks.
Frank
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: ag0927 on January 01, 2008, 02:54:24 PM
Thank you very much.

I change line 94 to
die('Invalid query: ' . mysql_error());

It echo a message:Invalid query: Got a packet bigger than 'max_allowed_packet' bytes

So it is a mysql error.

I edit /etc/my.cnf. Add a line like this.
==================
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_allowed_packet=32MB
====================

And it does work!!!!!
Title: Re: Problem with upload powerpoint file(*.ppt)
Post by: admin on January 04, 2008, 02:29:55 AM
Ok.

Good to know that this is fixed.

Thanks for your testing and help.

Frank