X-Cart: shopping cart software
Page 10 of 14 « First < 89 10 1112 > Last »
Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)
-   Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)
-   -   X-Cart Ability Template v4.4.x (https://forum.x-cart.com/showthread.php?t=61776)

kevbentz 08-05-2012 10:52 AM
Re: X-Cart Ability Template v4.4.x
 
I started getting this error:

SQL query : select categoryid, category from xcart_categories where categoryid in () order by category
Error code : 1064
Description : 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 ') order by category' at line 1
Request URI: /cart.php?mode=add&productid=137164&amount=1
Backtrace:
/include/func/func.db.php:303
/include/func/func.db.php:203
/include/func/func.db.php:483
/ability_minicart_content.php:33
/include/common.php:98 /cart.php:614
-------------------------------------------------

This particular query is found in ability_minicart_content.php on line 33:
Code:
$cart_categories1 = func_query("select categoryid, category from $sql_tbl[categories] where categoryid in (".$cat_list.") order by category");

I'm by no means an expert, so I can't figure out what is causing this but it appears to be something in the ".$cat_list." as indicated by the error:
Code:
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 ') order  by category' at line 1

I'm running MySQL 5.1.

Thank you

qwerty 08-08-2012 08:51 AM
Re: X-Cart Ability Template v4.4.x
 
hi phil
I submitted a support ticket that has been sitting unanswered for a while.
ID: MM14PSB7TE

JacksmithxD 08-09-2012 04:08 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by qwerty
hi phil
I submitted a support ticket that has been sitting unanswered for a while.
ID: MM14PSB7TE

He's busy with Adapt, leave him be! :D/

On a serious note, he'll answer it soon enough so don't worry, if I can help shoot me a PM or reply on here. Last time I spoke to him he was very busy. :D

PhilJ 08-09-2012 04:30 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
hi phil
I submitted a support ticket that has been sitting unanswered for a while.
ID: MM14PSB7TE


Already dealt with, thanks.

PhilJ 08-09-2012 02:19 PM
Re: X-Cart Ability Template v4.4.x
 
Hi folks, well our new responsive template, Adapt is nearly here!

You can try out the demo here, although I'm still testing, fixing odd minor things and documenting. A full write up will follow in a separate thread.

A few admin screenshots - One - Two - Three

Phil

JacksmithxD 08-10-2012 03:40 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by PhilJ
Hi folks, well our new responsive template, Adapt is nearly here!

You can try out the demo here, although I'm still testing, fixing odd minor things and documenting. A full write up will follow tomorrow (Friday) in a separate thread.

A few admin screenshots - One - Two - Three

Phil

Talk about going overboard! Man it looks great and by those pics there is a lot of features with this template. P.s just tested this out on my iphone and my girlfriends Ipad and it works excellent. Guess I have some work to do to upgrade my old site! Saves me a few hundred/thousand for a mobile skin too!

I have my weekend sorted! :D/

kevbentz 08-10-2012 07:36 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by kevbentz
I started getting this error:

SQL query : select categoryid, category from xcart_categories where categoryid in () order by category
Error code : 1064
Description : 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 ') order by category' at line 1
Request URI: /cart.php?mode=add&productid=137164&amount=1
Backtrace:
/include/func/func.db.php:303
/include/func/func.db.php:203
/include/func/func.db.php:483
/ability_minicart_content.php:33
/include/common.php:98 /cart.php:614
-------------------------------------------------

This particular query is found in ability_minicart_content.php on line 33:
Code:
$cart_categories1 = func_query("select categoryid, category from $sql_tbl[categories] where categoryid in (".$cat_list.") order by category");

I'm by no means an expert, so I can't figure out what is causing this but it appears to be something in the ".$cat_list." as indicated by the error:
Code:
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 ') order  by category' at line 1

I'm running MySQL 5.1.

Thank you

I've edited the code and the error went away...

code should read:
Code:
$cart_categories1 = func_query("select categoryid, category from  $sql_tbl[categories] where categoryid in ('".$cat_list."') order by  category");

Pitak 08-11-2012 12:18 AM
Re: X-Cart Ability Template v4.4.x
 
Phil, I visit your demo site for the adapt template and the pages do not scroll smoothly. I tried it on both firefox 14.0.1 and IE 9 on Windows 7. On the other hand, it works great on the ipad2.

FYI , the demo for the ability template is scrolling fine - a little jerkily but at an acceptable level. And I'm using a relatively fast computer.

Can you fix this on the adapt template?

JacksmithxD 08-11-2012 03:41 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by Pitak
Phil, I visit your demo site for the adapt template and the pages do not scroll smoothly. I tried it on both firefox 14.0.1 and IE 9 on Windows 7. On the other hand, it works great on the ipad2.

FYI , the demo for the ability template is scrolling fine - a little jerkily but at an acceptable level. And I'm using a relatively fast computer.

Can you fix this on the adapt template?

You know there is a key difference between Ability and Adapt right? Adapt is responsive, hence why it works on an Ipad and Iphone very well, the reason it won't scroll 'smooth' is because it is responsive. I'm a very fussy person and this didn't even enter my mind. :D

FYI, view any responsive template, it'll scroll the same way.

PhilJ 08-11-2012 03:49 AM
Re: X-Cart Ability Template v4.4.x
 
Thanks Pitak, duly noted, I will look into this.

PhilJ 08-11-2012 06:33 AM
Re: X-Cart Ability Template v4.4.x
 
Information regarding Adapt will appear on this thread

Please keep any related questions to that thread, thanks.

David-Allan 08-13-2012 12:56 AM
Re: X-Cart Ability Template v4.4.x
 
Hey Guys,

I see my request seems to have gotten lost in the release of the new theme. Does any one have any advice on fixing the issue I have with my header layout?

My original questions is way back here

Also I'm sure I seen a post that showed how to have the pop up images which display when you hover over the features items on the homepage pop up on all products but I can't seem to find it any more. Does anyone know/remember how to do this? I'm sure I had it working before upgrading my x-cart.

Cheers

BTW the new theme looks great. We wont be changing over to it though as we are still very happy with this theme and havent had it very long.

SGS 08-13-2012 02:22 AM
Re: X-Cart Ability Template v4.4.x
 
David,

Go to Post 335 on this thread. There is the fix for what your asking. It worked on my 452 cart, but there is also an update of ability 1.3 that has it built in now.

Don't feel bad David, I am still waiting for a fix, Post 344, Display Images and the product column have to much white space.

My guess is Phil is burning daylight and anything else he can find to get Adapt out the door. We will just have to wait till he come to the surface once again.

Hope that Helps,

Cheers

David-Allan 08-13-2012 04:04 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by SGS
David,

Go to Post 335 on this thread. There is the fix for what your asking. It worked on my 452 cart, but there is also an update of ability 1.3 that has it built in now.

Don't feel bad David, I am still waiting for a fix, Post 344, Display Images and the product column have to much white space.

My guess is Phil is burning daylight and anything else he can find to get Adapt out the door. We will just have to wait till he come to the surface once again.

Hope that Helps,

Cheers

Thanks SGS that's exactly what I was looking for. I must have missed this when looking through the thread.

It's cool, i'm in no rush to get the header working. I know that Phil is rushed off his feet just now. I thought maybe someone with more css experience than me might have known a quick fix for it.

I just can't get my head round the grid system so I have just being playing about with the little knowledge I have to get it to where it is at the moment.

JacksmithxD 08-13-2012 06:13 AM
Re: X-Cart Ability Template v4.4.x
 
Phil has a crazy sleeping pattern, that's if he sleeps! (Give him a day or two) He'll more than likely resolve the issue you have, I know the last time I was speaking to him he was working like mad to finish off Adapt, he just doesn't want to rush it and I don't blame him! I'd rather have a good solid product than a rushed buggy one for the sake of a few days! :D

Anything I can do to help the odd person just drop me a PM, I'm not the best but I'm alright.

hoosierglass 08-14-2012 06:15 AM
Re: X-Cart Ability Template v4.4.x
 
Phil - I put in a ticket about 10 days ago with no response other than the automated acknowledgement. I understand that you are busy, but could use some help.

hoosierglass 08-14-2012 09:06 AM
Re: X-Cart Ability Template v4.4.x
 
Here is a little update. Less than three hours after my post, Phil has me up to par again. Not to mention that it is dinner time in the UK. As I had thought, with so many requests for help coming through, mine was just overlooked.

Great service and just as happy as every that I made x-cart-mods part of my cart package.

Thank again Phil.

David-Allan 08-15-2012 07:14 AM
Re: X-Cart Ability Template v4.4.x
 
Hey guys got a quicky for you. I have been trying all day using the debug console and firebug to find where I would put this image but I just can't find the code that shows the product options drop down menu for size. here is an image of what I mean.

http://www.robertsonpackaging.com/images/support/screenshot150812.jpg

What I want to do is add an http://www.robertsonpackaging.com/images/support/animated_arrow_right.gifanimated arrow that points to the size field when this product option is available because for some reason even after writing in bold Red H1 tags that the customer has to select the desired size before they purchase they still phone up asking where the other sizes are.

I hate using animated images on a site, it brings me back to the 90's but I really don't see any other option to be honest.

Here is one of the products we are having problems with: Tamper Evident Containers

PhilJ 08-15-2012 07:25 AM
Re: X-Cart Ability Template v4.4.x
 
David, try this...

skin/ability/modules/Product_Options/customer_options.tpl

After...

Code:
          {if $usertype eq "A"}
            {$v.class}
          {else}
            {$v.classtext|escape|default:$v.class}
          {/if}

Insert...

Code:
{if $v.class eq "Size"}&nbsp;<img src="{$ImagesDir}/support/animated_arrow_right.gif" alt="" />{/if}

David-Allan 08-15-2012 07:37 AM
Re: X-Cart Ability Template v4.4.x
 
Wow Phil your an absolute super star. I don't know how you manage it.

It works perfectly. Thank you so much.

Hopefully this may get customers to actually use this option. :)

