Hi Gigya,

I have another issue on a different website namely samadhidancecompany.com

I get a warning:

user warning: Table 'samadhi.gigya' doesn't exist query: SELECT uid FROM gigya WHERE gigya_uid = '_gid_n/K+CtEMcbZxRbyhGA4xsQ==' in /home/vhosts/samadhidancecompany.nl/httpdocs/sites/all/modules/gigya/gigya.inc on line 293.
user warning: Table 'samadhi.gigya' doesn't exist query: SELECT uid FROM gigya WHERE gigya_uid = '_gid_n/K+CtEMcbZxRbyhGA4xsQ==' in /home/vhosts/samadhidancecompany.nl/httpdocs/sites/all/modules/gigya/gigya.inc on line 293.

Then when I login I am redirected to this page:

http://samadhidancecompany.nl/?timestamp=2009%2D12%2D05%2019%3A18%3A02&p...

Please help me with this

Regards, Krishna

Comments

Krishna Bosch’s picture

Krishna Bosch commented

I have switched of the module, because the pages of my site wouldn't load any more once logged in, just white and blank

I don't why this happens on this site and not on my other site

azinck’s picture

azinck commented

You're getting the warning because the gigya table doesn't exist. Re-activate the module and go to update.php to ensure the table gets created.

Gigya’s picture

Gigya commented

Thanks Azinck,

Krishna - was the issue fixed for you after you tried Azinck suggestion?

Krishna Bosch’s picture

Krishna Bosch commented

I followed the instruction, no fix. I am forwarded with fb login to this blank page:

http://samadhidancecompany.nl/?photoURL=http%3A%2F%2Fprofile%2Eak%2Efbcd...

to this blank page with twitter login:

http://samadhidancecompany.nl/?photoURL=http%3A%2F%2Fa1%2Etwimg%2Ecom%2F...

this warning again:

user warning: Table 'samadhi.gigya' doesn't exist query: SELECT uid FROM gigya WHERE gigya_uid = '_gid_aDkgnh6Q3mytAsCbTXInQO+gJvAKFjTpcZJld6oo3sY=' in /home/vhosts/samadhidancecompany.nl/httpdocs/sites/all/modules/gigya/gigya.inc on line 293.
user warning: Table 'samadhi.gigya' doesn't exist query: SELECT uid FROM gigya WHERE gigya_uid = '_gid_MX9Cz8BdMcnsLexe4V5eKg==' in /home/vhosts/samadhidancecompany.nl/httpdocs/sites/all/modules/gigya/gigya.inc on line 293.

Also again when I then after trying to login with the socialize module and failing, trying to login with the normal drupal loging directs me to an empty page with the URL http://samadhidancecompany.nl/?q=en/node, which should normally show as the frontpage

Could it have anything to do with my site being bi-lingual?

I am not really knowledgeable about php or mysql, so I won't be able to figure this out myself. I have to switch the module off again. I really would like this module to work, the possibilities are great. Thanks for taking all the trouble.

Kind regards, Krishna Bosch

azinck’s picture

azinck commented

The error seems pretty clear that the table doesn't exist. Don't forget that the database credentials you set up when you first configured Drupal must have "create" rights for your Drupal database or else the table won't get created. Do you see a table named "gigya" in your Drupal database? When you run update.php do you get any errors?

EvanDonovan’s picture

EvanDonovan commented

It could also be that it is looking for a table without a table prefix...Is table prefixing enabled on your site?

Krishna Bosch’s picture

Krishna Bosch commented

Thanks for the help,

I can't find any table named gigya in the database.

How, or where, do I enable or disable table prefixing?

EvanDonovan’s picture

EvanDonovan commented

Krishna: Table prefixing would have been enabled in settings.php. If there is no table named gigya, and you don't know what table prefixing is, then that's probably not the issue. Try disabling, uninstalling, and reinstalling the module. It should create the table when the module is installed. If not check the site error log (admin/settings/dblog) to see if it had any problems during installation.

Gigya’s picture

Gigya commented
Status: Active » Needs review
Krishna Bosch’s picture

Krishna Bosch commented

Thanks Evan, I haven't gotten round to it yet, but I will try it in the next few days. Just keeping you updated.

mosco_dj’s picture

mosco_dj commented
Version: 6.x-1.0-beta9 » 6.x-1.0-beta10

Hi!

A few days ago i have the same problem, now fixed. Try this:

1. Disable the module.
2. Uninstall the module.
3. Edit gigya.install file.
Search this part:

'gigya_uid' => array(
        'description' => t('Gigya User ID'),
        'type' => 'varchar',
        'length' => 950,
        'not null' => TRUE,
        'default' => '',
      ),

Replace "950" with "250", make sure the results are:

'gigya_uid' => array(
        'description' => t('Gigya User ID'),
        'type' => 'varchar',
        'length' => 250,
        'not null' => TRUE,
        'default' => '',
      ),

4. Upload the file to the server.
5. Install the module.

That's it. Now work.

I don't know if this change affect something, but now works for me.

PS: Excuse my bad english.

mosco_dj’s picture

mosco_dj commented

Ok, i have another problem here.

The "solution" i mentioned before works to install, but when Gigya it's already installed i can't see "Gigya Status Popups" in "Actions".

...I don't know what to do =(

Gigya’s picture

Gigya commented

Please use version 2 : http://drupal.org/node/720046

The Gigya team.

azinck’s picture

azinck commented
Status: Needs review » Closed (duplicate)

The root cause of this problem (field length too long for people on old versions of MySQL) will be fixed when this is fixed: #723850: Install/uninstall needs to be changed to reflect the fact that we no longer use the database