Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Database layout

Quote Reply
Database layout
Hi

Have databases changed between dev 10 and 11 ? Because now I get this:

Failed to execute query: 'INSERT INTO Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,isChanged,Mod_Date,isPopular,isValidated,Add_Date,ID) VALUES ('TEST','A4 Startsiden','are@a4.no','0','0','0','Yes','http://www.a4.no','0','No','2000-10-27','No','No','2000-10-27',NULL)' Reason: Unknown column 'LinkOwner' in 'field list'

Are

Quote Reply
Re: Database layout In reply to
Yes... the "Username" field in the Links table is now "LinkOwner".

This is to address a problem with dynamic templates, when the logged in user is not the "Links.Username". There would be confusion -- whichever was defined LAST in the passed hash would be used.

I found the problem with the Auction plug-in I'm working on, trying to differentiate between User.Username and Links.Username. I fixed that by creating new objects for the Seller and Bidder, but it pointed out a problem which sites that are generated dynamically would have if they tried to customize content on each page -- which "username" would get used.

You can use MySQLMan to rename the column (I don't know if you can do it in the SQL monitor or not) then resync the def file in the properties area.

That should fix it. It's all new to me as well :)

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: Database layout In reply to
Thanks!

A simple rename fixed it.

Are