Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

i can't setup SQL database

Quote Reply
i can't setup SQL database
Welcome to Links SQL Setup!
---------------------------
Loading SQL definitions and DBD::mSQL.
SQL.mSQL file loaded.
DBD::mSQL ... ok!

Creating Links: BSQL Database object.
Loading ... ok!

Connecting to the database.
Unable to connect! Error message:
DBSQL (23401): Fatal Error: Invalid DSN passed to connect: '' at /www/htdocs/tamilseek/links/admin/setup/setup.cgi line 240


Aborting.. please confirm your database connection information.


i am getting this error
Quote Reply
Re: i can't setup SQL database In reply to
alex
can you please, help me setting up the database?
Quote Reply
Re: i can't setup SQL database In reply to
i moved to new host, now i can't setup my table. can somebody please help me?

thanks
Quote Reply
Re: i can't setup SQL database In reply to
Creating tables ... (xxxx, xxxx, )
Creating table Build_Update ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Build_Update (
LinkID INT UNSIGNED NOT NULL PRIMARY KEY,
Hits SMALLINT UNSIGNED NOT NULL DEFAULT 0,
Votes SMALLINT UNSIGNED NOT NULL DEFAULT 0,
Rating SMALLINT UNSIGNED NOT NULL DEFAULT 0
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Build_Update. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... failed (Can't use an undefined value as a HASH reference at ../Links/DBSQL.pm line 1353.
)
Creating table Category ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Category (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Name CHAR(255) NOT NULL,
Description TEXT,
Meta_Description TEXT,
Meta_Keywords TEXT,
Header TEXT,
Footer TEXT,
Number_of_Links INT UNSIGNED NOT NULL DEFAULT 0,
Has_New_Links ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
Has_Changed_Links ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
Newest_Link DATE,

INDEX catndx (Name)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Category. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Creating Search Index ... failed (Search (32209): Fatal: new: Target Search table not defined, pass in target=tablename on creation. at ../Links/DBSQL.pm line 1526
) Saving def file ... ok!
Creating table CategoryAlternates ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE CategoryAlternates (
CategoryID INT UNSIGNED NOT NULL,
LinkID INT UNSIGNED NOT NULL,

INDEX catndx (CategoryID),
INDEX relndx (LinkID)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE CategoryAlternates. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table CategoryHierarchy ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE CategoryHierarchy (
CategoryID INT UNSIGNED NOT NULL,
SubCategoryID INT UNSIGNED NOT NULL,
Depth TINYINT UNSIGNED NOT NULL DEFAULT 1,

INDEX catndx (CategoryID, Depth)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE CategoryHierarchy. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table CategoryRelations ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE CategoryRelations (
CategoryID INT UNSIGNED NOT NULL,
RelatedID INT UNSIGNED NOT NULL,

INDEX catndx (CategoryID),
INDEX relndx (RelatedID)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE CategoryRelations. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Editors ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Editors (
Username CHAR(25) NOT NULL,
CategoryID INT UNSIGNED NOT NULL,

UNIQUE editorndx (Username, CategoryID)
)
. Reason: parse error at line 4 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Editors. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Hits_Track ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Hits_Track (
LinkID INT UNSIGNED NOT NULL,
IP CHAR(25) NOT NULL,
Created TIMESTAMP,

UNIQUE lndx (LinkID, IP),
INDEX cndx (Created)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Hits_Track. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Links ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Links (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Title CHAR(100) NOT NULL,
URL CHAR(150) NOT NULL,
Add_Date DATE NOT NULL,
Mod_Date DATE NOT NULL,
CategoryID INT UNSIGNED NOT NULL,
Description TEXT,
Contact_Name CHAR(50),
Contact_Email CHAR(50),
Hits SMALLINT UNSIGNED NOT NULL DEFAULT 0,
isNew ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isChanged ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isPopular ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
Rating DECIMAL (12, 2) NOT NULL DEFAULT 0,
Votes SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ReceiveMail ENUM ('Yes', 'No') NOT NULL DEFAULT 'Yes',
Status SMALLINT NOT NULL DEFAULT 0,
Date_Checked DATETIME DEFAULT "0000-00-00 00:00:00",

INDEX urlndx (URL),
INDEX catndx (CategoryID),
INDEX stndx (Status)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Links. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Creating Search Index ... failed (Search (32209): Fatal: new: Target Search table not defined, pass in target=tablename on creation. at ../Links/DBSQL.pm line 1526
) Saving def file ... ok!
Creating table Rate_Track ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Rate_Track (
LinkID INT UNSIGNED NOT NULL,
IP CHAR(25) NOT NULL,
Created TIMESTAMP,

UNIQUE lndx (LinkID, IP),
INDEX cndx (Created)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Rate_Track. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Search_Log ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Search_Log (
Term CHAR(25) PRIMARY KEY,
Count SMALLINT UNSIGNED NOT NULL DEFAULT 0,
Results SMALLINT UNSIGNED NOT NULL DEFAULT 0,
Last_Hit DATETIME DEFAULT "0000-00-00 00:00:00"
)
. Reason: Primary keys are obsolete. Use CREATE INDEX at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Search_Log. Reason: parse error at line 1 near "key DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Sessions ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Sessions (
ID BINARY(25) PRIMARY KEY,
Username CHAR(25) NOT NULL,
Created DATETIME NOT NULL ,
IP CHAR(25)
)
. Reason: parse error at line 3 near "ID BINARY" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Sessions. Reason: parse error at line 1 near "BINARY DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Subscribe ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Subscribe (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
Name CHAR(255) NOT NULL,
Email CHAR(255) NOT NULL,
Add_Date DATETIME DEFAULT "0000-00-00 00:00:00",
Add_By CHAR(100),

UNIQUE emailndx (Email)
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Subscribe. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Users ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Users (
Username CHAR(25) PRIMARY KEY,
Password BINARY(25) NOT NULL,
Email CHAR(50),
Validation CHAR(20),
Status ENUM ("Not Validated", "Registered", "Editor", "Administrator") NOT NULL DEFAULT "Not Validated",

INDEX sndx (Status)
)
. Reason: Primary keys are obsolete. Use CREATE INDEX at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Users. Reason: parse error at line 1 near "key DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Validate ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Validate (
ID INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
LinkID INT UNSIGNED,
Title CHAR(100) NOT NULL,
URL CHAR(150) NOT NULL,
Add_Date DATE NOT NULL,
Mod_Date DATE NOT NULL,
CategoryID INT UNSIGNED NOT NULL,
Description TEXT,
Contact_Name CHAR(50),
Contact_Email CHAR(50),
Hits SMALLINT UNSIGNED NOT NULL DEFAULT 0,
isNew ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isChanged ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
isPopular ENUM ('Yes', 'No') NOT NULL DEFAULT 'No',
Rating DECIMAL (12, 2) NOT NULL DEFAULT 0,
Votes SMALLINT UNSIGNED NOT NULL DEFAULT 0,
ReceiveMail ENUM ('Yes', 'No') NOT NULL DEFAULT 'Yes',
Status SMALLINT NOT NULL DEFAULT 0,
Date_Checked DATETIME DEFAULT "0000-00-00 00:00:00",
Mode ENUM ('Validate', 'Modify') NOT NULL DEFAULT 'Validate'
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Validate. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
Creating table Verify ... failed (DBSQL (32209): Fatal Error: Unable to execute query:
CREATE TABLE Verify (
LinkID INT UNSIGNED NOT NULL,
Status SMALLINT NOT NULL DEFAULT 0,
Date_Checked DATETIME DEFAULT "0000-00-00 00:00:00"
)
. Reason: parse error at line 3 near "int UNSIGNED" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 289
) Loading def file from SQL ... failed (DBSQL (32209): Fatal Error: Unable to execute query: DESCRIBE Verify. Reason: parse error at line 1 near "UNSIGNED DESCRIBE" at /www/htdocs/zaky/cgi/admin/setup/setup.cgi line 291
)
Saving def file ... ok!
All done!
Quote Reply
Re: i can't setup SQL database In reply to
Links SQL will not work with mSQL. It simply does not support enough SQL syntax to be practical. You'll need to switch to mysql.

Cheers,

Alex
Quote Reply
Re: i can't setup SQL database In reply to
You should really consider asking Alex to assist you in setting up your tables and also upgrading your database.

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
* Be sure to visit the Resource Center for FAQ's, Modifications and Extra Goodies!!
* Search Forums!
* Say NO to Duplicate Threads. :)
----------------------