Exhibitions photos

[Ewdiller]

I have installed and upgraded EE and everything was running fine ... now though .... when i click a thumb on the index page ... photo shows up fine.

When i click on an exhibition ... no photos show at all.

Any ideas?

www.ewdiller.com

[jeronimo]

i see everything the way it should be
clicking a thumb gives the biger photo
clicking the exhibition link gives a list of thumbnails, just the way it should be

[Ewdiller]

http://www.ewdiller.com/list.php?exhibition=2&ee_lang=eng

shows a blank page for me. not sure why

[MMCM]

Search you server logs for php or other errors.

[Ewdiller]

looked in the logs and didnt see any errors. .... any other ideas?

[Pekka]

Because all other pages in your EE work ok, it's not a php or server problem. Could be a missing style file. Check that editor/styles has correct paths for "Exhibition browser".

[Ewdiller]

the content template and layout stylesheet are:

templates/pages/ee_2_default/list/default_XHTML_content.php

[Ewdiller]

ok found the problem ... if i leave FREE TEXTUAL INFO (can contain html) blank then the photos show fine ... once i add a description to the exhibition ... no photos show.

Any ideas?

[Pekka]

OK, do you have html or special characters in your exhibition description? Did you type the text there or paste it from some text processing app?

[Ewdiller]

it did have three dots like ...

[Ewdiller]

just tested with any type of comment and same problem ... no pics ... leave it blank and photos show

[Pekka]

Do you see any SQL errors in editor: "Error/debug logs"?

[Ewdiller]

whoa ... theres quite a few. All of them say:

'write message (MESSAGE TABLE WILL BE REBUILT)' in 'SCRIPT_editor_functions.php'

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 't logged in ','internal ftp', NULL)' at line 3

[wkitty42]

does that username have any punctuation characters in it... like maybe an apostrophe?

[Ewdiller]

no punctuation in the username.

[Pekka]

whoa ... theres quite a few. All of them say:

'write message (MESSAGE TABLE WILL BE REBUILT)' in 'SCRIPT_editor_functions.php'

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 't logged in ','internal ftp', NULL)' at line 3

Could you let me in your EE Editor to check things out? That would help a lot. PM me access info if you can.

[Ewdiller]

pm sent ... thank you

[Pekka]

I fixed the blank page problem by

changing in list.php

print ee_textblock_print(ee_html_conversion_output($exhi bition_description,"0",$s_activate_br_list));

to

print ee_textblock_print($exhibition_description,"0",$s_activate_br_list);

That fix removes only one unused function (which returns exactly whatyou put in it), I really have no idea why it caused havoc in your server. Maybe a PHP bug.

The other errors you have in error log are caused by mysql_real_escape_string function not being able to work always with your external MySQL server behind TCP/IP (maybe MySQL character sets are not passed properly). To debug this would be hard, but I suspect it could be fixed by upgrading PHP. I fixed the message table errors, but if you have more let me know.

[Ewdiller]

thank you for your time ... appreciate it very much