Drupal 6.10, OG 6.x-1.3, Views 6.x-2.5.

I have tried install repeatedly. Downloaded repeatedly, reset permissions, run update.php, uninstalled and reinstalled, etc etc.

OG seems to install without problems, but when I install the OG Views integration I get a long string of similar error messages like this:

Warning: MySQL server has gone away 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:1527859:\"MySQL server has gone away\nquery: UPDATE cache_menu SET data = 'a:927:{s:4:\\"node\\";a:26:{s:5:\\"title\\";s:7:\\"Content\\";s:13:\\"page callback\\";s:17:\\"node_page_default\\";s:16:\\"access arguments\\";a:1:{i:0;s:14:\\"access content\\";}s:4:\\"type\\";i:4;s:6:\\"module\\";s:4:\\"node\\";s:14:\\"load_functions\\";s:0:\\"\\";s:16:\\"to_arg_functions\\";s:0:\\"\\";s:6:\\"weight\\";i:0;s:13:\\& in C:\wamp\www\platform\includes\database.mysqli.inc on line 128

Thanks in advance for advice.

Comments

Valeratal’s picture

Valeratal commented

i have this too

gjmokcb’s picture

gjmokcb commented

Also get this error msg on OG install:

user warning: Table 'mysite.og_uid' doesn't exist query: SELECT n.title, n.type, n.status, ou.* FROM og_uid ou INNER JOIN node n ON ou.nid = n.nid WHERE ou.uid = 1 AND ou.is_active >= 1 AND n.type IS NULL ORDER BY n.title in C:\wamp\www\platform\sites\all\modules\og\og.module on line 1134.

Confirmed that table doesn't exist. Related?

Also, after researching "MySQL server has gone away," I beefed up its config (more memory allocated) and extended its interactive timeout. Didn't help.

Valeratal’s picture

Valeratal commented

I downgrade to 1.2
And OG work

gjmokcb’s picture

gjmokcb commented

I'll try that. I upgraded to the latest dev snapshot and it still didn't work.

gjmokcb’s picture

gjmokcb commented

1.2 was the same. I can install OG, but not OG Views integrator. OG Views throws the error code mentioned at the top of this thread. And I still get the error msg about no og_uid table.

gjmokcb’s picture

gjmokcb commented
Category: support » bug
gjmokcb’s picture

gjmokcb commented

Found the answer here: http://drupal.org/node/186384

Apparently OG is a big mother, and needs more than the standard 1M packet limit set in a MySQL my.ini file. I raised it to 24M and now everyone is happy. Including me.

And to fix the og_uid table problem, build the table yourself. Fields: uid, nid, is_active.

Hey, even tho I fixed it myself, big thanks to Moshe and all the others who work so hard on this valuable module. (Now if you could find time to get around to Panels 3, please?)

I'm leaving this as an open bug for now, to remind maintainers to fix the og_uid table thing.

gjmokcb’s picture

gjmokcb commented
Status: Active » Fixed

On my eighty-seventh uninstall, reinstall, clean database, etc, I got a nice, complete install. I suspect that the problems with not creating tables correctly was tied to my original problem with the MySQL packet limit. I think it took several lame attempts on my part to get everything cleaned out that had to be be cleaned out. And the correct install came after I re-downloaded the module, so maybe my earlier download was corrupt. Whatever the cause, I'm getting a clean install now, and I'm marking this fixed.

Nice module, guys. Thanks.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

kenorb’s picture

kenorb commented

#327066: Warning: MySQL server has gone away: recursive error reporting

kenorb’s picture

kenorb commented
Project: Organic Groups » Drupal core
Version: 6.x-1.3 » 6.x-dev
Component: Og Views » menu system
Status: Closed (fixed) » Closed (duplicate)