Tiki Wiki CMS Groupware

This is in your MySQL configuration.

Even better: don't store files in MySQL but configure Tiki to store in the
filesystem (there is a setting in the admin panel)
On 2012-04-26 9:02 AM, "Kassem Moustapha" <Kassem.Moustapha@...>
wrote:

>  Classification: PUBLIC
>  *I am trying to attach a .doc document and it is 1.4 MB but getting this
> error:* *System error.*
>
> The following error message was returned:****
>
> *Got a packet bigger than 'max_allowed_packet' bytes*
>
> *The query was:*****
>
> *insert into
> `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`)
> values(?,?,?,?,?,?,?,?,?,?)* ****
>
> *Values:*****
>
> ** **
>
> ** **
>
> PUBLIC
>
> This email was classified by Kassem Moustapha on April 26, 2012 9:01:27
> AM.
>  ------------------------------
>
> Kassem ****
>
> ** **
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> TikiWiki-devel mailing list
> TikiWiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
>

Classification: INTERNAL DISTRIBUTION ONLY
You mean by setting up a path under var/www/myfolder ?


INTERNAL DISTRIBUTION ONLY

This email was classified by Kassem Moustapha on April 26, 2012 9:26:11 AM.

________________________________
From: Marc Laporte [mailto:marc@...]
Sent: April 26, 2012 9:24 AM
To: Tiki developers
Subject: Re: [Tiki-devel] How would I fix this ? is it in PHI.ini ?


This is in your MySQL configuration.

Even better: don't store files in MySQL but configure Tiki to store in the filesystem (there is a setting in the admin panel)
On 2012-04-26 9:02 AM, "Kassem Moustapha" <Kassem.Moustapha@...>> wrote:

Classification: PUBLIC

I am trying to attach a .doc document and it is 1.4 MB but getting this error:
System error.

The following error message was returned:

Got a packet bigger than 'max_allowed_packet' bytes

The query was:
insert into `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`) values(?,?,?,?,?,?,?,?,?,?)

Values:



PUBLIC

This email was classified by Kassem Moustapha on April 26, 2012 9:01:27 AM.

________________________________

Kassem


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
TikiWiki-devel mailing list
TikiWiki-devel@...>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Classification: PUBLIC
 Found it I just configured mysql to take up to 2MB , but is it a good idea though ?


PUBLIC

This email was classified by Kassem Moustapha on April 26, 2012 9:29:33 AM.

________________________________
From: Marc Laporte [mailto:marc@...]
Sent: April 26, 2012 9:24 AM
To: Tiki developers
Subject: Re: [Tiki-devel] How would I fix this ? is it in PHI.ini ?


This is in your MySQL configuration.

Even better: don't store files in MySQL but configure Tiki to store in the filesystem (there is a setting in the admin panel)
On 2012-04-26 9:02 AM, "Kassem Moustapha" <Kassem.Moustapha@...>> wrote:

Classification: PUBLIC

I am trying to attach a .doc document and it is 1.4 MB but getting this error:
System error.

The following error message was returned:

Got a packet bigger than 'max_allowed_packet' bytes

The query was:
insert into `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`) values(?,?,?,?,?,?,?,?,?,?)

Values:



PUBLIC

This email was classified by Kassem Moustapha on April 26, 2012 9:01:27 AM.

________________________________

Kassem


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
TikiWiki-devel mailing list
TikiWiki-devel@...>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

Depends on the number of files, size and traffic.

For small sites (less than 50 megs for the MySQL dump), I leave files in DB
since it's simpler to make a backup/transfer

If a large site, better to store files in file system.
On 2012-04-26 9:30 AM, "Kassem Moustapha" <Kassem.Moustapha@...>
wrote:

