I've created a database with the webfaction control panel and restored via sql script. When I tested my application i got this error:
the select command i'm using is something like this:
The thing is when I make a simple SELECT (ie: SELECT * FROM producto) everything works fine, so I'm guessing is something that have to do with the INNER JOIN command. When I tried to run the query in mysql Workbench it says:
but the user im using can't grant permissions on itself, how can I resolve this? asked 21 Jul '11, 10:53 marcoslhc |
Oh!, my bad! the problem was the name of the tables. It should be answered 21 Jul '11, 11:12 marcoslhc |