http://omeka.org/forums/ Forums Forum: Troubleshooting en Sat, 11 Oct 2008 23:09:10 +0000 http://omeka.org/forums/topic/edit-exhibit-issue#post-685 Fri, 10 Oct 2008 02:32:56 +0000 DaveLester 685@http://omeka.org/forums/ <p>Can you turn on debugging in your application/config/config.ini file and send the error message that's displayed on your screen for that specific page? It should provide a traceroot so we can see what file is causing the problem. </p> http://omeka.org/forums/topic/edit-exhibit-issue#post-680 Sun, 05 Oct 2008 10:36:35 +0000 kkastrad 680@http://omeka.org/forums/ <p>Hi there</p> <p>I have installed the 0.9.2 version of Omeka. I found out that everytime I create an exhibition, if I select "No" at the "Exhibit is Featured" section I get I a debugging page that among other php info includes this</p> <p><code><br /> </code><code>[&quot;message:protected&quot;] =&gt; string(91) &quot;Mysqli statement execute error : Incorrect integer value: &#39;&#39; for column &#39;featured&#39; at row 1&quot;</code></p> <p>Is there something I can do in order to avoid this error, since I don't want every exhibition I create to be in the featured list?</p> <p>Thanks<br /> Kostas </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-679 Fri, 03 Oct 2008 13:55:35 +0000 bkurt78 679@http://omeka.org/forums/ <p>Kris, with your suggestions this is now working just fine so far. We are still running the 0.9.0 version of Omeka, but everything is working nice and stably so far. We are running everything on RHEL 5.2 with their PHP 5.1.xxx. </p> <p>I made the changes to the string casting in the following files:<br /> application/models/ItemTable.php<br /> application/models/TagTable.php</p> <p>Once I made the changes to those files as you directed above we are able to search and order by tag with no errors at all.</p> <p>I'm hoping Red Hat will move PHP to version 5.2 in their upcoming update 3 to RHEL server but there is no guarantee of that and it wouldn't surprise me if they didn't but we can always hope. The bummer is that they have PHP 5.2 available in their application stack product which includes JBOSS and an updated LAMP stack among other things, but application stack is prohibitively expensive unless you are actually need the JBOSS portion of things. </p> <p>If others want to make the plunge and upgrade their RHEL servers to PHP 5.2 there are third party packages out there I found in doing my research. Obviously, using these packages takes you out of having a supported PHP install from Red Hat's perspective but that may not be a big deal to some people. At any rate I found the packages listed below for anyone thats interested. I didn't actually try them myself so use at your own risk, but I imagine they work well.</p> <p><a href="http://www.jasonlitka.com/yum-repository/" rel="nofollow">http://www.jasonlitka.com/yum-repository/</a><br /> <a href="http://oss.oracle.com/projects/php/" rel="nofollow">http://oss.oracle.com/projects/php/</a> </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-678 Thu, 02 Oct 2008 15:30:39 +0000 KrisKelly 678@http://omeka.org/forums/ <p>Some of our other users have had luck running Omeka on a virtual machine, which would give you the most control over how your system is configured. Unfortunately we don't have the resources to continuously test and design against multiple versions of PHP, but if you have any luck getting it to work on your server, please send us a patch and we'll see about integrating it into the Omeka codebase. Thanks! </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-671 Wed, 01 Oct 2008 15:01:47 +0000 bkurt78 671@http://omeka.org/forums/ <p>We are running version 0.9.0 of the software. I just tried upgrading to 0.9.2 and got it to work but we are still having the same issues with tags. So are the only options in this case to run Omeka to either go through and fix the code or break my support with Red Hat? Sounds like a bummer either way. Thanks for the help thus far! </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-670 Wed, 01 Oct 2008 14:53:19 +0000 KrisKelly 670@http://omeka.org/forums/ <p>The problem with the SQL statement is related to the way that PHP 5.1 casts objects to strings. You see the part where it says "Object id #137" in the SQL statement; that is the incorrect representation of an object as a string, whereas it should be another SQL statement that is nested in that i.id IN ( ) clause. </p> <p>One of the big differences between PHP 5.1 and 5.2 is the way that objects are converted to strings, which in this case is causing it to nosedive. </p> <p>In this case, the offending code in question is on line 320 (or thereabouts, depending on the version you're running) of application/models/ItemTable.php, and it is this line:</p> <p><code>$select-&gt;where(&#39;i.id IN (&#39; . (string) $subSelect . &#39;)&#39;);</code></p> <p>if you change <code>(string) $subSelect</code> to <code>$subSelect-&gt;__toString()</code> it will probably work. There may be a bunch of cases like this unfortunately, so there could be multiple spots where your Omeka installation bombs out. </p> <p>What version of the software are you running? </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-669 Wed, 01 Oct 2008 13:11:01 +0000 bkurt78 669@http://omeka.org/forums/ <p>Dave, as I mentioned we are running RHEL 5.2 which doesn't support php 5.2 yet so when you try to even install omeka 0.9.2 it won't go any further. Any ideas on the error above? This error would indicate its more of a sql syntax error than a php problem. </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-665 Wed, 01 Oct 2008 02:32:58 +0000 DaveLester 665@http://omeka.org/forums/ <p>Are you using the most-current version of Omeka, 0.9.2? </p> http://omeka.org/forums/topic/error-when-clicking-on-tag#post-662 Tue, 30 Sep 2008 20:36:14 +0000 bkurt78 662@http://omeka.org/forums/ <p>Whenever we click on a tag on a page we get an error message on screen saying an exception has occurred. In the application logs I see the messages below. It appears to be some sort of error in the sql statement according to the message. We are running on a RHEL 5 system fully patched out which uses php-5.1.6-20.el5_2.1. I know the requirements are to have PHP 5.2 but this needs to run on a Red Hat system and if I upgrade PHP I'm no longer supported so thats just not an option at this point. Any ideas?</p> <p>Type: Omeka_Db_Exception<br /> Date: 2008-09-30T12:53:20-0400<br /> An error occurred within the following SQL statement:</p> <p>SELECT<br /> COUNT(DISTINCT(i.id))<br /> FROM omeka_items i<br /> WHERE<br /> i.public = 1<br /> AND i.id IN (Object id #137)<br /> LIMIT 1</p> <p>^MStack Trace:<br /> #0 /var/www/hosts/memories/html/lits/application/libraries/Zend/Db/Statement.php(109): Zend_Db_Statement_Mysqli-&gt;_prepare('SELECT??COUNT(D...')<br /> #1 /var/www/hosts/memories/html/lits/application/libraries/Zend/Db/Adapter/Mysqli.php(284): Zend_Db_Statement-&gt;__construct(Object(Zend_Db_Adapter_Mysqli), 'SELECT??COUNT(D...')<br /> #2 /var/www/hosts/memories/html/lits/application/libraries/Zend/Db/Adapter/Abstract.php(261): Zend_Db_Adapter_Mysqli-&gt;prepare('SELECT??COUNT(D...')<br /> #3 /var/www/hosts/memories/html/lits/application/libraries/Omeka/Db.php(260): Zend_Db_Adapter_Abstract-&gt;query('SELECT??COUNT(D...', Array)<br /> #4 /var/www/hosts/memories/html/lits/application/libraries/Omeka/Db.php(280): Omeka_Db-&gt;query(Object(Omeka_Select), Array)<br /> #5 /var/www/hosts/memories/html/lits/application/models/ItemTable.php(377): Omeka_Db-&gt;fetchOne(Object(Omeka_Select))<br /> #6 /var/www/hosts/memories/html/lits/application/controllers/ItemsController.php(161): ItemTable-&gt;findBy(Array, true)<br /> #7 /var/www/hosts/memories/html/lits/application/libraries/Zend/Controller/Action.php(497): ItemsController-&gt;browseAction()<br /> #8 /var/www/hosts/memories/html/lits/application/libraries/Zend/Controller/Dispatcher/Standard.php(237): Zend_Controller_Action-&gt;dispatch('browseAction')<br /> #9 /var/www/hosts/memories/html/lits/application/libraries/Zend/Controller/Front.php(911): Zend_Controller_Dispatcher_Standard-&gt;dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))<br /> #10 /var/www/hosts/memories/html/lits/application/libraries/Omeka/Core.php(317): Zend_Controller_Front-&gt;dispatch()<br /> #11 /var/www/hosts/memories/html/lits/index.php(15): Omeka_Core-&gt;dispatch()<br /> #12 {main} </p> http://omeka.org/forums/topic/unknown-mysql-server-host-1270013307-3#post-645 Fri, 26 Sep 2008 06:20:33 +0000 jan 645@http://omeka.org/forums/ <p>Thanks to the guys from omeka we found the solution for this problem.</p> <p>Best jan</p> <p>Zend_Db,don't supports port numbers in the hostname.</p> <p>Looking at the initializeDb() function that begins on line 112 of<br /> application/libraries/Omeka/Core.php (http://tinyurl.com/3usnab), it<br /> looks like the port number is not being passed to the<br /> Zend_Db::factory. (The $dsn variable also looks to be vestigial)</p> <p>So first of all, db.ini needs the addition of :</p> <p>port = "3307"</p> <p>but in order for that to work, we need to add something like:</p> <p>'port' =&gt; $db-&gt;port,</p> <p>to line 128 of Core.php.</p> <p>Is any of this on target Kris?</p> <p>Details are on this page of the Zend<br /> Framework docs:</p> <p><a href="http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.connecting.parameters" rel="nofollow">http://framework.zend.com/manual/en/zend.db.html#zend.db.adapter.connecting.parameters</a> </p> http://omeka.org/forums/topic/unknown-mysql-server-host-1270013307-3#post-644 Thu, 25 Sep 2008 09:27:26 +0000 jan 644@http://omeka.org/forums/ <p>Hi, i get the following error when trying to install omeka.<br /> Unknown MySQL server host '127.0.0.1:3307' (3)<br /> My provider told me this is because omeka try to make the connection over MySQLi .<br /> MySQLi needs the Portinformation as the 4. or 5. Parameter.<br /> can you tell me how to arrange this?<br /> thanks for your help.<br /> best jan </p> http://omeka.org/forums/topic/still-getting-404s-and-whitepages-with-install#post-632 Tue, 16 Sep 2008 18:34:11 +0000 ammon 632@http://omeka.org/forums/ <p>Fritz,</p> <p>A little Google searching turns up the Apache manual for using .htaccess files. </p> <p><a href="http://httpd.apache.org/docs/2.0/howto/htaccess.html" rel="nofollow">http://httpd.apache.org/docs/2.0/howto/htaccess.html</a></p> <p>Give that a look over and see the section 'How directives are applied' for an example on how to get your 'Options' into the .htaccess file. </p> http://omeka.org/forums/topic/still-getting-404s-and-whitepages-with-install#post-627 Mon, 15 Sep 2008 22:20:21 +0000 Fritz 627@http://omeka.org/forums/ <p>I'm giving up. I'll try this thing again next summer.<br /> Thanks,<br /> Fgs </p> http://omeka.org/forums/topic/omeka-on-solaris-10#post-623 Fri, 12 Sep 2008 14:19:55 +0000 KrisKelly 623@http://omeka.org/forums/ <p>You can try setting the display_errors flag in your .htaccess to 1 instead of 0. If you're getting a blank screen it may show you the error message instead. Let us know if that works. </p> http://omeka.org/forums/topic/imagemagick-error#post-618 Thu, 04 Sep 2008 13:35:58 +0000 bethnicol 618@http://omeka.org/forums/ <p>FYI:<br /> I was having this issue as well -- </p> <p>hosting: pair.com<br /> path to convert: /usr/local/bin/convert</p> <p>I did indeed have to make the suggested change in File.php in order to correct the issue.</p> <p>Also, because I can run under php-cgiwrap on pair, I didn't have to set the folders in archive to 777 - they can stay 755, which makes me much more comfortable. </p> http://omeka.org/forums/topic/omeka-on-solaris-10#post-616 Wed, 03 Sep 2008 16:35:07 +0000 Dhanu 616@http://omeka.org/forums/ <p>Hi Dave,</p> <p>We enabled the error log, but it doesn't report any errors. And just to make sure our ImageMagick is working fine, we installed Gallery2 on the same server and it works fine. So it can't be a problem with ImageMagick, unless Omeka needs a very specific version of ImageMagick.</p> <p>Any thoughts?</p> <p>Thanks. </p> http://omeka.org/forums/topic/omeka-on-solaris-10#post-614 Fri, 29 Aug 2008 15:31:29 +0000 DaveLester 614@http://omeka.org/forums/ <p>1) Try editing the config.ini file in the/application/config/ folder, and change debug.exceptions on line 24 to true instead of false. That should (hopefully) print out some helpful information -- try causing the same error again and let us know what it says.</p> <p>2) The form submits to the ItemsController, located in /application/controllers/ </p> http://omeka.org/forums/topic/omeka-on-solaris-10#post-612 Thu, 28 Aug 2008 13:56:31 +0000 Dhanu 612@http://omeka.org/forums/ <p>Hi All,</p> <p>we are trying to set up Omeka 0.9.2 on a Solaris 10 machine.<br /> Our configurations are as follows.</p> <p>Apache - 2.2.8<br /> PHP - 5.2.6<br /> MySQL - 5.0.51b<br /> ImageMagick - 6.3.8</p> <p>1)<br /> When we follow "add an item" to add a JPG or a TIFF after the final step an empty page is displayed with no html source code. But when we check the archive folder the image has been properly resized and square and thumbnails have been produced. So Imagemagick seems to be working fine. In the public site the submission is been shown with all the meta data but without the image.</p> <p>When we follow "add an item" to add a PDF file system works perfectly and you can see the submission with the PDF file from the public site.</p> <p>Can someone please direct us in the appropriate direction to solve this problem.</p> <p>2)<br /> Where does the admin\themes\default\items\form.php submits to?</p> <p>Thanks in advance. </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-598 Thu, 14 Aug 2008 17:29:42 +0000 KrisKelly 598@http://omeka.org/forums/ <p>Good to hear that you got it working, though it's too bad that MAMP doesn't play well with ImageMagick. Let us know if you need any more help with anything! </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-596 Thu, 14 Aug 2008 11:45:03 +0000 inactinique 596@http://omeka.org/forums/ <p>OK, I found the problem.</p> <p>I read this thread on the same forum: <a href="http://omeka.org/forums/topic/imagemagick-error?replies=4#post-446" rel="nofollow">http://omeka.org/forums/topic/imagemagick-error?replies=4#post-446</a></p> <p>On line 347 application/models/File.php, you I changed $path . ' -version' to just $path.</p> <p>And Omeka works! </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-595 Thu, 14 Aug 2008 11:19:38 +0000 inactinique 595@http://omeka.org/forums/ <p>I gave up Fink, MAMP etc.</p> <p>I'm now using Mac OS X's Apache, entropy.ch's PHP5, MySQL compiled from source, ImageMagick compiled from source, magick.so compiled from source. I changed the php.ini file in ordre to tell PHP that it can use magick.so.</p> <p>And omeka still says me: "ImageMagick is not well configured".</p> <p>This time, convert is in /usr/local/bin</p> <p>I strangelly can't manage to change the path of the apache's environment. </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-584 Sat, 09 Aug 2008 07:13:42 +0000 inactinique 584@http://omeka.org/forums/ <p>Hi. Here are some links:</p> <p>- <a href="http://forum.macbidouille.com/index.php?showtopic=254569" rel="nofollow">http://forum.macbidouille.com/index.php?showtopic=254569</a> (in French),<br /> - <a href="http://ez.no/developer/forum/developer/problem_with_imagemagick" rel="nofollow">http://ez.no/developer/forum/developer/problem_with_imagemagick</a> (in English)</p> <p>It seems I could get Omeak to work with Apache/MySQL/PHP/ImageMagick compiled from Fink or MacPorts. </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-583 Fri, 08 Aug 2008 22:56:04 +0000 KrisKelly 583@http://omeka.org/forums/ <p>Very interesting. Could you do me a favor and post a link to the pages that said it was impossible to configure ImageMagick with MAMP? Thanks. </p> http://omeka.org/forums/topic/still-getting-404s-and-whitepages-with-install#post-581 Fri, 08 Aug 2008 16:48:30 +0000 Fritz 581@http://omeka.org/forums/ <p>I'm getting a 500 error that says &lt;Directory not allowed in the .htaccess file. Is there another way to get those commands into the file without putting it into the directory tag? </p> http://omeka.org/forums/topic/still-getting-404s-and-whitepages-with-install#post-580 Fri, 08 Aug 2008 16:07:04 +0000 ammon 580@http://omeka.org/forums/ <p>Fritz,</p> <p>Try adding this to the bottom of your .htaccess file.<br /> <code><br /> &lt;Directory /home/web/manchester-press.com/data&gt;<br /> Options -MultiViews -Includes -FollowSymLinks -Indexes<br /> Order Deny,Allow<br /> Allow from all<br /> &lt;/Directory&gt;<br /> </code></p> <p>This will disable the options set in the apache conf file. This might be necessary because MultiViews, if it can't find a file or directory, kind of makes one up. You'll also want to disable Indexes, so that the directory structure is not visible. Includes (server side includes) are pretty insecure, so it's also best to disable those. You probably won't have any symbolic links to worry about, so it's safe to disable that as well.</p> <p>Let us know if that works or does not. </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-579 Fri, 08 Aug 2008 07:28:49 +0000 inactinique 579@http://omeka.org/forums/ <p>Hi,</p> <p>thanks for your answer. I followed the instructions on that page:<br /> <a href="http://www.brybot.ca/archives/113-Getting-Imagemagick-and-more-to-work-with-MAMP-on-OS-X.html" rel="nofollow">http://www.brybot.ca/archives/113-Getting-Imagemagick-and-more-to-work-with-MAMP-on-OS-X.html</a></p> <p>I managed to add /sw/bin in Apache's PATH environment.</p> <p>Unfortunately, it did not solve my problem.</p> <p>Is there something I missed in the ImageMagick installation? a mod something that has to be installed?</p> <p>Is it possible to use images in Omeka (I'm just testing it) without ImageMagick?</p> <p><strong>EDIT: After looking at some webpages, it is probably impossible do configure ImageMagick to work with the MAMP's Apache version.</strong> </p> http://omeka.org/forums/topic/collection-seletion-list-in-the-default-admin-theme#post-578 Thu, 07 Aug 2008 18:52:40 +0000 gcollum 578@http://omeka.org/forums/ <p>Thanks Sheila,</p> <p>Will do.</p> <p>Garry </p> http://omeka.org/forums/topic/imagemagick-fink-mac-os-x-etc#post-577 Thu, 07 Aug 2008 17:14:28 +0000 KrisKelly 577@http://omeka.org/forums/ <p>Is /sw/bin in your Apache environment's path? I'm not sure if that would be the cause of the problem, but you can try it out and see. You can figure that out by looking at your phpinfo dump and looking at PATH under the Apache Environment heading. Let me know if adding that directory to your path solves your problem. </p> http://omeka.org/forums/topic/collection-seletion-list-in-the-default-admin-theme#post-576 Thu, 07 Aug 2008 15:44:09 +0000 SheilaBrennan 576@http://omeka.org/forums/ <p>Hi Garry, </p> <p>There is a patch for this available that was posted to the forums and on our dev list:</p> <p><a href="http://groups.google.com/group/omeka-dev/browse_thread/thread/1cfa3fa1fc19726c" rel="nofollow">http://groups.google.com/group/omeka-dev/browse_thread/thread/1cfa3fa1fc19726c</a></p> <p>To apply the patch, download the attached file and try:<br /> patch -p0 &lt; collections_limit.patch in the root of your installation.</p> <p>If you haven't already, please feel free to join the dev list.</p> <p>Sheila </p> http://omeka.org/forums/topic/still-getting-404s-and-whitepages-with-install#post-575 Thu, 07 Aug 2008 15:13:00 +0000 Fritz 575@http://omeka.org/forums/ <pre><code>&lt;Directory &quot;/home/web/manchester-press.com/data&quot;&gt; Options Indexes FollowSymLinks MultiViews Includes AllowOverride All Order allow,deny Allow from all &lt;/Directory&gt;</code></pre> <p>My sysadmin reports that the above is my entry in the .conf file. Is there anything in this that could be killing the omeka install? </p>