Morning!
With any luck someone will be able to narrow this problem down for me. I'm no prel programmer, and what I could find on the news groups hasn't help me, or I've not been able to interrigate the answer enought to find out how to fix it...
When trying to add a category, I get the following error messages...
Category: Add Record Failed
--- Start Flood ---
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)
GT::SQL::Driver::ODBC::sth (6360): Executing query: SELECT ID FROM lsql_Category WHERE FatherID = 0 AND Name = 'test' from Links::Category::can_add at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 101 GT::SQL::Driver::ODBC::sth (6360): Executing 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 ('test','','','2003-06-27 10:16:32','','test','','','No',0,'No','test','',0) from Links::Category::_plg_add at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 54 GT::SQL::Table (6360): 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) at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/GT/SQL/Driver/ODBC.pm line 419. GT::SQL::Driver::ODBC::sth (6360): Executing query: SELECT DISTINCT Full_Name, ID FROM lsql_Category from Links::Category::HTML::disp_fatherid_form at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 590
--- End Flood ----
There you have it. Any guru's out there want to take a stab at this one? I would appreciate it!
Scampi.
-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
With any luck someone will be able to narrow this problem down for me. I'm no prel programmer, and what I could find on the news groups hasn't help me, or I've not been able to interrigate the answer enought to find out how to fix it...
When trying to add a category, I get the following error messages...
Category: Add Record Failed
--- Start Flood ---
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)
GT::SQL::Driver::ODBC::sth (6360): Executing query: SELECT ID FROM lsql_Category WHERE FatherID = 0 AND Name = 'test' from Links::Category::can_add at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 101 GT::SQL::Driver::ODBC::sth (6360): Executing 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 ('test','','','2003-06-27 10:16:32','','test','','','No',0,'No','test','',0) from Links::Category::_plg_add at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 54 GT::SQL::Table (6360): 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) at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/GT/SQL/Driver/ODBC.pm line 419. GT::SQL::Driver::ODBC::sth (6360): Executing query: SELECT DISTINCT Full_Name, ID FROM lsql_Category from Links::Category::HTML::disp_fatherid_form at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Category.pm line 590
--- End Flood ----
There you have it. Any guru's out there want to take a stab at this one? I would appreciate it!
Scampi.
-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Category: Add Record Failed