Welcome, Guest
Please Login or Register.    Lost Password?

new install: cannot browse directory
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: new install: cannot browse directory
#4408
new install: cannot browse directory 3 Months, 2 Weeks ago Karma: 0
Just did a new installation of 1.0 on a new server. I'm using 'Documents' as a symlink, pointing to a directory under /home, which has correct permissions. When I click the Browse button logged in as admin, I get this response:

: Invalid SQL: SELECT linkedto from folders where id = '1'
: 1054 (Unknown column 'linkedto' in 'field list')
Session halted.

I had previously used the same setup (symlink to the real documents directory) on a different server, with Owl 0.81, and it worked fine.

Any suggestions?

Thanks,

Bill
Bill Gurley
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4409
Re:new install: cannot browse directory 3 Months, 2 Weeks ago Karma: 28
Sounds like you are using an Older Owl Database or you loaded the wrong mysql-table.sql table.

B0zz

Here is what the folders table should look like...

Code:


CREATE TABLE folders (
  id int(4) NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  parent int(4) NOT NULL default '0',
  description text NOT NULL,
  security varchar(5) NOT NULL default '',
  groupid int(4) NOT NULL default '0',
  creatorid int(4) NOT NULL default '0',
  password varchar(50) NOT NULL default '',
  smodified datetime default NULL,
  linkedto int(4) default NULL,
  rss_feed int(4) default NULL,
  PRIMARY KEY  (id),
  KEY folder_parentid (parent)
) TYPE=MyISAM;



B0zz
Owl DEV Team
Moderator
Posts: 2220
graph
User Offline Click here to see the profile of this user
Gender: Male b0zzit Location: Ottawa, Ontario, Canada
The administrator has disabled public write access.
 
#4410
Re:new install: cannot browse directory 3 Months, 2 Weeks ago Karma: 0
OK, thanks.

Sorry, but I did something stupid that probably caused this. I backed up the database from within an old Owl 0.81 installation, and attempted to just do a restore to this one, running 1.0. Of course that failed with an error, so I assumed that it did not do anything.

Probably the best thing for me to do is to just dump this new database 'intranet', create a new one and use the installation script to set it up properly.

I know just enough to be dangerous.

Thanks,

Bill
Bill Gurley
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#4411
Re:new install: cannot browse directory 3 Months, 2 Weeks ago Karma: 0
OK, I dropped the bad database and started over. All is well now.

Thanks.

Bill
Bill Gurley
Fresh Boarder
Posts: 5
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1

Ad Block