Places (Events + Business integrated) Mod Support - part 3

Quote · 17 Mar 2016

 Yes, patches must be applied sequentially.

When upgrading from 2.1.3 to 2.1.6 do we have to do everything in steps, like a Dolphin upgrade?

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 17 Mar 2016

Where is version 2.1.4?

Dolphin 7.1 patches folder goes up to 7.1.3 - which I have (Location version 2.1.3 by modzzz.com)

Dolphin 7.2 patches folder starts with 7.1.5 and has 7.1.6

TravelNotes.org - The Online Guide to Travel
Quote · 22 Mar 2016

 

Where is version 2.1.4?

Dolphin 7.1 patches folder goes up to 7.1.3 - which I have (Location version 2.1.3 by modzzz.com)

Dolphin 7.2 patches folder starts with 2.1.5 and has 2.1.6

For anyone looking in the upgrade folders and wondering about this, I believe the original 2.1.4 version was a duplicate of 2.1.3 and has since been removed from the download package.

Now the question is, should we update the sys_modules database table to put 2.1.4 in the place of 2.1.3 to know that we need to look for 2.1.5 after we update module to Dolphin 7.2 compatibility.

TravelNotes.org - The Online Guide to Travel
Quote · 23 Mar 2016

Here we go......

On Places Module Page:

https://www.boonex.com/m/Locations_Events_Hotels_Transport_Eateries_Shops_Nightlife

Demo:
http://dolphinmods.com/demo2/m/location/home link gives Module(location) was not found.

TravelNotes.org - The Online Guide to Travel
Quote · 23 Mar 2016

@TravelNotes - All demo sites are being re-created and modules are being re-uploaded and tested. Within another two two weeks everything should be back in place.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 23 Mar 2016

Thanks.

TravelNotes.org - The Online Guide to Travel
Quote · 23 Mar 2016

 

Changing Title

When changing a Location title that a member has given, an admin may want to change the URI to reflect this. This can be done in the 'modzzz_location_main' table (PHP MyAdmin).

If that uri is changed, the 'forum_uri' in the 'modzzz_location_forum' table will also need to be altered to reflect this; otherwise there's an error on the forum link.

Is there a possibility that the ability to make these changes in the admin interface can be coded into a new release?

 I posted that a while ago and while doing some spring cleaning on the site, I noticed something else to be considered if anyone edits in PHP MyAdmin.

► Also alter the title and uri in 'bx_wmap_locations' to keep the locations map sychronised.

Michel on Meta-Travel.com

TravelNotes.org - The Online Guide to Travel
Quote · 24 Mar 2016

Just to let you know, when deleting from Locations module pages a trace seems to remain in the 'bx_wmap_locations'  table (and therefore the map). I've deleted my orphans manually.

Might be something to consider.

TravelNotes.org - The Online Guide to Travel
Quote · 24 Mar 2016

The glitch with Map entries not being deleted was fixed in the latest upload of the module.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 25 Mar 2016

 

The glitch with Map entries not being deleted was fixed in the latest upload of the module.

Which means? People on Dolphin 7.1.6 don't have it?

TravelNotes.org - The Online Guide to Travel
Quote · 25 Mar 2016

 Dolphin 7.1 mods are no longer updated.

 

The glitch with Map entries not being deleted was fixed in the latest upload of the module.

Which means? People on Dolphin 7.1.6 don't have it?

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 25 Mar 2016

Does this mean we get no more support on things that are broken while using Dolphin 7.1.6?

I've been getting database errors on Attractions, Nightlife, Schools, Services, Shops, and Transportation for a while.

I didn't want to uninstall and install the module again since adding 'patches', like I had to do with Premium Business Listings to get it working again.

If only the Dolphin 7.1.6 to Dolphin 7.2.0 upgrade would work but that's full of problems too.

Frown

TravelNotes.org - The Online Guide to Travel
Quote · 26 Mar 2016

 What database errors are you getting ? I cannot provide help without details.

Does this mean we get no more support on things that are broken while using Dolphin 7.1.6?

I've been getting database errors on Attractions, Nightlife, Schools, Services, Shops, and Transportation for a while.

I didn't want to uninstall and install the module again since adding 'patches', like I had to do with Premium Business Listings to get it working again.

If only the Dolphin 7.1.6 to Dolphin 7.2.0 upgrade would work but that's full of problems too.

Frown

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 27 Mar 2016

Upgrading.... Readme says:

Login to your Admin Panel, go to Tools=>Modules and under "Installed Modules" select "Places"

I know what you mean but others might not. In my installed modules, it shows as:

Location version 2.1.3 by modzzz.com

Still have some work to do to get this one right.

checkAction() fatal error. Unknown action ID: 0

TravelNotes.org - The Online Guide to Travel
Quote · 28 Mar 2016

I get that error when trying to access a Location.

Looking through the admin, get the same error when trying to 'add'.

TravelNotes.org - The Online Guide to Travel
Quote · 28 Mar 2016

 

checkAction() fatal error. Unknown action ID: 0

Let's look at this bit by bit.

I can view the location by removing all the blocks and adding two test text blocks.

I guess I need to try and put bits back to see where the fault lies.

I'm guessing something doesn't match with in `sys_acl_actions` table.

TravelNotes.org - The Online Guide to Travel
Quote · 28 Mar 2016

I can now view all the sub-sections too (some gave database errors before) with the two test text boxes on the view page, but not add a location from there:

checkAction() fatal error. Unknown action ID: 0

TravelNotes.org - The Online Guide to Travel
Quote · 28 Mar 2016

_modzzz_location_block_actions (OK)
_modzzz_location_block_attractions (OK)
_modzzz_location_block_comments (OK)
_modzzz_location_block_desc (OK)
_modzzz_location_block_fans (OK)
_modzzz_location_block_fans_unconfirmed (OK)
_modzzz_location_block_files (OK)
_modzzz_location_block_foods (OK)
_modzzz_location_block_hotels (OK)
_modzzz_location_block_info (OK)
_modzzz_location_block_local (OK)
_modzzz_location_block_map_view (OK)
_modzzz_location_block_nightlifes (OK)
_modzzz_location_block_other (OK)
_modzzz_location_block_photo (OK)
_modzzz_location_block_rate (OK)
_modzzz_location_block_reviews (OK)
_modzzz_location_block_schools (OK)
_modzzz_location_block_services (OK)
_modzzz_location_block_shops (OK)
_modzzz_location_block_sound (OK)
_modzzz_location_block_transports (OK)
_modzzz_location_block_video (OK)
_modzzz_location_block_video_embed (OK)
_sys_block_title_social_sharing (OK)

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
checkAction() fatal error. Unknown action ID: 0
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_modzzz_location_block_contact
_modzzz_location_block_location (where is this place)
Click on Edit
Click on Add Photos
Add Location

I should add, no more database errors on some of the sub menu items since I took everything off and replaced one by one.

TravelNotes.org - The Online Guide to Travel
Quote · 28 Mar 2016

I don't know what the problem was, but modzzz has fixed it behind the scenes.

Thanks.

TravelNotes.org - The Online Guide to Travel
Quote · 29 Mar 2016

Hi modzzz,

Sorry to disturb you again but here's a few things I'm thinking about at the moment.

Locations Administration

Under cost in points/credits to feature a listing; how long does featured status run for?

Blocks in Location View

  • Where is this place?

I'm wondering how to make this a little better.

Maybe have a small country flag to add some colour.

I would also be inclined to have semi-colons after country, state and city. I know I can (probably) do this behind the scenes, but just thinking out aloud.

Could country, state and city be made into links?

  • Info

The category sub-category should also be links.

In your example they are:

http://www.dolphinmods.com/demo2/m/location/view/Brush

In mine, they are not:

http://meta-travel.com/m/location/view/Fort-Cochin

Any ideas why that is?

~~~~~~~~~~~~~~~~~~~~~~
MichelMeta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 29 May 2016

When we add new Categories and Sub Categories they land at the bottom of their relative lists on m/location/categories.

How do we get to arrange them alphabetically?

~~~~~~~~~~~~~~~~~~~~~~
MichelMeta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 9 Jun 2016

 Re-upload modules\modzzz\location\classes\BxLocationDb.php

When we add new Categories and Sub Categories they land at the bottom of their relative lists on m/location/categories.

How do we get to arrange them alphabetically?

~~~~~~~~~~~~~~~~~~~~~~
MichelMeta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 9 Jun 2016

Thanks.

TravelNotes.org - The Online Guide to Travel
Quote · 9 Jun 2016

Add Lodging seems to be missing from the Locations Actions block.

