While uploading multiple images to a single node, I select multiple images with the file dialog box, hit ok then hit 'Upload images'. The uploads start and I get a progress bar, but while it does come back with the "Image PICT0117.JPG added." etc messages, it also throws up error messages similar to this for each image;

"user warning: Table 'forest_drupal6.fupload_previewlist' doesn't exist query: INSERT INTO fupload_previewlist (fieldname, uid, nid, fid, created) VALUES ('field_images', 1, 189, 284, 1250479431) in /home/forest/public_html/modules/image_fupload/image_fupload_imagefield/image_fupload_imagefield.module on line 393."

when I click Nest step, it gives me;

user warning: Table 'forest_drupal6.fupload_previewlist' doesn't exist query: SELECT p.nid, p.fid, f.filename, f.filepath FROM fupload_previewlist AS p JOIN files AS f ON p.fid = f.fid WHERE p.fieldname = 'field_images' AND p.uid = 1 in /home/forest/public_html/modules/image_fupload/includes/images.previewlist.imagefield.inc on line 57.

No images have been found in queue, probably no images have been uploaded yet. Please return to image upload page if you want to upload some images.

if i hit back, there's nothing there, though if i thenn go to the gallery page itself, it comes up with all the images.

has the missing table not been added to the db on initial enabling of the module? if so, what sql can i use to add it? thanks!

CommentFileSizeAuthor
#12 image_fupload_nocaptionedit.png282.53 KBmxmilkiib
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

grandcat’s picture

Status: Active » Fixed

You didn't run the update.php file after having upgraded FUpload.
You could also uninstall and reinstall FUpload to fix it.

mxmilkiib’s picture

Status: Fixed » Active

i didn't upgrade it, i installed it for the first time ("initial enabling").

i tried disabling the module and reenabling it, but there was "No upgrades available" in upgrade.php

can i manually select one of the upgrade options in the drop down menu there or is that a Bad Idea? if i can, which one of the 5 should i choose?

thanks for any help.

grandcat’s picture

Choose 6300 (should be the 3. one).

grandcat’s picture

Status: Active » Fixed
mxmilkiib’s picture

eek, I get the following;

The following queries were executed
image_fupload module
Update #6300

* Failed: CREATE TABLE {fupload_previewlist} ( `fieldname` VARCHAR(32) NOT NULL DEFAULT '', `uid` INT(normal) NOT NULL DEFAULT 0, `nid` INT(normal) NOT NULL DEFAULT 0, `fid` INT(normal) DEFAULT 0, `created` INT(normal) NOT NULL DEFAULT 0, PRIMARY KEY (fid), INDEX fieldname (fieldname), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */

Update #6301

* No queries

Update #6304

* No queries

Any thoughts?

mxmilkiib’s picture

Status: Fixed » Active
grandcat’s picture

Have a look at the log messages, perhaps there's a error message to be able to understand this misbehaviour.

tonino66’s picture

I have the same error with a new installation. After update.php with 6300 I received this error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'normal) NOT NULL DEFAULT 0, `nid` INT(normal) NOT NULL DEFAULT 0, `fid` INT(no' at line 3 query: CREATE TABLE fupload_previewlist ( `fieldname` VARCHAR(32) NOT NULL DEFAULT '', `uid` INT(normal) NOT NULL DEFAULT 0, `nid` INT(normal) NOT NULL DEFAULT 0, `fid` INT(normal) DEFAULT 0, `created` INT(normal) NOT NULL DEFAULT 0, PRIMARY KEY (fid), INDEX fieldname (fieldname), INDEX uid (uid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\web\com\htdocs\includes\database.inc on line 517.

mxmilkiib’s picture

sorry for not reply before, but yes, what tonino66 posted is the logged error i get (appears above the text i posted on the 18th).

Steve Dondley’s picture

Component: User interface » Code
Category: support » bug

I, too, have not been successful at getting this table installed in my database. Same errors as above.

I have done a complete uninstall and reinstall of the module. I have run update.php per the suggestions above, but no luck.

UPDATE: I'm using the latest dev version dated 28 Sept.

Steve Dondley’s picture

OK, upgrading Drupal to latest version solved my problem (comment #9). There must have been a change to schema API.

I suggest everyone else who is having this problem do the same.

mxmilkiib’s picture

i'd upgraded to 6.14 around 10 days ago but the problem was still there. i've just run Image FUpload updates from 6300 and no more error messages, thanks steve!

but...

when i go onto the second stage, it shows thumbs of each image but nothing to edit captions.

hitting 'Done editing' then gives me the message;

Fatal error: Call to undefined function _content_is_empty() in /home/forest/public_html/modules/cck/content.module on line 935

and going back to the front page gives

* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/forest/public_html/modules/cck/content.module on line 926.
* warning: Invalid argument supplied for foreach() in /home/forest/public_html/modules/cck/content.module on line 926.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/forest/public_html/modules/cck/content.module on line 926.
* warning: Invalid argument supplied for foreach() in /home/forest/public_html/modules/cck/content.module on line 926.

i tried another test gallery - on the second page, it showed all the thumbs from the first gallery plus the newer test image thumbs. hitting 'Done editing' again game the same error.

i cleared the drupal caches, tried with a 3rd gallery and got the same result.

likewhoa’s picture

confirming issue in #12 here using latest -dev in drupal-6.14 and -dev modules.

grandcat’s picture

You have to add items to be edited. Open the ImageField settings page (with FUpload widget). There you can set which fields should be editable for the preview page.

mxmilkiib’s picture

cool, did this for the image description checkbox

now;

creating a new test gallery. when i click next, it takes me to the page and each image has a description box, but it's still showing the whole of the first gallery from the #12 plus the newly added images - but not the images from the first gallery i tried to upload the last time.

clicking at the bottom to continue gives me a white page with;

Fatal error: Call to undefined function _content_is_empty() in /home/forest/public_html/modules/cck/content.module on line 935

then going back to the front page gives me;

* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/forest/public_html/modules/cck/content.module on line 926.
* warning: Invalid argument supplied for foreach() in /home/forest/public_html/modules/cck/content.module on line 926.

the test gallery does come up fine on the site itself though..

bramface’s picture

I am getting the same Fatal Error when attempting to create a node using uc_node_checkout - and there is a discussion about that at http://drupal.org/node/541768. I resolved mine by deleting the "email address" field from the content types in question.

buzzman’s picture

ok, I got the same error as reported in #8. don't know about the later ones though, as I haven't fully tested those sections yet.

Here's what I did:

copied the "create" query over to my SQL client and edited it to the following (really just removed "(normal)" within quotes):

CREATE TABLE fupload_previewlist ( `fieldname` VARCHAR(32) NOT NULL DEFAULT '', `uid` INT NOT NULL DEFAULT 0, `nid` INT NOT NULL DEFAULT 0, `fid` INT DEFAULT 0, `created` INT NOT NULL DEFAULT 0, PRIMARY KEY (fid), INDEX fieldname (fieldname), INDEX uid (uid) );

query ran ok and the table "fupload_previewlist" was created successfully.

Q FOR GRANDCAT: is this an OK hack? I mean will it run into any problems for the normal operation of the mod down the line?

If yes, what can be done that doesn't involve updating core Drupal to latest version?

Thanks and hope this helps you guys as well.

grandcat’s picture

This is not a hack, you just inserted the sql code manually. There won't be any problems in future.