Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4260
Latest: Verrick
New This Month: 0
New This Week: 0
New Today: 0
Stats
Total Posts: 43323
Total Topics: 7527
Most Online Today: 296
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 282
Total: 282

Author Topic: Sql error when adding Product List  (Read 5738 times)

0 Members and 2 Guests are viewing this topic.

Offline bwyrwitzke

  • Member
  • *
  • Posts: 8
    • View Profile
Sql error when adding Product List
« on: June 21, 2009, 11:44:20 pm »
Installed Store 1.3.3 to SMF 1.1.9  site.  When I go to PRODUCT LIST the following is displayed:

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 'SELECT SUM(quantity) FROM smf_store_cart as t WHERE t.ID_ITEM =
File: /home/content/d/i/v/xxxxxxxxxxxl/forum/Sources/Load.php(1730) : eval()'d code
Line: 3043


Can anyone provide some direction for correcting this issue.  Thanks.

Offline bwyrwitzke

  • Member
  • *
  • Posts: 8
    • View Profile
Re: Sql error when adding Product List
« Reply #1 on: June 22, 2009, 07:18:44 pm »
Nobody?  I'm using mySQL 4.0   I have limited DB experience and really could use some help.

Thanks.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16464
    • View Profile
Re: Sql error when adding Product List
« Reply #2 on: June 22, 2009, 07:31:51 pm »
MySQL 4.0 is really old at this point. Can you try asking your host to upgrade it? Mysql ended support for it in 2006 and does not support most of the new features of MySQL
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 bwyrwitzke

  • Member
  • *
  • Posts: 8
    • View Profile
Re: Sql error when adding Product List
« Reply #3 on: June 22, 2009, 08:42:32 pm »
Hopefully that's the issue.  When we created the DB only 4.0 was available, now we have a choice up to 5.0.  Would it be worth creating a new database and importing the data from the old 4.0 version?  Maybe this is the wrong approach?

Thanks for the reply.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16464
    • View Profile
Re: Sql error when adding Product List
« Reply #4 on: June 22, 2009, 09:03:38 pm »
I would suggest doing that. Creating a new database in 5.0 and import the 4.0 data. That would fix the product list error that you are getting and probably will make your site/forum perform better since MySQL 5.0 offers better performance.
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
1 Replies
14029 Views
Last post February 26, 2008, 07:50:17 pm
by SMFHacks
3 Replies
5449 Views
Last post June 04, 2008, 07:11:13 am
by treasurenet
2 Replies
6951 Views
Last post October 24, 2008, 10:00:32 pm
by Bar Nuthin
5 Replies
7166 Views
Last post December 03, 2008, 11:09:15 am
by Bigjim
1 Replies
3192 Views
Last post June 14, 2010, 02:04:37 pm
by SMFHacks

+- Recent Topics

Failed to open stream: File name too long by Randem
June 21, 2024, 10:40:41 am

Attachment images Upsidedown or Sideways by SMFHacks
June 18, 2024, 10:53:24 am

JSON decode error: The maximum stack depth has been exceeded by SMFHacks
June 14, 2024, 10:15:16 pm

“Insert from Gallery” by donk
June 10, 2024, 01:26:57 pm

Pretty Urls extras by SMFHacks
May 13, 2024, 10:28:54 am

Mod question by Verrick
May 11, 2024, 02:42:50 pm

i have paid but cant download ad pro. by SMFHacks
May 02, 2024, 11:29:38 pm

Please Help! by SMFHacks
April 17, 2024, 08:04:55 am

Rate own images by fvlog19
April 11, 2024, 10:56:53 am

Tidy Child Boards on 2.1.4 by SMFHacks
April 04, 2024, 03:54:12 pm

Powered by EzPortal