SwissCenter - Re: error message video search


SwissCenter

Main Menu

No account yet? Create one

Home

Forums

SwissCenter Forums

home | post reply | threaded view | help

Boardwalk :: Forum List

SwissCenter

Bugs Reports

klaasvaak

User

Posts: 517

error message video search - 2008/10/10 17:32 When performing a video search I get the following error message

Code:


 Warning: in_array() [function.in-array]: Wrong datatype for second argument in /volume1/web/svr/swiss/base/media.php on line 1161

No new files are added to the DB.

I noticed this just recently, so I think it has something to do with one of the latest SVN updates.

regards, Klaas
---------------------------------------------------------------------------
SwissCenter SVN 1101
Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP
Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15
Synology DS107+ (128), firmware: DSM 2.0-0702
Pinnacle SC200

| | The administrator has disabled public write access.

klaasvaak

User

Posts: 517

Re: error message video search - 2008/10/25 15:15 The problem is persistent, I cannot add video files to the SwissCenter DB. I get the following error message:

Code:


 Table 'swiss.array' doesnt exist

The log shows:

Code:


 
[2008.10.25 21:04:10] ------------------------------------------------------------------------------
[2008.10.25 21:04:10] Page Requested : http://192.168.1.2:8050/do_refresh.php?type=category&spec=44 by client (192.168.1.75)
[2008.10.25 21:04:10] Set system preference 'MEDIA_SCAN_CATEGORY' to '44'
[2008.10.25 21:04:10] Set system preference 'MEDIA_SCAN_TYPE' to 'MEDIA'
[2008.10.25 21:04:10] Set system preference 'MEDIA_SCAN_STATUS' to 'In behandeling'
[2008.10.25 21:04:10] Set system preference 'MEDIA_SCAN_CLEANUP' to 'NO'
[2008.10.25 21:04:10] Executing (via wget) URL in the background: media_search.php
[2008.10.25 21:04:11] Device: 
[2008.10.25 21:04:11] Array
[2008.10.25 21:04:11] (
[2008.10.25 21:04:11]     [last_seen] => 2008-10-25 21:04:11
[2008.10.25 21:04:11]     [ip_address] => 192.168.1.2
[2008.10.25 21:04:11]     [port] => 8050
[2008.10.25 21:04:11]     [device_type] => UNKNOWN
[2008.10.25 21:04:11]     [agent_string] => Wget/1.10.1
[2008.10.25 21:04:11]     [browser_x_res] => 
[2008.10.25 21:04:11]     [browser_y_res] => 
[2008.10.25 21:04:11]     [screen_x_res] => 1280
[2008.10.25 21:04:11]     [screen_y_res] => 720
[2008.10.25 21:04:11]     [browser_scr_x_res] => 1280
[2008.10.25 21:04:11]     [browser_scr_y_res] => 720
[2008.10.25 21:04:11]     [aspect] => 16:9
[2008.10.25 21:04:11]     [screen_type] => HDTV
[2008.10.25 21:04:11] )
[2008.10.25 21:04:11] 
[2008.10.25 21:04:11] ------------------------------------------------------------------------------
[2008.10.25 21:04:11] Page Requested : http://192.168.1.2:8050/media_search.php by client (192.168.1.2)
[2008.10.25 21:04:18] Loaded en language file into language
[2008.10.25 21:04:25] Loaded nl language file into language
[2008.10.25 21:04:26] Including movie parser file /volume1/web/svr/swiss/ext/parsers/movie/www.imdb.com.php
[2008.10.25 21:04:26] Including tv parser file /volume1/web/svr/swiss/ext/parsers/tv/www.TheTVDB.com.php
[2008.10.25 21:04:26] Set system preference 'MEDIA_SCAN_STATUS' to 'Actief'
[2008.10.25 21:04:26] Refreshing MOVIES database
[2008.10.25 21:04:26] Scanning : /volume1/video/reeksen/Indiana Jones/
[2008.10.25 21:04:26] Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] update Array set verified ='N' where dirname like'/volume1/video/reeksen/Indiana Jones/%'
[2008.10.25 21:04:26] Set system preference 'LAST_MEDIA_SCAN_UPDATE' to '1224961466'
[2008.10.25 21:04:26] Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] select count(*) from Array where location_id = 47 and verified='N'
[2008.10.25 21:04:26] Unable to query database: Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] select count(*) from Array where location_id = 47
[2008.10.25 21:04:26] Unable to query database: Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] Table 'swiss.array' doesn't exist
[2008.10.25 21:04:26] delete from Array where verified ='N' and dirname like '/volume1/video/reeksen/Indiana Jones/%'
[2008.10.25 21:04:26] Completed refreshing MOVIES database
[2008.10.25 21:04:26] Set system preference 'MEDIA_SCAN_STATUS' to 'Analyseren film details'
[2008.10.25 21:04:26] Checking online for extra movie information from www.imdb.com
[2008.10.25 21:04:26] Online movie check complete
[2008.10.25 21:04:26] Set system preference 'MEDIA_SCAN_STATUS' to 'Opruimen database'
[2008.10.25 21:04:29] Set system preference 'MEDIA_SCAN_STATUS' to 'Voltooid'
[2008.10.25 21:04:38] ------------------------------------------------------------------------------

