Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 4255
Latest: andreios
New This Month: 3
New This Week: 1
New Today: 0
Stats
Total Posts: 43261
Total Topics: 7519
Most Online Today: 297
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 277
Total: 277

Author Topic: Sql error when adding Product List  (Read 5644 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: 16436
    • 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: 16436
    • 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
13949 Views
Last post February 26, 2008, 07:50:17 pm
by SMFHacks
3 Replies
5370 Views
Last post June 04, 2008, 07:11:13 am
by treasurenet
2 Replies
6899 Views
Last post October 24, 2008, 10:00:32 pm
by Bar Nuthin
5 Replies
7094 Views
Last post December 03, 2008, 11:09:15 am
by Bigjim
1 Replies
3141 Views
Last post June 14, 2010, 02:04:37 pm
by SMFHacks

+- Recent Topics

Problems SMF 2.0.19 > 2.1.4 SMF Gallery Pro - Recents Images to overall header by Michel68
Today at 08:27:36 am

No thumbnails on new uploads by Tonyvic
Today at 06:26:18 am

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

is it possible to add support for odysee.com by fvlog19
March 21, 2024, 08:47:51 am

Request for admin notification by davejo
March 10, 2024, 01:31:59 am

I need help with torrent upload by Ineedsmfhelp
March 09, 2024, 10:01:13 pm

an idea for new mod (( content type with different display )) by SMFHacks
February 27, 2024, 01:36:27 pm

[Mod] RSS Feed Poster by SMFHacks
February 27, 2024, 11:57:18 am

find duplicate pictures by fvlog19
February 14, 2024, 02:22:40 pm

Error uploading video. by SMFHacks
February 08, 2024, 02:04:16 pm

Powered by EzPortal