FAQ Manager

Tim,

Firstly to ask for help thats completely fine, as i said in many messages on this post read the testimonials on our site (which are submitted by real clients), ask our customers, our support is second to none when its our products and services we are supporting. We DID NOT develop this mod we merely sorted the problems. We installed this mod three times on a fresh Zencart install and DID NOT see the problem.

Secondly i am defending our position as a company since it seemed you were preparing to slander it just because we couldn't help strait away with a problem.

We receive loads of support emails everyday regarding software that we developed and release under the GNU/GPL and granted although they are all configuration requests it does take time to get through them all (this is all unpaid work), but again we will always support or software and services when we develop them.

The only person thats whining in this thread Tim is you, i am merely trying to get through to you that no one that releases free software under the GNU/GPL l;icence is actually obliged to support it, take microsoft for instance with the IE brwser for a MAC, they don't support it anymore, so being a MAC user should i contact Bill Gates and go crazy and demand that they support it? I think not.

I never ever said that i/we are the best thing since sliced bread, i myself asked for some support the other day which was kindly supported by Ajeh, (thanks btw ;-)) and although my problem wasn't solved i'm not going to start jumping up and down about it or start submitting posts like these to get a point across.

Clearly you are not a developer and have never experienceed what we have when using free software.

I have been contacted by another user this morning and this issue has now been taken to the next level as described in the post above that actually relates to the problem, once i get feedback i'lll gladly help.

However, that being said, we are a very, very busy company which is why we have been unable to contribute lately although i will make this issue a priority, so i can stop wasting my own time writing posts like this.

I am on these forums as a user, not a company and am not trying to make our company look good in any way and quite frankly don't need to, so stop making references to our company please.

BTW, if you require custom coding you would need to be booked in to get it done, the next placement is now mid April and theres more than me in the company.

Anyway enough said, i won't reply to anymore of these posts, i feel i have managed to get the point across.

Have a nice day

Derek

derek you are an absolute bozo mate.

telling us how busy you are and how you can clearly see that im not a developer- how the heck you can get that i wouldnt have a clue...but you seem to think that.

i merely got onboard with this as i saw others wanting help and you making promises that were never met.

more like me taking a position where i call a spade a spade more than slander- which it falls seriously short in meeting that criterion.

and me whining?...i sugges tthat you read through the posts and see what ive asked about, and your responses.

everytime anyone has asked about a fix for the issue you posted and promised to fix, youve gone off on this huge typing tirade..this then dovetailed into my response about contributions..which got another type-athon from you , and so forth.

if you are so busy, i have no idea how you can write these novels...surely the fix wouldve been faster?

it wouldve made you look good too. if you dont care to look good, and have plenty of clients, then ive news for you bro- you got the service game all wrong.

throw darts at my effigy when you go home but take every opportunity to advertise yourself i a good light. all this thread has done is make you look like a right tosser.

i have no commercil gain, so really i can write what i want..but you are in ''the business''....i certainly wouldnt be going at it with some anonymous user if i were in your shoes.

looks like perfect designing is not going to come through eh?...

shame too..imagine the name you'dve had for yourself and free advertising from peeps using the contrib?...you cant beat that.

Tim,

I never said you never had a clue, thats something you seem to have taken from the last post goodness knows why since all i was trying to state there is that if you were a developer you would also get a bit pissed when the end user comes at you like you have.

I also don't have any commercial gain here and don't expect to, your way out of line here Tim and quite frankly refuse to converse with someone with a clear aggression problem, maybe you need to seek help.

If you look at all your posts you have not helped, all you've done is slander our company which as no play in this, and make me look bad when in actual fact i am helping, but again you don't see that bit eh?

ofcourse if this peice of software was developed by the company or myself then maybe i would contribute more.

And i mean to make remarks like he ones in your last post, well that just sums you up!

As i said, i don't need to look good because i am not on these forums as a company i am on here as a user just like you wanting to help others and give something back, which i am, so i don't know why you consistently bring the company into it.

You keep making references to the company, why? its not the company thats helping with this module, its me!!!!!

We as a company are very busy but again thats no one elses concern, the reason i mention that is because i hope it would allow people to understand why I haven't replied.

Please read the last post properly, you clearly can't be since you keep saying I am not helping when clearly i am.

Again, stop making references to the company since its not the company thats helping, its me myself in my own capacity as a Zencart user!

Have a nice day

Derek

skunkworx:

you are making $ on zencart itself so my thoughts are that you ARE obliged to either contribute by way of programming or donations. But that is purely on moral grounds.

Tim

Tim, I have read this thread through from start to end. It seems these posts are pointless and you are out for an arguement with a developer who has offered their work up for nothing.