> **
>
> Classification: PUBLIC
>
>  Found it I just configured mysql to take up to 2MB , but is it a good
> idea though ?****
>
> ** **
>
> PUBLIC
>
> This email was classified by Kassem Moustapha on April 26, 2012 9:29:33
> AM.
>  ------------------------------
>
> *From:* Marc Laporte [mailto:marc@...]
> *Sent:* April 26, 2012 9:24 AM
> *To:* **Tiki developers**
> *Subject:* Re: [Tiki-devel] How would I fix this ? is it in PHI.ini ?****
>
> ** **
>
> This is in your MySQL configuration.****
>
> Even better: don't store files in MySQL but configure Tiki to store in the
> filesystem (there is a setting in the admin panel)****
>
> On 2012-04-26 9:02 AM, "Kassem Moustapha" <Kassem.Moustapha@...>
> wrote:****
>
> Classification: PUBLIC****
>  *I am trying to attach a .doc document and it is 1.4 MB but getting this
> error:***** *System error.*
>
> The following error message was returned:****
>
> *Got a packet bigger than 'max_allowed_packet' bytes*****
>
> *The query was:*****
>
> *insert into
> `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`)
> values(?,?,?,?,?,?,?,?,?,?)* ****
>
> *Values:*****
>
>  ****
>
>  ****
>
> PUBLIC
>
> This email was classified by Kassem Moustapha on April 26, 2012 9:01:27
> AM.****
>  ------------------------------
>
> Kassem ****
>
>  ****
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> TikiWiki-devel mailing list
> TikiWiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel****
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> TikiWiki-devel mailing list
> TikiWiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel
>
>

Classification: INTERNAL DISTRIBUTION ONLY
Perfect and yea that was the only reason for me to save files under Mysql. So far mysql dump is 30 MB.

Thank you for the quick help.



INTERNAL DISTRIBUTION ONLY

This email was classified by Kassem Moustapha on April 26, 2012 9:36:55 AM.

________________________________
From: Marc Laporte [mailto:marc@...]
Sent: April 26, 2012 9:34 AM
To: Tiki developers
Subject: Re: [Tiki-devel] How would I fix this ? is it in PHI.ini ?


Depends on the number of files, size and traffic.

For small sites (less than 50 megs for the MySQL dump), I leave files in DB since it's simpler to make a backup/transfer

If a large site, better to store files in file system.
On 2012-04-26 9:30 AM, "Kassem Moustapha" <Kassem.Moustapha@...>> wrote:

Classification: PUBLIC
 Found it I just configured mysql to take up to 2MB , but is it a good idea though ?


PUBLIC

This email was classified by Kassem Moustapha on April 26, 2012 9:29:33 AM.

________________________________
From: Marc Laporte [mailto:marc@...>]
Sent: April 26, 2012 9:24 AM
To: Tiki developers
Subject: Re: [Tiki-devel] How would I fix this ? is it in PHI.ini ?


This is in your MySQL configuration.

Even better: don't store files in MySQL but configure Tiki to store in the filesystem (there is a setting in the admin panel)
On 2012-04-26 9:02 AM, "Kassem Moustapha" <Kassem.Moustapha@...>> wrote:

Classification: PUBLIC

I am trying to attach a .doc document and it is 1.4 MB but getting this error:
System error.

The following error message was returned:

Got a packet bigger than 'max_allowed_packet' bytes

The query was:
insert into `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`) values(?,?,?,?,?,?,?,?,?,?)

Values:



PUBLIC

This email was classified by Kassem Moustapha on April 26, 2012 9:01:27 AM.

________________________________

Kassem


------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
TikiWiki-devel mailing list
TikiWiki-devel@...>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
TikiWiki-devel mailing list
TikiWiki-devel@...>
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel

You need to increase the max_allowed_packet in your php.ini file.

-R

---
Why be a dummy? Be a Smarty!
Tiki for Smarties: Your portal for Tiki Wiki CMS Groupware help, guides, and books
http://tikiforsmarties.com
Twitter: @twbasics


----- Original Message ----- 
  From: Kassem Moustapha 
  To: 'Tiki developers' 
  Sent: Thursday, April 26, 2012 9:01 AM
  Subject: [Tiki-devel] How would I fix this ? is it in PHI.ini ?


  Classification: PUBLIC

  I am trying to attach a .doc document and it is 1.4 MB but getting this error:
  System error.
  The following error message was returned:

Got a packet bigger than 'max_allowed_packet' bytesThe query was:

  insert into `tiki_wiki_attachments`(`page`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,`comment`,`path`) values(?,?,?,?,?,?,?,?,?,?) 

  Values:

   

   

  PUBLIC

  This email was classified by Kassem Moustapha on April 26, 2012 9:01:27 AM.


------------------------------------------------------------------------------

  Kassem 

   



------------------------------------------------------------------------------


  ------------------------------------------------------------------------------
  Live Security Virtual Conference
  Exclusive live event will cover all the ways today's security and 
  threat landscape has changed and how IT managers can respond. Discussions 
  will include endpoint security, mobile security and the latest in malware 
  threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/


------------------------------------------------------------------------------


  _______________________________________________
  TikiWiki-devel mailing list
  TikiWiki-devel@...
  https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel