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?
Support
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.
Request Support
Support is currently Offline
Support Availability
Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.
Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.
Guidelines
Before you post: read the documentation and search the forums for an answer to your question.
When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).
Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.
Language: only English
Search Users
Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.