Harald can you help me out?

I tried upgrading from the old 3.5.0 version and it didn't work. Now, like I said, my whole board is hosed and I can't even get to the control panel! I get the error message

"
There seems to have been a problem with the yoursite.com database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience."

When I log into control panel, this is the message I get. WHen I go to my forums, the message I get. Whats the code to run in the sql section so I can uninsall this? anyone? I can't get to my control panel

here's the exact error message I'm getting:

"Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT gallery, threadid, firstpostid, thread.title, attachmentid,
attachment.dateline FROM attachment, thread, forum
WHERE gallery='1' AND thread.forumid=forum.forumid AND thread.firstpostid =
attachment.postid AND attachment.dateline < 1147011676
GROUP BY thread.threadid
ORDER BY attachment.dateline DESC LIMIT 5;

MySQL Error : Unknown column 'gallery' in 'field list'
Error Number : 1054
Date : Sunday, May 7th 2006 @ 08:21:16 AM
Script : http://www.fubardsite.com/forums/index.php?
Referrer : http://www.fubardsite.com/forums/index.php?
IP Address : xx.xx.xx.xxx
Username : Unregistered
Classname : vb_database

You have to disable temporarily your plugins. You can do this via config.php as far as i remember or via the database. Search here at vb.org for doing this.

After you disabled the plugins you should be able to login again and remove the product.

I Have a error whit Thumbails .. look mi attachment .. i use GD sistem for Thumbails .. :surprised:

@headshotx: Check at your attachment-settings, if "Generating Thumbnails" is enabled. You don't find this in your vb-options, but in your attachment-settings (where you can define the filesize for attachments, and so).

Sorry but i don't find this option .. you can post a image whit this option please :surprised:

Just go show all settings then hit Ctrl+F and put "attachment" with out the qoutes.

Hi all,

The first reply on the second page (or third,so on...) is shown as a gallery table. Screenshot as below. Kindly advise a solution for me, thanks.

http://img221.imageshack.us/img221/1814/bug0ky.jpg

Please harald can you help me out!

@Ziki-Set: Can you grant me access to your AdminCP? Please contact me via PM.

@dt~: I've checked it. Yupp, you're right. This is definately a bug. I will look after it. Thanks for advice.

Bugfix for displaying the second side incorrect:

Change the code for the plugin "gallery_showthread_postbit" as followed:

That's it!

Harald_T help me whit thumbails please :surprised:

As i said, check in your attachment-manager if your system generates thumbs.

Check your settings:

Attachment 47146

And for sure look if the marked option is set to YES.

Attachment 47147

Those pictures are in german, but i think you can find it on your own, where to look.

Oh, and ARE you using attachments? This gallery doesn't work with [IMG]-Code at the moment.

Harald,
attachment tumbs are on yes and thubnamials are enabled and it still doesn't show up!What now?

Do the thumbnails work on the rest of your board?

In your vbulletin-options you have one to define if thumbs are used or not. Please check this also.

Oh, and check the permissions for viewing attachments.

I am having the same issue. Everything but the thumbnails work. I have gone over my user permissions, the attachment permissions and I even rebuilt the thumbnail data under maintainance and the thumbs still wont show. Any other suggestions? Thanks!

The thumgnails work on the rest of teh board.All is set

OK I got it to work.I forgot to rebuild attachment thumbnails ;)

@Superkiezer: Are you using attachments? May sound stupid, but i found out, that some people forget, that this gallery is only working with attachments yet.

Also, if you don't see any attachments: Do you enabled thumbs in your vbulletin-options?

Otherwise let me know the adress of your board.

Okay, for some reason after the inital post it seems to work now. Thanks. :)

Actually, sorry but another quick question.. Do you have a modification to make this work with vbadvance? I'm trying to get it to show up on the index page of the site but for some reason it won't show the pictures. Thanks!

I've one. But i have to check, if it still works with vbadvanced. Wait for the weekend.

Two quick questions that maybe I've overlooked:

1) Is it possible to have it not expand the images that are uploaded if they are under a specific size. Right now the thumbnails look fine but say a user uploads an image that is only 150x150 pixels the image full display shows it horribly distored and blown up.

2) Images under a certain size look fine in the thumbnail display but when I click on the thumbnail to view the full image I get an empty box with nothing I can click on or see where the image should be.

1) In the gallery_attachment templeat replace it with:

Does anyone have a English version of this up and running?? Specifically I'm trying to see if this is tied to the members profile, that way from the member's profile there's a link to that persons gallery.

@jadkar: This feature isn't implemented. You only can see a certain kind of pictures which has been posted of the member at last. A member-gallery is on the list, but i haven't started yet on it.

Harald_T Couldn't you use the "extension" field in the attachment table to only get images for forum display?

You mean, that only images could be uploaded to the gallery?

not quite but use it in the forum display query

I have it up and running on mine and it does post from their gallery on the members profile. It's pretty sweet. :)

Hello :cool:

I just installed this and I think it is fantastic however, I have a couple of questions please:

1) Even tho the option to download attachments has been enabled for each user group, I find that I am still getting a red x in place of the image when I am not logged in. How can I resolve this issue?

2) I am using a green colored border and green text on the forums. This creates a problem with being able to see the text under the image in the show last pictures area on the forum home. Is there some alternative I can take to help resolve the issue as opposed to having to change my original border and text colors for the entire forum?

3) I noticed that in some places there seems to be a bit of German text here and there. This text is not found in the template areas or in the phrase manager. Can I open the xml page in a text editor, find the text and make the changes from German to English or will this mess things up?

Here is a quick link to the forums for an example of the issues I am having:

http://www.currentday.com/forums/

Your help in resolving the issues would be greatly appreciated.

Sincerely,
Gehanna

1) You have to enable attachment download for unregistered members.
2) You can alter the gallery templates in the gallery_threadbit template. The text DateigroBe is located there too. You can replace it with a phrase by replacing it with $vbphrase[size]. Go to the phrase manager and add a phrase with the variable size, global, vbigallery.
3) That should work, or you can find the phrase manager in the languages & phrase manager and give an alternative translation there.

Hello Bernd,

Thank You for your reply. I will give suggestion #2 a try however suggestion #1 remains an issue as the attachment download for unregistered members is and has been enabled.

Sincerely,
Gehanna

Are you sure you have enabled it through forum permissions\correct forum?


Something completely different.

This hack doesn't support proper resizing of gallery images yet.
I am wondering if the following code can be used?

http://www.phpbuilder.com/board/show...68&postcount=7

I have tried adjusting the gallery_attachment template, but the attached thumbnails are not correctly read.

is the code used to resize the images.
file.jpg has to be replaced with
It seems attachments are not "read" as images, so it has to be either temporarily stored or something else needs to be done..not sure.

Bernd said:
Ahhhh ... it is fixed :banana:

Thank You Bernd very much for your help!!

I hope someone will respond to the questions you asked above as fast as you did mine.

Sincerely,
Gehanna

@Bernd: As far as i remember, there is a function for this. I'll look after it after the weekend. It's already bothering me too, this problem.

Coming soon (maybe tonight):

- new: featured gallery/forum. With the help of this you can define a special gallery or a forum and show the thread at the top of the page. I've to thank Bernd for this, he had the idea on this to do.

Here's a screenshot of it:

Does this forum allow you to restrict access to specific usergroups?

is there a way to get the images that are chosen as for this gallery, to show up on the control panel? I see where images can be submitted, but not where they can be put by admins