I now installed and reinstalled Drupal from scratch so many times, that I'm starting to wonder whether it's worth spend any more time on it. I mean, Drupal is awesome when it works - in my experience very rarely - but perhaps it's not for anyone, specially non developers.
After the Nth install, that's what it renders:

Warning: Got a packet bigger than 'max_allowed_packet' bytes query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:1708322:\"Got a packet bigger than 'max_allowed_packet' bytes\nquery: UPDATE cache_menu SET data = 'a:2:{s:4:\\"tree\\";a:97:{i:2;a:2:{s:4:\\"link\\";a:37:{s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\"to_arg_functions\\";s:0:\\"\\";s:15:\\"access_callback\\";s:11:\\"user_access\\";s:16:\\"access_arguments\\";s:45:\\"a:1:{i:0;s:27:\\"access administration pages\\";}\\";s:13:\\"page_callback\\";s:22:\\"sy in /Users/.../includes/database.mysqli.inc on line 128

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 5182110 bytes) in /Users/.../includes/bootstrap.inc on line 741

Warning: Cannot modify header information - headers already sent by (output started at /Users/.../includes/database.mysqli.inc:128) in Unknown on line 0

I had those errors before, but normally one at a time.
I'm on a Mac, Snow Leopard, MAMP 1.0, Drupal 6.14, with CCK, Views, Ubercart, Calendar, Date etc.

Any thoughts are welcome.
Thanks

Comments

damien tournoud’s picture

damien tournoud commented
Category: bug » support

You need to increase the max_allowed_packet configuration setting of MySQL to something decent. From a quick internet search, I'm not exactly sure what is the simplest way to do that in MAMP. Please get in touch with MAMP support.

tsvenson’s picture

tsvenson commented
Category: support » bug

removed

damien tournoud’s picture

damien tournoud commented
Category: bug » support
Perroud’s picture

Perroud commented

You're right Damien, it's a SQL thing, and it's not simple - well I've just fixed the problem and I have no idea whether it's really fixed or if it's temporarily only. Anyway, I'm back in business so I'm not complaining.
To solve it I followed the instructions from this website:

http://help.directadmin.com/item.php?id=44

Thing is, people keep saying you have to fix the so called max_allowed_packet. It took a long time to find out it actually didn't exit in my computer. Anyway, here is how I fixed:

1. On Finder, hit Command+Shift+G and go to /etc. It's a hidden folder so a search would yield no result.
2. Create a my.cnf file. In my case I couldn't - even though I'm the admin in my computer the system didn't allowed me to do that, so I created it in my desktop and then copied it to that folder. You have to authenticate.
3. Follow the steps on the link mentioned above and restart MAMP. Remember to cross your fingers.

Again, whether the problem is gone for good is still to be seen. Hope that helps.
Thanks heaps anyway.

Perroud

Perroud’s picture

Perroud commented
Status: Active » Closed (fixed)

Guys, it did fix the problem. Drupal is solid now.
Cheers