I have just installed LinksSQL on a Windows 2000 server, installed DBI and DBD::ODBC using ppm, created the DSN to connect to the Microsoft2000 SQL server. The problem that I am receiving now is when I try and add a category this is the message that I receive.

Failed to execute query: 'INSERT INTO lsql_Category (Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Changed_Links,Full_Name,Meta_Keywords,FatherID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1)

Any ideas???

Could you enable debugging in Setup > Misc Options, and then post the entire error message?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Can you try doing a trace, I think you need:

SET TRACE_ON=tracefile

Hi rhowell

Have you got a solution to your add cat problem. If so, would you be so kind to share the solution with me. I'm receiving:

Failed to execute query: 'INSERT INTO lsql_Category (Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Changed_Links,Full_Name,Meta_Keywords,FatherID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1)

It appears to be exactly the same error message you received.

cheers
helgi

PS for the veterans: The entire error message:

GT::SQL::Driver::ODBC::sth (2000): Executing query: SELECT ID FROM lsql_Category WHERE FatherID = 0 AND Name = 'Medier' from

Links::Category::can_add at d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 101 GT::SQL::Driver::ODBC::sth (2000): Executing

query: INSERT INTO lsql_Category

(Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Cha

nged_Links,Full_Name,Meta_Keywords,FatherID) VALUES ('bla','','default','2003-02-25

12:28:51','bla','Medier','footer.txt','header.txt','No',0,'No','Medier','bla',0) from Links::Category::_plg_add at

d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 54 GT::SQL::Table (2000): Failed to execute query: 'INSERT INTO lsql_Category

(Description,Newest_Link,Category_Template,Timestmp,Meta_Description,Name,Footer,Header,Has_New_Links,Number_of_Links,Has_Cha

nged_Links,Full_Name,Meta_Keywords,FatherID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)' Reason: [Microsoft][ODBC SQL Server Driver]Invalid

character value for cast specification (SQL-22018)(DBD: st_execute/SQLExecute err=-1) at

d:\www2\asp.stiften\cgi-bin\links/admin/GT/SQL/Driver/ODBC.pm line 395. GT::SQL::Driver::ODBC::sth (2000): Executing query: SELECT

DISTINCT Full_Name, ID FROM lsql_Category from Links::Category::HTML::disp_fatherid_form at

d:\www2\asp.stiften\cgi-bin\links/admin/Links/Category.pm line 590

Same here, what host are you using? I get the same error message form doing the same thing. I have just installed LinksSQL onto a Netcentra host. If has a solution to this problem, then please post.
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------

This one has me as well.

Any ideas?