MyBB-Plugins Forums
my achievements error - Printable Version

+- MyBB-Plugins Forums (http://forums.mybb-plugins.com)
+-- Forum: Archived Forums (http://forums.mybb-plugins.com/Forum-Archived-Forums)
+--- Forum: MyBB 1.4.x (http://forums.mybb-plugins.com/Forum-MyBB-1-4-x)
+---- Forum: General (http://forums.mybb-plugins.com/Forum-General)
+---- Thread: my achievements error (/Thread-my-achievements-error)



my achievements error - Glas - 06-30-2010

Type: 20
File: (Line no. 0)
Message
SQL Error: 1064 - 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 '' at line 1
Query: UPDATE mybb_users SET myachievements_threads=myachievements_threads+1 WHERE uid=


RE: my achievements error - Diogo Parrinha - 06-30-2010

(06-30-2010, 11:38 PM)Glas Wrote: Type: 20
File: (Line no. 0)
Message
SQL Error: 1064 - 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 '' at line 1
Query: UPDATE mybb_users SET myachievements_threads=myachievements_threads+1 WHERE uid=

Why are you posting this when you've sent me a PM with that already and I've explained to you that it's not a problem with My Achievements but a problem with the RSS plugin?


RE: my achievements error - Glas - 07-01-2010

D: oops sorry bad memory
i have uninstalled rss plugin and admin extra security (by zinga burga) that was giving me the error


RE: my achievements error - Diogo Parrinha - 07-01-2010

(07-01-2010, 12:48 AM)Glas Wrote: D: oops sorry bad memory
i have uninstalled rss plugin and admin extra security (by zinga burga) that was giving me the error

So..? Does that mean this is not happening anymore or does that mean this problem is still occurring regardless of having RSS plugin or not?


RE: my achievements error - Glas - 07-01-2010

it means that stopped happening
but what i don't know if the BOTH rss plugins are uncompatible with myachivements, or my achievements is the trouble maker =(

i don't know what do do.. rss plugin maker will tell me it's not his fault and you too :S


RE: my achievements error - Diogo Parrinha - 07-02-2010

Which plugin can be downloaded from MyBBoard? I remember two RSS plugins but one was not available on MyBB.com, which one is it so I can download it and look at it?


RE: my achievements error - Glas - 07-02-2010

http://www.mybbhacks.com/showthread.php?tid=12


RE: my achievements error - Diogo Parrinha - 07-02-2010

(07-02-2010, 06:59 AM)Glas Wrote: http://www.mybbhacks.com/showthread.php?tid=12

I said MyBBoard but okay..

Anyway, let me know if this fixes it:
Replace:
PHP Code:
$db->query('UPDATE '.TABLE_PREFIX.'users SET myachievements_threads=myachievements_threads+1 WHERE uid='.$mybb->user['uid']); 

With:
PHP Code:
$db->query('UPDATE '.TABLE_PREFIX.'users SET myachievements_threads=myachievements_threads+1 WHERE uid='.$posthandler->thread_insert_data['uid']); 

In inc/plugins/myachievements.php