SwissCenter - Re: PHP-Error when picturefolder should be shown


SwissCenter

Main Menu

No account yet? Create one

Home

Forums

SwissCenter Forums

home | post reply | threaded view | help

Boardwalk :: Forum List

SwissCenter

Bugs Reports

crazydogs
User

Posts: 60

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.

crazydogs
User

Posts: 60

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 display, year 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 = 1 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=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 = 1 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=1 
[2009.10.14 07:36:34]                                             order by 1
[2009.10.14 07:36:35] Cached file exists for C:/ProgramData/Simese/Data//styles/Linux Part Deux-neu/index.jpg at (800 x 450)
[2009.10.14 07:36:35] Outputting JPEG image
[2009.10.14 07:36:35] Outputting cached file as JPG
[2009.10.14 07:36:35] Cached file exists for C:/ProgramData/Simese/Data//images/c.gif at (36 x 25)
[2009.10.14 07:36:35] Cached file exists for C:/ProgramData/Simese/Data//images/a.gif at (36 x 25)
[2009.10.14 07:36:35] Cached 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.

Pernod

Admin

Posts: 2840

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.

crazydogs
User

Posts: 60

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.

Pernod

Admin

Posts: 2840

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.

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.