recreating regimage table

[Xyzzy]

running vBulletin 3.6.11 Patch Level 1

accidentally dropped regimage table

i know it has 4 values but i cannot remember their name, type or length

can anyone post the structure so i can rebuild my table?

thanks!

[Xyzzy]

I'm glad I keep backups. I was able to create a new database and load a backup to it and browse the tables. Maybe the attached image will help someone someday.

What is weird is Imagemagick suddenly stopped working for me. All I get is a black image. The path is correct and my support people tell me it is working but all I get is a black image. I had the idea of clearing out the regimage table but I dropped it by accident. Oops!

If anyone has any idea why I get black Imagemagick images please let me know. GD works fine, and I have it set with all the options, so it is barely readable (!) but I think Imagemagick is supposed to be more bot proof.

Additional data:

$ convert -version
Version: ImageMagick 6.4.1 06/18/08 Q16 http://www.imagemagick.org
Copyright: Copyright (C) 1999-2008 ImageMagick Studio LLC

$ identify -version
Version: ImageMagick 6.4.1 06/18/08 Q16 http://www.imagemagick.org
Copyright: Copyright (C) 1999-2008 ImageMagick Studio LLC

[Xyzzy]

Some additional info:

In the picture below, Imagemagick is NOT set up, and does not show up as a viewable section under "Image Verification Library". (I removed the path to /usr/local/bin to do this.)

[Xyzzy]

In this picture, the path is correct, so Imagemagick shows up as a viewable section under "Image Verification Library". However, the image is black.

Again:

No changes to setup
No patches added
No OS changes
It worked fine for a very long time and then died a few days ago

[Xyzzy]

For the record, Imagemagick went wonky before I dropped and recreated the table. (That i why I was in there mucking with the table in the first place!)