Are you not making money out of zencart also by selling products and utilising the free software? Are we not all doing this? Why then should a developer who has taken time to learn skills not be able to make money out of zencart by working for others, and also pick and choose the work they do due to timescales etc.

Problem with open source software is that we can receive wonderful and powerful features and software which is being handed to us on a plate for no cost.
The issue then becomes that we all expect more free feautres and further expansions to our website and more and more assistance for free. You would not get this in a commercial software enviroment, instead you would have to pay heavily for any support or personal assistance.

I have asked alot of questions on these forums and had some really good assistance, I have also communicated with developers and had to put my hand in my pocket to pay for things to be fixed for me.

We have to take our hat off to developers who offer their work for future use and development , even if it does not really work correctly at the time.. because someone else with applicable skills might be able to then make it into something better.

I can understand both sides of your discussions...... it is a shame you need to argue over this.
Why not offer to pay a developer to iron out the bugs of this component?? After all, if your car breaks down you need to pay a mechanic to fix it?

Just my two cents on this from reading your threads...., dont go replying with an arguementitive reply to this post because I am not going to follow this thread but think the forums should be about good discussions... but not a slanging match at others.

chief_wiggum:

Tim, I have read this thread through from start to end. It seems these posts are pointless and you are out for an arguement with a developer who has offered their work up for nothing.

.

im glad you pointed this out...this is PART of the point...what they've ''offered'' doesnt work.

and again the point has been missed. they also promised to address it. that is my main gripe...it drives me nuts when people make promises that they dont keep. if you're not sure, then dont make a promise.

im really sorry, but i cant help but think that you guys know each other also...being from the same part of the world and all...im big on ethics and integrity so my word is my word and a promise is a promise...a rare commodity i know...maybe i am naive.

regaridng making $ from the software...as i pointed out...we do it in different ways..like thread contributions etc...you seem to have the position that coding is at some echelon above other forms of contribution.

now, surely derek you are too busy to reply?

I am not too busy to reply ...

When a contribution is made, it is made to help others ...

The author is under no obligation to you or anyone else to maintain or fix issues that occure ...

If the contribution is what you are needing and there are issues ... either wait until that contribution is updated ... again there is no "time" element here obligating the author to update it in "your" time frame, if at all ...

Or update the contribution itself so that it works correctly and recontribute it ... if you are so inclined ...

Or higher someone to take the contribution and fix it for you ... and consider re-contributing it for others to use ...

Bottom line is ... no one - either an individual nor business ... is obligated to you or anyone else to maintain a contribution, fix a contribution or support a contribution ...

If it doesn't work for you and you cannot code or cannot afford to hire someone to make it work for you then remove it ...

Meanwhile ... end of arguement ... this is a support thread not a tit for tat thread ...

yeah whatever.

its so convenient that the points ive made since post one arent the ones being argued.

ill say it one last time....

i dont care if there is a technicality on contributions..this is about character..

if you say you'll fix it, then do it. go back a few posts now and see that otehrs asked about issues and they went unanswered- despite the heap of time spent answering me.

i dont need ZC 101 on contributions- that implies that i dont understand the nature of open source or free will.

i am in fact arguing for both of these things. free will including your word..

say it-do it..dont spend your time arguing why you havent done it.

maybe you cant actually do it?...i never even thought of that..in that case, just say so.

Anybody can stop this stupid flood?

Ajeh:

I am not too busy to reply ...

Meanwhile ... end of arguement ... this is a support thread not a tit for tat thread ...

very true..in that case please post wrt to both sides so we can move on.

please kindly remove the contrib as it is obvious that many cant get it to work so thus becomes a source for corrupting the instalaltion or taking it to a state where novice users cannot recover from.

If you don't like it don't use it ...

It will eventually be fixed ...

Until such time ... there is no need to remove it as someone else may wish to fix the issues first ...

So please drop the arguementative confrontation ... you have had your say now let this thread go on to what its purpose is ...

lankeeyankee:

So, would you kindly mind telling us which file contains the p.products code line that needs to be changed? I have searched and can't seem to find it.
Why you ask about it? You gote an error with 'p.products'? Can you show me this error?

a_berezin:

Why you ask about it? You gote an error with 'p.products'? Can you show me this error?

Hi Andrew,

This line of code doesn't actually exist within this contribution, but i have seen myself with another users site that it seems to cause a problem when the sidebox is active, which tells me there is a conflict in the sidebox code, but we need to find out which box it is.

I personally installed the contribution on 3 seperate sites this week on 3 new installs and never seen this error anywhere on any of the sites, so it kind of beats me now, so i now need to wait to find out from other users where the conflict exists.

If you foind the error or anyone else for that matter please let us know which modules you have installed, this will help us narrow down the problem.

Kind regards

Derek

What version of MySQL is being used on these sites?

DrByte:

What version of MySQL is being used on these sites?

