Sql error when adding Product List

   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

[bwyrwitzke]

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.

[bwyrwitzke]

Nobody?  I'm using mySQL 4.0   I have limited DB experience and really could use some help.

Thanks.

[SMFHacks]

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

[bwyrwitzke]

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.

[SMFHacks]

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.

Help Support the SMFHacks.com mod making.