Drive error; Error: 1064

[zicoo]

Date: Thu, 19 Feb 2015 08:38:15 +0000
 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE primary_id_field=1' at line 1
 IP Address: 77.252.183.184 - /baza/trading_na_betfair.html
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 mySQL query error: SELECT * FROM  WHERE primary_id_field=1
 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
 | File                                                                       | Function                                                                      | Line No.          |
 |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
 | admin/applications_addon/ips/ccs/sources/databases/fields.php              | [fields_relational].getFieldValue                                             | 458               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/extensions/content/feed_blocks/databases.php| [ccs_database_fields].getFieldValue                                           | 1167              |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/extensions/content/feed_blocks/databases.php| [feed_databases]._getRecords                                                  | 848               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/sources/blocks/feed/admin.php             | [feed_databases].executeFeed                                                  | 523               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/sources/blocks/adminInterface.php         | [adminBlockHelper_feed].recacheBlock                                          | 185               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/sources/pages.php                         | [adminBlockHelper].getBlockContent                                            | 551               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/sources/pages.php                         | [pageBuilder].getBlock                                                        | 336               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/modules_public/pages/pages.php            | [pageBuilder].recachePage                                                     | 839               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/modules_public/pages/pages.php            | [public_ccs_pages_pages]._getPageContent                                      | 536               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/applications_addon/ips/ccs/modules_public/pages/pages.php            | [public_ccs_pages_pages]._view                                                | 120               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
 | admin/sources/base/ipsController.php                                       | [public_ccs_pages_pages].doExecute                                            | 306               |
 '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Log powyżej. Co może być przyczyną oraz jak pozbyć się błędu. 

Błąd dotyczy tylko wyświetlania artykułów i stron w ccs. Co ciekawe niektóre strony wyświetlają się normalnie, na niektrych pojawia się błąd. Artykuły nie wyświetlają się żadne.

 

[DawPi]

Jaka wersja IP.Content? Najnowsza?

[zicoo]

Content  v2.3.6

[DawPi]

Jesteś pewny, że dobrze ustawiłeś swoje pola w tej bazie danych, co wyświetlasz jej zawartość? Pokaż screen z listą pól w niej.

[zicoo]

o jakie pola dokładnie ci chodzi? Nic nie było zmieniane w kodzie ani w konfiguracji, usunąłem tylko kilka custom databases.

[zicoo]

Problem rozwiązany. usunąłem jedną z custom db i problem znikł

[DawPi]

Czyli mój trop był słuszny.