vB Installation error

Yours Truly · May 5th, 2007, 04:23 AM

On the 1st step i get:

Quote:

Database error in vBulletin 3.6.5:

Invalid SQL:
CREATE TABLE ppgal_categories (
catid smallint(5) NOT NULL auto_increment,
styleid smallint(5) unsigned NOT NULL default '0',
title varchar(255) NOT NULL default '',
description text,
displayorder smallint(4) NOT NULL default '0',
hasimages smallint(3) unsigned NOT NULL default '0',
active smallint(3) unsigned NOT NULL default '0',
catuserid int(10) unsigned NOT NULL default '0',
allowusercats smallint(3) unsigned NOT NULL default '0',
parent smallint(5) unsigned NOT NULL default '0',
parentlist varchar(255) NOT NULL default '',
password varchar(100) NOT NULL default '',
catimage varchar(255) NOT NULL default '',
membercat smallint(3) unsigned NOT NULL default '0',
imagecount int(10) NOT NULL default '0',
postcount int(10) NOT NULL default '0',
lastimageid int(10) NOT NULL default '0',
lastimagetitle varchar(255) NOT NULL default '',
lastimageuserid int(10) unsigned NOT NULL default '0',
lastimageusername varchar(100) NOT NULL default '',
lastimagedateline int(10) unsigned NOT NULL default '0',
lastpostid int(10) unsigned NOT NULL default '0',
lastpostimagetitle varchar(255) NOT NULL default '',
lastpostuserid int(10) unsigned NOT NULL default '0',
lastpostusername varchar(100) NOT NULL default '',
lastpostdateline int(10) unsigned NOT NULL default '0',
options int(10) unsigned NOT NULL default '0',
useroptions int(10) unsigned NOT NULL default '0',
adv_setting text NOT NULL,
disext MEDIUMTEXT NOT NULL default '',
newimageemail varchar(255) NOT NULL default '',
newpostemail varchar(255) NOT NULL default '',
styleoverride smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (catid),
KEY parent (parent)
) TYPE=MyISAM;

MySQL Error : Table 'ppgal_categories' already exists
Error Number : 1050
Date : Saturday, May 5th 2007 @ 09:16:29 AM
Script : http://marmbi.com/admincp/vbgallery_install.php
Referrer : http://marmbi.com/admincp/vbgallery_install.php
IP Address : 81.77.74.63
Username : Dan
Classname : vB_Database

My Gallery folder is in my root but also are my forums. Is there anything i need to change to get this working?

Zachariah · May 5th, 2007, 07:57 AM

MySQL Error : Table 'ppgal_categories' already exists
States that the gallery is already installed. Are you trying to upgrade ?

ski-whiz · May 5th, 2007, 08:59 AM

If you are installing both vbulletin and vbgallery in the same folder, you are going to have issues.

Correct me if I'm wrong, but won't the index.php over right the other?

Yours Truly · May 5th, 2007, 09:29 AM

Im not trying to upgrade this is the 1st time i uploaded /gallery into my root and all the others normally?

Does this ned to be in /forums for it to function?

Zachariah · May 5th, 2007, 12:27 PM

I have my site set.
/root
/root/forums/
/root/gallery/

In the download of the gallery script pack.
- there is 2 folders "forums" and "gallery"

The content of the "forums" folder will need to be uploaded to /root/forums/ keeping in tact the directory structure and sub folders.

The "gallery" folder:
- can be renamed (ex: photos)
- uploaded parallel to the forums folder
- uploaded under the forums folder
- setup as a sub-domain

When you install the gallery make sure and fill out the correct PATH's and URL's to reflect how the gallery was uploaded.

@ Yours Truly

Quote:

MySQL Error : Table 'ppgal_categories' already exists

Tells be you ran the php install file from the AdminCP and have all the database changes needed for the gallery.

What errors are you getting in your when you view your gallery root ?

(IE: /gallery/ )

Yours Truly · May 5th, 2007, 01:48 PM

Quote:

Warning: chdir() [function.chdir]: No such file or directory (errno 2) in /mounted-storage/home34c/sub002/sc28242-WCVA/marmbi.com/gallery/gallery_global.php on line 56

Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /mounted-storage/home34c/sub002/sc28242-WCVA/marmbi.com/gallery/gallery_global.php on line 57

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/local/lib/php/') in /mounted-storage/home34c/sub002/sc28242-WCVA/marmbi.com/gallery/gallery_global.php on line 57

Thats what i get

And my structure is

/root <-- forums are here www.marmbi.com not www.marmbi.com/forums
/root/gallery

Does it need to be www.marmbi.com/forums for it to work?

Zachariah · May 5th, 2007, 02:04 PM

Rename:
gallery/gallery_config.php.new

To:
gallery/gallery_config.php

Edit:
gallery/gallery_config.php

Find:

Code:

Content visible to verified customers only.

Change to:

Code:

Content visible to verified customers only.

[save]

Yours Truly · May 5th, 2007, 04:12 PM

I still end up getting this =/

Quote:

Database error in vBulletin 3.6.5:

Invalid SQL:
CREATE TABLE ppgal_posts (
postid int(10) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
userid int(10) NOT NULL default '0',
username varchar(50) NOT NULL default '',
dateline int(10) NOT NULL default '0',
pagetext text NOT NULL,
imageid int(10) NOT NULL default '0',
visible smallint(3) unsigned NOT NULL default '0',
allowsmilie smallint(3) NOT NULL default '0',
iconid smallint(3) unsigned NOT NULL default '0',
showsignature smallint(3) NOT NULL default '0',
ipaddress varchar(15) NOT NULL default '',
PRIMARY KEY (postid),
KEY imageid (imageid),
KEY userid (userid),
KEY iconid (iconid),
) TYPE=MyISAM;

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 ') TYPE=MyISAM' at line 18
Error Number : 1064
Date : Saturday, May 5th 2007 @ 09:11:28 PM
Script : http://marmbi.com/admincp/vbgallery_install.php
Referrer : http://marmbi.com/admincp/vbgallery_install.php
IP Address : 81.77.74.63
Username : Dan
Classname : vB_Database

Yours Truly · May 6th, 2007, 11:36 AM

I tried uninstalling and the installing still no hope

Anyone?

Yours Truly · May 7th, 2007, 05:07 AM

Still no luck? Sorry to be a bother but i bought this product expecting it to work

Yours Truly · May 7th, 2007, 10:12 AM

Sorry to keep going on but any insights yet?

Zachariah · May 7th, 2007, 10:22 AM

Hello,
I will have an update soon. I left a comma at the end that needs to be removed.

forums\admincp\vbgallery_install.php

Line 1615

Code:

Content visible to verified customers only.

Kill the comma.

Code:

Content visible to verified customers only.

Yours Truly · May 7th, 2007, 10:31 AM

Worked a treat thanks a lot

Only thing was i had this at the top of all my pages through install

Warning: unserialize() expects parameter 1 to be string, array given in /admincp/vbgallery_install.php on line 45

Also i get

Quote:

Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /mounted-storage/home34c/sub002/sc28242-WCVA/marmbi.com/gallery/gallery_global.php on line 57

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/local/lib/php/') in /mounted-storage/home34c/sub002/sc28242-WCVA/marmbi.com/gallery/gallery_global.php on line 57

On my /gallery page but i think it's because my forum is in the root so i think i may be able to sort this one

Edit

I thought wrong lol any thought's on this?

Zachariah · May 7th, 2007, 12:56 PM

Take a look @ post # 7 in this thread

Yours Truly · May 7th, 2007, 01:01 PM

I swear i did that i must not have uploaded the edited one lol thanks again