While I have your attention, what do you think about the release of XCN? Are you looking to develop any skins for it? Not sure if I want to go down the route of upgrading to XCN and losing my customised Ability skin.

David-Allan 08-20-2012 05:50 AM
Re: X-Cart Ability Template v4.4.x
 
Hi Guys,

Does anyone know how to use multiple sliders on the home page?

What I did was add this to welcome.tpl

Code:
{include file="custom/welcome/promotions/image_roundabout/image_roundabout.tpl"}

but it won't load if there is another slider activated above it. I'm guessing this is something to do with the java running two instances but i'm not sure how to resolve it.

Basically I want to have the the responsive image slider at the top of the welcome page then further down I want the image roundabout or one of the other sliders to display also.

I'm not fussed about it being hard coded like this as I have to change the images and description manually anyway so its not an issue it not being in the admin section.

Any help would be appreciated.

PhilJ 08-20-2012 06:01 AM
Re: X-Cart Ability Template v4.4.x
 
skin/ability/custom/welcome/promotions/promotions_common.tpl

Just take out the IF statements surrounding the image roundabout code.

{if $config.Ability_Template.abi_home_promotions eq "image_roundabout"}
...
{/if}

David-Allan 08-20-2012 06:10 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by PhilJ
skin/ability/custom/welcome/promotions/promotions_common.tpl

