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

 Yes, patches must be applied sequentially.

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

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.

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 - 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.

Thanks.

 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

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.

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?

 Dolphin 7.1 mods are no longer updated.

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.

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

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

I get that error when trying to access a Location.

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

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.

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

_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.

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

Thanks.

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?

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

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?

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

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

Thanks.

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.

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

@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 ?

Ah, yes. I have the Add Place button.

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

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

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

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

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

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:

Maybe I should remove the restaurants module?

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

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

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'

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?

 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.

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

 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.

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

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

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

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

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

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

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

Tip-toe, tip-toe through the upgrades.

And first white page.

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.

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.

I've looked at the installer.php file and a few of the classes.

The     

function __construct($aConfig) {

        parent::__construct($aConfig);

    }

coding is there, so hopefully all goes well.

To say I'm confident that everything will come up rosy is an understatement , after all the upgrading experiences I've had over the years with Dolphin and 3rd Party modules.

And on it goes.

Places Module installed on Dolphin 7.4.2 successfully.

To cut down on possible problems I need to tread carefully with integrating Business and Lodging modules.

We probably won't integrate Restaurants module again.

As default Events integration needs a number of hard code changes, I'll steer clear of that.

One thing I have learned in all these years of frustrating Dolphin and 3rd party module upgrades is the less code changes we need to make, the better.

Without good notation, code changes are too easy to over-write and subsequently break the site.

TMD Hosting have been great in rolling back the site recently, as we continue to swim with dolphins cautiously.

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

When checking for updates in modules.php, I get:

Places version 2.1.7 by modzzz.com New version is available.

OK.

Here we go.

Places, Premium Directory and Lodgings all installed. When running sqlbusiness.php and sqllodging.php The Upgrading Databases start and then we have the something went wrong Red Box.

When looking at the last two entries in `sys_options` table, 'modzzz_location_business_listing' and 'modzzz_location_lodging_listing' are both there.

The problem seems to be no `location_id` added to `modzzz_listing_main` or `modzzz_lodging_main`.

I hope that makes sense.