Gossamer Forum
Home : Products : Gossamer Links : Discussions :

2 bugs in LSQL working with PostgreSQL

Quote Reply
2 bugs in LSQL working with PostgreSQL
Hello,

I found 2 bugs in LSQL working with PostgreSQL database:

1.- 'Full name' column doesn´t update: When I make changes in the name of one category or move the category from 'Browse' window en LSQL admin panel all seems to be done, but if I rebuild the directory or look into database I show the old values. For example:

I have this category tree:

- RootCat1

- RootCat1/Subcat1

- RootCat1/Subcat2

....

If I change the name or 'RootCat1' to 'RootCatX' and look into database I show this:

- RootCatX

- RootCat1/Subcat1

- RootCat1/Subcat2

....

Same if I try to move 'RootCat1' into another Category...

And this is a *big* problem... :-(

2.- Delete columns doesn´t work: When I try to delete column from LSQL admin panel:

Failed to execute query: '; BEGIN; LOCK TABLE Links; CREATE TABLE GTTemp05752653 ( ID int NOT NULL PRIMARY KEY ,Title varchar(100) NOT NULL ,URL varchar(255) NOT NULL DEFAULT '
http://',LinkOwner varchar(50) NOT NULL DEFAULT 'admin',Add_Date date NOT NULL ,Mod_Date date NOT NULL ,Description text ,Contact_Name varchar(255) ,Contact_Email varchar(255) ,Hits int NOT NULL ,isNew varchar NOT NULL DEFAULT 'No',isChanged varchar NOT NULL DEFAULT 'No',isPopular varchar NOT NULL DEFAULT 'No',isValidated varchar NOT NULL DEFAULT 'Yes',Rating float NOT NULL ,Votes smallint NOT NULL ,Status smallint NOT NULL ,Date_Checked datetime ,Timestmp timestamp ,Recommended int(11) ); INSERT INTO GTTemp05752653 ( ID,Title,URL,LinkOwner,Add_Date,Mod_Date,Description,Contact_Name,Contact_Email,Hits,isNew,isChanged,isPopular,isValidated,Rating,Votes,Status,Date_Checked,Timestmp,Recommended ) SELECT ID,Title,URL,LinkOwner,Add_Date,Mod_Date,Description,Contact_Name,Contact_Email,Hits,isNew,isChanged,isPopular,isValidated,Rating,Votes,Status,Date_Checked,Timestmp,Recommended FROM Links; DROP TABLE Links; ALTER TABLE GTTemp05752653 RENAME TO Links; COMMIT; ' Reason: ERROR: parser: parse error at or near "("

Any help? :-(

Thanks!

Subject Author Views Date
Thread 2 bugs in LSQL working with PostgreSQL avant 2020 Mar 10, 2003, 2:05 AM
Thread Re: [avant] 2 bugs in LSQL working with PostgreSQL
604 1948 Mar 18, 2003, 10:51 AM
Post Re: [TheStone] 2 bugs in LSQL working with PostgreSQL
avant 1927 Mar 22, 2003, 3:06 AM
Post New bug in LSQL working with PostgreSQL
avant 1891 Apr 6, 2003, 3:48 AM