Problems with store

[outbaker]

First of all, I never received an email with license key. Please send me an email on this registration address, so I can prove you I bought yesterday Store Module.

Seccond, I have few problems with store :

I first had to downgrade to SMF 1.1.7 because your store isn't work on 2.0. Too bad, the 2.0 board has more than a year now.

1. Anyway, I install Store and when I click on Admin -> Store Configuration -> Shipping I get this error message :

Code: [Select]

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 'condition, value1, value2, ID_CONDITION
FROM smf_store_shippingconditions' at line 2
File: /home/sites/*****/public_html/forum/Sources/Load.php(1726) : eval()'d code
Line: 5670

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

2. I inserted a product and don't appears in online Store ! Wow. I inserted another one, the same thing. In Admin section products are listed, but they don't appear in user area at Store section (categories are empty).

When I ckick some categorie when shoul be a product, this category is empty and "pages bar" has a lot of page [1][1][1]...[1] and so on...

3. When go to Shopping Cart, this is another error :

Code: [Select]

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 'condition, value1, value2, ID_CONDITION
FROM smf_store_shippingconditions' at line 2
File: /home/sites/******/public_html/forum/Sources/Store.php
Line: 5524

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.7, while your database is at version 1.1.6. The above error might possibly go away if you execute the latest version of upgrade.php.

What is this, can someone explain me how to resolve that ? I am not a php expert but I can resolve if small problem here.

For admins, I can provide you a account on my on-line web board, ftp, etc., to see yourself what's happening. 

Best regards,

[SMFHacks]

Forwarded the license information to the email at hcv.ro

We are in the process of working on the modification for SMF 2.0 which should be in a couple weeks.

1. Error Have that fix in this update for the next release found at
http://www.smfhacks.com/index.php/topic,3151.0.html
You need to be in the customer group to access this topic.

2. Sounds like your settings are not setup correctly. Check under admin -> Store Configuration -> Settings

Check the Items per page settings the default is 16 in your case probably is set to zero which causes the items not to appear.

3. Same issue as number one it is an issue with some versions  msyql but we have a fix for the next major release which can be found in that topic.

[outbaker]

Thanks for so very fast reply. Appreciate.

License is ok now, I received email from VisualBasicZone.com, everything ok.

I will hatch that thread you said for workaround.

Thanks again,

[outbaker]

Ok, I upgraded to 1.3 beta 2 without any problems, no database errors anymore.

You was right, the Settings were wrong and I suspect Items Per Page and Per Row vars. In future release maybe you can initialize them first  to something != zero.

Everything seems to work great now.

Thanks again and Merry Christmas All,

[SMFHacks]

Yeah they are normally initialized once in a while SMF's package manager might freak out and skip over some of sql inserts.