Just take out the IF statements surrounding the image roundabout code.

{if $config.Ability_Template.abi_home_promotions eq "image_roundabout"}
...
{/if}

Thanks Phil I did actually remove the if statement and it does display the images but doesn't start the slider script. It's as if the two java scripts are fighting with each other. SO the top slider runs fine but the next one only displays the images and descriptions but not in the slider format if you know what I mean.

Thanks for the speedy reply.

hoosierglass 08-23-2012 07:41 PM
Re: Ability Template Product List display problem
 
Did you ever get a fix on this? It seems we have the same problem when you have out of stock items, items with options and standard items. I switched to tubular display to avoid this for now.

Quote:
Originally Posted by jmccunep
I have the product list options in my development store set to 3 products per row (grid/row switchers enabled). The display of the products in each category on my store works just as I hoped and expected for all products in either grid view or row view. EXCEPT for one category--with that particular category there are some empty spaces in grid view (and none in row view.)

What's particularly odd about it is that there are other categories with about the same number of products, and some of the included products shown as in stock and some as out of stock in some of the categories just as with the problem category, but those other categories all display the grid view properly with no gaps.

The problem persists no matter how the products are sorted on the front end (SKU, price, etc), and no matter how they're sorted on the backend (position).

I've attached a JPG screen shot.

