SQL error using cache_set

I have retitled this to be more accurate, I think.

Hm. I haven't tested in PHP 5.2, and that may be the cause of the problem. Let me try a from-scratch install and see what I find.

What happens when you go to: admin/settings/mysite and try to configure the module?

OK, I just installed both Drupal 5.1 and MySite 5.x.1.8 from scratch using MySQL 4.1.13 and PHP 5.1.6, and I'm not really in position to replicate your install.

I didn't have any trouble. No errors; no warnings. So I suspect issues with the PHP or MySQL version(s).

Can you check a few things for me:

1) Was the {mysite} database table created?
2) Was the {mysite_data} table created?
3) Was the {mysite_content} table created?
4) Where (what path) were you when the first error occured? I assume admin/build/modules, after activating MySite. Is this correct.
5) What path generated the second error? I assume /mysite/1/view. Is this correct?

More technically:

If you're welling to do some debugging for me, try this:

a) Go to mysite.module in a text editor.
b) find lines 1447-48 in the mysite_load_includes() function.
c) Edit them like so:

      default:
        $list = mysite_get_includes($type, $name);
        break;
    }
  }
  print '<pre>';
  print_r($list);
  print '</pre>';
  if (!empty($list)) {
    foreach ($list as $key => $value) {

d) Navigate to /admin/settings/mysite.
e) There should be a large Array() printed at the top of your page.
f) Copy the entire array as plain text and paste it into a note below.

The array should look like this:

Array
(
    [aggregator] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/aggregator.inc
            [basename] => aggregator.inc
            [name] => aggregator
        )

    [blog] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/blog.inc
            [basename] => blog.inc
            [name] => blog
        )

    [book] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/book.inc
            [basename] => book.inc
            [name] => book
        )

    [feed] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/feed.inc
            [basename] => feed.inc
            [name] => feed
        )

    [forum] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/forum.inc
            [basename] => forum.inc
            [name] => forum
        )

    [term] => stdClass Object
        (
            [filename] => sites/all/modules/mysite/plugins/types/term.inc
            [basename] => term.inc
            [name] => term
        )

)

The 0.txt is a null value thrown into that array that should not exist. The question is "How did it get there"?

Just tested on PHP 5.2.0 and MySQL 4.1.20 without any errors.

Same problem here but I am using MySQL 5.0.24a and PHP 5.1.6 on Drupal 5.1.

Although I did not have the first error "failed to open stream", I had the same second error about the "Incorrect table name".

I simply went back in "MySite" config window and saved again all the options on the various tabs. TaDa!

The "My Site" module works like a charm again!

I hope this can help you solve this issue as easily as me.

Eric

Eric-

So, let me see if I understand.

1) You activated the module.
2) You followed the 'My sitename' link.
3) You got an error.
4) You went back and configured the module at admin/settings/mysite
5) The error went away.

Is that right?

Eric, please don't change issue titles.

Yes that is right.

Sorry I did not realise I was changing the title for the whole discussion...

Eric

I am also experiencing this problem. You can view the error at the following address:

http://www.vshiksha.com/mysite/1

@shuklasp:

What versions of MySQL, PHP, Drupal, and MySite are you running?

I have been able to duplicate the SQL error. Investigating now.

The SQL error was caused by a change in http://api.drupal.org/api/5/function/cache_set that I missed.

I'm going to split this original issue. Since the two problems may not be related.

For the first issue, see http://drupal.org/node/118650

This has been fixed in HEAD and 5.x.1-dev. I'd like to close more bugs (especially http://drupal.org/node/118650) before adding a point release.

The 5.x.1-dev tarball should be available later 13-FEB.

If you'd like to patch your current 5.x.1.8. Here's the code:

mysite.module line 404:

$data = cache_get('mysite:' . $mysite->uid, 'cache');

mysite.module line 434:

cache_set('mysite:' . $mysite->uid, 'cache', serialize($content), time() + $cache_set);

I'm still confused as to when the original error occured.

1) You put the MySite folder in your modules directory.
2) You went to /admin/build/modules
3) You checked MySite
4) You hit Submit
5) The error returned when the page re-loaded.

Is that right?

Ok. That makes sense. The 1.7 release had a dumb bug in it.