After upgrading to 2.0.5, $smcFunc['db_query'] doesnt work anymore

[whatever]

Hi,
I did upgrade from 2.0.4 to 2.0.5 but the $smcFunc['db_query'] doesn't work.

Let's say:

I have this code on my .php files:

Code Select Expand


$result = $smcFunc['db_query']('', '
UPDATE {db_prefix}members
SET posts = posts + 100
WHERE id_member = {int:id_member}
LIMIT 1',
array(
'id_member' => $context['user']['id'],
));


The code runs, but it doesn't update the posts from -lets say- 100 to 200, instead, it just stays there at "100".

The code works before on 2.0.4 but it doesn't anymore now

Anyone knows why?
Thanks

[Arantor]

Odd, that works fine for me, what else is going on in that code?

[whatever]

@arantor

I got it working finally!! it is just coding error on my side >.<
now I am trying to fix this problem:

everytime I click on "profile", "admin","home" or anything on the menu, it will just go back to the last page I am on. it works fine if I go to profile > summary and click on the "summary", but it will not work if I just go click on the "profile" directly, but yeah that's another question of the day

thanks and sorry for bothering you:D

[kat]

Could the coding squawk have caused your current problem, too?

[whatever]

hmmm, actually,
the problem doesn't stop there....
another weird thing: after upgrading into smf 2.0.5, my forum is loosing second page, hmmmm. I set it so that each page contains 10 message replies, the replies from 11 and up are missing, though user can still post replies and get his/her post count increased....

[whatever]

hmmm, actually,
the problem doesn't stop there....
another weird thing: after upgrading into smf 2.0.5, my forum is loosing second page, hmmmm. I set it so that each page contains 10 message replies, the replies from 11 and up are missing, though user can still post replies and get his/her post count increased....

okay, I have just realized that it can go to page 2;
it has been like 13 replies to the topic, but SMF listed it as 10 replies, and since I set the topic page to be 10 posts per page, it doesn't create second page, even though it really has 13 replies already on that topic.
by the time I posted the 14th replies to that topic, the second page appears, along with other missing replies.....
that's weird.

[Arantor]

Silly question: what did you upgrade *from*? 2.0.4 to 2.0.5 changed almost nothing, and what it did change was almost entirely in the admin area and so should not have affected anything like the things you're seeing (i.e. it's nothing whatsoever to do with the upgrade itself if you came from 2.0.4)