Thanks for any help with this oddity!

XCart 4.4.5
Ability Template 1.051
www.twinoakshammocks.com is the live URL.
The development URL is not live on the web (is in a password protected folder).

David-Allan 08-24-2012 12:13 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by PhilJ
skin/ability/custom/welcome/promotions/promotions_common.tpl

Just take out the IF statements surrounding the image roundabout code.

{if $config.Ability_Template.abi_home_promotions eq "image_roundabout"}
...
{/if}
Hi Phil,

Forgot about this post. I managed to get this to work so thanks again for your help. I seem to be getting better and better at fixing problems/customizing x-cart thanks to you.

David-Allan 08-24-2012 12:16 AM
Re: Ability Template Product List display problem
 
Quote:
Originally Posted by hoosierglass
Did you ever get a fix on this? It seems we have the same problem when you have out of stock items, items with options and standard items. I switched to tubular display to avoid this for now.

Hey guys just out of interest have you possible got a product that has a very long title on the pages that are out of alignment?

I noticed that this happened on just one of my categories pages and it turned out one of the products on that page had a longer than usual title and when I temporarily disabled that product I seen the issue resolved itself so I just adjusted the product title to fix the problem.

It may not be the issue your having but its worth a check.

PhilJ 08-24-2012 01:49 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Did you ever get a fix on this? It seems we have the same problem when you have out of stock items, items with options and standard items. I switched to tubular display to avoid this for now.

Hoosierglass, you should be able to overcome the issue by setting a fixed height on each product in the grid...

skin/ability/custom/css/common.css

Replace...

ul.grid_view li .product_block .overflow { overflow: hidden; width: 100%; height: auto; }

With for example...

ul.grid_view li .product_block .overflow { overflow: hidden; width: 100%; height: 350px; }

PhilJ 08-24-2012 02:26 AM
Re: X-Cart Ability Template v4.4.x
 
Just a heads up, for those exporting their databases from the X-Cart DB backup tool, it is important that you've made this small modification...

In admin/db_backup.php comment out or delete this code...

Code:
            if (!in_array($_table, $sql_tbl))
                continue;

It will then export ALL database tables including custom ones.

Also, if you have a large database, for importing it's a good idea to use Bigdump

hoosierglass 08-24-2012 03:31 PM
Re: X-Cart Ability Template v4.4.x
 
Any suggestions for incorporating a blog with this layout? I would love to find a way to use a speed tab for setting up a blog. Right now my mind is mush from uploading products and refining images etc.

SGS 08-28-2012 01:06 AM
Re: X-Cart Ability Template v4.4.x
 
Phil,

I have placed a ticket asking about add-on products you sell. Product rotator, water mark and Product download. Will these be update to work with Ability and the 4.5.x branch?

Cheers

