jeffreyhi1 / inline-google-docs

Automatically exported from code.google.com/p/inline-google-docs
0 stars 0 forks source link

Settings Returns "The Plugin was unable to connect to the database" #38

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

After installing the plugin in Wordpress, I go to the Settings/Inline
Google Docs section of my blog,
1. I key in my Google username
2. I key in my Google password
3. I set the cashing to 0
4. I save

What is the expected output? What do you see instead?
I'm looking for the Google Spreadsheet IDs, but instead it says:
"The plugin was unable to connect to the database"

What version of the product are you using? On what operating system?
I'm using Wordpress 2.9.2 hosted at Media Temple using PHP 5

Please provide any additional information below.
It's unusual that I see some very old Google Spreadsheets, but not the
current ones I'm trying display forms for.

Original issue reported on code.google.com by thriv...@gmail.com on 16 Feb 2010 at 2:17

GoogleCodeExporter commented 9 years ago
Same issue here, in error.log.php I see multiple

exception 'GDB_Exception' with message 'The plugin was unable to connect to the
database.' in 
/var/www/wwwroot/wp-content/plugins/inline-google-docs/inc/gdb.php:122

Stack trace:                                                                    

#0 
/var/www/wwwroot/wp-content/plugins/inline-google-docs/ajax-functions.php(134):
GDB::write(Array)                                                               

#1 
/var/www/wwwroot/wp-content/plugins/inline-google-docs/ajax-functions.php(59):
gdocs_update_list()                                                             

#2 {main}                                                                       

Original comment by tristang...@gmail.com on 17 Apr 2010 at 1:09

GoogleCodeExporter commented 9 years ago
The problem seems to be there is no table wp_gdocs. I did a manual 
CREATE TABLE IF NOT EXISTS wp_gdocs (                                           

                        title TINYTEXT NOT NULL,                                    

                        sub_title TINYTEXT NULL,                                    

                        type ENUM('document', 'spreadsheet') NOT NULL DEFAULT
'document',                                        
                        main_id VARCHAR(50) NOT NULL,                               

                        sub_id VARCHAR(50) NULL,                                    

                        INDEX(type),                                                

                        PRIMARY KEY(main_id, sub_id)                                

                ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

and fix, but I don't know why the installer didn't create the table.

Original comment by tristang...@gmail.com on 17 Apr 2010 at 1:29

GoogleCodeExporter commented 9 years ago
WOW!!! It's amazing when it's working!!!

Original comment by tristang...@gmail.com on 17 Apr 2010 at 1:49

GoogleCodeExporter commented 9 years ago
Tristan, sounds like you found the fix.

If I could understand how to plug this code into my Wordpress site, I would do 
it.  And where do I put it?

Jason

Original comment by thriv...@gmail.com on 17 Apr 2010 at 10:16

GoogleCodeExporter commented 9 years ago
Let me see what I can do. I did run that code in the mysql server. Try to 
uninstall
and reinstall the plugin, the table creation should be executed in the 
installation
process.

Original comment by tristang...@gmail.com on 18 Apr 2010 at 6:54