PhotoPost Community - Upgrade problem vBGallery 3.0 Beta 3 to version 3.0.

PhotoPost Community (http://www.photopost.com/forum/)

- Installs and Upgrade - vBulletin 4 (http://www.photopost.com/forum/installs-upgrade-vbulletin-4/)

- - Upgrade problem vBGallery 3.0 Beta 3 to version 3.0. (http://www.photopost.com/forum/installs-upgrade-vbulletin-4/144470-upgrade-problem-vbgallery-3-0-beta-3-version-3-0-a.html)

Upgrade problem vBGallery 3.0 Beta 3 to version 3.0.

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

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:

Quote:

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..

Quote:

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

or...

Quote:

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)

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