The following errors occurred with your search

[stagonolepis2085]

The original thread was closed - why?

The problem is not solved and still annoying me and users.

- If a picture is edited using "Image Tools - Edit Image".
- If the picture should be set as category image "Image Tools - Admin Options"

Following message appears (in German language):

"The following errors occurred with your search:

Please specify some words or valid user names to search on. There were no matches for those that you specified."

Another item: If title of picture is changed, the modification will not appear in the column "Last Upload".

Best regards
Stagonolepis

[Chuck S]

Have you removed the code I noted in that one thread?

No idea why the other thread was closed.

[stagonolepis2085]

Originally Posted by Chuck S

Have you removed the code I noted in that one thread?

No idea why the other thread was closed.

I changed the entries like you had advised:

"&c=$cats[catid]"

So the first problem was solved - if you click on a thumbnail the according picture is displayed. But if I try to edit this picture, or if I choose it as category image this message appears. Also changes in the headline of the picture will not appear in the category (if it is the last picture).

Cordialiter
Stagonolepis

[Chuck S]

http://www.photopost.com/forum/1235308-post2.html

I was referring to this snippet of code.

[stagonolepis2085]

Originally Posted by Chuck S

http://www.photopost.com/forum/1235308-post2.html

I was referring to this snippet of code.

It does not help, it make it worse because after removal of this code instead of a picture a "Database Error" was displayed.

Cordialiter
Stagonolepis

[Chuck S]

Removing that code would not cause a database error at any rate you need to let us know the actual errors to assist.

[stagonolepis2085]

Originally Posted by Chuck S

Removing that code would not cause a database error at any rate you need to let us know the actual errors to assist.

This was the error message:

"Invalid SQL:

SELECT images.imageid, images.title, images.userid, images.thumbname, extension
FROM vB_ppgal_images AS images

WHERE valid = 1 AND catid = '5' AND userid = 3
ORDER BY DESC, images.imageid DESC;

MySQL-Fehler : 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 'DESC, images.imageid DESC' at line 5
Fehler-Nr. : 1064
Fehler-Zeit : Friday, 14.11.2008 @ 14:57:02
Datum : Friday, 14.11.2008 @ 14:57:03
Skript : Sonnabend: Brauerei Hübner in Steinfeld - Letzte Station der Busfahrt war die Brauerei Hübner in Steinfeld. Galerien zur Tour-de-Bier
Referrer : Galerien zur Tour-de-Bier
IP-Adresse : 91.10.106.230
Benutzername : Sinister
Klassenname : vb_database
MySQL-Version : 5.0.67"

Best regards
Stagonolepis

[Chuck S]

Did you remove the line by mistake below the code noted to remove?

Content visible to verified customers only.

Looks to me like that has been removed by mistake as your orderby is empty

Try downloading 2.4.3 reupload showimage.php and lets start fresh.

[stagonolepis2085]

Originally Posted by Chuck S

Did you remove the line by mistake below the code noted to remove?

Content visible to verified customers only.

Looks to me like that has been removed by mistake as your orderby is empty

Try downloading 2.4.3 reupload showimage.php and lets start fresh.

I have reuploaded showimage.php today. It is still the same. The image is displayed. Image Tools -> Edit Image: Something is changed and afterwards the above mentioned message appears. The change is executed.

Same happens if you click on "Image Tools -> Printable Version". The printable version is displayed and some links appear, e.g.:

"Galerien zur Tour-de-Bier (Galerien zur Tour-de-Bier)
- Tour-de-Bier 2005 (Tour-de-Bier 2005 - Galerien zur Tour-de-Bier)
- - Memmelsdorf - Brauerei Gasthof Höhn (Tour-de-Bier) "

If you click on the last link

"- - Memmelsdorf - Brauerei Gasthof Höhn (http://www.tour-de-bier.de/gallery/showimage.php?i=87)"

again the above mentioned message appears (in German language):

"vBulletin-Systemmitteilung
Ihre Suchanfrage erzielte keine Treffer. Bitte versuchen Sie es mit anderen Suchbegriffen."

Cordialiter
Stagonolepis

[Chuck S]

Since vbgallery does not come in a german language what is that specific message say?

Memmelsdorf - Brauerei Gasthof Höhn - Lagerkeller Galerien zur Tour-de-Bier

That link works so basically from what I see we are back to this. Remove this from showimage.php and the link without c=5 should work as that is what has worked for quite a few people. I would suspect the issue is because of a vbulletin hack as I am unable to get any issues on a clean vb and vbgallery install with or without the catid present.

http://www.photopost.com/forum/1235308-post2.html

I am assuming your error message says something about some search and thats because somewhere in the code because of a hack or something the program thinks cat is being set to searchterms.

[stagonolepis2085]

The message is still the same, the corresponding message in English:

"The following errors occurred with your search:

Please specify some words or valid user names to search on. There were no matches for those that you specified."

I tried again to remove the code trying not to forget something or to remove too much code. The result is again an error message after changes are made and I click on "save Changes":

"Datenbankfehler in vBulletin 3.7.4:

Invalid SQL:

SELECT images.imageid, images.title, images.userid, images.thumbname, extension
FROM vB_ppgal_images AS images
LEFT JOIN vB_ppgal_favorites AS favorites USING (imageid)
WHERE valid = 1 AND favorites.userid = '1' AND userid = 1
ORDER BY images.dateline DESC, images.imageid DESC;

MySQL-Fehler : Column 'userid' in where clause is ambiguous
Fehler-Nr. : 1052
Fehler-Zeit : Sunday, 16.11.2008 @ 09:23:38
Datum : Sunday, 16.11.2008 @ 09:23:39
Skript : Tour-de-Bier
Referrer : Tour-de-Bier
IP-Adresse : 91.10.68.97
Benutzername : Sinister
Klassenname : vb_database
MySQL-Version : 5.0.67"

Cordialiter
Stagonolepis

[stagonolepis2085]

Chuck,

I have looked around a little bit. I am using VBCMS, too. And VBCMS is also using the variable "catid".

Cordialiter
Stagonolepis

[Chuck S]

Possibly in showimage.php make this line for userid images.userid

Content visible to verified customers only.