Fehlende Artikel in der Bestellung!?

Thema wurde von herbertgrabinger, 11. Juni 2014 erstellt.

  1. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    Hallo,
    nach einem Update auf die 15er Version und den neuen VRRL ebenso habe ich das neue PayPal draug gespuhlt, bekomme ich bei einer Bestellung per PayPal diese Fehlermeldung in der Bestellung??
    Ebenso bekomme ich keine Bestellbestätigung (auch der Kunde bekommt keine) nur die Mitteilung von PayPal.
    HTML:
    WARNING(512): "SQL Error" in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34 (Details)
    Backtrace: #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34] #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:77] #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/gm/classes/GMPayPal.php:161] #3 (#GMPayPal) orderHasTransactions called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/includes/modules/orders/orders_paypalng.php:21] #4 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/orders.php:631] 
    Bitte um schnelle Hilfe da ich nicht sehen kann was der Kunde bestellt hat!

    Danke schon mal im Voraus... :rolleyes:
     
  2. barbara

    barbara G-WARD 2014-2020

    Registriert seit:
    14. August 2011
    Beiträge:
    35.352
    Danke erhalten:
    11.198
    Danke vergeben:
    1.601
    Hallo Herbert
    was steht denn in den Error-Logs? (tools -> Logs anzeigen)
     
  3. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    Hallo Barbara,

    HTML:
    ================================================================================
    
    Query: SELECT customers_status FROM customers WHERE customers_id = '1'
    
    Error: MySQL server has gone away (error 2006)
    
    ================================================================================
    2014-05-28 08-59-15 (84.56.95.2)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:77]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/write_customers_status.php:27]
    #3 require called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/includes/application_top.php:562]
    #4 require called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/content_manager.php:26]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-17 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 require called at [/homepages/27/d453174544/htdocs/shop-gambio2/shop_content.php:21]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-17 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-21 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-21 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-25 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-25 (84.62.34.201)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT
    shipping_status_name,
    shipping_status_image,shipping_status_id,
    info_link_active
    FROM shipping_status
    where language_id = '2'
    
    Error: Unknown column 'info_link_active' in 'field list' (error 1054)
    
    ================================================================================
    2014-06-10 22-54-58 (84.56.109.204)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:33]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:68]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:434]
    #3 xtDBquery called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/classes/main.php:31]
    #4 (#main_ORIGIN) main_ORIGIN called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:553]
    #5 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    2014-06-10 23-12-14 (188.98.105.147)
    FATAL ERROR(256): Class not found in registry: EyeCandy # Captcha
    in /homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161]
    #1 (#MainFactory) create_object called at [/homepages/27/d453174544/htdocs/shop-gambio2/shop_content.php:49]
    
    ================================================================================
    2014-06-10 23-12-21 (188.98.105.147)
    FATAL ERROR(256): Class not found in registry: EyeCandy # Captcha
    in /homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161]
    #1 (#MainFactory) create_object called at [/homepages/27/d453174544/htdocs/shop-gambio2/shop_content.php:49]
    
    ================================================================================
    2014-06-10 23-12-30 (188.98.105.147)
    FATAL ERROR(256): Class not found in registry: EyeCandy # Captcha
    in /homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161]
    #1 (#MainFactory) create_object called at [/homepages/27/d453174544/htdocs/shop-gambio2/shop_content.php:49]
    
    ================================================================================
    2014-06-10 23-12-39 (188.98.105.147)
    FATAL ERROR(256): Class not found in registry: EyeCandy # Captcha
    in /homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161]
    #1 (#MainFactory) create_object called at [/homepages/27/d453174544/htdocs/shop-gambio2/shop_content.php:49]
    
    ================================================================================
    2014-06-10 23-40-49 (84.56.109.204)
    FATAL ERROR(256): Class not found in registry: EyeCandy # PageToken
    in /homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/system/core/MainFactory.inc.php:161]
    #1 (#MainFactory) create_object called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/application_top.php:1001]
    #2 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/index.php:27]
    
    ================================================================================
    2014-06-10 23-53-00 (84.56.109.204)
    WARNING(2): require_once(/homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment/ipayment.php): failed to open stream: No such file or directory
    in /homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment_cc.php:21
    Backtrace:
    #0 require_once called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment_cc.php:21]
    #1 include_once called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/gm/classes/GMModulesManager.php:96]
    #2 (#GMModuleManager) repair called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/modules.php:169]
    
    ================================================================================
    2014-06-10 23-54-09 (84.56.109.204)
    WARNING(2): require_once(/homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment/ipayment.php): failed to open stream: No such file or directory
    in /homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment_cc.php:21
    Backtrace:
    #0 require_once called at [/homepages/27/d453174544/htdocs/shop-gambio2/includes/modules/payment/ipayment_cc.php:21]
    #1 include_once called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/gm/classes/GMModulesManager.php:96]
    #2 (#GMModuleManager) repair called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/modules.php:169]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT COUNT(*) AS num FROM paypal_transactions WHERE orders_id = 2014187
    
    Error: Table 'db491041860.paypal_transactions' doesn't exist (error 1146)
    
    ================================================================================
    2014-06-11 08-57-33 (84.56.109.204)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:77]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/gm/classes/GMPayPal.php:161]
    #3 (#GMPayPal) orderHasTransactions called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/includes/modules/orders/orders_paypalng.php:21]
    #4 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/orders.php:631]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT COUNT(*) AS num FROM paypal_transactions WHERE orders_id = 2014187
    
    Error: Table 'db491041860.paypal_transactions' doesn't exist (error 1146)
    
    ================================================================================
    2014-06-11 13-40-50 (84.56.109.204)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:77]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/gm/classes/GMPayPal.php:161]
    #3 (#GMPayPal) orderHasTransactions called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/includes/modules/orders/orders_paypalng.php:21]
    #4 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/orders.php:631]
    
    ================================================================================
    ================================================================================
    
    Query: SELECT COUNT(*) AS num FROM paypal_transactions WHERE orders_id = 2014187
    
    Error: Table 'db491041860.paypal_transactions' doesn't exist (error 1146)
    
    ================================================================================
    2014-06-11 13-41-48 (84.56.109.204)
    WARNING(512): SQL Error
    in /homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34
    Backtrace:
    #0 trigger_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_error.inc.php:34]
    #1 xtc_db_error called at [/homepages/27/d453174544/htdocs/shop-gambio2/inc/xtc_db_query.inc.php:77]
    #2 xtc_db_query called at [/homepages/27/d453174544/htdocs/shop-gambio2/gm/classes/GMPayPal.php:161]
    #3 (#GMPayPal) orderHasTransactions called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/includes/modules/orders/orders_paypalng.php:21]
    #4 include called at [/homepages/27/d453174544/htdocs/shop-gambio2/admin/orders.php:631]
     
  4. Dennis (MotivMonster.de)

    Dennis (MotivMonster.de) G-WARD 2013/14/15/16

    Registriert seit:
    22. September 2011
    Beiträge:
    30.984
    Danke erhalten:
    6.097
    Danke vergeben:
    1.079
    Beruf:
    Mann für alles :)
    Ort:
    Weilburg
    sieht für mich auf ersten blick aus wie updater nicht ausgeführt??
     
  5. barbara

    barbara G-WARD 2014-2020

    Registriert seit:
    14. August 2011
    Beiträge:
    35.352
    Danke erhalten:
    11.198
    Danke vergeben:
    1.601
    Wenn Du im Admin die Bestellung aufrufst, siehst Du auch nicht was Bestellt wurde?
     
  6. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    Jetzt sehe ich auch die Artikel wieder

    Wenn ich den Ubdater ausführe kommt das hier:

    Nur diese Dateien finde ich nicht im Hauptverzeichnis!:(
     
  7. barbara

    barbara G-WARD 2014-2020

    Registriert seit:
    14. August 2011
    Beiträge:
    35.352
    Danke erhalten:
    11.198
    Danke vergeben:
    1.601
    Das sind keine Dateien, sondern nicht mehr benötigte Datenbanktabellen.
    ist schon richtig so.
     
  8. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    Und wo finde ich diese?
     
  9. barbara

    barbara G-WARD 2014-2020

    Registriert seit:
    14. August 2011
    Beiträge:
    35.352
    Danke erhalten:
    11.198
    Danke vergeben:
    1.601
    Die brauchst Du nicht suchen.
    Dein Shop hat doch "fertig" geschrieben. die wurden automatisch gelöscht.
     
  10. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    Achso das was da steht, machte der Shop und teilt es mir mit?

    Einfach nur Genial und ich dachte das ich das machen muss :eek:

    Könnt ihr mir jetzt noch sagen wie ich eine Testbestellung mit PayPal Zahlung durchführen kann ohne das mich das System als Admin erkennt?
     
  11. Dennis (MotivMonster.de)

    Dennis (MotivMonster.de) G-WARD 2013/14/15/16

    Registriert seit:
    22. September 2011
    Beiträge:
    30.984
    Danke erhalten:
    6.097
    Danke vergeben:
    1.079
    Beruf:
    Mann für alles :)
    Ort:
    Weilburg
    über nen privaten paypal acc kaufen oder freund kaufen lassen und dann stonieren und betrg rückerstatten.
    oder sandbox modus nutzen.
     
  12. herbertgrabinger

    herbertgrabinger Erfahrener Benutzer

    Registriert seit:
    12. September 2013
    Beiträge:
    96
    Danke erhalten:
    0
    Danke vergeben:
    85
    :eek: Danke