Hi there
I'm getting an error in ACYsms and the error report refers to Easy-Profile. Please see error report below and let me know if there anything I can do to prevent this from a Easy-Profile perspective.
1054 Unknown column 'receiver.cell' in 'field list' SQL=SELECT queue.*, queue.queue_priority as queue_priority, queue.queue_try as queue_try, queue.queue_senddate as queue_senddate, message.message_subject as message_subject, receiver.firstname as receiver_name, receiver.cell-num as receiver_phone, receiver.id as receiver_id FROM x1li0_acysms_queue AS queue JOIN x1li0_acysms_message AS message ON queue.queue_message_id = message.message_id JOIN x1li0_jsn_users AS receiver ON receiver.id = queue.queue_receiver_id WHERE (queue.queue_receiver_table = 'easyprofile') ORDER BY queue.queue_senddate desc, queue.`queue_receiver_id` ASC LIMIT 0, 20
I do import user records via csv import plugin from time to time. Could this have something to do with it?
I have also reported the issue with ACYsms under the following Forum Topic: Error 1054
Let me know where I should send the Site backend login details if required?
Hi, the problem is the column "receiver.cell-num", AcySMS not quote field name so cell-num in sql is like cell(- subtraction)num.
The correct way is to quote fields name so instead receiver.cell-num should be receiver.`cell-num`
to avoid these problems from version 1.2.2 when you create a field all alias (and DB column name) with "-" will be replaced with char "_"
So alternatives are:
1) Fix this problem is AcySMS - this is the best way but I think require many time
2) Recreate this field with correct alias - but you loss all data in this field
3) COMPLEX WAY, need to use some tool like PhpMyAdmin
- Make a backup of your database
- Change alias of field in table #__jsn_fields from cell-num to cell_num
- Change column name from cell-num to cell_num in table #__users_DB
- Configure AcySMS to use new field (now it try to get data from cell-num)
The correct way is to quote fields name so instead receiver.cell-num should be receiver.`cell-num`
to avoid these problems from version 1.2.2 when you create a field all alias (and DB column name) with "-" will be replaced with char "_"
So alternatives are:
1) Fix this problem is AcySMS - this is the best way but I think require many time
2) Recreate this field with correct alias - but you loss all data in this field
3) COMPLEX WAY, need to use some tool like PhpMyAdmin
- Make a backup of your database
- Change alias of field in table #__jsn_fields from cell-num to cell_num
- Change column name from cell-num to cell_num in table #__users_DB
- Configure AcySMS to use new field (now it try to get data from cell-num)
- Page :
- 1
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.