- Moderated by:
- Support
-
- rank:
-
Freshman
- registered:
- November 2004
- Status:
- offline
- last visit:
- 17.12.04
- Posts:
- 20
Hi,
I have been tasked with upgrading a PN 726 site to 750.
everything has gone fine appart from the zClassifieds module from http://www.pnaddons.com
The module installes, initialises, & activates
The admin panel for zClassifieds dies with _NOPERMISSION
the block seems to pull in the DB name rather than the DB prefix.
i have enabled Legacy support in the admin settings.
Has anyone managed to get this working? -
- rank:
-
Professional
- registered:
- September 2003
- Status:
- offline
- last visit:
- 21.10.07
- Posts:
- 2423
..update it yourself.. or pay someone else to. there's two solutions.
--
http://www.invalidresponse.com -
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 05.09.08
- Posts:
- 633
Hello,
I don't have zClassifieds but this error should be easy to fix.
Can you give me the first lines of the modules/zClassifieds/admin.php file ?
--
Visit my live reef aquarium.
My Amazon wish list. -
- rank:
-
Professional
- registered:
- September 2003
- Status:
- offline
- last visit:
- 21.10.07
- Posts:
- 2423
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 05.09.08
- Posts:
- 633
Yes I thing the change proposed by InvalidResponse should do the job.
--
Visit my live reef aquarium.
My Amazon wish list. -
- rank:
-
Helper
- registered:
- July 2002
- Status:
- offline
- last visit:
- 27.10.08
- Posts:
- 166
Howdy.
I'm having a similar problem but I get this when I try to modify any categories:
Error: Table 'phpAds.nuke_zc_category' doesn't exist
Back
Basically it is the same problem that PN-mod-books had, so I'm hoping that since you worked on that you'd know an easy fix for this.
Sean
--
http://www.Aquaria.info --> 30k user PostNuke site
http://www.EngineSubmittal.com -- Free search engine submission
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 05.09.08
- Posts:
- 633
You must have a mix between 2 differents modules : ZClassifieds and PN_Zclassifieds because all tables of the PN_ZClassifieds modules are named (your prefix)_classifieds_something so if you were using PN_ZClassifieds your table should be (your prefix)_classifieds_category
If you are using ZClassifieds and not PN_ZClassifieds, see if the table (your prefix)_zc_category exist in your database with phpMyAdmin. If it is not there something must be wrong with your ZClassifieds module installation.
--
Visit my live reef aquarium.
My Amazon wish list. -
- rank:
-
Helper
- registered:
- July 2002
- Status:
- offline
- last visit:
- 27.10.08
- Posts:
- 166
I am using zclassifieds and the tables do exist. The problem is that the module isn't looking in my nuke database, but in the phpads database that the ad banner uses.
This is the same problem that PN-mods-books had before you fixed it.
--
http://www.Aquaria.info --> 30k user PostNuke site
http://www.EngineSubmittal.com -- Free search engine submission
-
- rank:
-
Professional
- registered:
- January 2004
- Status:
- offline
- last visit:
- 05.09.08
- Posts:
- 633
Oh yes, I remember now, but I don't intend to work on ZClassifieds, because I use PN_ZClassifieds and also because fixing these very old modules is a lot of work so I am affaid that you are on your own this time :(
I must add that :
- both ZClassifieds and PN_Zclassifieds codes are very similar obviously they share the same ancestor
- switching to PN_ZClassifieds wouldn't solve your problem because the code of SQL queries is exactly the same in both module.
But maybe I have another idea : fix the code that conect to your other database to display banners. Can you send me this code (all the code in your banners that is calling the phpads application. In your source I see that you are calling adclick and adlog. Is that all ?) ? What I have in mind is to add calls to mysql_close() to close the link to the phpAds database once you have get the data out of it. Obviously this is not a perfect solution because we are correcting a problem in ZClassifieds patching phpAds !! but maybe we will have far less changes to do (I just discovered phpAds because of your post so I m not quite sure this is doable but we can try)
--
Visit my live reef aquarium.
My Amazon wish list.
