Upgrade problem vBGallery 3.0 Beta 3 to version 3.0.

[Flateric]

Hi,
When trying a upgrade I have this problem:

Database error in vBulletin 4.0.7:

Invalid SQL:
DROP TABLE IF EXISTS ppgal_setting;

MySQL Error : Error on delete of './forum/ppgal_setting.MYI' (Errcode: 13)
Error Number : 6
Request Date : Wednesday, November 10th 2010 @ 11:47:02 AM
Error Date : Wednesday, November 10th 2010 @ 11:47:05 AM
Script : http://localhost/admincp/vbgallery_i...pgradesettings
Referrer : http://localhost/admincp/vbgallery_install.php
IP Address : 127.0.0.1
Username : admin
Classname : vB_Database_MySQLi
MySQL Version : 5.0.88


Any suggests?

Andrew

[Luciano]

well that is a basic read/write error in mysql..
check: MySQL :: MySQL 5.0 Reference Manual :: C.5.2.13 Can't create/write to file

if you read a little lower.. you will find:

If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set in the temporary directory:

but it can be something else...(specially on windows)
Like antivirus scanning mysql tmp directory etc. etc.
There are some hints posted by users on that page to work around..

Turning "off" the scanning of windows/temp folder in the anti-virus resolved the issue for me.

or...

If you are running Microsoft Security Essentials on Windows, here's a way to fix the issue.....

Luc

PS once you turned off all antivirus run that step again:
http://localhost/admincp/vbgallery_i...pgradesettings

(PS2: I assume you are running apache on windows as localhost)

[Flateric]

Hello Luc,
Just a read/write setting in the folder.
Thank you.
Andrew