Bookmark and Share Recommend Our Website to Others! Home ·  Secure Log In
Best-Decals.com :: Your One-Stop Decal Shop! Specials · New Products
Featured Products · Contact Us

 
 
Advanced Search Site Map
Categories
Information
Decal Information
Links & Information
1054 Unknown column 'p.products_id' in 'on clause'
Array
(
    [0] => Array
        (
            [file] => /home/dbolivar/public_html/includes/classes/db/mysql/query_factory.php
            [line] => 158
            [function] => set_error
            [class] => queryFactory
            [object] => queryFactory Object
                (
                    [count_queries] => 29
                    [total_query_time] => 0.00918984040833
                    [database] => dbolivar_zencart
                    [link] => Resource id #8
                    [db_connected] => 1
                    [error_number] => 1054
                    [error_text] => Unknown column 'p.products_id' in 'on clause'
                )

            [type] => ->
            [args] => Array
                (
                    [0] => 1054
                    [1] => Unknown column 'p.products_id' in 'on clause'
                )

        )

    [1] => Array
        (
            [file] => /home/dbolivar/public_html/includes/classes/split_page_results.php
            [line] => 72
            [function] => Execute
            [class] => queryFactory
            [object] => queryFactory Object
                (
                    [count_queries] => 29
                    [total_query_time] => 0.00918984040833
                    [database] => dbolivar_zencart
                    [link] => Resource id #8
                    [db_connected] => 1
                    [error_number] => 1054
                    [error_text] => Unknown column 'p.products_id' in 'on clause'
                )

            [type] => ->
            [args] => Array
                (
                    [0] => select count(*) as total  from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd
                                  left join featured f on p.products_id = f.products_id
                                  where p.products_status = '1' and p.products_id = f.products_id and f.status = '1'
                                  and p.products_id = pd.products_id and pd.language_id = '1'
                )

        )

    [2] => Array
        (
            [file] => /home/dbolivar/public_html/includes/templates/template_default/templates/tpl_featured_products_default.php
            [line] => 45
            [function] => splitPageResults
            [class] => splitPageResults
            [object] => splitPageResults Object
                (
                    [sql_query] => select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd
                                  left join featured f on p.products_id = f.products_id
                                  where p.products_status = '1' and p.products_id = f.products_id and f.status = '1'
                                  and p.products_id = pd.products_id and pd.language_id = '1' order by pd.products_name
                    [number_of_rows] => 
                    [current_page_number] => 1
                    [number_of_pages] => 
                    [number_of_rows_per_page] => 10
                    [page_name] => page
                )

            [type] => ->
            [args] => Array
                (
                    [0] => select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd
                                  left join featured f on p.products_id = f.products_id
                                  where p.products_status = '1' and p.products_id = f.products_id and f.status = '1'
                                  and p.products_id = pd.products_id and pd.language_id = '1' order by pd.products_name
                    [1] => 10
                )

        )

    [3] => Array
        (
            [file] => /home/dbolivar/public_html/includes/templates/template_default/common/tpl_main_page.php
            [line] => 74
            [args] => Array
                (
                    [0] => /home/dbolivar/public_html/includes/templates/template_default/templates/tpl_featured_products_default.php
                )

            [function] => require
        )

    [4] => Array
        (
            [file] => /home/dbolivar/public_html/index.php
            [line] => 92
            [args] => Array
                (
                    [0] => /home/dbolivar/public_html/includes/templates/template_default/common/tpl_main_page.php
                )

            [function] => require
        )

)

Featured Products

Sort by: