pnZclassifieds. One more error. :: Zikula Community

Try Zikula 1.3.1!New core, modules & more

Download Zikula!Version 1.2.8 (stable)

pnZclassifieds. One more error.

Print topic

**unknown user**

Rank: Registered User

Registered: Mar 16, 2002

Last visit: Feb 12, 2008

Posts: 13
Posted: Feb 04, 2008 - 05:36 AM

Hi everybody! Installed new version of pnZclassified (2.3). But when I enter to any category, I see next:
Unknown column 'country_id' in 'on clause'
But I can enter ro any advertising. Please help me to solve this problem!
P.S . Forum at Technivore.net is not working.
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Feb 04, 2008 - 12:56 PM

Hello,
Most probably this is because your server is using MySql 5.
The solution is here http://community.pos…pic-topic-53919.htm
Line numbers are only valid for the PN_zClassifieds version downloaded from my website.

--
Visit my live reef aquarium.

My Amazon wish list.
**unknown user**

Rank: Registered User

Registered: Mar 16, 2002

Last visit: Feb 12, 2008

Posts: 13
Posted: Feb 06, 2008 - 10:02 AM

Dear jmvedrine! This is it!! I've already corrected the code and everything is fine! Module is working! Thank you very much!!!
P.S. Your site is great!
**unknown user**

Rank: Freshman

Registered: Mar 16, 2002

Last visit: Mar 10, 2008

Posts: 68
Posted: Feb 09, 2008 - 01:56 PM

I had the same issue as rus01, and the correction link worked for me as well. Thanks, I have another issue though, i get this message on the pn_zclassifieds home page:

Introduction ... Modify the file global.php to change the text

Ihave checked my PN global.php file and could not find that line to modify.

Were would i correct this message?

Thanks
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Feb 09, 2008 - 08:38 PM

Hello,
You need to open the modules/PN_zClassifieds/lang/eng/global.php file and look for the line
define('_INTRODUCTION','Introduction ... Modify the file global.php to change the text');
This method of customizing the module's display is rather outdated and I should change this for a module's pref that you can change in the administration but there are so many things that should be rewritten in this module (it's in fact an old phpnuke module that was adapted to PostNuke by Technivore and others)
Well at least it works and even with php5/mysql5 and does it's job

--
Visit my live reef aquarium.

My Amazon wish list.
**unknown user**

Rank: Freshman

Registered: Mar 16, 2002

Last visit: Mar 10, 2008

Posts: 68
Posted: Feb 11, 2008 - 01:52 PM

that worked great, appreciate it.
**unknown user**

Rank: Freshman

Registered: Mar 16, 2002

Last visit: Mar 10, 2008

Posts: 68
Posted: Mar 08, 2008 - 01:07 AM

Another issue just recently discovered with pn_zclassifieds.
the basket (my basket) works and it don't.
example:

1)you add an item(s) to your basket as you are browsing..via.. [add to my basket]
it appears to store the item.

2)then.. go to [my account overview] and the text list shows you have some items in your basket - you have two items in your basket.

3)then.. click on [my basket] in the links and it states..your basket is empty.

everything else seems to work great , at present.

this could be an issue that would turn off potential users/shoppers.
is there a fix?
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Mar 08, 2008 - 09:20 PM

Hello,
I tried to replicate your problem but I can't : the items in my basket are there if I go to My account > My basket
- Is your Postnuke site online ? if yes can you give me the address so that I can make some tests ?
- Can you try to replicate the problem on my own website http://www.vedrine.net ?
The basket is using cookies to store the items and I didn't change the technivore code so I will have a look at it to see if I see anything wrong.

--
Visit my live reef aquarium.

My Amazon wish list.
**unknown user**

Rank: Freshman

Registered: Mar 16, 2002

Last visit: Mar 10, 2008

Posts: 68
Posted: Mar 09, 2008 - 02:44 AM

ok, i see what may be the porblem. i tried adding stuff to my basket in my site and it showed, for whatever reason, it did not show yesterday. i can live with that unless it becomes a majar issue which is doubtfull.

maybe you can help with another couple of small pn_zclassifieds issues i am having.

i have a featured block on my homepage that displays a featured ad. the price shows as French or Euro currency not the U.S. dollar, not that dollar is worth a whole lot now. everything else shows as U.S. dollar.

if i search and ad from the main menu of pn_zclassifieds and do not plug a keyword i get this error:
Error: Unknown column 'country_id' in 'on clause'
steps taken
1 search and ad
2 choose category
3 choose state and country
4 run search just to see the whole listings in the category

i get the above error message

if i plug a keyword i get true results

thanks
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Mar 09, 2008 - 05:30 AM

This error message typically mean that a query was not updated for mysql5. Have you done ALL the changes given in my message http://community.pos…pic-topic-53919.htm including the 2 changes to the search.php file ?
For the currency problem, PN_zClassifieds has a strange way to deal with currencies. This is because the code originated from an old phpnuke classifieds module ported to PostNuke that didn't originally supported several currencies If I have to code it from scratch I would do it in a totally different way.
So the currency symbol is defined in a lot of files and as you may have guessed I made a mistake in one of the files and forgot to change the euro symbol (my currency) to the dollar one
Open the PN_zClassifieds\pnlang\eng\featured_ad.php file and correct the line :
define('_FEATUREDAD_MONEY','EUR');
Note the above EUR should be an euro symbol that you need to change to a $ one but I am unable to type an euro symbol in this forum !!

edited by: jmvedrine, Mar 09, 2008 - 06:33 PM

--
Visit my live reef aquarium.

My Amazon wish list.
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Mar 09, 2008 - 06:37 AM

Maybe I should explain why I find the way PN_zClassifieds manage currencies "strange" : currency symbols are defined in lang files, so if your website use several languages, the currency symbol change when you switch language : if in french an item has a 100 euros price, switching to english will show the same item with a $100 price (good for the buyer in those days) !! This is certainly not what you are expecting !!
So you may wonder why on my website http://www.vedrine.net prices are always displayed in euros even if language is set to english. This is because I replaced everywhere the code to display the currency mith pnModGetVar('PN_zClassifieds', 'currency').
But I was too lazy to write the code to permit to set the currency in the module's administration, I just used phpMyAdmin to define the needed record in the module vars table so this is why I never released this change.
In fact the good way to deal with currencies would be to allow currency setting on each different ad.

--
Visit my live reef aquarium.

My Amazon wish list.
jmvedrine

Rank: Helper

Registered: Jan 12, 2004

Last visit: Jan 20, 2010

Posts: 590
Posted: Mar 22, 2008 - 08:51 AM

Just to let you know that I published a modified 2.4 version where currency symbol and introduction text are now set in Module's Administration !! So no more editing of lang files !!

--
Visit my live reef aquarium.

My Amazon wish list.