Anyone have same errors:
Database error in My site
Query: UPDATE `` SET `` = '0' WHERE `` = '2921' LIMIT 1
Mysql error: Incorrect table name ''
Found error in the file '/path-to/inc/classes/BxDolCmtsQuery.php' at line 207.
Called 'query' function with erroneous argument #0.
Any suggestion on how to fix it?
Kind regards
Mayki
"When things get tough the tough get going..." |
Since there is no replay and since DB cleaning is important for Dolphin....., I'd like to extend what I first wrote for my problem:
Here is description of what is going on:
The problem is with daily cron job (inc/classes/BxDolCronCmd.php) which runs every midnight.
When it was working ok, I received e-mail with similar content:
- Membership expiration letters -
Send membership expire letters: 0 letters
- Temporary files check -
Total temp files: 2551
Deleted temp files: 366
- Database cleaning -
Deleted profiles: 1
Deleted virtual kisses: 7
Deleted messages: 38
Deleted sessions: 922
Deleted records from ip block list: 0
Deleted views: 1056
Deleted votes: 23
Deleted comment votes: 0
Then suddenly (after 10th of January) something happened and I started to receive emails with Subject: Database error in "My site name" and the content of this email is like this:
Query:
UPDATE `` SET `` = '3' WHERE `` = '867' LIMIT 1
Mysql error: Incorrect table name ''
Found error in the file '/dolphin-root/inc/classes/BxDolCmtsQuery.php' at line 207.
Called 'query' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /dolphin-root/inc/classes/BxDolDb.php
[line] => 237
[function] => error
[class] => BxDolDb
[object] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[_sTable] => bx_photos_cmts_albums
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] => Incorrect table name ''
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[type] => ->
[args] => Array
(
[0] => Database query error
[1] =>
[2] => UPDATE `` SET `` = '3' WHERE `` = '867' LIMIT 1
)
)
[2] => Array
(
[file] => /dolphin-root/inc/classes/BxDolDb.php
[line] => 205
[function] => res
[class] => BxDolDb
[object] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[_sTable] => bx_photos_cmts_albums
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] => Incorrect table name ''
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[type] => ->
[args] => Array
(
[0] => UPDATE `` SET `` = '3' WHERE `` = '867' LIMIT 1
)
)
[3] => Array
(
[file] => /dolphin-root/inc/classes/BxDolCmtsQuery.php
[line] => 207
[function] => query
[class] => BxDolDb
[object] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[_sTable] => bx_photos_cmts_albums
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] => Incorrect table name ''
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[type] => ->
[args] => Array
(
[0] => UPDATE `` SET `` = '3' WHERE `` = '867' LIMIT 1
)
)
[4] => Array
(
[file] => /dolphin-root/inc/classes/BxDolCmtsQuery.php
[line] => 188
[function] => updateTriggerTable
[class] => BxDolCmtsQuery
[object] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[_sTable] => bx_photos_cmts_albums
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] => Incorrect table name ''
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[type] => ->
[args] => Array
(
[0] => 867
[1] => 3
)
)
[5] => Array
(
[file] => /dolphin-root/inc/classes/BxDolCmts.php
[line] => 331
[function] => deleteAuthorComments
[class] => BxDolCmtsQuery
[object] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[_sTable] => bx_photos_cmts_albums
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] => Incorrect table name ''
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[type] => ->
[args] => Array
(
[0] => 2661
)
)
[6] => Array
(
[file] => /dolphin-root/inc/admin.inc.php
[line] => 417
[function] => onAuthorDelete
[class] => BxDolCmts
[object] => BxDolCmts Object
(
[_iId] => 2661
[sTextAreaId] => cmtProfileTextAreaParent
[iGlobAllowHtml] => 1
[iGlobUseTinyMCE] => 1
[_sSystem] => profile
[_aSystem] => Array
(
[system_id] => 1
[name] => profile
[table_cmts] => sys_cmts_profile
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => Profiles
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] => BxDolCmtsProfile
[class_file] => inc/classes/BxDolCmtsProfile.php
)
[_aCmtElements] => Array
(
[CmtParent] => Array
(
[reg] => ^[0-9]+$
[msg] => bad comment parent id
)
[CmtText] => Array
(
[reg] => ^.{3,2048}$
[msg] => Please enter 3-2048 characters
)
[CmtMood] => Array
(
[reg] => ^-?[0-9]?$
[msg] => Izbrati morate razpoloženje
)
)
[_oQuery] => BxDolCmtsQuery Object
(
[_aSystem] => Array
(
[system_id] => 1
[name] => profile
[table_cmts] => sys_cmts_profile
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => Profiles
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] => BxDolCmtsProfile
[class_file] => inc/classes/BxDolCmtsProfile.php
)
[_sTable] => sys_cmts_profile
[_sTableTrack] => sys_cmts_track
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
(
[error_checking] => 1
[error_message] =>
[host] => localhost
[port] =>
[socket] =>
[dbname] => dnname
[user] => *****
[password] => *****
[link] => Resource id #29
[current_res] => Resource id #98
[current_arr_type] => 1
[oParams] => BxDolParams Object
*RECURSION*
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
)
[_oCache] => BxDolCacheFile Object
(
[sPath] => /dolphin-root/cache/
)
[_sCacheFile] => sys_options_184bb65283c05a5837c1cad8e1e2697a.php
[_aParams] => [truncated]
)
[oDbCacheObject] =>
)
[_sOrder] => desc
[_aMoodText] => Array
(
[-1] => _sys_txt_cmt_mood_negative
[0] => _sys_txt_cmt_mood_neutral
[1] => _sys_txt_cmt_mood_positive
)
[_aSystems] => Array
(
[profile] => Array
(
[system_id] => 1
[name] => profile
[table_cmts] => sys_cmts_profile
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => Profiles
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] => BxDolCmtsProfile
[class_file] => inc/classes/BxDolCmtsProfile.php
)
[bx_videos] => Array
(
[system_id] => 2
[name] => bx_videos
[table_cmts] => bx_videos_cmts
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => RayVideoFiles
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] =>
[class_file] =>
)
[bx_photos] => Array
(
[system_id] => 3
[name] => bx_photos
[table_cmts] => bx_photos_cmts
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => bx_photos_main
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] =>
[class_file] =>
)
[bx_blogs] => Array
(
[system_id] => 5
[name] => bx_blogs
[table_cmts] => bx_blogs_cmts
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => bx_blogs_posts
[trigger_field_id] => PostID
[trigger_field_comments] => CommentsCount
[class_name] =>
[class_file] =>
)
[bx_sounds] => Array
(
[system_id] => 6
[name] => bx_sounds
[table_cmts] => bx_sounds_cmts
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => RayMp3Files
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] =>
[class_file] =>
)
[bx_sounds_albums] => Array
(
[system_id] => 13
[name] => bx_sounds_albums
[table_cmts] => bx_sounds_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[bx_photos_albums] => Array
(
[system_id] => 14
[name] => bx_photos_albums
[table_cmts] => bx_photos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[ads] => Array
(
[system_id] => 8
[name] => ads
[table_cmts] => bx_ads_cmts
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => bx_ads_main
[trigger_field_id] => ID
[trigger_field_comments] => CommentsCount
[class_name] =>
[class_file] =>
)
[bx_poll] => Array
(
[system_id] => 10
[name] => bx_poll
[table_cmts] => bx_poll_cmts
[table_track] => bx_poll_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 5
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => bx_poll_data
[trigger_field_id] => id_poll
[trigger_field_comments] => poll_comments_count
[class_name] =>
[class_file] =>
)
[bx_news] => Array
(
[system_id] => 12
[name] => bx_news
[table_cmts] => bx_news_comments
[table_track] => bx_news_comments_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 10
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] => bx_news_entries
[trigger_field_id] => id
[trigger_field_comments] => cmts_count
[class_name] => BxNewsCmts
[class_file] => modules/boonex/news/classes/BxNewsCmts.php
)
[bx_videos_albums] => Array
(
[system_id] => 15
[name] => bx_videos_albums
[table_cmts] => bx_videos_cmts_albums
[table_track] => sys_cmts_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 20
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => cmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] =>
[class_file] =>
)
[bx_wall] => Array
(
[system_id] => 16
[name] => bx_wall
[table_cmts] => bx_wall_comments
[table_track] => bx_wall_comments_track
[allow_tags] => 0
[nl2br] => 1
[sec_to_edit] => 90
[per_view] => 9999
[is_ratable] => 1
[viewing_threshold] => -3
[animation_effect] => none
[animation_speed] => 0
[is_on] => 1
[is_mood] => 0
[root_style_prefix] => wcmt
[trigger_table] =>
[trigger_field_id] =>
[trigger_field_comments] =>
[class_name] => BxWallCmts
[class_file] => modules/boonex/wall/classes/BxWallCmts.php
)
)
)
[type] => ->
[args] => Array
(
[0] => 2661
)
)
[7] => Array
(
[file] => /dolphin-root/inc/classes/BxDolCronCmd.php
[line] => 70
[function] => profile_delete
[args] => Array
(
[0] => 2661
)
)
[8] => Array
(
[file] => /dolphin-root/inc/classes/BxDolCronCmd.php
[line] => 287
[function] => clean_database
[class] => BxDolCronCmd
[object] => BxDolCronCmd Object
(
)
[type] => ->
[args] => Array
(
)
)
[9] => Array
(
[file] => /dolphin-root/periodic/cron.php
[line] => 117
[function] => processing
[class] => BxDolCronCmd
[object] => BxDolCronCmd Object
(
)
[type] => ->
[args] => Array
(
)
)
[10] => Array
(
[file] => /dolphin-root/periodic/cron.php
[line] => 131
[function] => runJob
[args] => Array
(
[0] => Array
(
[id] => 1
[name] => cmd
[time] => 0 0 * * *
[class] => BxDolCronCmd
[file] => inc/classes/BxDolCronCmd.php
[eval] =>
)
)
)
)
I am trying to figure it out by myself but no luck.
Please, any help, or a hint would be much appreciated.
Kind regards
Mayki
"When things get tough the tough get going..." |
First of all, just the database error without the backtrace is sufficient. Geeks, making the world a better place |
Query: UPDATE `` SET `` = '0' WHERE `` = '2921' LIMIT 1
This is the nature of the problem; when Dolphin went to generate the query, it is missing some data; first of all, the table name is missing; as well as the field. We have to figure out why.
Geeks, making the world a better place |
I am going to include the function containing the query so that others don't have to go out and find it if they are not familiar with the particular one in question.
function updateTriggerTable($iId, $iCount)
{
return $this->query("UPDATE `{$this->_aSystem['trigger_table']}` SET `{$this->_aSystem['trigger_field_comments']}` = '$iCount' WHERE `{$this->_aSystem['trigger_field_id']}` = '$iId' LIMIT 1");
}
Geeks, making the world a better place |
Problem is occurring cron run cleanup of comments.
My best guess would be a recent install or removal of a module that did not fully install or uninstall.
Did you add or remove anything about the time the problem started? https://www.deanbassett.com |
Thank you geek_girl
I am going to include the function containing the query so that others don't have to go out and find it if they are not familiar with the particular one in question.
function updateTriggerTable($iId, $iCount)
{
return $this->query("UPDATE `{$this->_aSystem['trigger_table']}` SET `{$this->_aSystem['trigger_field_comments']}` = '$iCount' WHERE `{$this->_aSystem['trigger_field_id']}` = '$iId' LIMIT 1");
}
and deano92964
Problem is occurring cron run cleanup of comments.
My best guess would be a recent install or removal of a module that did not fully install or uninstall.
Did you add or remove anything about the time the problem started?
@Geek_girl: as I understand, you are going to alter the current function in BxDolCmtsQuery.php?
@deano92964: I haven't install any new module at the time the problem begin. As I can remember, I did some manually editing in the table: `sys_albums_objects` but only the field `obj_order` at around that time...
Kind regards
Mayki
"When things get tough the tough get going..." |
@Geek_girl: as I understand, you are going to alter the current function in BxDolCmtsQuery.php?
No, I was including the function so we can see how the query is formed.
Geeks, making the world a better place |
@Geek_girl: as I understand, you are going to alter the current function in BxDolCmtsQuery.php?
No, I was including the function so we can see how the query is formed.
OK, I see. I know that because this is the line 207 in a file /inc/classes/BxDolCmtsQuery.php
So you were just explaining to other members...
"When things get tough the tough get going..." |
Are you sure nothing else has changed with your site? No other database errors? Geeks, making the world a better place |
Are you sure nothing else has changed with your site? No other database errors?
Yes, I am sure. No other changes have been made, and I can't see any other DB errors...., and site is working without problems....
"When things get tough the tough get going..." |
Rules → http://www.boonex.com/terms |
AlexT, it's definitely a bug.
I've changed the file /inc/classes/BxDolCmtsQuery.php and DB cleaning works again.
Thank you very much for your help!!
Kind regards
Mayki
"When things get tough the tough get going..." |
You are welcome!
I've changed the file /inc/classes/BxDolCmtsQuery.php and DB cleaning works again.
Thank you very much for your help!!
Rules → http://www.boonex.com/terms |
Thank you from me too.. was experiencing the same thing since updating to 7.1.5
I have applied the fix, and will let you know if that does not work for me!
You can't make chicken salad out of chicken shit.. although it does work the other way around! |
