Home » Forums » Ubercart » Bug Reports

WHAT in the world is this??

Submitted by jprieto on Fri, 11/23/2007 - 07:18
jprieto

Posts: 19
 Joined: 11/09/2007

user warning: 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 'DISTINCT(n.nid) FROM uc_files as f LEFT JOIN uc_file_products as fp ON (f.fid = ' at line 1 query: SELECT f.filename, n.title, fp.model, f.fid, pf.pfid, DISTINCT(n.nid) FROM uc_files as f LEFT JOIN uc_file_products as fp ON (f.fid = fp.fid) LEFT JOIN uc_product_features as pf ON (fp.pfid = pf.pfid) LEFT JOIN node as n ON (pf.nid = n.nid) ORDER BY f.filename ASC LIMIT 0, 50 in /home/usamain/public_html/cms/includes/database.mysql.inc on line 172.

what is this?

help please

am i posting in the right forum?

--

------------------------------------------------------------------------------
Using the cart in USAindie.com -- film & music production
------------------------------------------------------------------------------
permalink #1 Fri, 11/23/2007 - 08:56
Shawn Conn

Posts: 332
 Joined: 08/07/2007
Administrator

It looks like the count_query (used to determine the total number of rows) in the pager query calls isn't working automatically. I've added manual working count queries to all my calls of pager_query in uc_file.module. You can get the updated version via bazaar.

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine

permalink #2 Fri, 11/23/2007 - 17:51
jprieto

Posts: 19
 Joined: 11/09/2007

via baazar? frgive my ignorance .... but please explain

when im in VIEW DOWNLOAD FILES, they are not listed and the error is displayed

what steps need i take?

please

--

------------------------------------------------------------------------------
Using the cart in USAindie.com -- film & music production
------------------------------------------------------------------------------

permalink #3 Mon, 11/26/2007 - 09:10
Shawn Conn

Posts: 332
 Joined: 08/07/2007
Administrator

Bazzar is the version control system we use for ubercart. You can use it to get the latest work-in-progress ubercart code. Follow the link for details on how to retrieve the lastest code via bazzar. Once you have downloaded the ubercart package, you can overwrite your existing ubercart package with the package you've downloaded via bazzar. (WARNING: if this is a live site, I would do a backup or test the code out on a copy of your site. The latest bazzar release can be unstable)

--

-Shawn Conn: If the Name Don't Rhyme It Ain't Mine