Bug MySQL Error

Darkwaltz4

Former Developer

• May 3, 2012

• #21

Okay, then just replace that with

PHP:

floatval($obj->myself[$currencyid])

 

J

Jester

Customer

• May 3, 2012

• #22

Darkwaltz4 said:

Okay, then just replace that with

PHP:

floatval($obj->myself[$currencyid])

Click to expand...

Thanks DW, but out of fear of rendering the system worse off, could you tell me to replace exactly what with what like you did in the first post?

Thanks!

 

Darkwaltz4

Former Developer

• May 3, 2012

• #23

okay..

Edit (forums)/dbtech/credits/credits_core.php find

PHP:

$obj->myself[$currencyid]

replace with

PHP:

floatval($obj->myself[$currencyid])

 

J

Jens Heitzmann

Customer

• Jun 20, 2012

• #24

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:
UPDATE vb_user AS vbcreditst_1 SET vbcreditst_1.credits = WHERE vbcreditst_1.userid = ****;

MySQL-Fehler : 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 'WHERE vbcreditst_1.userid = ****' at line 1
Fehler-Nr. : 1064
Fehler-Zeit : Wednesday, 20.06.2012 @ 13:33:32
Datum : Wednesday, 20.06.2012 @ 13:33:32
Skript : Bloodpatches.net | blut-patch.de - Die Uncut Community
Referrer : Bloodpatches.net | blut-patch.de - Die Uncut Community
IP-Adresse : *.*.*.*
Benutzername : ****
Klassenname : vB_Database
MySQL-Version :

What does that error mean ?
Just a temporary one ?

 

Darkwaltz4

Former Developer

• Jun 20, 2012

• #25

Anyone who has this problem, the solution was posted here until I get it rolled into the next update: http://www.dragonbyte-tech.com/f63/mysql-error-7921/index3.html#post41683

 

mikez006

Customer

• Jul 9, 2012

• #26

Conflict with another mod

I use another mod called Multi-account login detector. Basically it checks to see if people are creating multiple accounts, then using an pre-set account, a normal (registered usergroup) account, it creates a thread listing the usernames of the accounts.

Since enabling this addon, it no longer works. I turned the credit mod off, then a few minutes later is started working again.

I think the Credits II mod is preventing the account from creating threads.

Any ideas on how to resolve this? Is there a way to exclude a usergroup or user from the system?

 

mikez006

Customer

• Jul 9, 2012

• #27

Seems the Multi-account mod is using an account with username "admin" to make the threads and the credits mod is also using an "admin" username to send notifications. I removed the "admin" username from the Credits mod and will see if this fixes it.

 

mikez006

Customer

• Jul 9, 2012

• #28

It seems even though I changed the username, its still now working as intended.

I can confirm that the multi-account checker mod is still working, the only problem is that the designated "admin" account used to create the threads is unable to create threads even though I changed the username for the credit II mod.

 

Last edited: Jul 9, 2012

Darkwaltz4

Former Developer

• Jul 9, 2012

• #29

Thanks for trying that, but I think the admin account thing is a red herring. It does not change anything with that user account, and only uses its username when sending the PM alerts.

Are you charging for thread creation in certain forums that include the forum that the other mod is trying to post a thread into? I could see that account not having enough credits and thus canceling the attempt to post the thread.

 

mikez006

Customer

• Jul 10, 2012

• #30

Im not charging for thread creation in any forum, but Im going to try disabling credits for that forum for thread creation and we'll see if that works. Its a private forum also, not sure if that would have any effect, just an fyi.

 

mikez006

Customer

• Jul 11, 2012

• #31

I disabled credits for new Threads in that forum, but that did not solve the problem. Any other ideas?

 

Darkwaltz4

Former Developer

• Jul 12, 2012

• #32

Can you disable awarding for threads entirely? I think I'll have to jump on your site to take a closer look though. IM me with ftp again whenever you're ready.

 

mikez006

Customer

• Jul 12, 2012

• #33

I turned off New Threads and turned on PM Notification for the multi-account detector and that works. So it just seems like New Threads are being blocked.

Ill test by turning off credits for threads also

 

mikez006

Customer

• Jul 12, 2012

• #34

disabling threads did not fix it. Still not able to create threads.

 

Darkwaltz4

Former Developer

• Jul 16, 2012

• #35

Mike's issue caused by same bug, so merged together. The mod conflict and thread stuff was a red herring; the email containing the db error was being suppressed.