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

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

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?