10379 Posts in 2194 Topics by 1710 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 205 Views |
-
Unusual error with ImageGallery

18 August 2012 at 5:00am
Hi all,
I have a simple site with DOM, Uploadify and ImageGallery only - all last trunks. My SS is 2.4.7.
On my test server everything works fine with the gallery - uploading, then attaching images with Uploadify etc.
On the official I got an unusual error - when I try to upload images, the progress bar goes to100% and then I have no attached images but got the error:ERROR [User Error]: Couldn't run query:
SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName"
FROM "File"
WHERE ("File"."ID" IN (?78))
ORDER BY "SortOrder" ASCUnknown column '?78' in 'where clause'
IN GET /admin/EditForm/field/GalleryItems/UploadifyForm/field/UploadedFiles/refresh?SecurityID=bc690f07fb5f6517725859a2dd5c400c612437ef&ctf[GalleryItems][start]=0&ctf[GalleryItems][per_page]=10&ctf[GalleryItems][showall]=0&ctf[GalleryItems][sort]=SortOrder&ctf[GalleryItems][sort_dir]=&ctf[GalleryItems][search]=&ctf[GalleryItems][filter]=AlbumID_2&ctf[GalleryItems][view]=grid&ctf[GalleryItems][imagesize]=100&FileIDs=%EF%BB%BF78
Line 525 in /home/bluewind/public_html/sapphire/core/model/MySQLDatabase.phpSource
======
516: }
517:
518: function databaseError($msg, $errorLevel = E_USER_ERROR) {
519: // try to extract and format query
520: if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521: $formatter = new SQLFormatter();
522: $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523: }
524:
* 525: user_error($msg, $errorLevel);
526: }
527:
528: /**
529: * Return a boolean type-formatted string
530: *
531: * @param array $values Contains a tokenised list of info about this data typeTrace
=====
<ul>user_error(Couldn't run query:
SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName"
FROM "File"
WHERE ("File"."ID" IN (?78))
ORDER BY "SortOrder" ASCUnknown column '?78' in 'where clause',256)
line 525 of MySQLDatabase.phpMySQLDatabase->databaseError(Couldn't run query: SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" IN (?78)) ORDER BY "SortOrder" ASC | Unknown column '?78' in 'where clause',256)
line 123 of MySQLDatabase.phpMySQLDatabase->query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" IN (?78)) ORDER BY "SortOrder" ASC,256)
line 129 of DB.phpDB::query(SELECT "File"."ClassName", "File"."Created", "File"."LastEdited", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."Sort", "File"."ShowInSearch", "File"."SortOrder", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" IN (?78)) ORDER BY "SortOrder" ASC,256)
line 404 of SQLQuery.phpSQLQuery->execute()
line 761 of File.phpFile->instance_get("File"."ID" IN (?78),,,,DataObjectSet)
line 2714 of DataObject.phpDataObject::get(File,"File"."ID" IN (?78))
line 182 of MultipleFileUploadField.phpMultipleFileUploadField->Files()
line 369 of ViewableData.phpViewableData->obj(Files,,,1,)
line 411 of ViewableData.php...........
...........
When I check for image in Store - everything is OK. The image is uploaded, on right place, in the right folder...
Can anybody help?
Peace
| 205 Views | ||
|
Page:
1
|
Go to Top |

