need help cannot install vbgallery :(

[appsfinder]

error trying to install need help?

Database error in vBulletin 3.8.6:

Invalid SQL:

CREATE TABLE IF NOT EXISTS ppgal_setting (
varname varchar(100) NOT NULL default '',
grouptitle varchar(50) NOT NULL default '',
value mediumtext NOT NULL default '',
defaultvalue varchar(250) NOT NULL default '',
optioncode mediumtext NOT NULL,
displayorder smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (varname)
) TYPE=MyISAM;

MySQL Error : Can't create/write to file '/var/lib/mysql/mysite_forum/ppgal_setting.MYI' (Errcode: 2)
Error Number : 1

[Chuck S]

That issue is with the actual mysql tables on your server there is no issues with the query structure it is valid. Possibly try repairing all your database tables first.

[appsfinder]

ok tryed that got it installed but now get another error when i click on an image



Database error in vBulletin 3.8.6:

Invalid SQL:

SELECT categories.title AS cattitle, categories.description AS catdesc, images.imageid, username, images.userid, images.title, images.catid, dateline, images.description, keywords, filename, thumbname, width, height, extension, filesize, originalname, originalfilesize, originalwidth, originalheight, views, posts, valid, open, sticky, votenum, votetotal, options, catimage, catuserid, membercat, useroptions, adv_setting, customfields.*
L
L
L
FROM ppgal_images AS images
LEFT JOIN ppgal_categories AS categories ON (images.catid = categories.catid)
LEFT JOIN ppgal_customfields_entries AS customfields ON (images.imageid = customfields.imgid)
L
L
L
WHERE images.imageid = '4';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'L
L
FROM ppgal_images AS images
LEFT JOIN ppgal_categories AS categories O' at line 3
Error Number : 1064

please can you help

[Chuck S]

Please lets keep issues in one thread as I think you already have that opened elsewhere.