Error on installation

[MorrisMcD]

I appologize I dont have the original error... But this was the thing in the first error that caused it. Luckily I had it copied to search for a resolution

INSERT INTO phrasetype (phrasetypeid, fieldname, title, editrows) VALUES (574, 'adv_links', 'vBadvanced Links Directory', 3);

Now when I try to go to the vbalinks_install.php, I get the following..

Database error in vBulletin 3.5.3:

Invalid SQL:

CREATE TABLE links (
linkid int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
url varchar(255) NOT NULL default '',
catid smallint(5) unsigned NOT NULL default '0',
description text NOT NULL,
keywords varchar(255) default NULL,
views int(10) NOT NULL default '0',
posts int(10) unsigned NOT NULL default '0',
valid smallint(5) NOT NULL default '0',
open smallint(3) unsigned NOT NULL default '0',
notes varchar(255) NOT NULL default '',
sticky smallint(3) unsigned NOT NULL default '0',
username varchar(50) default NULL,
dateline int(10) unsigned NOT NULL default '0',
lastupdated int(10) unsigned NOT NULL default '0',
userid int(10) unsigned NOT NULL default '0',
suspended smallint(3) NOT NULL default '0',
votenum smallint(5) unsigned NOT NULL default '0',
votetotal smallint(5) unsigned NOT NULL default '0',
lastpostdateline int(10) unsigned NOT NULL default '0',
lastpostuserid int(10) unsigned NOT NULL default '0',
lastpostusername varchar(255) default NULL,
PRIMARY KEY (linkid),
FULLTEXT KEY name (name),
FULLTEXT KEY description (description),
FULLTEXT KEY keywords (keywords),
KEY linkid (linkid,suspended,valid,dateline)
) TYPE=MyISAM;

MySQL Error : Table 'links' already exists
Error Number : 1050
Date : Sunday, February 5th 2006 @ 03:07:10 AM
Script : http://forums.cincybengals.com/admincp/vbalinks_install.php
Referrer : http://forums.cincybengals.com/admincp/vbalinks_install.php
IP Address : 10.9.85.7
Username : Brian
Classname : vB_Database

I am running vB 3.5.3, MySQL 4.1.16, and PHP 5.1.2

This site is not live.. I am getting my new server up and running offline before I import all the data...

Suggestions? Please? :(

[MorrisMcD]

Strangely enough my sql service completely quit responding.. I rebooted the system, and was able to get the choice to install again. Same error. I then still got the option to install, so I uninstalled... I then reinstalled and it worked fine.. I changed nothing :shrug:

Anyway.

I am having one small issue now.. All the images are pointing to the wrong directory. For example...

http://forums.cincybengals.com/links/images/statusicon/forum_old.gif

When it should be

http://forums.cincybengals.com/images/statusicon/forum_old.gif

I could fix this easily with another copy of the images it uses, but it also is pointing every link, such as the links on the navbar, with that extra 'links' folder.

Any ideas how to fix this? I would glady rename the /links/index.php and move it and the rest of it's contents into the root if that will fix this issue. Would that be recommended or is there an easier way?


*EDIT* Appologies but I did find the answer to my own question...
http://www.vbadvanced.com/forum/showthread.php?t=13516

But that still doesnt explain the images not showing up which I did reenter the path during installation and then when I did a reinstall option for just updating image paths, the ones missing previously were showing correctly

[MorrisMcD]

Ok.. Disregard everything... As soon as I went straight to the styles and put full paths in for all those, everything was fine...

You may want to consider making a sticky in each forum to the faq forum for more awareness.. I kept seeing you mention it in dif threads, but never a link and it took me a min to realize it was at the root of the entire board..