CMS Made Simple Forums

Posted: **Thu Feb 07, 2013 5:24 pm**

I am only uding CalGuy's ecommerce module along with cart, orders, products. Not any version of shop made simple.

Posted: **Thu Feb 07, 2013 5:30 pm**

I see them listed in your modules, do you have them not installed or ?..

Posted: **Thu Feb 07, 2013 6:47 pm**

Swear on my cats life. Just CalGuys eccommerce modules. I have been sick with a cold these last few days. I will take a screen shot of myodule manager page if that helps.

Posted: **Thu Feb 07, 2013 6:48 pm**

Please paste the entire page template... that site was puking before the body was finishing.. wasn't a problem with the head template... that I saw.

Posted: **Thu Feb 07, 2013 9:04 pm**

Could not login to "http://honfish.pixelita.com" and the site was set to "Site down for maintenance" and the admin required a username and password.

Try removing CTLModuleMaker. This module is very old and no longer supported. It may be using old syntax in the PHP code that is incompatible with later versions of CMSMS.

It's also not needed on a client site, only the module that it generated. What is the module it created?

Posted: **Sat Feb 09, 2013 7:22 pm**

pixelita, might be fixed by now? But if not, the way I see it is: you didn't do anything to change the sites. But something has changed - so it surely must be the hosting?

Check with them what changes were made at the time the sites first went wrong. That info should help you get to the bottom of the problem.

Posted: **Wed Mar 06, 2013 4:13 am**

As an update, with the help of a forum member, I pretty much got most everything settled down. And it was fine a few days ago. No one breathed on it wrong.

And now, once more, same misbehavior (starts parsing with the </__body> tag, skipping what's above), but I have isolated it to something that used to work and now has stopped working so I thought I'd come here and ask, once more, for some help.

The Product (CGeCommerce) module is involved. I have a detail template that calls a summary template at the bottom of the page, which is to display three random products from the same category. It had been working when Wonderful Forum Guy handed the site back to me. And neither of us has touched it since. And now it stopped working; as in, the code that once worked works no more. We are out of ideas.

I know this summary template code is the culprit because if I remove it, the page loads fine. But I really want that feature -- the ability to display other related products, with pictures, formatted as I had them.

One big clue is error text that is displayed in place of the summary template:

Code: Select all

INTERNAL ERROR: Query failed - SELECT SQL_CALC_FOUND_ROWS C.*,PH.hierarchy_id FROM cms_module_products C LEFT JOIN cms_module_products_prodtohier PH ON PH.product_id = C.id WHERE C.status = 'published' ORDER BY random asc LIMIT 0, 3 -- Unknown column 'random' in 'order clause'

Here is the summary template code that is supposed to display those three random same-category products:

Code: Select all

<!-- HFC_V3_PRODUCT_SUMMARY_SIMILAR_INLINE_REVD -->
{foreach from=$items item=entry}
	<div class="store-similar-items">
	{if count($entry->fields)}
		{foreach from=$entry->fields key='name' item='field'}
		{if $field->name == 'image'}
			<a href="{$entry->detail_url}" class="item-link"><img class="item-image" src="{$entry->file_location}/{$field->value}" width="225" height="260" alt="{$field->value}"/></a>
			<ul class="store-similar-list">
			<li><strong>Item:</strong> <a class="summary-product-link" href="{$entry->detail_url}" class="item-link">{$entry->product_name}</a></li>
			<li><strong>Price:</strong> {$currency_symbol}{$entry->price}</li>
			{if isset($entry->categories)}
			<li><strong>Category</strong>: {foreach from=$entry->categories item='category'}{$category->name},&nbsp;{/foreach}</li>
			{/if}
			</ul>
		{/if}
		{/foreach}
	{/if}
	</div><!-- /store-similar-items -->
{/foreach}

And here is the code in the detail template that used to call that summary template without a problem until yesterday, and which, once removed, causes the page to load fine (although without the Similar Products displayed):

Code: Select all

{Products action='default' category=$category->name sortby='random' pagelimit='3' summarytemplate='hfc_v3_product_summary_similar_inline_revd'}

And here is the main products page. clicking on any product should take you to the detail page for that product.
Login Credentials: client/letmein
http://honfish.pixelita.com/store

Oh, and while I was writing this, I encountered more failure. Now, it throws out an error:

Code: Select all

Error: at line 127 in file /home/pixelita/public_html/honfish/lib/smarty/sysplugins/smarty_internal_templatebase.php:

Message:
Unable to load template module_db_tpl 'Cart;addtocart_hfc_v3_add2cart'

And here's the template it complains about; and it also complains in the same way if I switch to the sample template. Oy.

Code: Select all

<!-- CART: hfc_v3_add2cart -->
<div class="add2cart">
{if isset($cart_error)}
{cgerror}{$cart_error}{/cgerror}
{/if}

<div class="mycart">
{$formstart}
<input type="text" name="{$quantityname}" value="1" size="2" maxlength="2"/>
{if isset($attribute_count) && $attribute_count gt 0} 
{foreach from=$attributes item='attrib'}
{$attrib->name}: {$attrib->control}
{/foreach}
{/if}
<input type="submit" name="{$submitname}" value="{$addtocarttext}"/>
{$formend}
</div><!-- /mycart -->
</div><!-- /add2cart -->

This is exactly the kind of thing that had started happening when I first posted this thread. The fact that you can sit there and DO ABSOLUTELY NOTHING and your CMSMS-based site can fail.

Is there something I am not doing (and I've been developing CMSMS sites for awhile so I am not exactly a newbie, although I don't understand as much as some of you about Smarty and PHP)???

Posted: **Wed Mar 06, 2013 5:10 am**

Well, obviously something has changed.

BTW. the sortby=random will not work in Products 2.18.4, it's a bug I have fixed but haven't released yet.

Posted: **Wed Mar 06, 2013 6:26 am**

BTW. the sortby=random will not work in Products 2.18.4, it's a bug I have fixed but haven't released yet.

CalGuy, if you are trying to drive me crazy, it will be a short trip!

So should I just hang on and wait for the release? (I am having eye surgery in three weeks and I am trying to prod my client to get this thing launched before that as I don't know what shape my eye will be in after that.

(Lesson for all you young pups out there, old age ain't for wimps!)

Posted: **Sat Mar 09, 2013 2:31 am**

The Looking for similar products? section is working for me at the moment. Does that mean it's been fixed?

Posted: **Sat Mar 09, 2013 4:06 am**

I have had this issue before ... When I turned on debug, PHP errors showed up, which gave me a clue what the issue was.. I don't remember what the actual issue was, however.

Posted: **Sun Jul 07, 2013 12:11 pm**

THIS IS SOLVED!

[EDIT] The updats for mudules in the module manager showed up first half an hour after the update! When I updated the Cart-Module all is working OK

When upgrading from 1.11.4 to 1.11.7 mind to upgrade the modules for the CGE-ecommerce-suit, checkout in the download-area of the website if you have all the new modules!
Then it will work perfectly again!

Kind regards,
Jan

Posted: **Sun Jul 07, 2013 3:58 pm**

adjust the timesettings in your config.php
add [SOLVED] to the title

Posted: **Sun Jul 07, 2013 7:04 pm**

I cannot add solved to the title, this is not a thread I started.

Kind regards,
Jan

CMS Made Simple Forums

Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header

Re: Pages start with </__body> tag, not parsing header