Posts to Show on Topic Summary Bug

Started by whatsadollartoya, October 14, 2011, 01:24:54 PM

Previous topic - Next topic

whatsadollartoya

Hello SMF Forum. I love what SMF has become over the last few years, it is quite spectacular. I have spent the last month working on my forum here and there, I have come across some database crashing problems along the way while figuring out themes and such, but I finally got the forum set up and ready. Until I came across this problem, I'm worried I am going to have to reinstall the forum again.

I am using SMF 2.0.1, with MysticJade skin. The only Mods I have are, GoogleAd Mod v1.4 and SMFShop. Here is the order of which the error started to occur.

1. I searched admin settings for "Time required between posts from the same IP.

2. I set Posts to show on topic from 15 to 10.

3. The problem started to occur. First, someone replied twice to a post, it didn't create a page two, and it would show the Last Post by: (The name of person who replied twice), but when you go to the post, it doesn't show their posts.

I set the number back to 15, in hopes this would resolve the problem. It still doesn't show those 2 posts, and gives a strange error when I try to remove a topic / post.

I made a new topic in a seperate section for testing, i replied to it 15 times, to make sure it hops back over to the next page like it is supposed to, and now it does. But when I try to remove a post, it gives this error "Wrong value type sent to the database. Integer expected. (amount)" - The number of "Replies" to this topic goes down by 1, but the post that I removed and got the error from, is not removed.

Any help would be much appreciated, I really don't want to have to re-install the whole forum again when I finally got my members to start posting after a month of tweaks.


Oldiesmann

What file/line are associated with that database error?
Michael Eshom
Christian Metal Fans

whatsadollartoya

Quote from: Oldiesmann on October 14, 2011, 01:32:59 PM
What file/line are associated with that database error?

I have no idea, after switching from 15 to 10, someone tried to reply to a topic that had more than 10, and it bugged out. Now when ever I try to remove a post or topic, it gives that same error;

"Wrong value type sent to the database. Integer expected. (amount)"

It isn't showing it as a database error on line ___, it shows it as a SMF Error. I attached a screen shot of what the error is saying.

if there is no way to actually fix this, what can I do about backing up all my topics and posts and forum categories/subforums?

Illori

what if you edit that value again and input 15 and save it?

whatsadollartoya

Quote from: Illori on October 14, 2011, 01:40:35 PM
what if you edit that value again and input 15 and save it?

That's what I did. When I woke up I had a PM saying that "my posts didnt show in your topic", so I changed it back to 15. After changing it back, this is when the error starts when removing topics/posts.

emanuele

Could you please attach your RemoveTopic.php file?


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.


emanuele

#7
Quote from: whatsadollartoya on October 14, 2011, 01:24:54 PM
[...]
2. I set Posts to show on topic from 15 to 10.

[...]
I made a new topic in a seperate section for testing, i replied to it 15 times, to make sure it hops back over to the next page like it is supposed to, and now it does.
Also, please note that the "post to show etc..." that you find in admin > post settings (the admin page you find when you search for the string in your point 1) is not the number of posts to show in each page. This setting is in admin > themes and layout > member options.

Edit: please check also your error log, there you should find a better description of the error with the line it occurs.


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

whatsadollartoya

Quote from: emanuele on October 14, 2011, 02:48:20 PM
Quote from: whatsadollartoya on October 14, 2011, 01:24:54 PM
[...]
2. I set Posts to show on topic from 15 to 10.

[...]
I made a new topic in a seperate section for testing, i replied to it 15 times, to make sure it hops back over to the next page like it is supposed to, and now it does.
Also, please note that the "post to show etc..." that you find in admin > post settings (the admin page you find when you search for the string in your point 1) is not the number of posts to show in each page. This setting is in admin > themes and layout > member options.

I was just explaining how I got to the settings, I was originally finding post from IP flood control, and decided I wanted to play with the Posts to show aswell, the posts to show from 15 to 10 and back is what caused the problem. See Attachments.

emanuele

I just wanted to be sure. ;)

Could you please check the error log of your forum? You should be able to find a better description of the error with the line and the file it occurs.


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

whatsadollartoya

Alright, didn't even think to look at the log lol. Apologies, but here are the two errors. Removing a Topic and Removing a Post.

QuoteWrong value type sent to the database. Integer expected. (amount)
Function: removeTopics
File: public_html/forum/Sources/RemoveTopic.php
Line: 270

QuoteWrong value type sent to the database. Integer expected. (amount)
Function: removeMessage
File: public_html/forum/Sources/RemoveTopic.php
Line: 950

Those are the only two different errors logged (thankfully :D)

Best Regards & Thank you very much for the help.

emanuele

This is a problem with the mod SMFShop.

Please be sure that SMFShop is properly configured (i.e. shopPointsPerPost is set to something) and just in case, installed (i.e. the column money is present in your smf_members table.

I would also suggest to ask more in the support topic of the mod. ;)


Take a peek at what I'm doing! ;D




Hai bisogno di supporto in Italiano?

Aiutateci ad aiutarvi: spiegate bene il vostro problema: no, "non funziona" non è una spiegazione!!
1) Cosa fai,
2) cosa ti aspetti,
3) cosa ottieni.

whatsadollartoya

Thank you again for helping me resolve this, I was in a panic that I was going to have to re-install the forum. I removed the SMFShop for now. This is why I have always loved to choose SMF over any other forum provider, complete and utter AWESOME supporting community.

Best Regards!

Advertisement: