2096 replies to this topic

[josmos23]

I have installed the latest version of QTPro and followed the install directions carefully. Now when I click on  the "Buy Now" button for certain  products, no product image or description is displayed and I get the following error:

Warning: ksort() expects parameter 1 to be array, null given in c:program filesapache groupapachehtdocscatalogincludesfunctionsgeneral.php on line 104



Warning: Variable passed to each() is not an array or object in c:program filesapache groupapachehtdocscatalogincludesfunctionsgeneral.php on line 106

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 ') and language_id=1' at line 1[/quote]

select products_options_id as id,special from products_options where products_options_id in () and language_id=1

When I click on other items, the product image displays along with the description except that where the "add to cart" would be, I get the following error message:

  

Model

1146 - Table 'catalog.products_stock' doesn't exist



select products_stock_quantity as quantity from products_stock where products_id=26 and products_stock_attributes='3-8'



[TEP STOP]

Any ideas on this one?

Thanks!  :?

[josmos23]

Sorry,   Please disregard the [code]  and [quote] tags in the previous message.

[HISComm]

What changes does this make to general.php?

I have a modified version of general.php due to other modules installed, so I need to know what parts this module changes so I can make the changes manually.

Thanks.

[josmos23]

I am using TexPad. I compared the QTPro and Original (tep_snapshot-20030116) general.php files. There is quite alot of changes. Do you want me to post the text here or can I email the just the changes to you?

Thank you for taking the time to help me.



Craig :wink:

[vtec]

i am getting errors when trying to update the stock levels of an item, mainly when i try to zero out the item so there is a quantity of 0 in stock.  here is an example of the error.

1064 - You have an error in your SQL syntax near 'where products_id=42' at line 1



update products set products_quantity= where products_id=42



[TEP STOP]

i will be needing the ability to zero an item out b/c both my retail and web store will be sharing the smae inventory...

i am also still recieving an error when i add an item to the stock, but on the client side of oScommerce the item is said to be out of stock once placed in the shopping cart.  

any suggestions would be much appreciated on what the solution could be.

thanks

kevin

[vtec]

also, the first time i try to update the stock of an item, any item, the url does not complete itself correctly and gives a page not found error.

eg
instead of going to http://www.domain.com/catalog/admin/stock.php
it gives   http://catalog/admin/stock.php

if you can point me to where the code for this is i could change it, thanks,

[vtec]

now i am really confused.  some items stock work some dont.

SHopping Cart View
[img]http://www.kspaintball.com/images/shoppingcart.jpg[/img]

Inventory Admin View
[img]http://www.kspaintball.com/images/inventory.jpg[/img]

db view through php myadmin of products_stock
[img]http://www.kspaintball.com/images/phpmyadmin.jpg[/img]


please help!

[zonetown]

This module is pretty complex and I am still working out some minor bugs. It has consume a bit of my time and will be a bit before I get everything corrected.

The QTpro project is in the mist of being handed down to Linda McGrath of http://www.thewebmakerscorner.com in hopes she will improve the contribution. Show your support to her for taking over QTpro project.

I will be updating the site with the last Patch and Version soon hopefully. It will fix the auto checked on the catalog product info page, that is causing it to show up as null on the shopping cart.

Right now, this module is not made to be supported with Buy it Now feature. If you want to use QTpro, disable that feature. Maybe in the future or someone will figure a solution for this.

Thanks,
Joe

[msweehoo]

Thanks joe for working on this.. I sell clothes too and this was a must have.

Vtec: I am having the same problem and I think I know what is happening.. but because I am a newbie I have no idea how to fix it..

This is what I noticed. If I go into the product and just click add to cart I get the "product not in stock" error. Notice in the cart that the attribute is not listed below the item. The radio button was selected but it doen't register.

Now if I go into the product and click a different attribute and then click the top attribute again.. THEN add it to the cart.. all is good.

So the problem is with that top radio button..  

If anyone has a fix I would love to hear from you.

Thanks!

Staci

[vtec]

yeah, thats exactly what this is doing, but we never tried selecting one then the other to fix that.  great find staci!  hopefully this will be an ewasy fix.

[msweehoo]

Quote

I will be updating the site with the last Patch and Version soon hopefully. It will fix the auto checked on the catalog product info page, that is causing it to show up as null on the shopping cart.

Sorry Joe I didn't read that part.. I am also having problems with items that don't have attributes.. I sell a lot of one of a kinds and have been getting this error when I go to the cart:

