Home » Forums » Ubercart » Bug Reports

wierd SQL error

Submitted by flavoflav on Tue, 10/30/2007 - 18:42
flavoflav
Posts: 42
 Joined: 10/01/2007

any idea why this would be happening to logged in users:

Location http://www.xyxyxyxyxyx.com/?q=admin/store/orders/41/payment_details/chec...
Referrer http://www.xyxyxyxyxyx.com/admin/store/orders/41/edit

Message 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 '= '') AND node.nid = 94' at line 1 query: SELECT count(node.nid) FROM node node WHERE (node.status = '1') AND (.is_product = '') AND node.nid = 94 in /home/xxxxxx/public_html/includes/database.mysql.inc on line 172.

John
permalink #1 Thu, 11/01/2007 - 14:17
flavoflav
Posts: 42
 Joined: 10/01/2007

bump - I am getting a lot of these errors

permalink #2 Thu, 11/01/2007 - 14:48
torgosPizza

Posts: 1374
 Joined: 08/14/2007
Bug FinderEarly adopter... addicted to alphas.Getting busy with the Ubercode.

This part jumps out at me:

(node.status = '1') AND (.is_product = '')

There should be a table name before the . - so it looks like some value is not being passed. Do a search for that query and see if there is a table name reference missing there. Or it could be a module that's supposed to be passing that value that was deleted or disabled unintentionally.. couldn't tell ya without looking at it myself.

Good luck!

EDIT: I also noticed this line: SELECT count(node.nid) FROM node node

There should only be one node there. So if your query looks like this:

SELECT count({node}.nid) FROM {node} {node} ...

Move one of those {node} values and put it in front of the period mentioned above. That might fix it.

--

"Pain don't hurt." - Dalton

Mike Nelson's RiffTrax! www.rifftrax.com

permalink #3 Thu, 11/01/2007 - 15:51
flavoflav
Posts: 42
 Joined: 10/01/2007

Ok licked it -

looks like it was the views module I disabled it and error gone:

SELECT *
FROM `xxx_xxx510`.`view_filter`
WHERE (
`vid` LIKE '%node.status%'
OR `tablename` LIKE '%node.status%'
OR `field` LIKE '%node.status%'
OR `value` LIKE '%node.status%'
OR `operator` LIKE '%node.status%'
OR `options` LIKE '%node.status%'
OR `position` LIKE '%node.status%'
)
LIMIT 0 , 30