Why is Zend Framework (Zend_Db_table) rejecting this SQL Query?

Question

I'm working on a simple JOIN of two tables (urls and companies). I am using this query call:

print $this->_db->select()->from(array('u' => 'urls'),
                                 array('id', 'url', 'company_id'))
                          ->join(array('c' => 'companies'),
                                 'u.company_id = c.id');

which is out putting this query:

SELECT `u`.`id`, `u`.`url`, `u`.`company_id`, `c`.* FROM `urls` AS `u` INNER JOIN `companies` AS `c` ON u.company_id = c.id

Now, I'd prefer the c.* to not actually appear, but either way it doesn't matter. ZF dies with this error:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 1"

but I can run that query perfectly fine in my MySQL CLI. Any ideas how to fix up this query?

Check if you have a reserved keyword (field) in the companies table. dev.mysql.com/doc/refman/5.1/en/reserved-words.html — Michael D. Irizarry
– Michael D. Irizarry, Commented Jun 10, 2010 at 21:35

Community · Accepted Answer · 2017-05-23 10:33:15Z

5

I just tried that code in a test script against ZF 1.10 and MySQL 5.1, and it works fine.

What user/password are you using to connect to your database? It says "or access violation" so I would test that your db username has the right privileges. Try connecting in the MySQL CLI using the exact same user/password and connection method (because privileges can vary depending on the client host, even for the same user/password).

See MySQL Zend Framework - SQLSTATE[42000]: Syntax error or access violation:

Btw, you can omit c.* columns by passing an empty array for columns as the third argument to join():

->join(array('c' => 'companies'), 'u.company_id = c.id', array());

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Jun 10, 2010 at 21:52

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Why is Zend Framework (Zend_Db_table) rejecting this SQL Query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related