Database Error when uploading files

dcpaq2 · May 27th, 2006, 11:17 AM

Group,

My site was off line for a while and I just restored my site files and database and I was trying to upload a file to the gallery for the first time since restoring the site yesterday and I received this database error message. (Please see attached image)

The files will upload and display but I keep getting this error everytime I try to upload and I notice that everytime I upload a file the duplicate entry number increases as well. You can see in the image that I have uploaded 4 times so far.

I orginally saved all my files and did a database restore as my site was off line for a little while, and then I changed servers and uploaded my site files and did a database restore. But now I am receiving errors.

I have updated the server path to the new servers settings.

I am using VB Gallery 1.0.2 with Vbulletin 3.5.4, does anyone have any idea what might be wrong or not setup correctly?

Thanks

Doug

Zachariah · May 27th, 2006, 02:09 PM

Take a look @ your adv_gallery_images table via. phpMyAdmin.

Browse the table and find out what the last imageid is on the last record added.

Hit: Operations Tab
At the bottem of the page is AUTO_INCREMENT under table options section.

Add 1 to your last / largest imageid and save.

EX: If your last record has imageid 2000 then place 2001 in the AUTO_INCREMENT field.

Save

dcpaq2 · May 27th, 2006, 02:18 PM

Is this something that I have to do Everytime I have to restore my database?

Doug

Update... It will not let me browse that table. Only certain tables I am able to browse and thats not one of them.

Zachariah · May 27th, 2006, 02:48 PM

I have restored my DB many times w/o problems.
Shoot me some FTP access via PM I'll see what I can do.

dcpaq2 · May 27th, 2006, 03:51 PM

Quote:

Originally Posted by Zachariah

I have restored my DB many times w/o problems.

Yes I understand that, But thats restoring just the database, I had restored my whole entire site, database, folders, files and etc.

Doug

Chuck S · May 27th, 2006, 05:22 PM

Have you done a repair on the tables via phpmyadmin?

dcpaq2 · May 27th, 2006, 06:20 PM

Quote:

Originally Posted by Chuck S

Have you done a repair on the tables via phpmyadmin?

Chuck,

We have found the problem and Zachariah is aware of the problem and indicated he would be working on a fix soon.

Thanks

Doug

dcpaq2 · October 13th, 2006, 07:47 PM

Zachariah,

Have you had a chance to fix this?

Doug

Zachariah · October 13th, 2006, 08:31 PM

Thanks for the bump

- I lost this thread.

I am on it Sir. I'll post a fix when I make it, and include the fix in further builds.

dcpaq2 · October 13th, 2006, 08:41 PM

Your very welcome Zachariah; Cool, Sounds great!

Thank you Thank you very much!

Doug