PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.7x / 3.8x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-7x-3-8x/)
-   -   need help cannot install vbgallery :( (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-7x-3-8x/143516-need-help-cannot-install-vbgallery.html)

appsfinder August 2nd, 2010 06:29 AM

need help cannot install vbgallery :(
 
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 August 2nd, 2010 09:12 AM

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 August 2nd, 2010 10:15 AM

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 August 2nd, 2010 10:18 AM

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


All times are GMT -5. The time now is 07:35 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97