SwissCenter - Re: database error


SwissCenter

Main Menu

No account yet? Create one

Home

Forums

SwissCenter Forums

home | post reply | threaded view | help

Boardwalk :: Forum List

SwissCenter

Linux Related

fizze

User

Posts: 26

database error - 2008/09/28 08:21 When I navigate to browse video by title or actor, swisscentre bails on me with a "database error".
This happens regardless of the client I use.

The funny thing is that the first page when I browse by title shows up alright, but when I try to navigate further I get the error.
The loglevel 9 didn't show anything, neither did the php error log.

Funny thing is that this just occurs for movies, and not for TV series (which are a different category altogether). TV series work like a charm

Also, browsing videos by filesystem works fine.

I've read that in one case it was a problem with a cookie setting in php.ini, which isn't set for me. I'm using lampp on top of ubuntu 8.04 by the way, and am running the latest dev build of swisscenter.

| | The administrator has disabled public write access.

fizze

User

Posts: 26

Re: database error - 2008/09/30 15:03 Well, I had some time to tinker with it, here's what I found out:

The functio
function search_hist_most_recent()
{
# if (count($_SESSION["history"]) == 0)
# page_error(str('DATABASE_ERROR'));

return $_SESSION["history"][count($_SESSION["history"])-1];
}

Bails in the first if. When I comment it out everything works as expected.

As this was also appearing on my Showcenter 200, I guess the sanity check was a little overzealous

It's also working fine on my showcenter now.

I guess this http://tools.assembla.com/swiss/changeset/673 should be amended.

| | The administrator has disabled public write access.

Pernod

Admin

Posts: 1335

Re: database error - 2008/10/05 07:56 It could be that you PHP session has a low timeout period (check php.ini), in which case the $_SESSION variable will be being reset. Player : Netgear EVA700 & Popcorn A-100 (081106)
Server : Vista SP1 Home Premium (Simese 2.07, SwissCenter current SVN)
Spec : Intel C2Q Q6600, 2GB RAM, 1Tb storage.

| | The administrator has disabled public write access.

fizze

User

Posts: 26

Re: database error - 2008/10/06 12:37

Code:


 session.cookie_lifetime = 0
session.gc_maxlifetime = 1440

I don't think so.
I've installed standard lampp, and other than upping the PHP memory limit, I didn't change anything. So I'd at least expect it's half-decently configured defaults.

Are there any other variables I should check?

| | The administrator has disabled public write access.

Pernod

Admin

Posts: 1335

Re: database error - 2008/10/06 12:54 The session details are stored in the Session subfolder of wherever your php.exe is installed.

Can you check that this exists and that it contains a recent session file? Player : Netgear EVA700 & Popcorn A-100 (081106)
Server : Vista SP1 Home Premium (Simese 2.07, SwissCenter current SVN)
Spec : Intel C2Q Q6600, 2GB RAM, 1Tb storage.

| | The administrator has disabled public write access.

fizze

User

Posts: 26

Re: database error - 2008/10/07 13:40 Yes, sessions are saved to /tmp.
I just logged on and see a sess* file now. size is about 100k. So it looks alright.

When I naviagte in swisscenter I can see the mtime of the file is being updated.
I haven't waited 30 minutes now, but 10. And the file is still there. So it looks like everything is alright there.

It's not like I've tried to exploit a few options there.

| | The administrator has disabled public write access.

fizze

User

Posts: 26

Re: database error - 2008/10/08 14:36 Just updated to the recent SVN. Same game there.

The weird thing is that for TV series browsing works fine. Only for Videos is it broken for me.
applying the same "patch" as above fixes it for me.... *whistles*

| | The administrator has disabled public write access.

Boardwalk :: Forum List SwissCenter Linux Related

Simpleboard Forum Component 1.1.0 Stable
Two Shoes Mambo Factory

Screenshots

www.flickr.com

This is a Flickr badge showing public photos from swisscenter. Make your own badge here.

Mambo is Free Software released under the GNU/GPL License.