Home » Forums » Ubercart » Bug Reports
3 replies [Last post]
Fri, 11/23/2007 - 08:18
jprieto
jprieto's picture
Offline
Joined: 11/09/2007
Juice: 79
Was this information Helpful?

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 WebARtSale.com -- a new site not yet in production
---------------------------------------------------------------------------

Top
Fri, 11/23/2007 - 09:56
#1 View page
Shawn Conn
Shawn Conn's picture
Offline
Administrator
Joined: 08/07/2007
Juice: 916
Re: WHAT in the world is this??

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

Top
Fri, 11/23/2007 - 18:51
#2 View page
jprieto
jprieto's picture
Offline
Joined: 11/09/2007
Juice: 79
Re: Re: WHAT in the world is this??

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 WebARtSale.com -- a new site not yet in production
---------------------------------------------------------------------------

Top
Mon, 11/26/2007 - 10:10
#3 View page
Shawn Conn
Shawn Conn's picture
Offline
Administrator
Joined: 08/07/2007
Juice: 916
Bazzar is the version

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

Top