Mediashare not running under Zikula 1.0

Topic:	Mediashare not running under Zikula 1.0
Converted 12 Posts: 0 Posted: 10.Jun 2008 - 17:17	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?
Converted 12 Posts: 0 Posted: 10.Jun 2008 - 21:07	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.
Converted 12 Posts: 0 Posted: 11.Jun 2008 - 09:26	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.
Converted 12 Posts: 0 Posted: 11.Jun 2008 - 10:02	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.
Converted 12 Posts: 0 Posted: 12.Jun 2008 - 06:10	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.
Converted 12 Posts: 0 Posted: 13.Jun 2008 - 14:39	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
Converted 12 Posts: 0 Posted: 3.Oct 2008 - 18:13	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.
Converted 12 Posts: 0 Posted: 11.Nov 2008 - 23:53	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
Converted 12 Posts: 0 Posted: 15.Nov 2008 - 19:14	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).
Converted 12 Posts: 0 Posted: 16.Jan 2009 - 17:38	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

Topic:

Mediashare not running under Zikula 1.0

Converted
avatar

12
Posts: 0

Posted:
10.Jun 2008 - 17:17

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?

Converted
avatar

12
Posts: 0

Posted:
10.Jun 2008 - 21:07

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.

Converted
avatar

12
Posts: 0

Posted:
11.Jun 2008 - 09:26

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.

Converted
avatar

12
Posts: 0

Posted:
11.Jun 2008 - 10:02

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.

Converted
avatar

12
Posts: 0

Posted:
12.Jun 2008 - 06:10

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.

Converted
avatar

12
Posts: 0

Posted:
13.Jun 2008 - 14:39

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

Converted
avatar

12
Posts: 0

Posted:
3.Oct 2008 - 18:13

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.

Converted
avatar

12
Posts: 0

Posted:
11.Nov 2008 - 23:53

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

Converted
avatar

12
Posts: 0

Posted:
15.Nov 2008 - 19:14

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

Converted
avatar

12
Posts: 0

Posted:
16.Jan 2009 - 17:38

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