manolo

Installing glossary 1.5 is going good and i think it works well too, but... when a user at the frontend want to check his items out, this message appears;

Notice: Unknown column 'checked_out_time' in 'field list' in /***/****/public_html/test/includes/database.php on line 184
Checked out items have now been all checked in

It only appears when ive got glossary 1.5 installed, cause when i uninstall it, the error goes/is away/gone...

Any advice?

anthonyaykut

I have had the same problem, twice -- it seems that field "checked_out_time" is missing from the DB for the two components I have had...

1) glossary
2) akostaff

So I fired up PHPmyAdmin - first found a table that does have this field and extracted the data type... then:

ALTER TABLE `mos_glossary` ADD `checked_out_time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ;

to add the field to the glossary table

ALTER TABLE `mos_akostaff` ADD `checked_out_time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ;

to add the field to the akostaff table

et voila, errors are gone

Hope this helps everybody!

Regards,
Anthony Aykut

LastBoyscout

Thanks for the Tip! I Had the same problems with 'PartyStaff'. Adding that extra field solved them

manolo

Wow, so your solution works... but im a newbie at phpadmin, can any of you be a bit more specific what to do?

What field to delete/add for example?

Thx!

anthonyaykut

Geen probleem - assuming you have access to PHPmyAdmin:

1) Fire up PHPmyAdmin, select your DB
2) Click on SQL tab on the top, right
3) In the box "Draai SQL query/queries op database xxx", type (or cut/paste):

ALTER TABLE `mos_glossary` ADD `checked_out_time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ;

4) Click on Start
5) You will get a message that the field was added (or similar)
6) Et voila, errors are gone
7) Let me know if this works for you...

Regards/Mvg
Anthony Aykut

manolo

Thx!!! or should I say:

Hartstikke Bedankt