If I enable upload image, I get:
"user warning: Table 'drupal.upload_images' doesn't exist query: SELECT f.*, u.* FROM upload_images u INNER JOIN files f ON u.fid = f.fid WHERE oid = 12416 ORDER BY f.fid in /srv/www/htdocs/localdrupal/includes/database.mysql.inc on line 172."

on every page load where an image is shown. Running update.php and selecting "1" in upload_image results in:

Update #1
* Failed: ALTER TABLE {upload_image} DEFAULT CHARACTER SET utf8

and
* user warning: Table 'drupal.upload_image' doesn't exist query: ALTER TABLE upload_image DEFAULT CHARACTER SET utf8 in /srv/www/htdocs/localdrupal/includes/database.mysql.inc on line 172.
* user warning: Table 'drupal.upload_image' doesn't exist query: SHOW FULL COLUMNS FROM upload_image in /srv/www/htdocs/localdrupal/includes/database.mysql.inc on line 172.

I use
MySQL version: 5.0.26
PHP version: 5.2.0
with mysqli.

Very strange.

Comments

drewish’s picture

drewish commented

was this after a clean install? if so could you try disabling and then uninstalling the module, then re-installing to see if there are any error messages creating the table?

Hetta’s picture

Hetta commented

Disabled upload_image, deleted it, downloaded the latest 5.x-1.x-dev, unzipped it, enabled the module - no error messages. I still can't run update#1 with the update.php, either.
I could create the thing manually, seeing that everything is in that install file ...

Hetta’s picture

Hetta commented

That is, no error message on installing the module.

I still get
"user warning: Table 'drupal.upload_images' doesn't exist query: SELECT f.*, u.* FROM upload_images u INNER JOIN files f ON u.fid = f.fid WHERE oid = 13251 ORDER BY f.fid in ..."

on every image node load (and once for every image on some gallery page loads).

Hetta’s picture

Hetta commented
Status: Active » Closed (fixed)

I'm closing this, as it looks like nobody else has this problem.