Skip to content

Unexpected query error #547

@staabm

Description

@staabm
            $sql = rex_sql::factory();
            $sql->setQuery('SELECT * FROM ' . $sql->escapeIdentifier($this->table));

leads to

132    Query 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/MariaDB server  
         version for the right syntax to use near '1 LIMIT 0' at line 1                                                                                                             
                                                                                                                                                                                    
         Simulated query: SELECT * FROM 1 LIMIT 0 (42000).                                                                                                                          
  132    Query 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/MariaDB server  
         version for the right syntax to use near '1 LIMIT 0' at line 1      

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions