Hi, ok fixed the problem with the theme not loading, It was because there was no themeoptions.php. I've create a blank one (see below) now and all seems fine.
Here is the themeoptions.php code i've used, php is way above my head but seems to be working ok and no errors on the theme options page.
`
`
Can you please let me know if I should change it..
Yes paragraphs are now working fine, thank you very much!
Will do some general testing and if all goes well upgrade Lis's site to this
version.
Thankyou again : - )
boo
Hi, ok.
Have found an issue with copy image, I get:
Zenphoto Error
MySQL Query ( INSERT INTO zp_images (albumid, filename, title, desc, location, city, state, country, credit, copyright, commentson, show, date, sort_order, height, width, thumbX, thumbY, thumbW, thumbH, mtime, hitcounter, total_value, total_votes, used_ips, EXIFOrientation, EXIFMake, EXIFModel, EXIFExposureTime, EXIFFNumber, EXIFFocalLength, EXIFFocalLength35mm, EXIFISOSpeedRatings, EXIFDateTimeOriginal, EXIFExposureBiasValue, EXIFMeteringMode, EXIFFlash, EXIFImageWidth, EXIFImageHeight, EXIFContrast, EXIFSharpness, EXIFSaturation, EXIFWhiteBalance, EXIFSubjectDistance, EXIFGPSLatitude, EXIFGPSLatitudeRef, EXIFGPSLongitude, EXIFGPSLongitudeRef, EXIFGPSAltitude, EXIFGPSAltitudeRef, custom_data, rating, rating_status, EXIFDescription, EXIFArtist, EXIFCopyright, IPTCImageCaption, IPTCImageCaptionWriter, EXIFDateTime, EXIFDateTimeDigitized, IPTCDateCreated, IPTCTimeCreated, IPTCDigitizeDate, IPTCDigitizeTime, IPTCImageCredit, IPTCByLine, IPTCByLineTitle, IPTCSource, IPTCContact, IPTCCopyright, EXIFFocalLengthIn35mmFilm, IPTCCity, IPTCSubLocation, IPTCState, IPTCLocationCode, IPTCLocationName, IPTCImageHeadline, IPTCOriginatingProgram, IPTCProgramVersion, Location, City, State) VALUES ('14', 'toward-salcombe-hill-sidmouth.jpg', 'View from Connaught Gardens', 'This view is looking towards the town and Salcombe Hill from Connaught Gardens.', NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '2009-08-28 17:30:00', '4', '500', '750', '107', '0', '482', '482', '1251477000', '41', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'A Photo of Sidmouth viewed from Connaught Gardens - Lis Elwell\'s Photo Gallery', '0', '3', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); ) failed. Error: Column 'state' specified twice
Also a very minor bug, when changing image order the top save button doesn't work, bottom button does.
When creating a new album, the created album folder name is case sensitive, personally I would prefer the folder name to be forced as lower case, but then that is my preference and is not really a problem.
Thanks,
boo
Quote:When creating a new album, the created album folder name is case sensitive, personally I would prefer the folder name to be forced as lower case, but then that is my preference and is not really a problem.
Welcome to the world of Unix identifiers. Case matters (unfortunately).
I have reproduced the SQL error above. Once I figure out what is causing it I will get a fix up.
Regarding the SQL error. Unfortunately it seems that an error in one of the SVN updates caused the image table country, location, state, and credig fields to be set with capital first letters. MySQL is not case sensitive (Yeah!) but unfortunately, PHP is.
The simplest fix is to drop your images table and re-run setup. Most likely, doing an zenphoto backup first will preserve your data, but no guarantees. You can also try renaming these fields. (Yes, I know they appear to be in lowercase in phpMyAdmin.)
Hi, ok I have a backup from June 1.2.5 version which is also the current live site version.
Will upgrade my test machine from the above version and re-test.
Regarding case, would also be good to force lower case on image filenames as well.
Had a problem when using online sitemap generator tools, they ignored case and created all the urls in lowercase which of course were then incorrect. So I'm now using GSiteCrawler which has an option for unix case sensitive urls.
I recently renamed all of Lis's image filenames to lowercase for consistency as well as to make it clear to search engines what the image was. ie: jockey-paul-hanagan.jpg,
parrot-macaw.jpg.
It's not a really big issue but we do like to be consistent.
Thanks for your great support,
boo
Hi, ok have tried dropping albums and image tables and ran setup.
Then created 2 test albums and uploaded 2 images to 1 of the test albums
and then tried copying 1 of the images to the other test album
but unfortunately I get same error message.
Also my test machine was set to use an iso... and not utf-8 in php5
which I have now changed to utf-8 as well as the database collation
in phpmyadmnin.
Do I need to do anything to convert all the data in tables / fields to utf8 ?
Thanks,
boo
Hi, have been thinking today, if you look at Lis's gallery index page, the album titles all contain the word "photos" which at the time I thought would be a good move for search engines, but I think now we have tried that now with little success.
It is quite likely that the engines will give the page a lower score for over use of the word "photos"
However, it works for the meta titles for example:
Bird Photos
Photos of Plants and Flowers
If we now change the album titles to:
Birds
Plants and Flowers
We will lose the photos word from the title tag, we could hard code it in to the tag after the title but we then lose some flexibilty and Lis has albums that do not require the word "photos" and some that work better if the word "photos" in front ie:
Designer Art Images
Acknowledgments
Photos of Plants and Flowers
Having typed this out I'm wondering if I'm being too fussy, she could drop the "Acknowledgments" album and insert the word "Photos" the end of the title which would not be so bad.... hmmm
I think there may be a good case to have an optional "Meta Page Title" field on Albums and Images as well as the "Meta Page Description" for which we are currently using the "Custom Data Field".
Hmm, then again maybe the best approach is if we use:
Birds | Lis Elwell's Photo Gallery
Plants and Flowers | Lis Elwell's Photo Gallery
etc.
But then on the album page we lose out for the keyword "photos" on the page but you can't have everything... and nothing is perfect.
Ok, also we have to take into account the extra admin work to maintain the "Page Meta Title" field if we had one - or "Custom Data Fields" using filters.
May I ask your opinion please guys, I really do want to get Lis as many visitors as is possible.
Many thanks,
boo
First, I/we are no SEO experts. You might want to ask something like that in a SEO forum.
Generally I think that you can "overoptimise" a site for search engines. This can lead to texts that are SEO optimised with loads of keywords but hardly readably be real humans. But for whom is the site actually? Right, humans.
As important it is to be found on Google & Co I think that still most visitors surely come by sort of recommendation. Unless you offer something really specific "of use" to people like a script or information about something is is really hard to find anything by simple searching by accident. There are already loads of photography sites out there so it will be really hard to stand out from those. Photos from landscapes or such are not that specifically at all to be found without also looking for the photographer's name.
Some users might have more things to say of that.
Hi, yes good points.
Yes, fairly unique content on not over popular subjects and getting links from other sites / popularity.
I'm determined to get there, without using any "tricks", I think that's the best advice - design for visitors not search engines.
and in our case, keep it as simple as possible and let Lis focus on her content.
Thankyou for your imput : - )
boo