I also notice on the 'Add Eatery' page, there's a 'Lodging at Location' heading.

Surprised

~~~~~~~~~~~~~~~~~~~~~~
MichelMeta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 14 Jun 2016

@TravelNotes - The Actions block has an "Add Place" button which allows adding Hotels etc.

I cannot replicate the second issue mentioned. Do you have this module customized such as to integrate the Lodgings module ?

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 14 Jun 2016

Ah, yes. I have the Add Place button.

Silly me, I thought it was a location place not a place to stay, place.

Cool

~~~~~~~~~~~~~~~~~~~~~~
MichelMeta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 14 Jun 2016

Morning Modzzz,

Quick question. How can I adjust the map to show satellite and US and Canada by default? I have it set that way in the word map setting but it does not seem to change on your module?

 

Thank You for your help..

James

Quote · 20 Jul 2016

The map is managed at http://www.yoursite.com/m/wmap/administration_parts/location

Quick question. How can I adjust the map to show satellite and US and Canada by default? I have it set that way in the word map setting but it does not seem to change on your module?

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 20 Jul 2016

Thanks Modzzz. That worked out even better then I thought it would..

Quote · 20 Jul 2016

 

@TravelNotes - The Actions block has an "Add Place" button which allows adding Hotels etc.

I cannot replicate the second issue mentioned. Do you have this module customized such as to integrate the Lodgings module ?

 

 

I also notice on the 'Add Eatery' page, there's a 'Lodging at Location' heading.

Surprised

 

ie:

 

From http://meta-travel.com/m/location/view/Columbus-Mississippi

Add Eatery takes me to http://meta-travel.com/m/restaurant/browse/my&filter=add_restaurant&location=18

 

Then we have:

Restaurant Info
Lodging at Location
Columbus, Mississippi

 

Maybe I should remove the restaurants module?

TravelNotes.org - The Online Guide to Travel
Quote · 2 Sep 2017

By the way, on the module page you may want to update the version number to 2.1.7

http://www.boonex.com/m/Locations_Events_Hotels_Transport_Eateries_Shops_Nightlife

TravelNotes.org - The Online Guide to Travel
Quote · 2 Sep 2017

Version 2.1.7 released. (see patches/version_2.1.7 folder)

 Added Post block to main page.

 Please apply the patch only if your existing version is 2.1.6

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 3 Sep 2017

Database Errors are back.

 

Marmaris
Main - http://meta-travel.com/m/location/view/Marmaris (error)
Accomodation - http://meta-travel.com/m/location/hotel/browse/Marmaris (works)
Attractions - http://meta-travel.com/m/location/attraction/browse/Marmaris (error)
Comments - http://meta-travel.com/m/location/comments/Marmaris (works)
Events - http://meta-travel.com/m/location/event/browse/Marmaris (works)
Fans - http://meta-travel.com/m/location/browse_fans/Marmaris (works)
Food - http://meta-travel.com/m/location/food/browse/Marmaris (works)
Forum - http://meta-travel.com/forum/location/forum/Marmaris-0.htm (works)
Nightlife - http://meta-travel.com/m/location/nightlife/browse/Marmaris (error)
Reviews - http://meta-travel.com/m/location/review/browse/Marmaris (works)
Schools - http://meta-travel.com/m/location/school/browse/Marmaris (error)
Services - http://meta-travel.com/m/location/service/browse/Marmaris (error)
Shops - http://meta-travel.com/m/location/shop/browse/Marmaris (error)

Transportation - http://meta-travel.com/m/location/transport/browse/Marmaris (error)

 

Main:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='attraction'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Attractions:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='attraction'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Nightlife:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='nightlife'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Schools:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='school'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Services:
ELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='service'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Shops:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='shop'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Transportation:
SELECT COUNT(*) FROM `modzzz_listing_main`  left JOIN `Profiles` ON `Profiles`.`ID`=`modzzz_listing_main`.`author_id` WHERE 1 AND `modzzz_listing_main`.`status` ='approved' AND `modzzz_listing_main`.`location_id` ='13' AND `modzzz_listing_main`.`location_type` ='transport'

Mysql error: Unknown column 'modzzz_listing_main.location_id' in 'where clause'

