Categories
View Replies (2)

Resolved 1146 Table 'xyz_ezrealty_profile' doesn't exist

  1. GoHost4U
    GoHost4U
  2. RO CSVI
  3. Sunday, 07 December 2014
  4.  Subscribe via email
Hi Roland

I am trying to export properties but when I start the export i get 1146 Table 'xyz_ezrealty_profile' doesn't exist SQL=SELECT mid AS value, dealer_name AS text FROM xyz_ezrealty_profile ORDER BY dealer_name

I know this is about the agent stuff but can you tell me how this can be fixed please
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error
Table 'xyz_ezrealty_profile' doesn't exist
means you are running a newer version of EZ Realty. Version 7 no longer has this table where as version 6 still does. Your change looks good to me. It should work as expected.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hi Roland
I am not sure if this is correct or there are other repercussions but I edited com_csvi\models\forms\com_ezrealty\export\property.xml and changed lines 102 to 116 as follows:

<field name="owner"
type="sql"
size="7"
label="COM_CSVI_EXPORT_EZREALTY_OWNER_LABEL"
description="COM_CSVI_EXPORT_EZREALTY_OWNER_DESC"
multiple="true"
query="SELECT uid AS value,
seller_name AS text
FROM #__ezportal
ORDER BY seller_name"
key_field="value"
value_field="text"
default="">
<option value="">COM_CSVI_DONT_USE</option>
</field>

It seems to work but if you could just confirm there is no issues with what I have done please
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!