David-Allan 08-28-2012 02:46 AM
Re: X-Cart Ability Template v4.4.x
 
Hey Guys,

I have added this code:
Code:
{include file="customer/main/products.tpl" products=$f_products}

to this page : Farm Shop Packaging supplies

But if you look at the page you will see that the rating stars are all messed up for some reason. They work fine everywhere else but not when called to a static page.

Does anyone know how to resolve this issue? i'm thinking it may be a css issue with the correct css not being called to the static pages.

Thanks

D-A

hoosierglass 08-28-2012 03:31 PM
Re: X-Cart Ability Template v4.4.x
 
I was playing around with the FAQ portion of the template. The accordion is set to on and works just fine if you are in the Contact Us section. I followed the instructions for making a static page as shown here:

Use this Smarty code in your template/static page...

{include file="custom/addons/faqs/faqs.tpl"}

If including into a static page, ensure you have checked this option in X-Cart General Settings...

"Parse Smarty tags in the content of embedded static pages"

The problem is the accordion will not work and when you click on Show All or Hide All it takes you to the main page of the website. Same goes for clicking on any of the subjects in the FAQ.

Anyone have any ideas as to why this is not working?

PhilJ 08-29-2012 05:17 AM
Re: X-Cart Ability Template v4.4.x
 
Try, skin/ability/custom/addons/addons_common.tpl

Find the code below and change the pageid value to your FAQ static page ID...

{if ($main eq "product" && $config.Ability_Template.abi_product_info_display eq "accordion") || ($main eq "help" && $config.Ability_Template.abi_addon_faqs eq "Y") || $smarty.get.pageid eq "1"}

hoosierglass 08-29-2012 05:39 AM
Re: X-Cart Ability Template v4.4.x
 
That worked like a charm.

Only other problem I am seeing right now is on the front page featured, new and random items. It shows a + Add To Cart instead of the buttons and quantity box. Any quick fixes for that one?

David-Allan 08-29-2012 06:13 AM
Re: X-Cart Ability Template v4.4.x
 
Any ideas on my issue Phil?

Also i'd like to move the pagination items from the top of the product pages to the bottom, being at the top just doesnt make sense unless its at the bottom too.

I have found the actual pagination bit in navigation_masonry.tpl but can't find where this is called from so I can move it tot he bottom or at least copy it to the bottom of the page.

Any tips would be appreciated

David-Allan 08-30-2012 07:37 AM
Re: X-Cart Ability Template v4.4.x
 
Got another question for you Phil.

If you go to the checkout page of my ability theme the structure of the page is all wonky. Have a look here

Any idea what may be causing this?

JacksmithxD 08-30-2012 11:35 AM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by David-Allan
Got another question for you Phil.

If you go to the checkout page of my ability theme the structure of the page is all wonky. Have a look here

Any idea what may be causing this?

.CSS Issue, view the Demo then look at your .CSS and compare to see what's missing? Just an idea. :D

elmirage001 08-30-2012 09:02 PM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by David-Allan
Got another question for you Phil.

If you go to the checkout page of my ability theme the structure of the page is all wonky. Have a look here

Any idea what may be causing this?
Go to Ability Template Options in Admin and under "Theme Options" make sure "Checkout Width" is set to "Fixed Width"

David-Allan 09-03-2012 11:57 PM
Re: X-Cart Ability Template v4.4.x
 
Quote:
Originally Posted by elmirage001
Go to Ability Template Options in Admin and under "Theme Options" make sure "Checkout Width" is set to "Fixed Width"

Thanks mate that did the trick.

hoosierglass 09-04-2012 12:44 PM
Re: X-Cart Ability Template v4.4.x
 
Is there a way to get the alt tags for the detailed images to work in this? This is kind of important for some of our products. It would also help SEO.


All times are GMT -8. The time now is 10:22 PM.
Page 10 of 14 « First < 89 10 1112 > Last »
Show 40 posts from this thread on one page

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.