As I enable picasa module & save I get this error
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB/TEXT column 'images' can't have a default value: CREATE TABLE {picasa_node_album} ( `nid` INT unsigned NOT NULL, `uid` INT unsigned NOT NULL, `google_user` VARCHAR(64) NOT NULL DEFAULT '', `album_id` VARCHAR(64) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `added` INT unsigned NOT NULL DEFAULT '0', `updated` INT unsigned NOT NULL DEFAULT '0', `images` TEXT NOT NULL DEFAULT '', INDEX `nid` (`nid`), INDEX `album_id` (`album_id`), INDEX `added` (`added`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8; Array ( ) in db_create_table() (line 2686 of /home/sacoin/public_html/sunnyvale-chennai.in/includes/database/database.inc).

Comments

mmilano’s picture

mmilano commented
Status: Active » Needs review

Thanks for the post. I committed a fix for the install schema.

Please try the 7.x-1.x-dev snapshot build once the date reflects a time after this post. I'm not sure when it actually gets automatically built.

kanted’s picture

kanted commented
Version: 7.x-1.0-beta1 » 7.x-1.x-dev

I have installed zend & picsa node picasa_node_album-7.x-1.x-dev and in the configure of zend module I gave the picasa folder name it gave me this error

Fatal error: require_once() [function.require]: Failed opening required 'picasa_node_album-7.x-1.x-dev/Loader/Autoloader.php' (include_path='.:/usr/lib/php:/usr/local/lib/php:/home/sacoin/public_html/sunnyvale-chennai.in/picasa_node_album-7.x-1.') in /home/sacoin/public_html/sunnyvale-chennai.in/sites/all/modules/zendt/zend.module on line 18

I removed zend & picasa folder from the modules folder then too the issue. pls save me ,SOS site down

mmilano’s picture

mmilano commented

That looks like an issue with the configuration of the zend module/library. Do you have access to run a MySQL query? If so, you can disable both modules with these queries:

update system set status = 0 where name = 'zend';
update system set status = 0 where name = 'picasa_node_album';

Once you successfully turn these modules off, your site should be back to normal. You should then go to /admin/modules/uninstall and uninstall before trying again.

I highly recommend you test the setup on an environment other than production.

mmilano’s picture

mmilano commented
Status: Needs review » Closed (fixed)