msoft

Hi, it´s me again, Martin

Gallery: http://www.shop.pilotviews.com

Installed 3.2.4

It´s almost functioning, there are a few minor glitches i can live with, but

there are two major problems for me.

After Email checkout, the notification Email to the Shopowner is not going out. Well it goes out, but there is no content.

The Mail shows only:

Normal
0

21

false
false
false

DE-AT
X-NONE
X-NONE

MicrosoftInternetExplorer4

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Normale Tabelle”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:”Calibri”,”sans-serif”;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:”Times New Roman”;
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:”Times New Roman”;
mso-bidi-theme-font:minor-bidi;}

From: “Pilotviews Onlineshop” Content-type: text/html; charset=utf8
====================================
The Mail to the customer is perfect! All nessesary content displayed!

The second thing is, when i go to “Sales” in the Back Office, everything but the STREET ADRESS  is displayed, which is the most important field for me, cause i need to know the shipping address.
If i check out with PayPal, all the fields are filled with  ”  a,  ”
Please guys, HELP me!!!
I want to get online a.s.a.p.
Martin
Ah yes, i found inside php code the word ” berofe” and changed it to “before”, but it seems that this had no impact on any of the features!

Here is the latest ERROR LOG
[23-Mar-2013 10:19:11 UTC] WordPress-Datenbank-Fehler Unknown column ‘excerpt’ in ‘order clause’ für Abfrage SELECT SQL_CALC_FOUND_ROWS  im.ID, im.post_title, p.comment_status,
pm.meta_value meta, im.post_excerpt, im.post_parent, im.post_type, p.post_author
FROM ( SELECT * FROM pvs_posts  ORDER BY
excerpt ASC )  AS im

LEFT JOIN pvs_postmeta AS pm ON pm.post_id = im.ID
LEFT JOIN pvs_posts AS p ON p.ID =  im.post_parent

