×

Notice

The forum is in read only mode.
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Import Error

Import Error 8 years 6 months ago #24688

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hello,

Just testing the extension for use on ou website to display addresses from SobiPro entries.
Site is using Joomla 3.2.1 SobiPro 1.1.5 Budgie HotSpotCore 3.5.5
I have enabled the SobiPro plugin, created a category on HotSpot, gone to import and reconfigured the ID for each field type.
When Import is clicked, an error 500 is reported:

Unknown column 'o.published' in 'where clause' SQL=SELECT c.id AS catid, o.name AS cat_name, c.description, o.state as published FROM aao_sobipro_category AS c LEFT JOIN aao_sobipro_object AS o ON c.id = o.id WHERE o.published = '1'


Not sure why this is though, but thought I would let you know as Sobi has just been updated.

Import Error 8 years 6 months ago #24693

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
Hey Simon,
The published field in sobiPro is now changed to state. that is why the above query brakes.
I've just pushed a new hotspots dev. release. Just download it, install it over the version you use and the import should be working as expected.
Regards,
Daniel

Import Error 8 years 6 months ago #24704

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hi Daniel,

Just tried the dev release.
1054 Unknown column 'o.published' in 'where clause' SQL=SELECT c.id AS catid, o.name AS cat_name, c.description, o.state as published FROM aao_sobipro_category AS c LEFT JOIN aao_sobipro_object AS o ON c.id = o.id WHERE o.published = '1'

I checked versions in Extension manager and they are all listed as git_c2a8031 which is correct.

Will try again later, when I have more time to test, then report back.

Simon

Import Error 8 years 6 months ago #24705

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
go to administrator/components/com_hotspots/controllers/import.pho around line 45 you should have this:
		if ($input->get('sobi2published', 0) == 1)
		{
			$where = " o.state = " . $db->q(1);
		}

if it is o.published, than the update was not applied properly.

Import Error 8 years 6 months ago #24707

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hey Daniel,

Just checked and I have this code:
$where = '';
        if ($input->get('sobi2published', 0) == 1) {
            $where = " o.published = '1' ";
        }

So it looks like the update worked.
Would a screenshot of the Import field dat be useful?
I do not use the default category created with Sobi, so my fields all have different IDs than expected, but are updated to reflect the new ones.

Simon

Import Error 8 years 6 months ago #24710

  • Daniel Dimitrov
  • Daniel Dimitrov's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 9618
  • Karma: 155
  • Thank you received: 1081
In my previous message I said that if you have o.published the update was NOT properly applied.

Try to install download the package again and install it. I just checked and the file is correct in the package.

Regards,
Daniel

Import Error 8 years 6 months ago #24711

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
{facepalm}

Simon

Import Error 8 years 6 months ago #24712

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Hey Daniel,
I uninstalled the component, then reinstalled using the dev copy from compojoom.com/downloads/developer-releas...pots-core/gitc2a8031
Then tried again and it failed.
I just checked the dev download and that file com_hotspots-git_c2a8031-core\administrator\components\com_hotspots\controllers\import.php and it is coded
$where = '';
        if ($input->get('sobi2published', 0) == 1) {
            $where = " o.published = '1' ";
        }

This would mean that the dev version code is not as you expect it?

Simon

Import Error 8 years 6 months ago #24713

  • Simon Wells
  • Simon Wells's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
I have just edited the import.php and changed the original code to
if ($input->get('sobi2published', 0) == 1)
		{
			$where = " o.state = " . $db->q(1);
		}

Import now works, as it should.
Does seem that the dev code needs updating to reflect the changes you expect :)

Simon
  • Page:
  • 1
Time to create page: 0.169 seconds