nuBuilder Forum

Code: Select all

===PDO MESSAGE===

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'rcs2022db.___nu163ea16ab4b751___' doesn't exist

===SQL===========

SELECT COUNT(*) FROM (SELECT idProperties,BuildingName,UnitNo,UnitName,HouseNo,RoadName,Parish,Postcode
 FROM ___nu163ea16ab4b751___
WHERE 1) nuTCount

Code: Select all

===PDO MESSAGE===

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 '/ WHERE (1 = 1)  -- your where clause, if there is any

 AND (1 = 1)' at line 14

===SQL===========

CREATE TABLE ___nu163ea16ab4b751___ 

SELECT 

    BuildingName,
    UnitNo,
    UnitName,
    HouseNo,
    RoadName,
    Postcode

FROM tblProperties LEFT JOIN tblRoads ON tblRoads.idRoads = tbpProperties.id_Roads

// WHERE (1 = 1)  -- your where clause, if there is any

 AND (1 = 1) 

===BACK TRACE====

Code: Select all

===PDO MESSAGE===

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 '/-- your where clause, if there is any

 AND (1 = 1)' at line 15

===SQL===========

CREATE TABLE ___nu163ea1b9f5249e___ 

SELECT 

    BuildingName,
    UnitNo,
    UnitName,
    HouseNo,
    RoadName,
    Postcode

FROM tblProperties LEFT JOIN tblRoads ON tblRoads.idRoads = tblProperties.id_Roads

WHERE (1 = 1)  
//-- your where clause, if there is any

 AND (1 = 1) 

Code: Select all

//-- your where clause, if there is any

Code: Select all

===PDO MESSAGE===

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idProperties' in 'field list'

===SQL===========

SELECT idProperties,BuildingName,UnitNo,UnitName,HouseNo,RoadName,Parish,Postcode
 FROM ___nu163ea2209e52c8___
WHERE 1 LIMIT 0, 20

Code: Select all

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'idProperties' in 'field list'

===SQL===========

SELECT idProperties,BuildingName,UnitNo,UnitName,HouseNo,RoadName,Parish,Postcode
 FROM ___nu163ea265e89aa5___
WHERE 1 LIMIT 0, 20