Found error in the file '/home/metatrav/public_html/inc/classes/BxDolSearch.php' at line 506.
Called 'db_value' function with erroneous argument #0.

 

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/metatrav/public_html/inc/classes/BxDolDb.php
            [line] => 246
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Unknown column 'modzzz_listing_main.location_id' in 'where clause'

 

Frown

TravelNotes.org - The Online Guide to Travel
Quote · 6 Sep 2017

I'm wondering if this might have something to do with Business Listing module integration, as I had to uninstall that module and install again to get it working.

 

Should I run sqlbusiness.php again?

TravelNotes.org - The Online Guide to Travel
Quote · 6 Sep 2017

 Your assumption is correct. You need to re-run sqlbusiness.php

I'm wondering if this might have something to do with Business Listing module integration, as I had to uninstall that module and install again to get it working.

 

Should I run sqlbusiness.php again?

 

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 6 Sep 2017

 

 Your assumption is correct. You need to re-run sqlbusiness.php 

Excellent. Everything is working as should again.

Modzzz Modules are a must have for greater Dolphin functionality; and integrate so well together.

Next up: Actions Manager, Social Connection, and Admin Tools.

Cool

~~~~~~~~~~~~~~~~~~~~~~
Michel - Meta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 7 Sep 2017

 

 

@TravelNotes - The Actions block has an "Add Place" button which allows adding Hotels etc.

I cannot replicate the second issue mentioned. Do you have this module customized such as to integrate the Lodgings module ?

 

 

I also notice on the 'Add Eatery' page, there's a 'Lodging at Location' heading.

Surprised

 

ie:

 

From http://meta-travel.com/m/location/view/Columbus-Mississippi

Add Eatery takes me to http://meta-travel.com/m/restaurant/browse/my&filter=add_restaurant&location=18

 

Then we have:

Restaurant Info
Lodging at Location
Columbus, Mississippi

 

Maybe I should remove the restaurants module?

 The wrong text on the Add Eatery page still needs looking at.

For the other issue....

Add Place action on a place (location) needs to be Add Lodging.

 

TravelNotes.org - The Online Guide to Travel
Quote · 16 Sep 2017

Please re-upload files and recompile the language for the module to fix issues with some language strings.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 17 Sep 2017

1. We ran into a new issue with the Add Eatery page language string.... reported in Restaurants support thread.

2. The action problem is easy enough to resolve.

Issue:

Add Place action on a place (location) needs to be Add Lodging, as the module has been renamed Places and we have Add Place as the main action at the top of the page.

I would feel better if it was still Add Location as it used to be, but that's a different issue.

We are where we are; so....

To Resolve:

In Language String _modzzz_location_action_title_add_hotel (Modzzz Location)

Change Add Place to Add Lodging

Cool

With that sorted, I'm now ready for the Actions Manager.

~~~~~~~~~~~~~~~~~~~~~~
Michel - Meta-Travel.com
~~~~~~~~~~~~~~~~~~~~~~

TravelNotes.org - The Online Guide to Travel
Quote · 18 Sep 2017

Thank you @TravelNotes but that language change is already included in the update I posted yesterday. Did you apply that update to your site ?

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 18 Sep 2017

Hi Modzzz, Has this module been fully updated for 7.4.0 - 7.4.2?

BxLocationPageMain contains a deprecited PHP command $iCurrCount = mysql_num_rows($rData); on line 578.

I'm having problems with PHP7.2 but not 5.6 and this could be one of the reasons.

Regards

John

Quote · 23 Feb 2020

Dolphin 7.4 update - Re-upload modules\modzzz\location\classes\BxLocationPageMain.php

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 26 Feb 2020

Tip-toe, tip-toe through the upgrades.

And first white page.

TravelNotes.org - The Online Guide to Travel
Quote · 31 May 2020

I'm  really starting to think the only real way to solve all these conflicts when upgrading to Dolphin 7.4.2 is to remove everything and starting again.

 

Upgrading Dolphin before modules fails.

 

Upgrading modules before Dolphin fails too; especially with the PHP version conflicts.

TravelNotes.org - The Online Guide to Travel
Quote · 31 May 2020

In inc/header.inc.php , change the setting below to true

$site['fullError']         = false;

 

Also, add the following line at the end of that file :

ini_set("display_errors",1);

 

You will then be able to see exactly what is causing the error.

Paypal email is jeromemingo@gmail.com - http://www.boonex.com/market/posts/modzzz
Quote · 1 Jun 2020
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.