1054 - Unknown column 'value' in 'field list'

[Guest]

The following error is displayed when attempting to view the catalog.

 

I'm assuming that the error is coming from sessions.php.

 

1054 - Unknown column 'value' in 'field list'

 

select value from sessions where sesskey = '894b3a84892220cc5e45d681c431b098' and expiry > '1131593131'

 

using phpMyAdmin I took a look at the sessions table.

 

my sessions table has 4 fields:

sesskey varchar(32)

expiry int(11)

expireref varchar(64)

data (text)

 

What should it look like?

[Guest]

The following error is displayed when attempting to view the catalog.

 

I'm assuming that the error is coming from sessions.php.

 

1054 - Unknown column 'value' in 'field list'

 

select value from sessions where sesskey = '894b3a84892220cc5e45d681c431b098' and expiry > '1131593131'

 

using phpMyAdmin I took a look at the sessions table.

 

my sessions table has 4 fields:

sesskey varchar(32)

expiry int(11)

expireref varchar(64)

data (text)

 

What should it look like?

 

 

I found the problem. Installing tikiwiki deletes and redefines the sessions table with the added <expireref> field and replacing the <value> field with one called <data>.

 

Isn't there some kind of standard that all table names should be prefixed with a package name??? (hint to OSCommerse developers !!!)

 

Obviously the tikiwiki people don't believe in it either. SMF is a great example to follow. Each table name start with smf_. It's a pretty simple concept that allows package installation to share the same database.