What's going wrong? regards, Klaas
---------------------------------------------------------------------------
SwissCenter SVN 1108
Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP
Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15
Synology DS107+ (128), firmware: DSM 2.0-0702
Pinnacle SC200

| | The administrator has disabled public write access.

Pernod

Admin

Posts: 1504

Re: error message video search - 2008/10/25 15:40 Not sure what's happened to your installation but it looks as though one of either media.php or media_search.php have not updated correctly.

I'd suggest downloading these two files manually from SVN and overwriting your existing versions. Player : Netgear EVA700 & Popcorn A-100 (081224)
Server : Vista SP1 Home Premium (Simese 2.06, SwissCenter current SVN)
Spec : Intel C2Q Q6600, 2GB RAM, 2Tb storage.

| | The administrator has disabled public write access.

klaasvaak

User

Posts: 517

Re: error message video search - 2008/10/25 15:54 Nope, no results and same error message. In addition, when I try to adjust the movie details in the SwissCenter config screen I get the following:

Code:


 Unknown column 'MEDIA_TYPE_DVD' in 'where clause'

.

any ideas? Klaas
---------------------------------------------------------------------------
SwissCenter SVN 1108
Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP
Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15
Synology DS107+ (128), firmware: DSM 2.0-0702
Pinnacle SC200

| | The administrator has disabled public write access.

Pernod

Admin

Posts: 1504

Re: error message video search - 2008/10/25 16:41 MEDIA_TYPE_DVD no longer exists, it went when the DVD and Video types were merged. I still think one or more of your files is not consistant with the current SVN, no idea which though.

Only thing I can suggest is downloading the whole SVN and overwrite each file manually. Player : Netgear EVA700 & Popcorn A-100 (081224)
Server : Vista SP1 Home Premium (Simese 2.06, SwissCenter current SVN)
Spec : Intel C2Q Q6600, 2GB RAM, 2Tb storage.

| | The administrator has disabled public write access.

klaasvaak

User

Posts: 517

Re: error message video search - 2008/10/25 18:05 Hi Nigel,

Your suggestion worked out fine, problem solved. thanks, Klaas
---------------------------------------------------------------------------
SwissCenter SVN 1108
Simese 1.40 / PHP 4.4.4 / MySQL 4.0.21 / Windows XP
Apache 2.2.8 / PHP 5.2.6 / MySQL 5.0.51b / Linux Synology 2.6.15
Synology DS107+ (128), firmware: DSM 2.0-0702
Pinnacle SC200

| | The administrator has disabled public write access.

Boardwalk :: Forum List SwissCenter Bugs Reports

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.