Driver error

[artrix]

Witam na moim forum wyskakuje driver error poniżej zamieszczam logi

 

 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:02:50 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 83.29.24.154 - /admin/index.php?adsess=3feaff81778685c7b5066773d137808d&app=ibEconomy&module=shop&section=shop&do=do_item
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT SUM(m.points) as total_points, SUM(pc.eco_worth) as total_worth, SUM(pc.eco_welfare) as total_welfare FROM members m  LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points != 0 OR pc.eco_worth != 0 OR pc.eco_welfare != 0
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [ibEconomyMySQL].rebuildStatsCache                                            | 3379              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/sources/ecoclass.php              | [ips_CacheRegistry].rebuildCache                                              | 1607              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [class_ibEconomy].acm                                                         | 397               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [admin_ibEconomy_shop_shop].doItem                                            | 80                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_ibEconomy_shop_shop].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:02:54 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 83.29.24.154 - /admin/index.php?adsess=3feaff81778685c7b5066773d137808d&app=ibEconomy&module=shop&section=shop&do=do_item
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT SUM(m.points) as total_points, SUM(pc.eco_worth) as total_worth, SUM(pc.eco_welfare) as total_welfare FROM members m  LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points != 0 OR pc.eco_worth != 0 OR pc.eco_welfare != 0
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [ibEconomyMySQL].rebuildStatsCache                                            | 3379              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/sources/ecoclass.php              | [ips_CacheRegistry].rebuildCache                                              | 1607              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [class_ibEconomy].acm                                                         | 397               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [admin_ibEconomy_shop_shop].doItem                                            | 80                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_ibEconomy_shop_shop].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:03:02 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 83.29.24.154 - /admin/index.php?adsess=3feaff81778685c7b5066773d137808d&app=ibEconomy&module=shop&section=shop&do=do_item
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT SUM(m.points) as total_points, SUM(pc.eco_worth) as total_worth, SUM(pc.eco_welfare) as total_welfare FROM members m  LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points != 0 OR pc.eco_worth != 0 OR pc.eco_welfare != 0
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [ibEconomyMySQL].rebuildStatsCache                                            | 3379              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/sources/ecoclass.php              | [ips_CacheRegistry].rebuildCache                                              | 1607              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [class_ibEconomy].acm                                                         | 397               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [admin_ibEconomy_shop_shop].doItem                                            | 80                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_ibEconomy_shop_shop].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:03:07 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 83.29.24.154 - /admin/index.php?adsess=3feaff81778685c7b5066773d137808d&app=ibEconomy&module=shop&section=shop&do=do_item
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT SUM(m.points) as total_points, SUM(pc.eco_worth) as total_worth, SUM(pc.eco_welfare) as total_welfare FROM members m  LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points != 0 OR pc.eco_worth != 0 OR pc.eco_welfare != 0
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [ibEconomyMySQL].rebuildStatsCache                                            | 3379              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/sources/ecoclass.php              | [ips_CacheRegistry].rebuildCache                                              | 1607              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [class_ibEconomy].acm                                                         | 397               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [admin_ibEconomy_shop_shop].doItem                                            | 80                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_ibEconomy_shop_shop].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:03:17 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 80.239.243.132 - /
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT m.member_id,m.name,m.member_group_id,m.joined,m.posts,m.last_visit,m.last_activity,m.login_anonymous,m.title,m.members_display_name,m.members_seo_name,pp.*,m.points AS eco_points, pc.eco_worth, pc.eco_welfare FROM members m  LEFT JOIN profile_portal pp ON ( m.member_id=pp.pp_member_id ) 
 LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points > 0 OR pc.eco_worth > 0 OR pc.eco_welfare > 0 GROUP BY m.member_id ORDER BY m.points DESC LIMIT 0,10
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications_addon/other/ibEconomy/sources/classes/class_global.php  | [ibEconomyMySQL].queryMembers                                                 | 1412              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | hooks/ibEconomySidebarBlocks_50b433731e51deeb07342be04d8e70c4.php          | [class_global].blocks                                                         | 47                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/output/publicOutput.php                              | [ibEconomySidebarBlocks].getOutput                                            | 3462              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/output/publicOutput.php(3526) : eval()'d code        | [output].templateHooks                                                        | 6                 |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/output/formats/html/htmlOutput.php                   | [shoutboxGlobalJs].globalTemplate                                             | 312               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/classes/output/publicOutput.php                              | [htmlOutput].fetchOutput                                                      | 2722              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications/forums/modules_public/forums/boards.php                 | [output].sendOutput                                                           | 124               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_forums_forums_boards].doExecute                                       | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Date: Tue, 22 Jan 2013 21:03:39 +0000
 Error: 1054 - Unknown column 'm.points' in 'field list'
 IP Address: 83.29.24.154 - /admin/index.php?adsess=3feaff81778685c7b5066773d137808d&app=ibEconomy&module=shop&section=shop&do=do_item
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT SUM(m.points) as total_points, SUM(pc.eco_worth) as total_worth, SUM(pc.eco_welfare) as total_welfare FROM members m  LEFT JOIN pfields_content pc ON ( m.member_id=pc.member_id )   WHERE m.points != 0 OR pc.eco_worth != 0 OR pc.eco_welfare != 0
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/sources/base/ipsRegistry.php                                         | [ibEconomyMySQL].rebuildStatsCache                                            | 3379              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/sources/ecoclass.php              | [ips_CacheRegistry].rebuildCache                                              | 1607              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [class_ibEconomy].acm                                                         | 397               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/other/ibEconomy/modules_admin/shop/shop.php       | [admin_ibEconomy_shop_shop].doItem                                            | 80                |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [admin_ibEconomy_shop_shop].doExecute                                         | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

[DawPi]

Dodaj pole o nazwie points do tabeli members. Pole int o długości 10.

[artrix]

Możesz trochę dokładniej opisać gdzie co wybrać , wpisać ?

[DawPi]

Co dokładniej? Napisałem to tak dokładnie, że głowa boli. Robisz to w PMA (PhpMyAdmin).

Albo po prostu zapytaniem:

ALTER TABLE members ADD points INT( 10 ) DEFAULT 0 NOT NULL;

Jeśli masz prefiks w bazie danych nie zapomnij go dodać przed nazwą tabeli w tym zapytaniu.

[artrix]

Dziękuje za pomoc można zamknąć