spacer
spacer search

SwissCenter

Search
spacer
Main Menu
Home
Documentation + FAQ
Screenshots
Downloads
Forums
Bug Tracking
History
Login
Username

Password

Remember me
?
No account yet?

Locations of visitors to this page

 
Home arrow Forums

SwissCenter Forums  


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

 Warningin_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.
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:10Page 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:10Set system preference 'MEDIA_SCAN_CATEGORY' to '44' [2008.10.25 21:04:10Set system preference 'MEDIA_SCAN_TYPE' to 'MEDIA' [2008.10.25 21:04:10Set system preference 'MEDIA_SCAN_STATUS' to 'In behandeling' [2008.10.25 21:04:10Set system preference 'MEDIA_SCAN_CLEANUP' to 'NO' [2008.10.25 21:04:10Executing (via wgetURL in the backgroundmedia_search.php [2008.10.25 21:04:11Device:  [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:11Page Requested http://192.168.1.2:8050/media_search.php by client (192.168.1.2) [2008.10.25 21:04:18Loaded en language file into language [2008.10.25 21:04:25Loaded nl language file into language [2008.10.25 21:04:26Including movie parser file /volume1/web/svr/swiss/ext/parsers/movie/www.imdb.com.php [2008.10.25 21:04:26Including tv parser file /volume1/web/svr/swiss/ext/parsers/tv/www.TheTVDB.com.php [2008.10.25 21:04:26Set system preference 'MEDIA_SCAN_STATUS' to 'Actief' [2008.10.25 21:04:26Refreshing MOVIES database [2008.10.25 21:04:26Scanning : /volume1/video/reeksen/Indiana Jones/ [2008.10.25 21:04:26Table '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:26select count(*) from Array where location_id 47 and verified='N' [2008.10.25 21:04:26Unable to query databaseTable 'swiss.array' doesn't exist [2008.10.25 21:04:26] Table 'swiss.array' doesn't exist [2008.10.25 21:04:26select count(*) from Array where location_id 47 [2008.10.25 21:04:26Unable to query databaseTable 'swiss.array' doesn't exist [2008.10.25 21:04:26] Table 'swiss.array' doesn't exist [2008.10.25 21:04:26delete from Array where verified ='N' and dirname like '/volume1/video/reeksen/Indiana Jones/%' [2008.10.25 21:04:26Completed refreshing MOVIES database [2008.10.25 21:04:26Set system preference 'MEDIA_SCAN_STATUS' to 'Analyseren film details' [2008.10.25 21:04:26Checking online for extra movie information from www.imdb.com [2008.10.25 21:04:26Online movie check complete [2008.10.25 21:04:26Set system preference 'MEDIA_SCAN_STATUS' to 'Opruimen database' [2008.10.25 21:04:29Set 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.
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.
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.
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.
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.
spacer
 

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.
spacer