Version 3.31

Discuss and get help installing, using and configuring SiT!

Version 3.31

Postby stonej55 » Wed Nov 07, 2007 9:04 am

Hello

Updated to latest svn version. Run setup to upgrade schema.
Logged in and comes up with error :

Fatal error: Unknown column 'lastseen' in 'field list' in C:wampwwwsitincludesauth.inc.php on line 46

Thanks

Jeff
stonej55
SiT! Regular
SiT! Regular
 
Posts: 41
Joined: Sun Feb 01, 2009 9:49 pm

RE: Version 3.31

Postby ivanlucas » Wed Nov 07, 2007 11:25 am

Hi Jeff,

3.31 is alpha still and isn't ready for production use yet so there will be issues from time to time. In this case the issue is caused by a database schema change, but the setup script doesn't upgrade schemas between alpha/beta versions.

If you want to keep up with the alpha/beta versions, you'll need to keep an eye on the bottom of setup-schema.php and run the appropriate SQL commands as they get added to the file.

For this problem you'll need to run

ALTER TABLE `users` ADD `lastseen` TIMESTAMP NOT NULL ;

but there could be other schema changes, I'd have a look at the file and see if you need to run others.

Cheers,

Ivan

Ivan Lucas, Project Lead, Support Incident Tracker (SiT!) GPL. ......... Chat live on irc, #sit on freenode.
Help free software: Make a donation to the SiT! project or Join the Free Software Foundation as an Associate Member.
User avatar
ivanlucas
SiT! Developer
SiT! Developer
 
Posts: 981
Joined: Sun Feb 01, 2009 9:49 pm
Location: Derbyshire, UK

RE: Version 3.31

Postby stonej55 » Wed Nov 07, 2007 11:56 am

Hello,

Thats seems to have fixed that but i now get :

* Help
Warning: in_array() [function.in-array]: Wrong datatype for second argument in C:wampwwwsitincludeshtmlheader.inc.php on line 78

This is with all menu items, it changes line numbers, but all show the same message

Thanks

Jeff
stonej55
SiT! Regular
SiT! Regular
 
Posts: 41
Joined: Sun Feb 01, 2009 9:49 pm

RE: Version 3.31

Postby xerosis » Wed Nov 07, 2007 12:41 pm

Hi Jeff,

It looks like you are missing includes/strings.inc.php, you need to check that you have updated all of trunk/ and not just trunk/htdocs/.
User avatar
xerosis
SiT! Developer
SiT! Developer
 
Posts: 198
Joined: Sat Jan 24, 2009 10:36 pm

RE: Version 3.31

Postby stonej55 » Wed Nov 07, 2007 1:30 pm

Hello Kieran,

I have updated all the trunk, cleared the cache as well, just in case. Up to revision 1290

Thanks

Jeff
stonej55
SiT! Regular
SiT! Regular
 
Posts: 41
Joined: Sun Feb 01, 2009 9:49 pm

RE: Version 3.31

Postby ivanlucas » Wed Nov 07, 2007 2:03 pm

It looks as if your session isn't getting populated with permissions, though I don't know why.

Could you try going to logout.php first to clear any existing session?

Ivan
Ivan Lucas, Project Lead, Support Incident Tracker (SiT!) GPL. ......... Chat live on irc, #sit on freenode.
Help free software: Make a donation to the SiT! project or Join the Free Software Foundation as an Associate Member.
User avatar
ivanlucas
SiT! Developer
SiT! Developer
 
Posts: 981
Joined: Sun Feb 01, 2009 9:49 pm
Location: Derbyshire, UK

RE: Version 3.31

Postby stonej55 » Wed Nov 07, 2007 2:41 pm

Hello Ivan,

I have spoken to Kieran and run the additional db commands that are found in setup-schema.php. All now seems to be working. I will now start to play with the portal functionality and report back

Thanks

Jeff
stonej55
SiT! Regular
SiT! Regular
 
Posts: 41
Joined: Sun Feb 01, 2009 9:49 pm

RE: Version 3.31

Postby ivanlucas » Wed Nov 07, 2007 4:03 pm

Excellent! Thanks Jeff.

Ivan
Ivan Lucas, Project Lead, Support Incident Tracker (SiT!) GPL. ......... Chat live on irc, #sit on freenode.
Help free software: Make a donation to the SiT! project or Join the Free Software Foundation as an Associate Member.
User avatar
ivanlucas
SiT! Developer
SiT! Developer
 
Posts: 981
Joined: Sun Feb 01, 2009 9:49 pm
Location: Derbyshire, UK


Return to Installing, Configuring and Using SiT!

Who is online

Users browsing this forum: No registered users and 0 guests

cron