Log in | Register | Lost password

Bottom
Mediashare not running under Zikula 1.0
  • Posted: 10.06.2008, 17:17
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Just upgraded a site from PostNuke 0.8 RC4 to Zikula 1.0. Everything upgraded without a problem EXCEPT Mediashare and Pagesetter. Content 2.01 ran just fine.

    When trying to run Mediashare 3.2.0 after installing, I received the following error message:


    Quote

    /home/brother/public_html/modules/mediashare/pnuserapi.php(132): "getAlbum" failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , ms_template, ms_p' at line 10 while executing: SELECT ms_id, ms_ownerid, UNIX_TIMESTAMP(ms_createddate), UNIX_TIMESTAMP(ms_modifieddate), ms_title, ms_summary, ms_description, ms_keywords, ms_topicId, , , ms_template, ms_parentAlbumId, ms_viewkey, ms_mainmediaid, ms_thumbnailsize, ms_nestedsetleft, ms_nestedsetright, ms_nestedsetlevel FROM pn_mediashare_albums LEFT JOIN ON ms_topicId = WHERE ms_id = 1


    The configuration of the server that this site is running on is:
    cPanel Build 11.23.3-RELEASE 25133
    Operating system Linux
    Kernel version 2.6.9-023stab043.1-enterprise
    Machine Type i686
    Apache version 2.2.8 (Unix)
    PERL version 5.8.8
    PHP version 5.2.5
    MySQL version 5.0.45-community
    Zikula version 1.0

    I even completely uninstalled Mediashare and re-installed it, but that did not seem to help at all. This ran perfect on PostNuke 0.8 RC4 before I upgraded to Zikula 1.0.

    Any suggestions?
    Top
  • Posted: 10.06.2008, 21:07
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Okay, I think I solved this problem. First, instead of just changing out all of the old command files and keeping the previous database I had, I created an entirely new database. This overcame one problem, but there was still a second problem. During the new installation, I received an error message telling me that Mediashare could not be installed because it required the "Topics" module to run....but the Topics module is not used in Zikula 1.0. Consequently, after the installation was successfully (almost) completed, I copied the Topics module from PostNuke 0.8 RC4 into my new Zikula 1.0 installation. I then went into the Modules module, installed the Topics module and then the mediashare module. Now it appears that all works correctly.

    Note to J?rn: Since the "Topics" module is not used in Zikula 1.0, you may want to go back and update Mediashare so that it no longer requires the Topics module. Possibly replace the use of topics with the Zikula categories? While your at it, possibly do something about the pop-ups. If the "SafeHTML output filter" is on, the code for the JavaScript pop-ups doesn't work.
    Top
  • Posted: 11.06.2008, 09:26
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0

    Quote

    Since the "Topics" module is not used in Zikula 1.0, you may want to go back and update Mediashare so that it no longer requires the Topics module. Possibly replace the use of topics with the Zikula categories?


    Not if I want to maintain backwards compatibility with .76x.
    Top
  • Posted: 11.06.2008, 10:02
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Then if you are going to require that the "Topics" module be included in a site in order to run Mediashare, at least update the instructions both on the website and in an included DOC file letting people know that they must install the "Topics" file first before Mediashare can be installed.
    Top
  • Posted: 12.06.2008, 06:10
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    Yea, I had The Same Problem.

    But Wow, With Categories, This Would Be Really Sweet. For now the Topics Mod is ok,

    Consider the only folks who have the Topics Module are folks with one of the .08 release candidates(?), or that they will ask where to get the Topics module ENDLESSLY if they are new to Zikula. A friendly word, or package the topics mod with the release, eh it is up to you.

    This is a nice module, good job.
    Top
  • Posted: 13.06.2008, 14:39
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0

    TakeIT2

    ... or that they will ask where to get the Topics module ENDLESSLY if they are new to Zikula...


    I asked the same on the German Postnuke site. It can now be downloaded from
    http://support.pn-cms.de/module-Downloads-view-cid-501-start-0.htm
    Top
  • Posted: 03.10.2008, 18:13
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    I have the same problem mentioned in the original post. Judging by the resolution it seems like somewhere in the code is something like:

    Code

    if zikula_version < 1 then

    set db_prefix = "pn_"

    else

    set db_prefix = "zk_"

    endif


    That is the only real change between RC4 and 1.0 is the default db prefix (an upgrade between the versions would not change that prefix) but seeing as the problem appears when upgrading that would make sense.
    Top
  • Posted: 11.11.2008, 23:53
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0
    This problem still seems to exist. I have tried to download the mediashare from several links now and always get the same result. Install not possible because of:

    ....\modules\mediashare\pninit.php(35): Mediashare requires Topics module to be installed

    There is mention of a version 3.4 in one of the update comments but where do we download that as only 3.2 seems to be available from downloads. This link also spoke of the topic module no longer being required.

    I have just followed the link as indicated above

    Also, I tried to download and install the TopicAccess module, but although this installed it is complaining

    ...modules\TopicAccess\pnadminapi.php(135): "getTopics" failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' FROM while executing: SELECT , FROM ORDER BY

    So mediashare will still not install. I assume this error may have something to do with it.

    Any advise would be great, as I am very excited by the potential here

    :-) 13/11/08 I have just installed the Topic module from the German site mentioned in the previous entry. It worked a treat and I now have mediashare installed without any errors!!!



    edited by: ian543, Nov 13, 2008 - 03:40 AM
    Top
  • Posted: 15.11.2008, 19:14
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0

    Quote

    ....\modules\mediashare\pninit.php(35): Mediashare requires Topics module to be installed


    This is *not* the same as the TopicAccess module. Mediashare is referering to the core Topic module which is available as an add-on to Zikula somewhere. If not as a download then directly through SVN (code.zikula.org).
    Top
  • Posted: 16.01.2009, 17:38
     
    Converted
    rank:
    12
    registered:
     March 2009
    Status:
    offline
    last visit:
    Posts:
    0

    Colombo

    TakeIT2

    ... or that they will ask where to get the Topics module ENDLESSLY if they are new to Zikula...


    I asked the same on the German Postnuke site. It can now be downloaded from
    http://support.pn-cms.de/module-Downloads-view-cid-501-start-0.htm


    New URL for topics module download:
    http://support.…opic-28731.htm

    Top

Template courtesy of Designs By Darren.