Issue information
-
#035669
-
Fixed
-
2.3.0 Beta 1
-
2.3.0 Beta 1
-
4 - High
Issue Confirmations
-
Yes (0)No (0)
0
I don't know what I did bad, but when I sent first record in database I got Driver error with this report in header:
And Driver Error:
Record was added, however and another three records were added without problems.
Warning: No parent ID passed to /root_path/admin/applications_addon/ips/ccs/extensions/comments/records.php in /root_path/admin/applications_addon/ips/ccs/extensions/comments/records.php on line 716
And Driver Error:
Date: Thu, 02 Feb 2012 00:07:53 +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 'AND c.comment_database_id=3 ORDER BY c.comment_date asc LIMIT 0,25' at line 8 IP Address: xx.xx.xx.xx - /root_path/page/test/axel.html/_/category/nhl-2012/sharks-vs-rangers ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT c.*,m.*,pc.*,pp.*,rep_index.rep_rating as has_given_rep,rep_cache.rep_points, rep_cache.rep_like_cache FROM ccs_database_comments c LEFT JOIN members m ON ( m.member_id=c.comment_user ) LEFT JOIN pfields_content pc ON ( pc.member_id=m.member_id ) LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) LEFT JOIN reputation_index rep_index ON ( rep_index.app='ccs' AND rep_index.type='comment_id' AND rep_index.type_id=c.comment_id AND rep_index.member_id=2 ) LEFT JOIN reputation_cache rep_cache ON ( rep_cache.app='ccs' AND rep_cache.type='comment_id' AND rep_cache.type_id=c.comment_id ) WHERE c.comment_record_id= AND c.comment_database_id=3 ORDER BY c.comment_date asc LIMIT 0,25 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/ips/ccs/extensions/comments/records.php | [classes_comments_renderer].fetch | 885 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/classes/comments/bootstrap.php | [comments_ccs_records].fetch | 202 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/sources/databases.php | [classes_comments_renderer].fetchFormatted | 2977 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/sources/databases.php | [databaseBuilder]._getRecordDisplay | 294 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/sources/pages.php | [databaseBuilder].getDatabase | 556 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/sources/pages.php | [pageBuilder].getDatabase | 232 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/modules_public/pages/pages.php | [pageBuilder].recachePage | 756 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications_addon/ips/ccs/modules_public/pages/pages.php | [public_ccs_pages_pages]._getPageContent | 506 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | 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 | 302 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
Record was added, however and another three records were added without problems.
I take it you got that error (looking at the stack trace) AFTER the record was saved when you were redirected to the page to view the record?
I assume you simply refreshed the page and it loaded after that?
I assume you simply refreshed the page and it loaded after that?
I wrote record and clicked Save. Immediately I got Driver Error, I went to ACP to see what kind Driver error is it and in my custom database I saw that record was added. I think I only refreshed page an all was OK.
Maybe it was coincidence, I'll try it with other database, it appears that the error occurred only when adding the first record. Will investigate further
Maybe it was coincidence, I'll try it with other database, it appears that the error occurred only when adding the first record. Will investigate further
OK, tested again, I got the same error. I found issue:
When you are creating new database basic setting for Title field is Record ID (You can change it, when you create field for Title).
But when you leave it (no change anything) you will have title for record Record ID, in this case number 1. When I click on "1" I got Driver Error. I will send you PM on test board, where you can reproduce this issue.
When you are creating new database basic setting for Title field is Record ID (You can change it, when you create field for Title).
But when you leave it (no change anything) you will have title for record Record ID, in this case number 1. When I click on "1" I got Driver Error. I will send you PM on test board, where you can reproduce this issue.
1 user(s) are reading this issue
0 members, 1 guests, 0 anonymous users
