Сообщение HBiT » 2011-11-17 18:01:19
После установки при заходе на пользователи, услуги - открывается пустая страница.
При заходе под клиентом на Home так же.
debug.log
[17:55:33.37][26491] [MySQL->Query]: SELECT `ID`,`OrderID`,`UserID`,`OrderDate`,`ContractID`,`DomainName`,`SchemeID`,`ExpirationDate`,`StatusID`,`StatusDate`,(SELECT `UserNotice` FROM `Orders` WHERE `DomainsOrdersOwners`.`OrderID`=`Orders`.`ID`) AS `UserNotice`,(SELECT `AdminNotice` FROM `Orders` WHERE `DomainsOrdersOwners`.`OrderID`=`Orders`.`ID`) AS `AdminNotice`,ID as `Number`,(SELECT CONCAT(`Name`,' (',(SELECT `Name` FROM `Registrators` WHERE `Registrators`.`ID` = `DomainsSchemes`.`RegistratorID`),')') FROM `DomainsSchemes` WHERE `DomainsSchemes`.`ID` = `DomainsOrdersOwners`.`SchemeID`) as `Scheme`,(SELECT SUM(`YearsRemainded`) FROM `DomainsConsider` WHERE `DomainsConsider`.`DomainOrderID` = `DomainsOrdersOwners`.`ID` AND `DomainsConsider`.`YearsRemainded` 0) as `Expiration`,StatusID as `Status`,UNIX_TIMESTAMP() - `StatusDate` as `StatusOver` FROM `DomainsOrdersOwners` WHERE (`UserID` = @local.__USER_ID) GROUP BY `ID` ORDER BY `Number` DESC LIMIT 0, 5
[17:55:33.37][26491] [!] [1024]-[MySQL->Query]: 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 '0) as `Expiration`,StatusID as `Status`,UNIX_TIMESTAMP() - `StatusDate` as `Stat' at line 1 в линии 128 файла /opt/joonte/hosts/root/system/classes/auto/MySQL.class
AND `DomainsConsider`.`YearsRemainded` 0) as `Expiration` - нет условия.
В чем может быть проблема ?
После установки при заходе на пользователи, услуги - открывается пустая страница.
При заходе под клиентом на Home так же.
debug.log
[quote][17:55:33.37][26491] [MySQL->Query]: SELECT `ID`,`OrderID`,`UserID`,`OrderDate`,`ContractID`,`DomainName`,`SchemeID`,`ExpirationDate`,`StatusID`,`StatusDate`,(SELECT `UserNotice` FROM `Orders` WHERE `DomainsOrdersOwners`.`OrderID`=`Orders`.`ID`) AS `UserNotice`,(SELECT `AdminNotice` FROM `Orders` WHERE `DomainsOrdersOwners`.`OrderID`=`Orders`.`ID`) AS `AdminNotice`,ID as `Number`,(SELECT CONCAT(`Name`,' (',(SELECT `Name` FROM `Registrators` WHERE `Registrators`.`ID` = `DomainsSchemes`.`RegistratorID`),')') FROM `DomainsSchemes` WHERE `DomainsSchemes`.`ID` = `DomainsOrdersOwners`.`SchemeID`) as `Scheme`,(SELECT SUM(`YearsRemainded`) FROM `DomainsConsider` WHERE `DomainsConsider`.`DomainOrderID` = `DomainsOrdersOwners`.`ID` AND `DomainsConsider`.`YearsRemainded` 0) as `Expiration`,StatusID as `Status`,UNIX_TIMESTAMP() - `StatusDate` as `StatusOver` FROM `DomainsOrdersOwners` WHERE (`UserID` = @local.__USER_ID) GROUP BY `ID` ORDER BY `Number` DESC LIMIT 0, 5
[17:55:33.37][26491] [!] [1024]-[MySQL->Query]: 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 '0) as `Expiration`,StatusID as `Status`,UNIX_TIMESTAMP() - `StatusDate` as `Stat' at line 1 в линии 128 файла /opt/joonte/hosts/root/system/classes/auto/MySQL.class
[/quote]
AND `DomainsConsider`.`YearsRemainded` 0) as `Expiration` - нет условия.
В чем может быть проблема ?