Warning: ksort() expects parameter 1 to be array, null given in /home/virtual/site30/fst/var/www/html/catalog/includes/functions/general.php on line 104

Warning: Variable passed to each() is not an array or object in /home/virtual/site30/fst/var/www/html/catalog/includes/functions/general.php on line 106
1064 - You have an error in your SQL syntax near ') and language_id=1' at line 1

select products_options_id as id,special from products_options where products_options_id in () and language_id=1

Any help is greatly appreciated!

Staci

[zonetown]

that was a simple fix about the adding products to cart. I just nulled out the auto checked.

You can download it on the following url.

http://vary.net/qtpro/download/product_info.zip

I actually had this fix for awhile, but I was having some personal problems and everything else. I'm sorry for the delay.

Joe

I am aware of other problems...

[zonetown]

MSWOOHEE, the directory stucture you gave me looks very similar to the ENSIM CP.

I made QTpro to function on cPanel and not on ENSIM and Plesk because of how difficult it is to work with them.

I am surprise you got osCommerce to even work on it. The problem I had was not being able to send emails to anyone. Several other small problems eventually popped up.

Joe

[msweehoo]

Quote

MSWOOHEE, the directory stucture you gave me looks very similar to the ENSIM CP.

I made QTpro to function on cPanel and not on ENSIM and Plesk because of how difficult it is to work with them.

I am surprise you got osCommerce to even work on it. The problem I had was not being able to send emails to anyone. Several other small problems eventually popped up.

Joe

Joe, Absolutely NO IDEA what you just said lol. your mod is the only thing I have added. OSC sits on a new host withnothing else on it.. actually I don't know what caused the error but when I log off and start a new cart that product works fine. But I still have one cart locked up because of that error. So, I dunno.. if it happens again I will note everything.

Also the URL for the fix should be:

http://vary.net/qtpro/download/patch/product_info.zip

[msweehoo]

Quote

that was a simple fix about the adding products to cart. I just nulled out the auto checked.

You can download it on the following url.

http://vary.net/qtpro/download/product_info.zip

I actually had this fix for awhile, but I was having some personal problems and everything else. I'm sorry for the delay.

Joe

I am aware of other problems...

Joe, That the correct file because I'm not seeing a difference. Its still auto selecting and its not going to the cart properly.

[zonetown]

I did it again, I lost my mind.

yea wrong file not to mention the wrong url. Here it is again...

http://vary.net/qtpro/download/patch/product_info.zip

Joe

[msweehoo]

Thanks Joe, That worked!

Staci

[vtec]

I made QTpro to function on cPanel and not on ENSIM and Plesk because of how difficult it is to work with them.

Quote

really?  i have this installed in ensim and its works great except for the error when adding that to the cart.  thanks for the fix Joe, you rock!

[vtec]

i have another question.  when i add a new product and change its stock levels for the attributes for the first time, when i click the 'add' button it doesnt go to the proper url.  eg instead of www.domain.com/catalog/admin/stock.php?blahblahblabh , it goes to just /catalog/admin/... so i get a page not found.  it still works when i insert the full url, but is there a way to make it do that automatically.

also, i get an error when i try to zero out the last attribute.  eg i have a blue and a black widget.  i can zero out one, and it goes away just fine, but when i try to zero out the other with no more attributes, it gives this.

1064 - You have an error in your SQL syntax near 'where products_id=49' at line 1



update products set products_quantity= where products_id=49



[TEP STOP]

the first one isnt really a pressing issue b/c i can manually enter the url, but the second one is a little more important b/c i sell things in the retial store which shares the same inventory as the web store will.  i understand that if i am zeroing out the last attributew for that item i can just turn the item off(same result no more item in the catalog on the client side) but i just wanted to give a heads up on a bug.

kevin

[Rucas]

I could use a little help.  When doing a base install then putting qtpro 2.0 in, whenever i add an item to my cart I get this:

Quote

Warning: ksort() expects parameter 1 to be array, null given in /home/threadz/public_html/catalog/includes/functions/general.php on line 104  

Warning: Variable passed to each() is not an array or object in /home/threadz/public_html/catalog/includes/functions/general.php on line 106  
1064 - You have an error in your SQL syntax near ') and language_id=1' at line 1  

select products_options_id as id,special from products_options where products_options_id in () and language_id=1

Any ideas???