...not sure where to post this, so move as appropriate...
...When I click on the "New replies to your posts" this is what I've gotten all day...Suggestions please? huh
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
Thanks Ron. We recently upgraded the forum software and it looks as though the database was supposed to update as well, but for some reason it didn't quite work as they had planned. LOL
I'll see what I need to do to fix it.....
Dennis
....thanks Dennis....works now |^|
Not working for me.
Quote from: waterboy on November 29, 2017, 08:18:29 AM
Not working for me.
"Show unread posts since last visit".......this ?.....it's working...try a refresh?.....
"Show unread posts since last visit" Works OK.
"Show new replies to your posts" doesn't work
Yep, checked out the SMF website and it's a known problem with the database query..... I'm sure they will get it sorted out in the next update.
Dennis
okay...thanks....
Okay, it turns out that our forum software is not up to speed with the newer versions of MySQL, that's the database that contains all the posts, settings, etc.
I manually corrected the query statement to be compliant with the new versions so the "Show new replies to your posts" now works. The only problem is, that if the forum software folks don't correct the problem, when the software gets it's next update I'll need to make the fix again.
I love computers and the software that makes 'em go!!! |^|
Dennis
Quote from: BallAquatics on December 03, 2017, 09:47:36 AM
Okay, it turns out that our forum software is not up to speed with the newer versions of MySQL, that's the database that contains all the posts, settings, etc.
I manually corrected the query statement to be compliant with the new versions so the "Show new replies to your posts" now works. The only problem is, that if the forum software folks don't correct the problem, when the software gets it's next update I'll need to make the fix again.
I love computers and the software that makes 'em go!!! |^|
Dennis
...thanks Dennis......appreciate it a whole bunch.... |^|
Quote from: Mugwump on December 03, 2017, 03:39:06 PM
Quote from: BallAquatics on December 03, 2017, 09:47:36 AM
Okay, it turns out that our forum software is not up to speed with the newer versions of MySQL, that's the database that contains all the posts, settings, etc.
I manually corrected the query statement to be compliant with the new versions so the "Show new replies to your posts" now works. The only problem is, that if the forum software folks don't correct the problem, when the software gets it's next update I'll need to make the fix again.
I love computers and the software that makes 'em go!!! |^|
Dennis
...thanks Dennis......appreciate it a whole bunch.... |^|
Yes we do Dennis.
You are both very welcome. ;D
Let me know if you run across any other problems. I wouldn't be surprised if this same type of problem exists somewhere else in the software.
Dennis
MIne's finally working now....thanks...
I think that I just answered the posts.....on two different threads....and not an email sent..or attempted....weird...
Apply Filter: Only show the error messages of this member Mugwump
Apply Filter: Only show the error messages of this IP address 208.89.149.29
Reverse chronological order of list Today at 05:47:38 AM
Apply Filter: Only show the error messages of this session 0ecf8d3487f5fdbdebe164a929ac0ad8
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URL
http://www.mugwump-fish-world.com//index.php?action=post2;start=7500;board=24
Apply Filter: Only show the errors with the same message
Unable to send mail to the email address 'rondsower@gmail.com'
Apply Filter: Only show the error messages of this member Mugwump
Apply Filter: Only show the error messages of this IP address 208.89.149.29
Reverse chronological order of list Today at 05:41:57 AM
Apply Filter: Only show the error messages of this session 0ecf8d3487f5fdbdebe164a929ac0ad8
Apply Filter: Only show the errors of this type Type of error: General
Apply Filter: Only show the error messages of this URL
http://www.mugwump-fish-world.com//index.php?action=post2;start=0;board=39
Apply Filter: Only show the errors with the same message
Unable to send mail to the email address 'rondsower@gmail.com
Quote from: Mugwump on December 04, 2017, 06:02:55 AM
I think that I just answered the posts.....on two different threads....and not an email sent..or attempted....weird...
Unable to send mail to the email address 'rondsower@gmail.com
I'm pretty sure I know what that one is.....
Ron has asked the system to "Notify" him when posts are made to certain threads. Since this server doesn't have email capability it throws the error it can't email Ron to "Notify" him of the new post.
Dennis
Quote from: BallAquatics on December 04, 2017, 07:21:45 AM
Quote from: Mugwump on December 04, 2017, 06:02:55 AM
I think that I just answered the posts.....on two different threads....and not an email sent..or attempted....weird...
Unable to send mail to the email address 'rondsower@gmail.com
I'm pretty sure I know what that one is.....
Ron has asked the system to "Notify" him when posts are made to certain threads. Since this server doesn't have email capability it throws the error it can't email Ron to "Notify" him of the new post.
Dennis
....Bingo...I think you nailed it..... |^|....thanks..
Is that why it says I have a message but when I click on it it gives me the same data base error?
Quote from: LizStreithorst on December 04, 2017, 08:30:06 AM
Is that why it says I have a message but when I click on it it gives me the same data base error?
huh I'm not seeing an error in the log files, so I don't know what is up with this one. huh
Dennis
Hmmm, it told me to contact anmin about it huh Dennis, try sending me a PM and let's see if I get it.
...just click mssg's.....I'm getting it too noe...
........................
Database Error
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ballaqua_mugwump.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /var/www/mugwump-fish-world.com/public_html/Sources/PersonalMessage.php
Line: 700
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.15, while your database is at version 2.0.2. The above error might possibly go away if you execute the latest version of upgrade.php.
Okay, got errors in the logs now. I probably caused this one by editing the DB Query statement. Should be fixed now. Clear your cache and give it a try.
Dennis
Seems to be working for my alter ego account LOL.
I BCC you both with the test message....
Dennis
I didn't know how to clear my cache but I clicked on my messages and it let me see them! I'm happy again.
Dennis, you are a genius.
Enough excitement for today..... we now return you to your regularly scheduled program..... ;)
Quote from: LizStreithorst on December 04, 2017, 02:19:22 PM
I didn't know how to clear my cache but I clicked on my messages and it let me see them! I'm happy again.
Dennis, you are a genius.
Thanks Liz :-*
Dennis