jucs

16 minutes ago, Marc Stridgen said:

Please respond to the ticket to let our techs know if you have been asked in the ticket

No clue where this is now. 

I have re-updated AdminCP access as it seems to be getting overwritten on the pop up as I just made sure again it is correct.

As in the system logs, Jedd Johnson

You can see the errors in the Admin CP jacking up and when clicking on the details it's this user.

Thanks.

16 minutes ago, Marc Stridgen said:

Your login requires email. We would need email adding rather than display name

Whoops. Sorry. updated.

9 minutes ago, Marc Stridgen said:

We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. 

We look forward to further assisting you. 

 

Done. Updated Admin CP login.

Just did the latest monthly update. I have a user with a Samsung Galaxy s21 showing template errors and I went to the logs and saw system logs racking up with this.  Screenshot from his phone is attached too. I assume some bug was introduced in the lastest monthly since no prior errors until now?  I have never made any modifications to any of the forum templates from the default btw.

Please advise. Thanks.

SELECT COUNT(*) FROM `ibf_core_rc_index` AS `core_rc_index` WHERE (( ( class='IPS\\core\\Messenger\\Conversation' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Messenger\\Message' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Status' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\core\\Statuses\\Reply' AND ( perm_id IN(2,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,585,593,594,595,597,598,599,600,601,602,603,604,605,608,609,610,611,614,615,616) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\Post' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\forums\\Topic\\ArchivedPost' AND ( perm_id IN(465,466,467,468,472,478,479,480,481,482,483,484,485,488,489,490,491,492,494,496,498,499,500,501,502,503,507,508,509,510,511,512,513,514,515,516,518,519,520,523,524,525,526,586,587,589,591,607,612) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image\\Comment' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Image\\Review' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Item' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Comment' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\gallery\\Album\\Review' AND ( perm_id IN(259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,279) ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Review' AND ( perm_id IN() ) OR perm_id IS NULL )) OR ( class='IPS\\nexus\\Package\\Item' ) OR ( class='IPS\\nexus\\Package\\Review' )) AND status IN( 1,2 )
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ) OR perm_id IS NULL )) OR ( ( class='IPS\\calendar\\Event\\Comment' AND ( per' at line 1

#0 /home/gripboar/public_html/system/Db/Select.php(388): IPS\_Db->preparedQuery('/*gripboar_grip...', Array, true)
#1 /home/gripboar/public_html/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#2 /home/gripboar/public_html/system/Db/Select.php(370): IPS\Db\_Select->rewind()
#3 /home/gripboar/public_html/system/Member/Member.php(3174): IPS\Db\_Select->first()
#4 /home/gripboar/public_html/system/Theme/Theme.php(885) : eval()'d code(8886): IPS\_Member->reportCount()
#5 /home/gripboar/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->mobileNavigation()
#6 /home/gripboar/public_html/system/Theme/Theme.php(885) : eval()'d code(6787): IPS\Theme\_SandboxedTemplate->__call('mobileNavigatio...', Array)
#7 /home/gripboar/public_html/system/Theme/SandboxedTemplate.php(61): IPS\Theme\class_core_front_global->globalTemplate('a9a956a28572a22...', '\n\n\n\n\n\t\n\t<div cl...', Array)
#8 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(173): IPS\Theme\_SandboxedTemplate->__call('globalTemplate', Array)
#9 /home/gripboar/public_html/system/Dispatcher/Standard.php(113): IPS\_Dispatcher->finish()
#10 /home/gripboar/public_html/system/Dispatcher/Front.php(630): IPS\Dispatcher\_Standard->finish()
#11 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(155): IPS\Dispatcher\_Front->finish()
#12 /home/gripboar/public_html/index.php(13): IPS\_Dispatcher->run()
#13 {main}

1 hour ago, Adriano Faria said:

Take a look at Admin CP -> Members-> Notifications. Maybe you disabled it there.

Interesting!  It was disabled. And, no I am not going senile. I did no such change in settings. LOL! 😄

Thanks for the support.

1 minute ago, Adriano Faria said:

Are you CiC (hosted by IPS)? Maybe they removed that option to reduce resource usage?

I have no idea. Email was supposed to be there.

Nope. I am on a dedicated server.  I get notifications for new registrations for example. This just seemed to happen recently and I just never noticed yet.  I think it is tied to the last update frankly.  I keep the software up to date as you guys push out the updates.

No such option. Take a look

Call me a sleeper I guess, but I noticed I was not getting emails for when I received PMs on my forum.  I was getting notices for new registrations and I then when to my settings on my own forum and noticed that the option for PM emails is no longer??  

When did this get changed? Thanks.

Thanks!

I need to turn it back on for a group and for the life of me cannot find where to do this.  Thanks in advance!

1 hour ago, Fast Lane! said:

log in to your account via SSH.  Type "mysql" then hit enter.  Then type "use database" (where database is your database name).  Then you can run the queries they tell you to.

 

Best SSH client to use?

Thanks!

12 minutes ago, CoffeeCake said:

When self-hosting, there are skill sets that you will need to have and develop. IPS offers cloud-based packages for those customers that want a fully managed experience, and alternatively you can develop those skills yourself or contract with a provider to help with these sorts of things.

For smaller databases, this isn't an issue, yet you get the warning you saw when tables exceed certain sizes that may time out. It seems that your install has some larger tables, so brushing up on how to handle this yourself would be well advised.

The alternative is that the upgrader doesn't warn you, it times out, and you end up with issues due to the timeout. These issues vary greatly depending on what MySQL is doing in the background.

For sure. Thanks for the clarification btw.  Next time with such a big upgrade, I will have to learn how to run the queries myself via the commend line for sure. 🙂

1 hour ago, CoffeeCake said:

The reason IPS is asking you to run these on the SQL server itself is because PHP-based queries may time out depending on the configuration of your web server, PHP, and MySQL instance. Long story short: do not use phpMyAdmin to do this. Just like IPS, it runs through your web server and PHP. There is no difference between phpMyAdmin and the upgrader.

You should instead connect directly to your MySQL instance via command line to run these queries. Typically, this will involve the mysql command while connected to SSH in a Linux environment.

https://dev.mysql.com/doc/refman/8.0/en/mysql.html

Read that carefully. It does not say phpMyAdmin.

Well, this didn't need to occur thank goodness. However, this is completely unreasonable to think you can have your server admin real time online doing these command line queries and frankly the majority of people are not SSH and Unix/MysSqul command line up to speed to go connect and do this. themselves.  Just my 2 cents.

1 minute ago, Adriano Faria said:

Click in SQL to run the queries 

I was just going to ask this instead. Got it. Thanks!

Anything else to do manually if need be?  That I should know before I start?

Thanks!

Was going to finally take the upgrade step and ran into this below. I do know how to pull up PhpMyAdmin and hit the Query tab. I assume the software will tell me the exact query to use and I will then submit it via PhpMyAdmin where I have the arrow in the attached screen shot? I am just making sure I am fully prepared to do this without getting hosed.   Thanks!

WHY change colors in the default!?  I had never customized and now a bunch of defaults are changed in 4.5.2.  Now, it creates a huge amount of work for me.  Does anyone have a theme with the OLD default colors?

Thanks.

On 7/25/2016 at 8:55 PM, Martin A. said:

The field type is probably set to "Editor", But if this is a field you've had going for quite some time, changing the field type will cause you to lose the data in the field.

I've made some changes to the next version to deal with this, just disable the feature for now.

There might be several reasons. When you write the location, do you get an autocomplete list underneath? You need to select one of them to be able to submit the form.

If you don't see the list, I may need you board URL, as there might be a JS error some where.

Yeah, I just disabled Member Map for now.  Easier.

Here is what tech support said:

Hello,

the problem is indeed in the membermap application.
One user has a wrong location which is causing the issue.

/home/gripboar/public_html/applications/membermap/extensions/core/MemberSync/membermap.php(113): IPS\membermap\_Map->getLatLng('<p>\n\tTest\n</p>')

I would suggest to contact the membermap coders for further support.

Quote

Are you sure you've selected the correct profile field to use as location sync? Surely "Youtube something something" isn't anyones physical location.

I don't know what you mean here. I can duplicate this issue on my forum for anyone that has selected a marker. So, it appears someone selected a wrong location and it is causing the issue?

Thanks.

4 hours ago, jucs said:

Updated to the latest member map and it appears to be causing an issue with member profiles now. I made a change to a member profile, clicked save, and got this error. The change to the profile was saved however. 

 

RuntimeException: BAD_JSON (0)
#0 /home/gripboar/public_html/applications/membermap/sources/Map/Map.php(207): IPS\Http\_Response->decodeJson()
#1 /home/gripboar/public_html/applications/membermap/extensions/core/MemberSync/membermap.php(113): IPS\membermap\_Map->getLatLng('<p>\n\tYoutube:\xC2\xA0...')
#2 [internal function]: IPS\membermap\extensions\core\MemberSync\_membermap->onProfileUpdate(Object(IPS\Member), Array)
#3 /home/gripboar/public_html/system/Member/Member.php(3031): call_user_func_array(Array, Array)
#4 /home/gripboar/public_html/system/Member/Member.php(347): IPS\_Member->memberSync('onProfileUpdate', Array)
#5 [internal function]: IPS\_Member->save()
#6 /home/gripboar/public_html/init.php(434) : eval()'d code(25): call_user_func_array('parent::save', Array)
#7 /home/gripboar/public_html/applications/core/modules/admin/members/members.php(889): IPS\autowelcome_hook_validatehook->save()
#8 [internal function]: IPS\core\modules\admin\members\_members->edit()
#9 /home/gripboar/public_html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#10 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#11 /home/gripboar/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#12 {main}

confirmed when I disabled the membermap application the problem went away.  However, I have another site running the exact latest Invision software (the latest) and it does not have this issue?????

Updated to the latest member map and it appears to be causing an issue with member profiles now. I made a change to a member profile, clicked save, and got this error. The change to the profile was saved however. 

RuntimeException: BAD_JSON (0)
#0 /home/gripboar/public_html/applications/membermap/sources/Map/Map.php(207): IPS\Http\_Response->decodeJson()
#1 /home/gripboar/public_html/applications/membermap/extensions/core/MemberSync/membermap.php(113): IPS\membermap\_Map->getLatLng('<p>\n\tYoutube:\xC2\xA0...')
#2 [internal function]: IPS\membermap\extensions\core\MemberSync\_membermap->onProfileUpdate(Object(IPS\Member), Array)
#3 /home/gripboar/public_html/system/Member/Member.php(3031): call_user_func_array(Array, Array)
#4 /home/gripboar/public_html/system/Member/Member.php(347): IPS\_Member->memberSync('onProfileUpdate', Array)
#5 [internal function]: IPS\_Member->save()
#6 /home/gripboar/public_html/init.php(434) : eval()'d code(25): call_user_func_array('parent::save', Array)
#7 /home/gripboar/public_html/applications/core/modules/admin/members/members.php(889): IPS\autowelcome_hook_validatehook->save()
#8 [internal function]: IPS\core\modules\admin\members\_members->edit()
#9 /home/gripboar/public_html/system/Dispatcher/Controller.php(85): call_user_func(Array)
#10 /home/gripboar/public_html/system/Dispatcher/Dispatcher.php(129): IPS\Dispatcher\_Controller->execute()
#11 /home/gripboar/public_html/admin/index.php(13): IPS\_Dispatcher->run()
#12 {main}

So, if I upgrade it should remember the current markers placed by members?  Thanks!

17 minutes ago, Martin A. said:

I think you'll have to add it to the main navigation using the Menu Manager in the ACP.  Then go to ACP > Members > Groups, click the "Edit" icon next to each member group to grant permissions to add, edit and/or delete personal markers.

I only see permissions for Form, Calendar, and Gallery. Nothing for Member Map. No one can edit their location once placed now. Members already gave that feedback and I tested it too and I cannot even edit my location as Admin.

I installed this...where does it show up exactly. I marked Member Map per the instructions.  Thanks.