Library Image Show Problem

The file is uploading I can see inside of library folder. But I can't show on layout or I can't preview thumbs. It means this is about database I think? I don't know. It is very urgent. :( If you help me I will very apperaciate to you.

Are you sure you didn't change the SENDFILE_MODE setting to something your web host doesn't support?

Try setting it to OFF for the moment and see if that helps.

Otherwise, have a look in the logs to see if there are any errors being logged.

Yesterday I put password to mysql and phpmyadmin. But I don't think it is about of this.

And how I will make OFF what is sendfile_mode?

My Clients and Server 1.4.2
Server ubuntu 10.0.4
Clients win 7 professional 32 bit

my library folder /xibo-library/

I give www-data permissions. I can upload the images I can see inside of the library folder. But I can't see on cms?

I couldn't find similar my problem in launchpad but there is one : https://answers.launchpad.net/xibo/+question/63462

Here is my logs : https://www.dropbox.com/s/idvupr3ujvve3jh/Logs.txt

I opened a layout and select background after that I upload image, saved. Nothing happened.

And here is the screenshot : https://www.dropbox.com/s/i81dqem842x6d3u/thumb.png

I will be really crazy :( I looked everything but nothing changed! I know It is very easy problem. It is little thing I can't see but what is this! :'(

By the way I have localhost. I'm not using any web host.

Sorry I'm doing spam but it is very important for me. There is another information, if I take url to the clipboard and open a webpage. That error is coming.

"cannot be displayed, because it contains error" It is about GD but on the cms gd looks ok. And before I was using. Please Dan, Please Alex help me and save my a.. :(

If it helps here is my client logs : https://www.dropbox.com/s/ukqlz1r18l7vmwv/XiboLog.txt

I created a design with 2 images and these are the logs. I hope I explained everything.

The client logs say that the layout xml isn't valid. Can you post the xlf
for the layout

<?xml version="1.0"?>
<layout schemaVersion="1" width="800" height="450" bgcolor="#000000" background=""><region id="53e3d9111d6ff" userId="1" width="468" height="267" top="71" left="107"><media id="12" type="image" duration="10" lkid="135" userId="1" schemaVersion="1">
                            <options><uri>12.jpg</uri></options>
                            <raw/>
                    </media><media id="21" type="image" duration="4" lkid="136" userId="1" schemaVersion="1">
                            <options><uri>21.jpg</uri></options>
                            <raw/>
                    </media></region></layout>

As I said there is only two images. The client can't show the images so It is hanging on splash screen.

I will eat my brain really.

It's not hanging because it can't show the images, it's going to the splash
screen because it says that layout xml is invalid. I'm not sure why though
because it looks OK to me.

Presumably you've already tried clearing the client library directory?

Yes I also cleared. Alex the problem is not client.

It is about someting on server because cms can't preview the thumbnails so It means there is some error on mysql or another thing but I don't know why? :S

Really It is god damn problem I hope nobody can have this.

I don't want to setup new installation because I must change settings of every client. I can upload backup of sql but I don't know maybe it is about sql. Aargh.

MySQL has no part in previewing thumbnails. You need to revert the changes
you made one at a time until it starts working again

I don't remember and I don't think I made mixing this issue.

Ok then. I think I must reinstall and do some tests.

Yesterday I made these things? To recovery password etc.

http://coolestguidesontheplanet.com/how-to-change-the-mysql-root-password/

Do you think some of the codes caused this problem?

For example : sudo mysqld_safe --skip-grant-tables

FLUSH PRIVILEGES;

And at the end I run resetroot.bat file.

Here is the content;

@ECHO OFF
..\apache\bin\pv.exe --kill --force mysqld*.exe >nul 2>&1

ECHO USE `mysql`; >resetroot.sql
ECHO. >>resetroot.sql
ECHO INSERT IGNORE INTO `user` VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0); >>resetroot.sql
ECHO REPLACE INTO `user` VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0, 0); >>resetroot.sql
ECHO INSERT IGNORE INTO `user` VALUES ('localhost', 'pma', '', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0); >>resetroot.sql
ECHO REPLACE INTO `user` VALUES ('localhost', 'pma', '', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0, 0); >>resetroot.sql

bin\mysqld.exe --no-defaults --bind-address=127.0.0.1 --bootstrap --console --skip-grant-tables --skip-innodb --standalone <resetroot.sql >resetroot.err 2>&1
IF ERRORLEVEL 1 GOTO FEHLER
GOTO KEINFEHLER

:FEHLER
TYPE resetroot.err
ECHO.
ECHO Passwoerter fuer Benutzer "root" und "pma" wurden nicht geloescht!
ECHO Passwords for user "root" and "pma" were not deleted!
GOTO WEITER

:KEINFEHLER
ECHO.
ECHO Passwoerter fuer Benutzer "root" und "pma" wurden geloescht.
ECHO Passwords for user "root" and "pma" were deleted.
ECHO.
ECHO Bitte den MySQL Server neu starten.
ECHO Please restart the MySQL server.
GOTO WEITER

:WEITER
DEL resetroot.err
DEL resetroot.sql
ECHO.
PAUSE

As long as you backup the server library and MySQL database fully then you
can always restore to where you are now

I was waiting you will give me an answert and I will repair it. But it is hard huh?

Anyway, thank again try to help me.

Last question,

Tomorrow I will install windows 7 for server. I will make fresh installation but I don't want to lost connection with clients. I don't want to set all of them. So If I take display table can I save my clients and licenses?

Maybe when I install fresh xampp everything will be good. Let's see. I'm very sad about this situtation. :( Thanks anyway.

You need to take the complete database
and server library, not just part of it.

If your system is this critical then you really should consider having it
professionally hosted so y
you have backup from someone if a situation like this occurred

It is unlikely you have an un-recoverable error with your installation, but as Alex says it sounds like you will need some professional help to connect up and look at it for you.

There are companies that will be able to help you with this in the Xibo Directory.

I overwrite xibo files to my folder and now it works. It wasn't about mysql or something It was about filesystem. Again I don't know what but I think I did something. Thanks for you patience.