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  


PHP-Error when picturefolder should be shown - 2009/10/13 04:54 Hi,
since last update I have that problem.
If I click picures and then sorted by folders I get that errormessage PHP Warning: array_slice() expects parameter 1 to be array, boolean given in C:\ProgramData\Simese\Data\base\search.php on line 131 PHP Warning: join() [function.join]: Argument must be an array in C:\ProgramData\Simese\Data\base\search.php on line 142.

I already tried rename Picturefolder -> Look for new Media (SC think there are no media and pictureicon isnīt shown anymore) - then give Foilder old name and look again for new Media. then Sc founds media again, but still have that error if I try to show the pics.
PCH A-200
Windows 7 Ultimate
Simese 2.6.2 Beta
SwissCenter SVN newest version
  | | The administrator has disabled public write access.
Re: PHP-Error when picturefolder should be shown - 2009/10/14 01:45 same
problem with serial and movies. Then PHP fail
Code:

 Page Requested http://localhost:8080/video_search.php?sort=title by client (127.0.0.1) [2009.10.14 07:36:34] FUNCTION swiss.trim_article does not exist [2009.10.14 07:36:34]    select title displayyear info [2009.10.14 07:36:34]                                  from movies media   inner join media_locations ml on media.location_id ml.location_id [2009.10.14 07:36:34]             left outer join certificates media_cert on media.certificate media_cert.cert_id [2009.10.14 07:36:34]             inner join certificates unrated_cert on ml.unrated unrated_cert.cert_id  left outer join viewings v on (media.file_id v.media_id and v.user_id and v.media_type 3)  [2009.10.14 07:36:34]                                 where title != '0' and trim_article(title,''like '%'  AND IFNULL(media_cert.rank,unrated_cert.rank) <= 100 and ml.media_type=3 [2009.10.14 07:36:34]                              group by title [2009.10.14 07:36:34]                                having  1=[2009.10.14 07:36:34]                              order by trim_article(display,'') [2009.10.14 07:36:34] FUNCTION swiss.trim_article does not exist [2009.10.14 07:36:34]  select distinct upper(substring(trim_article(title,''),1,1)) display [2009.10.14 07:36:34]                                                 from movies media   inner join media_locations ml on media.location_id ml.location_id [2009.10.14 07:36:34]             left outer join certificates media_cert on media.certificate media_cert.cert_id [2009.10.14 07:36:34]             inner join certificates unrated_cert on ml.unrated unrated_cert.cert_id  left outer join viewings v on (media.file_id v.media_id and v.user_id and v.media_type 3)  [2009.10.14 07:36:34]                                                where title !='0' and trim_article(title,''like '%'  AND IFNULL(media_cert.rank,unrated_cert.rank) <= 100 and ml.media_type=3 [2009.10.14 07:36:34]                                             group by title [2009.10.14 07:36:34]                                               having  1=[2009.10.14 07:36:34]                                             order by 1 [2009.10.14 07:36:35Cached file exists for C:/ProgramData/Simese/Data//styles/Linux Part Deux-neu/index.jpg at (800 x 450) [2009.10.14 07:36:35Outputting JPEG image [2009.10.14 07:36:35Outputting cached file as JPG [2009.10.14 07:36:35Cached file exists for C:/ProgramData/Simese/Data//images/c.gif at (36 x 25) [2009.10.14 07:36:35Cached file exists for C:/ProgramData/Simese/Data//images/a.gif at (36 x 25) [2009.10.14 07:36:35Cached file exists for C:/ProgramData/Simese/Data//images/b.gif at (36 x 25)

PCH A-200
Windows 7 Ultimate
Simese 2.6.2 Beta
SwissCenter SVN newest version
  | | The administrator has disabled public write access.
Re: PHP-Error when picturefolder should be shown - 2009/10/15 05:46 The last update should've installed a new MySQL function which your log shows as not existing. Which version of MySQL are you using? Players : Netgear EVA700 | Popcorn A-100 (100516) | Popcorn A-200 (100208)
Webserver : Simese v2.6.4 | Apache 2.2.16 | PHP v5.2.12 | MySQL v5.1.32
Server : Windows 7 Home Premium 64bit
Spec : Intel C2Q Q6600 - 4GB RAM - 4TB HDD
AV : Pioneer VSX-915 | Samsung LE40C650
  | | The administrator has disabled public write access.
Re: PHP-Error when picturefolder should be shown - 2009/10/15 06:02 "mysql_upgrade_info" says Version 5.1.32
File Attachment:
File name: support_00018.log
File size:182117 bytes
PCH A-200
Windows 7 Ultimate
Simese 2.6.2 Beta
SwissCenter SVN newest version
  | | The administrator has disabled public write access.
Re: PHP-Error when picturefolder should be shown - 2009/10/15 12:59 Your problems are definitely caused by the last update failing to install correctly (other users haven't reported problems). The update creates a new MySQL stored function which requires MySQL 5.0 or later which you obviously have.

When was your database last created? The only thing I can think of is that even though your database server is 5.1 your database could still be 4.0 which will not allow the function to be created. You database may need upgrading. The simple solution is to re-create your database. If you are more technical minded then you could follow the instructions here to upgrade your database manually, without losing your current database.
Players : Netgear EVA700 | Popcorn A-100 (100516) | Popcorn A-200 (100208)
Webserver : Simese v2.6.4 | Apache 2.2.16 | PHP v5.2.12 | MySQL v5.1.32
Server : Windows 7 Home Premium 64bit
Spec : Intel C2Q Q6600 - 4GB RAM - 4TB HDD
AV : Pioneer VSX-915 | Samsung LE40C650
  | | 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