Bug report on Cooliris integration

Hello turboczi,

no problems, important is the report.

I need more information.

The point is to investigate from where come the warning. Normaly can't "Gallery Assist for the Cooliris Viewer" works when this field not exist or have a 0.

Please reisntall (realy deactivate the module and unisntall, then install again) maybe is a error ocurred by the installation or the db cache is to hard configured. This here is a suposition. Test and let me about yous results.

Regards
Juan Carlos

I have an issue that might be related. When I go to upload an image I get the following two errors:

Gallery_assist is installed. ga_cooliris is not, but once was.

user warning: Field 'cooliris_conf' doesn't have a default value query: INSERT INTO gallery_assist (gref, ref, lang, nid, uid, ganame, description, in_profile, comments, show_title, shadow, gallery_assist_weight, data) VALUES (0, 53, 'en', 53, 1, 'gallery_assist53', '', 0, 0, 0, 0, 20, 'a:6:{s:8:\"ga_align\";s:4:\"none\";s:9:\"gap_align\";s:4:\"none\";s:10:\"t_ga_float\";s:4:\"none\";s:10:\"p_ga_float\";s:4:\"none\";s:11:\"show_layout\";N;s:22:\"show_in_homepage_block\";N;}') in c:\inetpub\wwwroot\drupal\includes\common.inc on line 3467.

The gallery places had to be recreated. Possible causes: The gallery feature was assigned to this content type after the creation of this article or the gallery-assist module has been reinstalled. In order to be able to upload pictures you have to reload this page. RELOAD HERE

Hello turboczi,

The error is produced by unisntall together Gallery Assist and the Gallery Assist for the Cooliris Viewer Modules.
The uninstaller application order the modules are to be uninstalled by name. 4c_viewer want drop the field to late, the table not exists more.

Here a patch to avoid this error.
It change the line:

  $sql = "ALTER TABLE {gallery_assist} DROP `cooliris`, DROP `cooliris_conf`";

to

  $sql = "ALTER TABLE {gallery_assist} IF EXISTS DROP `cooliris`, DROP `cooliris_conf`";

Regards and Thanks
Juan Carlos

Hello spittlbm,

Your report is not a issue. I change the status and as next give you the answer.

Juan Carlos

to spittlbm,

It is so that by the uninstall process all modules drop theirs tables.

If you reinstall Gallery Assist all the information is deleted. You begin by 0. Assigments exists not more. The existing articles for example from Gallery Assist node type have not entries in the gallery_assist table.

Gallery Assist only inform you that all the data is lost and by reload the needed enviroment for a gallery will be created.

If you click the Reload link a new entry is inserted and Gallery Assist have a nid and a gid. With this two parameters Gallery Assist can create the directories if not exists and the upload process work as wanted.

I hope this help you to understand
Regards
Juan Carlos

I have problems with gallery assistant

Gallery works, but there are error messages in the all pages:

user warning: Unknown column 'cooliris' in 'field list' query: SELECT cooliris, cooliris_conf FROM drpl_gallery_assist WHERE nid = 9 in /home/www/vambutai.eu/elena/modules/gallery_assist_4cviewer/gallery_assist_4cviewer.module on line 519.

ok Beata43,

let us solve your issue.
Sure it is not a problem for you to deactivate "Gallery Assist for the Cooliris Viewer" and then uninstall.

I need the information: which version are you using?.

Reinstall the module and check please or the fieds cooliris and cooliris_data are created in the gallery_assist table.

I wait your response
Juan Carlos

I use the last version, installed yesterday

I have already uninstalled Brilliant Gallery because of errors and no help
I wonder if I get here help

Thank you for answer

My problems are such:

I have installed Gallery assist:

gallery_assist_ic-6.x-1.1
gallery_assist-6.x-1.9-rc2
gallery_assist_4cviewer-6.x-1.0
gallery_assist_upport-6.x-1.x-dev

I have tried to activate all,
Gallery Assist ImageCache is installed but I can't activate it
There is written:
Depends on: Gallery Assist (enabled), Imagecache (missing), Imageapi_gd (missing)

What is Imageapi_gd?

On all pages I have error:

user warning: Unknown column 'cooliris' in 'field list' query: SELECT cooliris, cooliris_conf FROM drpl_gallery_assist WHERE nid = 9 in /home/www/vambutai.eu/elena/modules/gallery_assist_4cviewer/gallery_assist_4cviewer.module on line 519.

maybe this will give you some solution
I am waiting answer before uninstalling

I am attaching screen shot
Do I need something else? Why I can't activate?
B.T.W. My Drupal is instaled in folder...

Sorry, I see, my problems are not with Cooliris but with Image cashe ?

I am waiting an answer so much ....

Hello Beata43,

ImageCache having nothing to do with the functionality from GA4CV.

I recognize you are a newby drupal user if you don't know ImageCache.

Please clear your cache, reinstall GA and GA4CV. (Dont forget: first you have to deactivate the modules and then you can uninstall)

I have twoo questions:
1- Works Gallery Assist (alone) properly in your drupal installation?
2- Can I get a link to your Site so maybe I can investigate and recognize some behaviors, errors etc?

Regards
Juan Carlos

Hello Juan Carlos,

Thank you for answer very much

Yes I am quite new with Drupal, it is my first trial to learn Drupal, but I am good with Joomla and usually work with it.

As you see, I can't neither activate or deactivate Image Cashe, only to delete through FTP (I tried upload once again). look my attached image
Do you mean uninstal all files?

Gallery works but I don't like style, maybe it is possible to adjust, I didn't try yet. (I would like to see all thumbnails in one place, not only three on page with large margins, but this maybe I will be able to change in the future....) Now I am concerned about errors

Gallery is here: http://www.vambutai.eu/elena/node/9
The Home of website : http://www.vambutai.eu/elena/

1. I have deactivated all Assist modules and uninstalled Gallerry assist
2. The I went to FTP and deleted all modules
3. I have uploaded gallery_assist-6.x-1.9-rc2 through FTP, activated, for my surprise I found all my photos.
I looked and found that they were in folder
sites/default/files. No error in my website, I have changed layout

Additional modules:
4.I have installed gallery_assist_ic-6.x-1.1 and activated - I can't activate like previuos and there is written:

This module help Gallery Assist to work with ImageCache.
Depends on: Gallery Assist (enabled), Imagecache (missing), Imageapi_gd (missing)

5. My Lightbox2 is installed previuosly but does it work with gallerry I didn't noticed yet. In simple pages it works.
6. I have installed gallery_assist_4cviewer-6.x-1.0 and when I activated I got error at once:

user warning: Table 'beacon2_elenai.gallery_assist' doesn't exist query: ALTER TABLE `gallery_assist` ADD `cooliris` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `data`, ADD `cooliris_conf` LONGTEXT NOT NULL AFTER `cooliris` in /home/www/vambutai.eu/elena/modules/gallery_assist_4cviewer/gallery_assist_4cviewer.install on line 39.

Than I deactivated Cooliris Viewer, error disapeared

7.Finally I have installed gallery_assist_upport-6.x-1.x-dev, activated it

Solved,

Beata43 have updated to the latest version from Gallery Assist for the Cooliris Viewr and after update all works fine.

Solution: Update to the 1.1-beta4 and run update.php

Regards
Juan Carlos

My Cooliris worked normally. I didn't visited a website a couple of weeks.

Suddenly I see today my all images dissapeared, cooliris without images with black squares

What happenned, can somebody say?

Why closed?

Beata this tread was closed and I opened it at the moment I read your report.
Is this your question?
Regards
Juan Carlos

Yes it's me
You remember me

I didn't work in my Drupal ( I was busy with my new CMS "Moodle") 3 or 4 weeks and when I came, I see no one image in my Cooliris

What happenned I can't understand
And I tried again to upload one image yesterday. It didn't appear at all

You have access if you remember.
Please if you can look..............at it
The images should be in "FOTOGRAFIJOS" and "PAVEIKSLAI" and 2 images in "APIE PARODAS"

Oh, I see this morning, that this image appeared which I have uploaded yesterday.
Should I do it again ?

P.S. Sorry, maybe you forgot URL
http://www.vambutai.eu/elena/

But why they dissapeared? Nobody have access to this website.

And the question, how to verify in FTP? where exactly should be cooliris images in FTP?

I installed on a fresh Drupal install and still have this problem...

user warning: Field 'cooliris_conf' doesn't have a default value query: INSERT INTO gallery_assist (gref, ref, lang, nid, uid, ganame, description, in_profile, comments, show_title, show_in_homepage_block, gallery_assist_weight, data) VALUES (0, 24, '', 24, 1, 'gallery_assist24', '', 0, 0, 0, 0, 20, 'a:9:{s:8:\"ga_align\";s:6:\"center\";s:9:\"gap_align\";s:6:\"center\";s:10:\"t_ga_float\";s:4:\"none\";s:10:\"p_ga_float\";s:4:\"none\";s:11:\"show_layout\";s:4:\"grid\";s:6:\"shadow\";N;s:18:\"show_download_link\";i:0;s:17:\"ga_db_order_field\";s:6:\"weight\";s:11:\"ga_db_order\";s:4:\"DESC\";}') in drupal\includes\common.inc on line 3468.

Tried both beta and dev branches, same problem.

If the Gallery Assist is already installed with all add-on submodules AND I have an existing Gallery, I can add this gallery_assist_4cviewer module and all works. It is fantastic.

However, when I add a new Gallery, I get the same error as above

...user warning: Field 'cooliris_conf' doesn't have a default value query: INSERT INTO gallery_assist.....

I have to uninstall ALL Gallery Assist components (disable modules, uninstall modules, run update.php) and then I can gradually add back Gallery Assist components (WITHOUT gallery_assist_4cviewer module) to get everything running again -

Does not matter the version of gallery_assist_4cviewer I try. All result in the error above at some point

This is a nice module if this can be fixed.