Support community for TTG plugins and products.
NOTICE
The Turning Gate's Community has moved to a new home, at https://discourse.theturninggate.net.
This forum is now closed, and exists here as a read-only archive.
You are not logged in.
After having not updated my CE4 plugins for a long time I am a bit confused how to get the latest versions of my modules. In the past I got links or I had the chance to download them with my order numbers, but all old links are dead and I wasn´t able to find a link that works. What can I do?
Wolfram
Thanks Ben!
Hi,
updated all plugins (Publisher, Gallery, AutoIndex,...)
Tried today to update one of my Galleries and got the following error:
Ein interner Fehler ist aufgetreten: JSON.lua:458: JSON.lua:197: can't parse JSON at char 1 of: Update query failed with error: SQLSTATE[HY000]: General error: 1 no such column: top_level_gallery_path
sql:
'UPDATE `album` SET
`id`=\'10166\',
`publisher_root_id`=\'1\',
`parent_id`=\'\',
`type`=\'album\',
`slug`=\'black-and-white\',
`breadcrumb`=\'\',
`title`=\'B&W Prints\',
`description`=\'\',
`template`=\'gallery_CE4_Galleries\',
`page_copy`=\'\',
`page_copy_placement`=\'replace\',
`sidebar_copy`=\'\',
`sidebar_copy_placement`=\'replace\',
`enable_video`=\'no\',
`video_id`=\'\',
`cover_image`=\'custom_thumbnails/\',
`items_per_page`=\'100\',
`enable_maps`=\'no\',
`enable_password`=\'no\',
`username`=\'\',
`password`=\'enc_a0636379347e32d1ff25e9cfa632d385\',
`enable_cart`=\'yes\',
`pricing_scheme`=\'Print\',
`enable_crg`=\'no\',
`crg_feedback_profile_id`=\'\',
`crg_client_mode`=\'\',
`ordering`=\'lightroom\',
`has_user_order`=\'yes\',
`hide_from_autoindex`=\'no\',
`hide_from_search`=\'no\',
`show_breadcrumbs`=\'yes\',
`needs_first_visit`=\'no\',
`created`=\'2015-02-24 13:12:05\',
`modified`=\'2015-06-26 13:23:46\',
`top_level_gallery_path`=\'../galleries.php\',
`top_level_gallery_title`=\'Galleries\'
WHERE `id`=\'10166\''
params:
array (
)|#0 /home/.sites/351/site6695921/web/ttg-be/framework/dao/PdoExtended.php(449): PdoExtended->_throwSqlQueryException('UPDATE `album` ...', Array, 'Update query fa...')
#1 /home/.sites/351/site6695921/web/ttg-be/framework/dao/GenericDAO.php(31): PdoExtended->update('album', Array, Array)
#2 /home/.sites/351/site6695921/web/ttg-be/publisher/application/dao/AlbumDAO.php(131): GenericDAO->editItem(10166, Array)
#3 /home/.sites/351/site6695921/web/ttg-be/publisher/application/controllers/ApiController.php(763): AlbumDAO->editAlbum(10166, Array)
#4 [internal function]: ApiController->setPhotoOrder()
#5 /home/.sites/351/site6695921/web/ttg-be/framework/controllers/Controller.php(41): call_user_func_array(Array, Array)
#6 /home/.sites/351/site6695921/web/ttg-be/framework/Framework.php(124): Controller->dispatch(Array)
#7 /home/.sites/351/site6695921/web/ttg-be/publisher/index.php(23): Framework->route()
#8 {main}|URL: /ttg-be/publisher/index.php
What can I do?
I get these errors on both of my pages:
www.art4u.photography
www.art4u.gallery
No show stopper, I can live with that
Thanks Ben!
Hi Ben,
sorry for confusion, just found a good solution:
The price in the gallery is the the price without tax, which is the same as for all non European customers.
Afterwards according to the delivery country tax and shipping is added. That´s perfect for me.
If we are talking of an European customer with valid UID-number I need to give him the same status as non-European customers (no tax, only shipping)
We are almost there!
Thanks
One more thing,
I am charging the Austrian tax (VAT) only when shipping to an European country (exept if the European customer outside of my country has a valid UID-number). When shipping to one of all other countries in the world I ship without tax, only add the shipping costs.
So in my understanding I need to start with the ground price (no tax), when the Delivery country is one of the European countries I need to add the Austrian tax.
When I select a European country it does not add the tax it only shows me that € ... is allready included what is not true.
Am I wrong?
Hello Ben,
thanks for the improvements!
I understand that I have to add the additional needed UID-number field which the customer fills in during the checkout. The customer allway pays the full price with the included tax.
I get the order, check via internet the UID number and if it is valid give him the tax back.
I don´t know if there is a better way so that the customer does not have to pay the tax first and get it back later?
I don´t know if there is a possibility, that whenever the customer fills in a UID number that the order process is interrupted, I get a mail, check the number, if it is ok I send him a discount number for the included tax and he finishes the order with the reduced price?
Any ideas are wellcome!
Thanks
Wolfram
Ben,
When I am talking of VAT, then I am talking of sales tax.
So, when I am selling Prints (no digital downloads, there I don´t know the law)to someone in the EU and the customer has no VAT reg. nr. then I have to add our Sales tax.
So I only need to extend the Sales Tax Country to all European countries. If there is a possibility for the customer to insert in a separate field the VAT. reg. Nr. which would exclude then the addition of Sales Tax it would be perfect.
For a correct bill then we would also need to have the VAT. reg. Nr. of the Seller and the Customer below its address.
Hallo together,
At the moment I intend to add the VAT to the price, tell the people that the VAT is included and everyone that is outside the EU or has an UID-number will get a discount code to reduce the overall price by the included VAT.
Best for me would be to have a possibility to choose for which countries I would like to add the VAT.
If an American sells something to Europe he ships it without VAT and the European customs will charge the tax from the customer.
Greetings
Wolfram
Sorry, I dont want to hijack this posting, the point is that I have the same problem and urgently need to solve it.
Thanks Ben, for the quick and professional help!
Hello Ben,
I´ve sent you the requested log
Thanks for your support.
When I add this WS_20140922_0977 to the pictures it looks normal. when I take it out of the gallery as normal, the picture is not there anymore but the empty 20/22. This happens only with this picture.
Hi,
there is something where I don´t know what I did wrong. In my gallery view there is a picture which I do not have in Lightroom and I don´t know how to delete it.
Please have a look:
http://www.art4u.photography/galleries/ … afie-graz/
Picture 1/22 is not existing in Lightroom. Is there a possibility to get rid of this non existing picture?
I republished the pictures and now it´s 20/22 !?
I think the issue with the size is the fact that my pictures originally are all 16 bit adobe rgb files. When exporting them via publisher it converts them into 8 bit rgb files but it does not export them as srgb, they are still adobe rgb files, thats why they are double the size.
Is there a possibility to change the color space in the export configuration of the templates or the publisher?
Finally I got an Email from my Hoster, that they are sorry it was a problem in their system and now it should work!
Nevertheless I want to say Thank You to all the great guys that tried to help me!
Thanks,
Wolfram
According to Ben´s suggestion I got in touch with my host provider They increased the available RAM (memory_limit) to 128M which seems to be the max for my package.
The site works better now but still not perfect.
I am using this site for picture galleries and a blog.
So, how can I improve my situation (what uses most ram?), or do I have to change the hosting package?
Thanks for Your support!
br
Wolfram
Thanks Ben,
the reason why I didn´t think about this as issue is, that I have a second, private, page at the same host without problems at all.
www.artography.eu
br
Wolfram
Ben, I wrote you a mail!
If there is a way to get rid of the problems, please Your help is apreciated.
Wolfram
Guys, now I think I have an idea what is wrong.
When checking at my host i get a long php error log with the following:
[Sun Aug 10 09:41:56 2014] [error] [client 157.55.39.228] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 09:45:03 2014] [error] [client 212.183.62.59] File does not exist: /home/.sites/500/site9562498/web/favicon.ico
[Sun Aug 10 09:45:03 2014] [error] [client 212.183.62.59] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 09:50:29 2014] [error] [client 91.178.1.20] File does not exist: /home/.sites/500/site9562498/web/favicon.ico
[Sun Aug 10 09:50:29 2014] [error] [client 91.178.1.20] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 09:50:29 2014] [error] [client 91.178.1.20] File does not exist: /home/.sites/500/site9562498/web/favicon.ico
[Sun Aug 10 09:50:29 2014] [error] [client 91.178.1.20] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 10:36:56 2014] [error] [client 212.183.62.59] File does not exist: /home/.sites/500/site9562498/web/favicon.ico
[Sun Aug 10 10:36:56 2014] [error] [client 212.183.62.59] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 10:56:10 2014] [error] [client 157.55.39.209] File does not exist: /home/.sites/500/site9562498/web/resources
[Sun Aug 10 10:56:10 2014] [error] [client 157.55.39.209] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 11:22:50 2014] [error] [client 66.249.78.242] File does not exist: /home/.sites/500/site9562498/web/galleries/7-diverse-fotografie
[Sun Aug 10 11:22:50 2014] [error] [client 66.249.78.242] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 11:32:03 2014] [error] [client 188.23.52.50] File does not exist: /home/.sites/500/site9562498/web/favicon.ico
[Sun Aug 10 11:32:03 2014] [error] [client 188.23.52.50] File does not exist: /home/.sites/500/site9562498/web/error
[Sun Aug 10 11:59:23 2014] [error] [client 62.210.73.70] File does not exist: /home/.sites/500/site9562498/web/feed
[Sun Aug 10 11:59:23 2014] [error] [client 62.210.73.70] File does not exist: /home/.sites/500/site9562498/web/error
So my standard procedure when changing somethin in the Lightroom web-site setup:
1.) exporting the page-gallery, the Gallery-template, the AutoIndex-template and the wordpress-template to the desktop.
2.) uploading the files of the pages-folder (except the gallery-folder) to the root of my homepage
3.) uploading the Gallery-template to ttg-be/templates/gallery/
4.) uploading the AutoIndex-template to ttg-be/templates/autoindex/
5.) uploading the Wordpress-template to wordpress/wp-content/themes/
6.) updating all Albums from within Lightroom
Nevertheless it looks like something with the php-path is wron because according to the error log some files can not be found.
Any idea what went wrong? Looks like something in my working order is wrong
Hi Fredy,
yes I have the same experience, it looks like to loose sometimes the connection, but we have another page also at this hoster without these problems. Thats why I think it has to do with this page. Whenever I do a site refresh I get different errors, how come.
Thanks anyway!
Greetings to Belgium.
Wolfram
Thanks fredy for the info,
maybe it was during the time i tried the older version without any change, now i changed back to the latest version, same behavior. I don´t know what else i could do, tried almost everythingbut something must be wrong.
I am trying now since three days to get my gallery pages working, but no success!
Every time I am in the deepest level of the galleries I get corrupt results. Every refresh of the page gives me a different kind of corruption.
I am at the end, I don´t know what else to try?! I need to have my page online again by tomorrow!
Please, has anyone out there an idea?
It´s an Austrian hosting, up to now I had no problem with them. I also changed the jpeg compression from 80 to 60%, no difference.
With Firefox it looks better, but with several refreshes I get also problems.
If you have any idea what else to check, please tell me.
br
Wolfram