hi
there is this error when I click on a picture to homepage - D7.0.6
Query:
SELECT `r`.`cmt_rate` AS `cmt_rated`, `c`.`cmt_id`, `c`.`cmt_parent_id`, `c`.`cmt_object_id`, `c`.`cmt_author_id`, `c`.`cmt_text`, `c`.`cmt_mood`, `c`.`cmt_rate`, `c`.`cmt_rate_count`, `c`.`cmt_replies`, (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`, `p`.`NickName` AS `cmt_author_name` FROM bx_photos_cmts AS `c` LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`) LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 10) WHERE `c`.`cmt_object_id` = '244' AND `c`.`cmt_parent_id` = '0' ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5
Mysql error:
Unknown column 'c.cmt_text' in 'field list'
Found error in the file '/home/enaturis/www/inc/classes/BxDolCmtsQuery.php' at line 54.
Called 'getAll' function with erroneous argument #0.
What is the problem - thank you
|
hi
there is this error when I click on a picture to homepage
Query:
SELECT `r`.`cmt_rate` AS `cmt_rated`, `c`.`cmt_id`, `c`.`cmt_parent_id`, `c`.`cmt_object_id`, `c`.`cmt_author_id`, `c`.`cmt_text`, `c`.`cmt_mood`, `c`.`cmt_rate`, `c`.`cmt_rate_count`, `c`.`cmt_replies`, (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`, `p`.`NickName` AS `cmt_author_name` FROM bx_photos_cmts AS `c` LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`) LEFT JOIN sys_cmts_track AS `r` ON (`r`.`cmt_system_id` = 3 AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = 10) WHERE `c`.`cmt_object_id` = '244' AND `c`.`cmt_parent_id` = '0' ORDER BY `c`.`cmt_time` DESC LIMIT 0, 5
Mysql error:
Unknown column 'c.cmt_text' in 'field list'
Found error in the file '/home/enaturis/www/inc/classes/BxDolCmtsQuery.php' at line 54.
Called 'getAll' function with erroneous argument #0.
What is the problem - thank you
Check your database. It appears the field cmt_text has been deleted from the table bx_photos_cmts
If it's missing it will need to re-created.
https://www.deanbassett.com |
sorry but I do not understand - I search - in my database
bx_photos_cmts - it exists in database
and what to do after
|
in the table there
cmt_parent_id
cmt_object_id
cmt_author_id
cmt_text_id
cmt_mood
cmt_rate
cmt_rate_count
cmt_time
cmt_replies
|
What version of dolphin?
Have you installed any new modules that alter or enhance the comments?
I ask because one of your field names appears to be incorrect, but it might not be for your version of dolphin, so i have to look up the field names for the exact version you have.
https://www.deanbassett.com |
I compared with another database - and I have not the same thing - you know why
two database of D7.0.6
one with - I have the error
cmt_parent_id
cmt_object_id
cmt_author_id
cmt_text_id
cmt_mood
cmt_rate
cmt_rate_count
cmt_time
cmt_replies
and another - no error
cmt_parent_id
cmt_object_id
cmt_author_id
cmt_text
cmt_mood
cmt_rate
cmt_rate_count
cmt_time
cmt_replies
|
What version of dolphin?
Have you installed any new modules that alter or enhance the comments?
I ask because one of your field names appears to be incorrect, but it might not be for your version of dolphin, so i have to look up the field names for the exact version you have.
I modules - but nothing for the comments - D7.0.6
|
The second one you listed is correct.
Something on the one with the error changed the field named cmt_text to cmt_text_id which is not correct. I am betting it is the cause. Should be named cmt_text of type text with Collation of utf8_general_ci
It other words, it should match the one your not getting a error on.
As for why the name was changed, i cannot tell you that. Unless one of your mods did it as something it required, there is no reason it should have been changed.
https://www.deanbassett.com |
I modified - cmt_text_id - by - cmt_text
and there is no error - it works
I checked the table
bx_videos_cmts - also -- cmt_text_id
strange - is a module that has changed my database !!
deano92964 - thank you for your quick help -
|
strange - is a module that has changed my database !!
As i said, i don't know what changed it, and i will not be able to tell you what did. A module is only a guess.
https://www.deanbassett.com |
strange - is a module that has changed my database !!
As i said, i don't know what changed it, and i will not be able to tell you what did. A module is only a guess.
ok, a big thank you - :)
|
