PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.5.X (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-5-x/)
-   -   Database installation error (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-5-x/118913-database-installation-error.html)

dbembibre August 8th, 2005 12:27 AM

Database installation error
 
A fresh install under vb3.5 RC2

In the first step the installer say

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
CREATE TABLE adv_gallery_categories (
catid smallint(5) NOT NULL auto_increment,
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 '',
PRIMARY KEY (catid),
KEY parent (parent)
) TYPE=MyISAM;

MySQL Error : Table 'adv_gallery_categories' already exists
Error Number : 1050
Date : Monday, August 8th 2005 @ 07:36:01 AM
Script : http://www.bmwfaq.com/admincp/vbagallery_install.php
Referrer : http://www.bmwfaq.com/admincp/vbagallery_install.php
IP Address : xxx.xxx.xxx
Username : xxxx
Classname : vb_database

dbembibre August 8th, 2005 12:31 AM

Re: Database installation error
 
I delete by hand all tables called adv_gallery and can install as normal.
I cant understand if i never install vbGallery how the tables exist in my database ???
Exuse my broken English

Brian August 8th, 2005 11:35 AM

Re: Database installation error
 
The only thing I can figure is that you may have hit the refresh button or hit the continue button more than once when trying to install.


All times are GMT -5. The time now is 05:54 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