WHERE im.post_type = ‘ims_image’ AND pm.meta_key = ‘_wp_attachment_metadata’
AND im.post_status = ‘publish’ AND p.post_status = ‘publish’ AND im.post_parent IN (  SELECT DISTINCT ID FROM pvs_posts WHERE 0 = 0 AND
post_type = ‘ims_gallery’ AND post_status = ‘publish’ AND post_password = ” )
GROUP BY im.post_parent ORDER BY p.post_date DESC, p.post_date DESC
von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/celestial-lite/page.php’), get_template_part, locate_template, load_template, require(‘/themes/celestial-lite/partials/content-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ImStoreFront->imstore_shortcode, ImStoreFront->get_galleries

[23-Mar-2013 10:19:35 UTC] WordPress-Datenbank-Fehler Unknown column ‘title’ in ‘order clause’ für Abfrage SELECT SQL_CALC_FOUND_ROWS  im.ID, im.post_title, p.comment_status,
pm.meta_value meta, im.post_excerpt, im.post_parent, im.post_type, p.post_author
FROM ( SELECT * FROM pvs_posts  ORDER BY
title ASC )  AS im

LEFT JOIN pvs_postmeta AS pm ON pm.post_id = im.ID
LEFT JOIN pvs_posts AS p ON p.ID =  im.post_parent

WHERE im.post_type = ‘ims_image’ AND pm.meta_key = ‘_wp_attachment_metadata’
AND im.post_status = ‘publish’ AND p.post_status = ‘publish’ AND im.post_parent IN (  SELECT DISTINCT ID FROM pvs_posts WHERE 0 = 0 AND
post_type = ‘ims_gallery’ AND post_status = ‘publish’ AND post_password = ” )
GROUP BY im.post_parent ORDER BY p.post_date DESC, p.post_date DESC
von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/celestial-lite/page.php’), get_template_part, locate_template, load_template, require(‘/themes/celestial-lite/partials/content-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ImStoreFront->imstore_shortcode, ImStoreFront->get_galleries

[23-Mar-2013 10:19:58 UTC] WordPress-Datenbank-Fehler Unknown column ‘date’ in ‘order clause’ für Abfrage SELECT SQL_CALC_FOUND_ROWS  im.ID, im.post_title, p.comment_status,
pm.meta_value meta, im.post_excerpt, im.post_parent, im.post_type, p.post_author
FROM ( SELECT * FROM pvs_posts  ORDER BY
date ASC )  AS im

LEFT JOIN pvs_postmeta AS pm ON pm.post_id = im.ID
LEFT JOIN pvs_posts AS p ON p.ID =  im.post_parent

WHERE im.post_type = ‘ims_image’ AND pm.meta_key = ‘_wp_attachment_metadata’
AND im.post_status = ‘publish’ AND p.post_status = ‘publish’ AND im.post_parent IN (  SELECT DISTINCT ID FROM pvs_posts WHERE 0 = 0 AND
post_type = ‘ims_gallery’ AND post_status = ‘publish’ AND post_password = ” )
GROUP BY im.post_parent ORDER BY p.post_date DESC, p.post_date DESC
von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/celestial-lite/page.php’), get_template_part, locate_template, load_template, require(‘/themes/celestial-lite/partials/content-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ImStoreFront->imstore_shortcode, ImStoreFront->get_galleries

Here is the Errorlog

[03-Mar-2013 19:55:53 UTC] WordPress-Datenbank-Fehler Unknown column ‘title’ in ‘order clause’ für Abfrage SELECT SQL_CALC_FOUND_ROWS  im.ID, im.post_title, p.comment_status,
pm.meta_value meta, im.post_excerpt, im.post_parent, im.post_type, p.post_author
FROM ( SELECT * FROM pvs_posts  ORDER BY
title ASC )  AS im

LEFT JOIN pvs_postmeta AS pm ON pm.post_id = im.ID
LEFT JOIN pvs_posts AS p ON p.ID =  im.post_parent

WHERE im.post_type = ‘ims_image’ AND pm.meta_key = ‘_wp_attachment_metadata’
AND im.post_status = ‘publish’ AND p.post_status = ‘publish’ AND im.post_parent IN (  SELECT DISTINCT ID FROM pvs_posts WHERE 0 = 0 AND
post_type = ‘ims_gallery’ AND post_status = ‘publish’ AND post_password = ” )
GROUP BY im.post_parent ORDER BY p.post_date DESC, p.post_date DESC
von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/celestial-lite/page.php’), get_template_part, locate_template, load_template, require(‘/themes/celestial-lite/partials/content-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ImStoreFront->imstore_shortcode, ImStoreFront->get_galleries

AND – your PayPal is not working, tried to make a Donation, but it says that there is an error.

Error Detected

Error Message
PayPal cannot process this transaction because of a problem with the seller’s website. Please contact the seller directly to resolve this problem.

Hi Paul,

thx for the advice, i did reset, but still the same issue.

I had NO plugin at all, and i used about 15 different themes, from clean ones to the latest TwentyTwelve, no way!

I got it working by replacing the store.php with the one from 3.2.1 RC1

but then the Notificationmessages won´t work correctly.

@HAX

Maybe it helps if i give you the message from my error.log

=================================

[24-Feb-2013 19:49:26 UTC] WordPress-Datenbank-Fehler (Database Error)

Unknown column ‘p.post_post_title’ in ‘order clause’ für Abfrage (Query) SELECT SQL_CALC_FOUND_ROWS p.*, pm.meta_value meta
FROM pvs_posts AS p LEFT JOIN pvs_postmeta AS pm ON p.ID = pm.post_id
WHERE p.post_type = ‘ims_image’
AND pm.meta_key = ‘_wp_attachment_metadata’
AND p.post_status = ‘publish’ AND p.post_parent = 74
ORDER BY p.post_post_title ASC LIMIT 0, 100 von require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/celestial-lite/templates/page-centered.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, ImStoreFront->gallery_shortcode, ImStoreFront->get_gallery_images

=======================================

THX for Help

Martin

P.S.

I´ll definetly make a donation if we get this to work!