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: 3
New This Week: 0
New Today: 0
Stats
Total Posts: 43301
Total Topics: 7525
Most Online Today: 105
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 89
Total: 89

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

0 Members and 1 Guest 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: 16455
    • 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: 16455
    • 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
14009 Views
Last post February 26, 2008, 07:50:17 pm
by SMFHacks
3 Replies
5415 Views
Last post June 04, 2008, 07:11:13 am
by treasurenet
2 Replies
6930 Views
Last post October 24, 2008, 10:00:32 pm
by Bar Nuthin
5 Replies
7135 Views
Last post December 03, 2008, 11:09:15 am
by Bigjim
1 Replies
3174 Views
Last post June 14, 2010, 02:04:37 pm
by SMFHacks

+- Recent Topics

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

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
March 30, 2024, 12:41:08 pm

Can't DROP 'id_member'; check that column/key exists Datei: by SMFHacks
March 30, 2024, 11:58:20 am

No thumbnails on new uploads by Tonyvic
March 29, 2024, 06:26:18 am

Display the Contact Page for guests by SMFHacks
March 27, 2024, 10:55:43 am

Powered by EzPortal