Hi DrByte,

I can't talk for anyone else but i have installed it on verion 4 & 5 and everything works perfect.

Derek

Hi Derek,

Dehaw:

This line of code doesn't actually exist within this contribution,Yes.
Dehaw:

but i have seen myself with another users site that it seems to cause a problem when the sidebox is activeWhat faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?
Dehaw:

I personally installed the contribution on 3 seperate sites this week on 3 new installs and never seen this error anywhere on any of the sitesI too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

to

$main_faq_category_tree = new faq_category_tree();

a_berezin:

Hi Derek,
Yes.
What faq manager they use? What version of faq manager they use? What zen-cart version? What a problem? Problem with 'p.products'?
I too. But I remove includes/open-operations/ processing.
And in sideboxes/faq_categories.php change

$main_faq_category_tree = new faq_category_tree;

> to
> ```
$main_faq_category_tree = new faq_category_tree();

Hi Andrew,

Yeah this is the original FAQ manager contrib from Dave @ Open Operations, i helped sort a few bugs to get it actually working, which it does for most but not for some, but i'm not sure why.

I have tested on 1.3X including the latest release of Zencart and all is fine. it seems that some people get this error where the sql query is trying to select the p.products_date_added where clearly that doesn't exist and it should be referencing the p.faqs_date_added, but again this p.products_date_added doesn't exist within this contrib.

However, since Dave based this contrib on the zencart site products and amended tables and code to accommodate for FAQS as opposed to products, that would tell me that the FAQ categories side box is conflicting with another sidebox, since this is where the problem seems to occur.

I'm kind of stumped since i never see this problem even on a new install with all sideboxes activated and no one else seems to report that they got it working.

So i'll wait and see if either there is a solution or even an explanation would be good.

Thanks ;-)

Derek

Hi,

OK, I think I figured out why I kept getting the p.products error in the sidebox. I had expanded catagory mod loaded and once I removed that I didn't get that error anymore.

BUT, every time I reload the SQL patch for faq manager and enable the sidebox I get this message below. The odd thing is, and I know almost nothing about coding yet (but I am learning as fast as I can!), when I go to the store after loading the SQL patch and enabling the faq sidebox everything is normal. Then when I click on anything on the page I get the following errors and they then won't go away for any page unless I restore my SQL database to an earlier time and thus remove the faq patch.

The first error message appears in the main body of the store under the header, and all of the text is really big, even the store's text:

1064 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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070305 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

These other errors are above the header:

Warning: Variable passed to each() is not an array or object in /home/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/globaldr/public_html/customdrumshop/zen/includes/classes/db/mysql/query_factory.php:114) in /home/globaldr/public_html/customdrumshop/zen/includes/init_includes/init_templates.php on line 78

When I remove the faq SQL patch by restoring to an earlier database all of these go away.

I disabled all of the sideboxes on the left side except for faq manager and that didn't help.

I have heavily modded the store, I'm new to this and have been trying out the various mods to see what I want to use for our store. I have:

cart upsell/cross sell
dual pricing 1_3_7
easy populate
image handler 2
order steps tableless
quick updates 2.0
testimonials manager
stock by attributes 4.4
designer monthly boxes
usps click and ship
fedex mod
email archive search 1.2
backup mysql
qbi v3.21b

I hope that this helps. Please let me know if you need any more info or would like access to the store to check it out yourself. It's on a remote server but we're not using it yet so you can go in and see for yourself what the problem may be.

Thanks!

Matt

Hi matt,

Finally someone has come to the rescue with what might be the problem! ;-)

Ok so the problems you are having now are relating to your configuration, it seems the database entries have not loaded properly.

Do you have a url so we can see it?

many thanks

Derek

The url is http://www.customdrumshop.com/zen I know that the layout is screwed up somewhat with the search box in a un-aligned spot etc. I am still messing around to get a feel for what does what and haven't focused on the CSS or any layout options yet, so don't laugh too hard. :laugh: Unless something is causing the problem?

I just installed the faq SQL patch again so you can see what is happening and now when you go to the faq page by clicking on the link the error message in the main body of the page is:

Warning: Division by zero in /home/globaldr/public_html/customdrumshop/zen/includes/classes/split_page_results.php on line 76

The other errors above the headers are there, too. Then when I go back to the home page I get the other errors that I mentioned in the last post.

I hope that this will help figure it out. I just installed a fresh 1.3.7 on my home computer after going through the setup in the new zen cart book, so I will try to install the faq manager on it and see what happens. I'll let you know the results.

Thanks!

Matt

Hi matt,

It looks to me that those errors are present as a result of those variables being missing from the database, have you used an older database with new files?

Try installing a fresh copy of the site using a new database, then install the faq manager, it shoulfd all work fine.

Let us know how you get on ;-)

Derek