X-Cart forums

[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:

$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:

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]

hi phil
I submitted a support ticket that has been sitting unanswered for a while.
ID: MM14PSB7TE

[JacksmithxD]

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!

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.

[PhilJ]

hi phil
I submitted a support ticket that has been sitting unanswered for a while.
ID: MM14PSB7TE

Already dealt with, thanks.

[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 in a separate thread.

A few admin screenshots - One - Two - Three

Phil

[JacksmithxD]

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!

[kevbentz]

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:

$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:

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:

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

[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?

[JacksmithxD]

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.

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

[PhilJ]

Thanks Pitak, duly noted, I will look into this.