New Fresh Install [added 2.3]

[elyk]

Trying to do a new install of vbgallery 2.2 to our vb 3.6.5. forum and as soon as the start installation is clicked we are getting this error;

Database error in vBulletin 3.6.4:

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 : Monday, April 23rd 2007 @ 03:57:01 PM
Script : http://www.xxxxxxxx.com/forum/adminc...ry_install.php
Referrer : http://www.xxxxxxx.com/forum/admincp...ry_install.php

Classname : vb_database

Line 18 shows:
define('CVS_REVISION', '$RCSfile: vbgallery_install.php,v $ - $Revision: 2.2 $');

[Zachariah]

Hello,
What version on MySQL are you running ?
I had another problem with a member (day or so ago) who had 5.x MySQL.

Content visible to verified customers only.

changes to:

Content visible to verified customers only.

He reported that once the double quote was on the next line all went fine.

forums\admincp\vbgallery_install.php

Content visible to verified customers only.

I have plans to change the syntax.

[elyk]

Thanks Zachariah,

MySQL 4.1.21

I will try what you posted and see how it goes.

[elyk]

Did the above changes and now when we run the install we get this:

Parse error: syntax error, unexpected T_STRING in /home/xxx/xxxxxx/forum/admincp/vbgallery_install.php on line 936

Line 936 shows:
SELECT imageid, imgid

[Zachariah]

Shoot me some ftp access and AdminCP via PM.
- Ill take a look @ whats going on.

[warrior]

I get the same error howe can I fix this plz ?

[Zachariah]

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

Content visible to verified customers only.

Kill the comma.

Content visible to verified customers only.

[warrior]

Originally Posted by Zachariah

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

Content visible to verified customers only.

Kill the comma.

Content visible to verified customers only.

sorry I dont have that to this version 2.2 I have download that from you howe shuld I do ????

[Shelby]

I'm also reciving the error:

Database error in vBulletin 3.6.4:

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 : Wednesday, May 2nd 2007 @ 12:04:21 AM
Script : http://www.yourmomma.com/forums/admi...ry_install.php
Referrer : http://www.yourmomma.com/forums/admi...ry_install.php
IP Address : 69.225.55.125
Username : YourMomma
Classname : vB_Database

Now I made the changes and removed the coma and drop down on the double quote. However after install now in the admincp, I no longer see a gallery link in the left hand column.

[Zachariah]

Originally Posted by Shelby

However after install now in the admincp, I no longer see a gallery link in the left hand column.

http://www.vbulletin.com/docs/html/u...up_admin_perms

Administrator permissions allow you to manage the amount of privileges each of your administrators has in the control panel. This has no effect on their permissions on the actual board.

AdminCP => Usergroups => Administrator Permissions
- [Edit Permissions]

[ x ] Can Administer Vbgallery