Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12371
Latest: wkingyork
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 40210
Total Topics: 7081
Most Online Today: 27
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 1
Guests: 23
Total: 24

Author Topic: Problems with store  (Read 5408 times)

0 Members and 1 Guest are viewing this topic.

Offline outbaker

  • Newbie
  • *
  • Posts: 3
    • View Profile
Problems with store
« on: December 18, 2008, 06:31:42 pm »
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,
« Last Edit: December 18, 2008, 06:34:38 pm by outbaker »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15105
    • View Profile
Re: Problems with store
« Reply #1 on: December 18, 2008, 06:55:00 pm »
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.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline outbaker

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Problems with store
« Reply #2 on: December 18, 2008, 07:21:15 pm »
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,

Offline outbaker

  • Newbie
  • *
  • Posts: 3
    • View Profile
Re: Problems with store
« Reply #3 on: December 18, 2008, 07:38:57 pm »
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  :o to something != zero.

Everything seems to work great now.

Thanks again and Merry Christmas All,

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15105
    • View Profile
Re: Problems with store
« Reply #4 on: December 18, 2008, 07:43:04 pm »
Yeah they are normally initialized once in a while SMF's package manager might freak out and skip over some of sql inserts.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
4 Replies
2403 Views
Last post June 27, 2010, 04:51:01 am
by prestigehackers
1 Replies
3780 Views
Last post April 26, 2011, 10:02:09 am
by SMFHacks
7 Replies
3448 Views
Last post January 13, 2013, 01:57:20 pm
by SMFHacks
1 Replies
1962 Views
Last post February 14, 2013, 07:51:05 am
by amwebby
6 Replies
1025 Views
Last post January 25, 2019, 08:31:42 pm
by jaydog29

+- Recent Topics

Download System Lite by Rock Lee
June 03, 2020, 07:34:24 pm

Font question by SMFHacks
May 27, 2020, 08:15:26 am

Error message with latest SMF 2.1 Github build by Hatshepsut
May 25, 2020, 01:43:26 am

smfblog not working on 2.0.17 by tech9
May 20, 2020, 01:44:34 pm

Copyright removal by stbc
May 18, 2020, 01:27:57 am

Mod Verified User i can't square the image by Rock Lee
May 07, 2020, 07:56:10 pm

SMF4Mobile 2.0 released for SMF 2.0.x by SMFHacks
May 06, 2020, 12:13:14 pm

SMF Social Login Pro - Discontinued? by Nicole
May 02, 2020, 05:47:04 pm

Likes by SMFHacks
April 30, 2020, 09:50:35 pm

Upgrade Issue - by SMFHacks
April 28, 2020, 12:40:13 pm

Powered by EzPortal