Problems with store

   Community Suite
   SMF Gallery Pro
   SMF Store
   SMF Classifieds
   Newsletter Pro
   Downloads System Pro
   Ad Seller Pro
  
   Hacks and Mods
   Latest SMF Hacks
   TopTen Hacks
   Styles and Themes
   Add a Hack
   Manage Hacks
  
   Earn Money from Your Forum with these tips
   SMF Theme Generator
   SMF Package Parser
   Free SMF Hosting
   HostRocket Webhosting for SMF
  
   Site Showcase

Advanced search

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

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:

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.

Help Support the SMFHacks.com mod making.