Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
"Show all results" error
04-07-2011, 02:12 AM,
#1
"Show all results" error
Hi,

In search results, the 'all' button does not work ; it gives the following output:

Code:
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 '-25,25' at line 1
SELECT `tblDocuments`.*, `tblDocumentContent`.`version`, `tblDocumentStatusLog`.`status`, `tblDocumentLocks`.`userID` as `lockUser` FROM `tblDocumentContent` LEFT JOIN `tblDocuments` ON `tblDocuments`.`id` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatus` ON `tblDocumentStatus`.`documentID` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatusLog` ON `tblDocumentStatusLog`.`statusID` = `tblDocumentStatus`.`statusID` LEFT JOIN `ttstatid` ON `ttstatid`.`maxLogID` = `tblDocumentStatusLog`.`statusLogID` LEFT JOIN `ttcontentid` ON `ttcontentid`.`maxVersion` = `tblDocumentStatus`.`version` AND `ttcontentid`.`document` = `tblDocumentStatus`.`documentID` LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id`=`tblDocumentLocks`.`document` WHERE `ttstatid`.`maxLogID`=`tblDocumentStatusLog`.`statusLogID` AND `ttcontentid`.`maxVersion` = `tblDocumentContent`.`version` AND (CONCAT_WS(' ', `tblDocuments`.`keywords`, `tblDocuments`.`name`, `tblDocuments`.`comment`) LIKE '%2011%') AND `tblDocuments`.`folderList` LIKE '%:1:%' LIMIT -25,25

LetoDMS: 3.0RC3
Server details: Ubuntu 10.10; php 5.3.6; MySQL 5; Apache 2

Any help is appreciated.
Thanks,
Max
Reply
04-07-2011, 03:30 PM,
#2
RE: "Show all results" error
(04-07-2011, 02:12 AM)max Wrote: Hi,

In search results, the 'all' button does not work ; it gives the following output:

Code:
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 '-25,25' at line 1
SELECT `tblDocuments`.*, `tblDocumentContent`.`version`, `tblDocumentStatusLog`.`status`, `tblDocumentLocks`.`userID` as `lockUser` FROM `tblDocumentContent` LEFT JOIN `tblDocuments` ON `tblDocuments`.`id` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatus` ON `tblDocumentStatus`.`documentID` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatusLog` ON `tblDocumentStatusLog`.`statusID` = `tblDocumentStatus`.`statusID` LEFT JOIN `ttstatid` ON `ttstatid`.`maxLogID` = `tblDocumentStatusLog`.`statusLogID` LEFT JOIN `ttcontentid` ON `ttcontentid`.`maxVersion` = `tblDocumentStatus`.`version` AND `ttcontentid`.`document` = `tblDocumentStatus`.`documentID` LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id`=`tblDocumentLocks`.`document` WHERE `ttstatid`.`maxLogID`=`tblDocumentStatusLog`.`statusLogID` AND `ttcontentid`.`maxVersion` = `tblDocumentContent`.`version` AND (CONCAT_WS(' ', `tblDocuments`.`keywords`, `tblDocuments`.`name`, `tblDocuments`.`comment`) LIKE '%2011%') AND `tblDocuments`.`folderList` LIKE '%:1:%' LIMIT -25,25

LetoDMS: 3.0RC3
Server details: Ubuntu 10.10; php 5.3.6; MySQL 5; Apache 2

Any help is appreciated.
Thanks,
Max

This is a bug in letodms. Thanks for reporting it. It will be fixed before the final release of 3.0.0.

Uwe
Reply
05-28-2011, 05:00 PM,
#3
RE: "Show all results" error
(04-07-2011, 03:30 PM)steinm Wrote:
(04-07-2011, 02:12 AM)max Wrote: Hi,

In search results, the 'all' button does not work ; it gives the following output:

Code:
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 '-25,25' at line 1
SELECT `tblDocuments`.*, `tblDocumentContent`.`version`, `tblDocumentStatusLog`.`status`, `tblDocumentLocks`.`userID` as `lockUser` FROM `tblDocumentContent` LEFT JOIN `tblDocuments` ON `tblDocuments`.`id` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatus` ON `tblDocumentStatus`.`documentID` = `tblDocumentContent`.`document` LEFT JOIN `tblDocumentStatusLog` ON `tblDocumentStatusLog`.`statusID` = `tblDocumentStatus`.`statusID` LEFT JOIN `ttstatid` ON `ttstatid`.`maxLogID` = `tblDocumentStatusLog`.`statusLogID` LEFT JOIN `ttcontentid` ON `ttcontentid`.`maxVersion` = `tblDocumentStatus`.`version` AND `ttcontentid`.`document` = `tblDocumentStatus`.`documentID` LEFT JOIN `tblDocumentLocks` ON `tblDocuments`.`id`=`tblDocumentLocks`.`document` WHERE `ttstatid`.`maxLogID`=`tblDocumentStatusLog`.`statusLogID` AND `ttcontentid`.`maxVersion` = `tblDocumentContent`.`version` AND (CONCAT_WS(' ', `tblDocuments`.`keywords`, `tblDocuments`.`name`, `tblDocuments`.`comment`) LIKE '%2011%') AND `tblDocuments`.`folderList` LIKE '%:1:%' LIMIT -25,25

LetoDMS: 3.0RC3
Server details: Ubuntu 10.10; php 5.3.6; MySQL 5; Apache 2

Any help is appreciated.
Thanks,
Max

This is a bug in letodms. Thanks for reporting it. It will be fixed before the final release of 3.0.0.

Uwe

Hey,

Is there a fix for this bug yet? is "LIMIT -25,25 " the problem?

Thanks.
Reply
06-01-2011, 05:48 PM,
#4
RE: "Show all results" error
Okay, I checked the 3.0.0 stable version out, I used the changes in my file too.
The search is fine now.

Thanks.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)

Contact Us | LetoDMS Community Forum | Return to Top | | Lite (Archive) Mode | RSS Syndication